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);
}
}
private void btnCreateBase_Click(object sender, EventArgs e)
{
var dbManager = new DatabaseSQL();
dbManager.BaseName = tbBaseName.Text;
dbManager.ServerName = cbServerName.Text;
var result = dbManager.CreateDatabase();
if (result["result"].Equals("true"))
{
MessageBox.Show("Database Created Successfully", "Contract keeper",
MessageBoxButtons.OK, MessageBoxIcon.Information);
this.ConnectionString = "Data Source =" + cbServerName.Text + "\\SQLEXPRESS; Initial Catalog = " + tbBaseName.Text + "; Integrated Security = True";
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show(result["ex"], "Contract keeper", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
