public DtoEmployee[] GetAllEmployees() { using (var db = new KadrDataContext()) { return (db.FactStaffs.Where(w => w.DateEnd == null || w.DateEnd > DateTime.Today).Select( s => DtoClassConstructor.DtoEmployee(s.Employee)).Distinct().ToArray()); } }
public DtoEmployee[] GetDepartmentEmployees(int idDepartment) { using (var db = new KadrDataContext()) { return (db.FactStaffs.Where(w => w.PlanStaff.idDepartment == idDepartment && (w.DateEnd == null || w.DateEnd > DateTime.Today)).Select( s => DtoClassConstructor.DtoEmployee(s.Employee)).Distinct().ToArray()); } }