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()); }