private void button1_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.UserName = txt_username.Text; cDB.Password = txt_password.Text; if (rbtn_admin.Checked) { cDB.UserType = "Admin"; } else if (rbtn_user.Checked) { cDB.UserType = "User"; } if (cDB.Authenticate(cDB)) { Home hform = new Home(); hform.lbl_GetIDhere.Text = txt_username.Text; hform.lbl_getusertype.Text = cDB.UserType; txt_password.Text = ""; hform.Show(); //MessageBox.Show("Login Successfully"); } else { MessageBox.Show("Login Failed"); } }
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 deleteuser(Credential_DB cDB) { string query = String.Format("delete from credential where username = '******'", cDB.UserName); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
private void btn_changePassword_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); //Home hobj = new Home(); cDB.UserName = label4.Text; cDB.UserType = label5.Text; cDB.Password = txt_oldpassword.Text; // cDB.txt_newpassword = txt_cnewpassword.Text; if (cDB.Authenticate(cDB)) { if (txt_newpassword.Text == txt_cnewpassword.Text) { cDB.Password = txt_newpassword.Text; cDB.changemypassword(cDB); MessageBox.Show("Password Changed"); } else { MessageBox.Show("Password Does Not Match"); } } else { MessageBox.Show("Old Password is incorrect"); } }
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); }
private void ViewUser_Load(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); dataGridView1.AutoGenerateColumns = true; cDB.FillGrid(dataGridView1); }
private void btn_delete_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.UserName = cBox_selectuser.Text; cDB.deleteuser(cDB); lbl_message.Text = "User Deleted"; }
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); } }
private void btn_cnewuser_Click(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.name = txt_name.Text; cDB.city = txt_city.Text; cDB.UserName = txt_username.Text; if (txt_password.Text == txt_Confirm_Password.Text) { cDB.Password = txt_password.Text; } cDB.UserType = txt_usertype.Text; if (txt_password.Text == txt_Confirm_Password.Text) { cDB.createnewuser(cDB); MessageBox.Show("New User Created"); } else { MessageBox.Show("Password Does Not Match"); } }
private void DeleteUser_Load(object sender, EventArgs e) { Credential_DB cDB = new Credential_DB(); cDB.fillcombobox(cBox_selectuser); }