public bool checkLogin(string _username, string _password)
{
int Count = 0;
var connect = DatabaseSQL.GetProvider().GetConnection;
connect.Open();
var command = new System.Data.SqlClient.SqlCommand("SELECT * FROM users WHERE username = '******' and password = '******'", connect);
var reader = command.ExecuteReader();
while (reader.Read())
{
Count++;
}
connect.Close();
if (Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public void modify(string _id, string _username, string _password)
{
var connect = DatabaseSQL.GetProvider().GetConnection;
connect.Open();
var command = new System.Data.SqlClient.SqlCommand("UPDATE users SET [username]='" + _username + "',[password]='" + _password + "' WHERE [id]= '" + _id + "'", connect);
command.ExecuteNonQuery();
connect.Close();
}
public void delete(string _username)
{
var connect = DatabaseSQL.GetProvider().GetConnection;
connect.Open();
var command = new System.Data.SqlClient.SqlCommand("DELETE FROM users WHERE username = '******'", connect);
command.ExecuteNonQuery();
connect.Close();
}
public void create(string _username, string _password)
{
var connect = DatabaseSQL.GetProvider().GetConnection;
connect.Open();
var command = new System.Data.SqlClient.SqlCommand("INSERT INTO users ([username],[password]) VALUES ('" + _username + "','" + _password + "')", connect);
command.ExecuteNonQuery();
connect.Close();
}
public System.Data.DataTable load()
{
var connect = DatabaseSQL.GetProvider().GetConnection;
connect.Open();
var command = new System.Data.SqlClient.SqlCommand("SELECT * FROM users", connect);
var adaper = new System.Data.SqlClient.SqlDataAdapter(command);
var table = new System.Data.DataTable();
adaper.Fill(table);
connect.Close();
return(table);
}
public static bool testConnection()
{
var Connect = DatabaseSQL.GetProvider().GetConnection;
Connect.Open();
if (Connect.State == ConnectionState.Open)
{
Connect.Close();
return(true);
}
else
{
Connect.Close();
return(false);
}
}
