//Lấy role người dùng
public string getRole(string id_dn)
{
try
{
NGUOIDUNGNHOMNGUOIDUNG nd = quanLyKho.NGUOIDUNGNHOMNGUOIDUNGs.FirstOrDefault(s => s.ID_DN == id_dn);
NHOMNGUOIDUNG nhomND = quanLyKho.NHOMNGUOIDUNGs.FirstOrDefault(s => s.ID_NHOM == nd.ID_NHOM);
return(nhomND.TENNHOM);
}
catch
{
return(null);
}
}
public bool suaNhomNguoiDung(string id, string tennhom)
{
try
{
NHOMNGUOIDUNG mh = quanLyKho.NHOMNGUOIDUNGs.Where(s => s.ID_NHOM == id).FirstOrDefault();
mh.TENNHOM = tennhom;
quanLyKho.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool xoaNhomNguoiDung(string id)
{
try
{
NHOMNGUOIDUNG mh = quanLyKho.NHOMNGUOIDUNGs.Where(s => s.ID_NHOM == id).FirstOrDefault();
quanLyKho.NHOMNGUOIDUNGs.DeleteOnSubmit(mh);
quanLyKho.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//public dynamic load_NhomND()
//{
// var c = (from mh in db.MANHINHs join pq in db.PHANQUYENs
// on mh.MAMANHINH equals pq.MAMANHINH
// select new { mh.MAMANHINH, mh.TENMANHINH, pq.COQUYEN });
// return c;
//}
//public bool themNhomNguoiDung(string manhom, string tennhom)
//{
// try
// {
// NHOMNGUOIDUNG nhomND = new NHOMNGUOIDUNG();
// nhomND.MANHOM = manhom;
// nhomND.TENNHOM = tennhom;
// db.NHOMNGUOIDUNGs.InsertOnSubmit(nhomND);
// db.SubmitChanges();
// return true;
// }
// catch
// {
// return false;
// }
//}
public bool xoaNhomNguoiDung(string manhom)
{
try
{
NHOMNGUOIDUNG nhomND = (from nd in db.NHOMNGUOIDUNGs
where nd.MANHOM == manhom
select nd).First();
db.NHOMNGUOIDUNGs.DeleteOnSubmit(nhomND);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool themNhomNguoiDung(string id, string tennhom)
{
try
{
NHOMNGUOIDUNG mh = new NHOMNGUOIDUNG();
mh.ID_NHOM = id;
mh.TENNHOM = tennhom;
quanLyKho.NHOMNGUOIDUNGs.InsertOnSubmit(mh);
quanLyKho.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool capNhatNhomQuyen(int maNhom, string tenNhom)
{
try
{
NHOMNGUOIDUNG nnd = new NHOMNGUOIDUNG();
nnd = _qllk.NHOMNGUOIDUNGs.Where(t => t.ID == maNhom).FirstOrDefault();
if (nnd != null)
{
nnd.TenGoi = tenNhom;
_qllk.SubmitChanges();
return(true);
}
return(false);
}
catch
{
return(false);
}
}
