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