public StaffDTO login(string id, string pw)
{
StaffDTO staff = new StaffDTO();
string cmd = "SP_CHK_LOGIN_NHANVIEN";
SqlCmd = new SqlCommand(cmd, SqlCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter username = new SqlParameter("@TENDN", SqlDbType.NVarChar, 100, "TENDN");
username.IsNullable = false;
username.Direction = ParameterDirection.Input;
username.Value = id;
SqlCmd.Parameters.Add(username);
SqlParameter password = new SqlParameter("@MATKHAU", SqlDbType.VarChar, 100, "MATKHAU");
password.IsNullable = false;
password.Direction = ParameterDirection.Input;
password.Value = pw;
SqlCmd.Parameters.Add(password);
ArrayList list = executeQueryArrayList(1);
int n = list.Count;
if (n == 0)
return null;
return (StaffDTO)list[0];
}
public override object convertOneRowIntoADTO(DataTable dt, int i, int type = 0)
{
StaffDTO obj = new StaffDTO();
if (type == 0)
{
obj.StaffID = dt.Rows[i]["MANV"].ToString();
obj.StaffName = dt.Rows[i]["HOTEN"].ToString();
obj.Email = dt.Rows[i]["EMAIL"].ToString();
obj.Salary = Int32.Parse(dt.Rows[i]["LUONG_CB"].ToString());
}
else if (type == 1)
{
obj.StaffID = dt.Rows[i]["MANV"].ToString();
obj.Username = dt.Rows[i]["TENDN"].ToString();
obj.Password = Encoding.ASCII.GetString((byte[])dt.Rows[i]["MATKHAU"]);
}
return obj;
}
