public bool DeleteRisk(Risk risk)
{
SqlForRisk sqlForRisk = new SqlForRisk();
bool ok = sqlForRisk.DeleteRisk(risk);
return(ok);
}
public bool InsertRisk(Risk risk)
{
SqlForRisk sqlForRisk = new SqlForRisk();
bool ok = sqlForRisk.InsertRisk(risk, CurrentUser);
return(ok);
}
public bool UpdateRisk(Risk risk)
{
SqlForRisk sqlForRisk = new SqlForRisk();
bool ok = sqlForRisk.UpdateRisk(risk, CurrentUser);
return(ok);
}
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());
}
