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); } }