public List <clsTaiKhoan> List_SelectTaiKhoan()
{
List <clsTaiKhoan> list = new List <clsTaiKhoan>();
try
{
dt = dh.ExecuteDataSet("usp_TAIKHOAN_Select", new SqlParameter[0]).Tables[0];
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
clsTaiKhoan us = new clsTaiKhoan
{
MaNV = dr["MANV"] == DBNull.Value ? "" : dr["MANV"].ToString(),
MatKhau = dr["MATKHAU"] == DBNull.Value ? "" : dr["MATKHAU"].ToString(),
QuanLy = dr["ADM"] == DBNull.Value ? false : bool.Parse(dr["ADM"].ToString()),
};
list.Add(us);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public bool ThemTaiKhoan(clsTaiKhoan tkAdd)
{
System.Data.Common.DbTransaction suaTran = db.Connection.BeginTransaction();
try
{
db.Transaction = suaTran;
src.DAOs.DB_QLTD.tblTAIKHOAN tk = new DAOs.DB_QLTD.tblTAIKHOAN();
//vt.MaVT = 12;
tk.ID_NV = tkAdd._Id_NV;
tk.Usernames = tkAdd._StrUsername;
tk.Passwords = tkAdd._StrPassWord;
tk.MaRole_R = tkAdd._MaRole;
db.tblTAIKHOANs.InsertOnSubmit(tk);
db.SubmitChanges();
db.Transaction.Commit();
return(true);
}
catch
{
db.Transaction.Rollback();
return(false);
}
}
