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