public void deleteuser(Credential_DB cDB) { string query = String.Format("delete from credential where username = '******'", cDB.UserName); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void changemypassword(Credential_DB cDB) { string query = String.Format("UPDATE [credential] SET [password] = '{0}' where [username] = '{1}' and [usertype] = '{2}'", cDB.Password, cDB.UserName, cDB.UserType); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void createnewuser(Credential_DB cDB) { string query = String.Format("Insert into Credential Values('{0}','{1}','{2}','{3}','{4}')", cDB.UserName, cDB.Password, cDB.UserType, cDB.name, cDB.city); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void FillGrid(DataGridView GV) { string query = "select * from credential"; Business_Logic BL = new Business_Logic(); DataSet ds = BL.Adapter(query); GV.DataSource = ds.Tables[0]; //adapter return dataset }
public void fillcombobox(ComboBox CB) { // ComboBox CB = new ComboBox(); string query = "Select username from credential where usertype = 'user'"; Business_Logic BL = new Business_Logic(); OleDbDataReader rec = BL.SelectQuery(query); while (rec.Read()) { CB.Items.Add(rec[0].ToString()); } // return CB; }
public bool Authenticate(Credential_DB cDB) { string query = String.Format("select * from Credential where username = '******' and password = '******' and usertype ='{2}'", cDB.UserName, cDB.Password, cDB.UserType); Business_Logic BL = new Business_Logic(); OleDbDataReader rec = BL.SelectQuery(query); if (rec.Read()) { return(true); } else { return(false); } }