public void InsertUpdate()
{
KhachSanContext context = new KhachSanContext();
context.Accounts.AddOrUpdate(this);
context.SaveChanges();
}
public static void Delete(int id)
{
KhachSanContext context = new KhachSanContext();
Account ac = context.Accounts.Where(p => p.STT == id).FirstOrDefault();
try
{
context.Accounts.Remove(ac);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public static List <DTO_Account> GetAllAccount()
{
KhachSanContext context = new KhachSanContext();
var query = (from n in context.Accounts
select new DTO_Account
{
STT = n.STT,
CMND = n.CMND,
TenDangNhap = n.TenDangNhap,
MatKhau = n.MatKhau,
ChucVu = n.ChucVu,
});
return(query.ToList());
}
public static void Delete(int cmnd)
{
KhachSanContext context = new KhachSanContext();
User u = context.Users.Where(p => p.CMND == cmnd).FirstOrDefault();
try
{
context.Users.Remove(u);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
public static List <DTO_User> GetAllUser()
{
KhachSanContext context = new KhachSanContext();
var query = (from n in context.Users
select new DTO_User
{
SDT = n.SDT,
DiaChi = n.DiaChi,
CMND = n.CMND,
HoTen = n.HoTen,
Sex = n.GioiTinh,
NgaySinh = n.NgaySinh,
});
return(query.ToList());
}
public static Account GetAccount(int idAccount)
{
KhachSanContext context = new KhachSanContext();
return(context.Accounts.Where(p => p.STT == idAccount).FirstOrDefault());
}
public static List <Account> GetAll()
{
KhachSanContext context = new KhachSanContext();
return(context.Accounts.ToList());
}
public static User GetUser(int cmnd)
{
KhachSanContext context = new KhachSanContext();
return(context.Users.Where(p => p.CMND == cmnd).FirstOrDefault());
}
public static List <User> GetAll()
{
KhachSanContext context = new KhachSanContext();
return(context.Users.ToList());
}
