private void changePasswordToolStripMenuItem_Click(object sender, EventArgs e) { objCP = new Login_CP_02b(); objCP.txtUsername.Text = staffID; objCP.state = "Reset_Password"; objCP.Closed += new EventHandler(objCP_Closed); objCP.Show(); }
private void linkForgotPW_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { adminMaster.errObj.txtBtnClicks.Text += "\n" + MethodBase.GetCurrentMethod().Name; if (c.cnn.State != ConnectionState.Open) { c.cnn.Close(); c.cnn.Open(); } c.cmd.CommandText = "select count(*) from LoginTable where staffid='" + txtUsername.Text + "'"; if ((int)c.cmd.ExecuteScalar() <= 0) { txtUsername.Focus(); lblError.Text = "Username not found!"; Interaction.Beep(); return; } Login_CP_02b objChangePassword = new Login_CP_02b(); objChangePassword.state = "Reset_Password"; objChangePassword.txtUsername.Text = txtUsername.Text; objChangePassword.Show(); }
private void btnLogin_Click(object sender, EventArgs e) { adminMaster.errObj.txtBtnClicks.Text += "\n" + MethodBase.GetCurrentMethod().Name; try { if (c.cnn.State != ConnectionState.Open) { c.cnn.Close(); c.cnn.Open(); } c.cmd.CommandText = "select count(*) from LoginTable where staffid='" + txtUsername.Text + "'"; if ((int)c.cmd.ExecuteScalar() <= 0) { txtUsername.Focus(); lblError.Text = "Username not found!"; Interaction.Beep(); return; } else { c.cmd.CommandText = "select resetpassword from LoginTable where staffid=@staffid"; c.cmd.Parameters.Clear(); c.cmd.Parameters.Add("@staffid", SqlDbType.VarChar).Value = txtUsername.Text; string resetpassword = (string)c.cmd.ExecuteScalar(); switch (resetpassword) { case "Reset_Full": Login_CP_02b objCPFull = new Login_CP_02b(); objCPFull.state = "Reset_Full"; objCPFull.txtUsername.Text = txtUsername.Text; objCPFull.Show(); break; case "Reset_Password": Login_CP_02b objChangePassword = new Login_CP_02b(); objChangePassword.state = "Reset_Password"; objChangePassword.txtUsername.Text = txtUsername.Text; objChangePassword.Show(); break; case "Not_Required": c.cmd.CommandText = "select count(*) from LoginTable where staffid=@staffid and password=@password"; c.cmd.Parameters.Clear(); c.cmd.Parameters.Add("@staffid", SqlDbType.VarChar).Value = txtUsername.Text; c.cmd.Parameters.Add("@password", SqlDbType.VarBinary).Value = ConvertToByteArray(txtpword.Text); if ((int)c.cmd.ExecuteScalar() > 0) { this.Hide(); adminMaster.staffID = txtUsername.Text; adminMaster.Show(); adminMaster.Closed += new EventHandler(adminMaster_Closed); } else { txtpword.Clear(); lblError.Text = "Wrong Password!"; } break; default: MessageBox.Show(""); break; } } } catch (Exception ex) { this.Hide(); adminMaster.errObj.txtException.Text += ex.ToString(); adminMaster.errObj.Show(); } finally { c.cnn.Close(); } }