public NHOMQUYEN LayNhomQuyen(NGUOIDUNG user)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = (from s in db.NHOMQUYENs
where s.MaNhomQuyen == user.MaNhomQuyen
select s).FirstOrDefault();
return(x);
}
}
catch (Exception)
{
return(null);
}
}
public bool Update(NGUOIDUNG item)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.NGUOIDUNGs
where s.ID == item.ID
select s;
var sv = x.FirstOrDefault();
if (sv != null)
{
if (sv.MaDangNhap.CompareTo(item.MaDangNhap) != 0)
{
var y = from s in db.NGUOIDUNGs
where s.MaDangNhap == item.MaDangNhap
select s;
var svy = x.FirstOrDefault();
if (svy != null)
{
return(false);
}
}
sv.MaDangNhap = item.MaDangNhap;
sv.MatKhau = item.MatKhau;
sv.HoTen = item.HoTen;
sv.Email = item.Email;
sv.SoDT = item.SoDT;
sv.MaNhomQuyen = item.MaNhomQuyen;
db.SaveChanges();
return(true);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Insert(NGUOIDUNG item)
{
try
{
using (var db = new QLPhongKaraokeEntities())
{
var x = from s in db.NGUOIDUNGs
where s.MaDangNhap == item.MaDangNhap
select s;
var sv = x.FirstOrDefault();
if (sv == null)
{
db.NGUOIDUNGs.Add(item);
db.SaveChanges();
return(true);
}
return(false);//trung username
}
}
catch (Exception)
{
return(false);
}
}