public void changePass(String OldPass, String NewPass, String RNewPass)
{
Datalayer dl = new Datalayer();
MySqlDataReader dr = dl.Select("cond", "account", "SSN", Global.GlobalVar);
if (dr.Read())
{
if (!dr["Password"].Equals(OldPass))
{
MessageBox.Show("Wrong Password Input");
dr.Close();
return;
}
else
{
if (!NewPass.Equals(RNewPass))
{
MessageBox.Show("New Password Not Equal The Renter Password");
dr.Close();
return;
}
else
{
dr.Close();
dl.changePass(NewPass);
MessageBox.Show("Password Updated Successfully");
}
}
}
dr.Close();
return;
}
public MySqlDataReader Select(String type, String table, String col, String val)
{
Datalayer dl = new Datalayer();
MySqlDataReader dr = dl.Select(type, table, col, val);
return(dr);
}
public bool IsSSNExist(String CustomerSSN)
{
Datalayer dl = new Datalayer();
MySqlDataReader dr = dl.Select(null, "customer", "SSN", CustomerSSN);
if (dr.Read())
{
return(true);
}
else
{
return(false);
}
}
