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