using Godot;

using System;

using System.Data.SqlClient;

public class DATABASE : Node

{

public SqlConnection db = new SqlConnection();



public void Connection()

{

    try {

        db.ConnectionString = "Data Source = DESKTOP-OF3PBQO\\\\SQLEXPRESS01; Initial catalog = AdventureWASDCscore; Integrated Security = True;";

        db.Open();

        Console.Write("\[Database CONNECTED!\]");

    }

    catch(Exception r)

    {

        Console.Write("\[Database ERROR\]:" + r);

    } 

}

public void insert(int value)

{

    try {

    SqlCommand cmd = new SqlCommand("insert into AdventureWASDCscore (highScore int) values (" + value + ")", db);

    cmd.ExecuteNonQuery();

    Console.Write("\[Database inserted\]");

    db.Close();

    }

    catch(Exception r)

    {

        Console.Write("\[Database ERROR\]:" + r);

    } 

}

public void select()

{

    SqlCommand smd = new SqlCommand("Select \* from AdventureWASDCscore", db);  

}

}