private void ActiveChildFrm_ChangePassword(string name)
{
foreach (Form Frm_ChangePassword in this.MdiChildren)
{
if (Frm_ChangePassword.Name == name)
{
Frm_ChangePassword.Activate();
break;
}
}
}
public void DoiPW()
{
try
{
sqlcon.Open();
string id = txtTenDangNhap.Text.ToUpper().Trim();
if (id != null) // Textbox không bỏ trống
{
string sql = "Select Count(*) From [KTPM].[dbo].[Info_Secret] Where ID_Emp=@id COLLATE SQL_Latin1_General_CP1_CS_AS";
SqlCommand cmd = new SqlCommand(sql, sqlcon);
cmd.Parameters.Add(new SqlParameter("@id", id));
int x = (int)cmd.ExecuteScalar();
if (x == 1) // đúng id thì mới mở form đổi mật khẩu
{
this.Hide();
Frm_ChangePassword change = new Frm_ChangePassword(txtTenDangNhap.Text);
change.Show();
}
else
{
PassFlag = false;
MessageBox.Show("Wrong log in information. \n Please try again!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
PassFlag = false;
errorProvider1.SetError(txtTenDangNhap, "Do not accept blank fields !");
}
}
catch (Exception)
{
PassFlag = false;
MessageBox.Show("Error connection!", "Try Again");
}
finally
{
sqlcon.Close();
}
}
