public IEnumerable <CommonResearch> AllNegativeSortedByStainAndOrgan() { var stains = stainRepo.GetStains(); var organs = organRepo.GetOrgans(); var reports = reportRepo.GetAllNegativeReports(); var sorted = new List <CommonResearch>(); foreach (var s in stains) { foreach (var o in organs) { var item = new CommonResearch { Stain = s.Name, Organ = o.Name, Number = 0 }; foreach (var r in reports) { if (r.StainName == item.Stain && r.OrganName == item.Organ) { item.Number++; } } if (item.Number != 0) { sorted.Add(item); } } } return(sorted); }
public IEnumerable <CommonResearch> CommonReportPositive() { var stains = stainRepo.GetStains(); var organs = organRepo.GetOrgans(); var tissues = tissueRepo.GetTissues(); var reports = reportRepo.GetAllPositiveReports(); var sorted = new List <CommonResearch>(); foreach (var s in stains) { foreach (var o in organs) { foreach (var t in tissues) { var item = new CommonResearch { Stain = s.Name, Organ = o.Name, Tissue = t.Name, Number = 0 }; foreach (var r in reports) { if (r.StainName == item.Stain && r.OrganName == item.Organ && r.TissueName == item.Tissue) { item.Number++; } } if (item.Number != 0) { sorted.Add(item); } } } } return(sorted); }