public Role GetByIdWithDetails(int id) { Role role = db.Set <Role>(). Include(x => x.RolePrivileges).ThenInclude(x => x.Privilege). Include(x => x.UserRoles).ThenInclude(x => x.User). FirstOrDefault(x => x.Id == id); return(role); }
public List <AbsenceStatus> GetByDate(DateTime startDate, DateTime endDate) { List <AbsenceStatus> absenceStatuses = db.Set <AbsenceStatus>(). Include(x => x.AbsenceType).Include(x => x.User). Where(x => x.StartDate >= startDate && x.StartDate <= endDate || x.EndDate >= startDate && x.EndDate <= endDate || startDate >= x.StartDate && endDate <= x.EndDate).ToList(); return(absenceStatuses); }
public void Remove(RemovableTable removableTable) { db.Set <RemovableTable>().Remove(removableTable); db.SaveChanges(); }
public List <UserRole> GetByUserId(int userId) { return(db.Set <UserRole>().Where(x => x.UserId == userId).ToList()); }
public List <User> GetAll() { return(db.Set <User>().Include(x => x.Department).ToList()); }
public void Update(UpdatableTable updatableTable) { db.Set <UpdatableTable>().Update(updatableTable); db.SaveChanges(); }
public void Add(CreatableTable creatableTable) { db.Set <CreatableTable>().Add(creatableTable); db.SaveChanges(); }
public void AddRange(List <MultipleAddableTable> multipleAddableTables) { db.Set <MultipleAddableTable>().AddRange(multipleAddableTables); db.SaveChanges(); }
public List <RolePrivilege> GetByRoleId(int roleId) { return(db.Set <RolePrivilege>().Where(x => x.RoleId == roleId).ToList()); }
public List <ReadableTable> GetAll() { return(db.Set <ReadableTable>().ToList()); }
public Privilege GetByName(string privilegeName) { return(db.Set <Privilege>().FirstOrDefault(x => x.Name == privilegeName)); }
public void RemoveAll(List <MultipleRemovableTable> multipleRemovableTables) { db.Set <MultipleRemovableTable>().RemoveRange(multipleRemovableTables); db.SaveChanges(); }