public UserProject[] GetUsersWithProjects() { SqlForUserProject sqlForUserProject = new SqlForUserProject(); var result = sqlForUserProject.SelectAll(); return(result); }
public Risk[] GetRisks() { SqlForUserDepartment sqlForUserDepartment = new SqlForUserDepartment(); var departments = sqlForUserDepartment.SelectAllByAppUser(CurrentUser); var projects = new List <Project>(); SqlForProject sqlForProject = new SqlForProject(); foreach (UserDepartment department in departments) { var t = sqlForProject.SelectByDepartment(department.Department); projects.AddRange(t); } SqlForUserProject sqlForUserProject = new SqlForUserProject(); projects.AddRange(sqlForUserProject.SelectAllByAppUser(CurrentUser).Select(x => x.Project)); projects = projects.Distinct().ToList(); var risks = new List <Risk>(); SqlForRisk sqlForRisk = new SqlForRisk(); foreach (Project project in projects) { var t = sqlForRisk.SelectByProject(project); risks.AddRange(t); } IEqualityComparer <Risk> comparer = new ModelsComparer(); risks = risks.Distinct(comparer).ToList(); return(risks.ToArray()); }
public Project[] GetUserProjects() { if (CurrentUser == null) { return(null); } SqlForUserProject sqlForUserProject = new SqlForUserProject(); UserProject[] up = sqlForUserProject.SelectAllByAppUser(CurrentUser); var result = up.Select(x => x.Project); return(result.ToArray()); }