public ActionResult GetObituaries(int CWFuneralHomeId)
        {
            CWFuneralHome cwHome = db.CWFuneralHomes.Find(CWFuneralHomeId);

            if (cwHome != null)
            {
                CompetitorWatchHelper cwHelper = new CompetitorWatchHelper();
                int numOfObitsInserted         = cwHelper.ScrapeObituaries(cwHome);
            }
            else
            {
                return(Json(new { result = "Error with funeral one api" }));
            }

            return(Json(new { result = "success" }));
        }
        public ActionResult Compare(int id, int competitorId)
        {
            CWFuneralHome cwYourHome  = db.CWFuneralHomes.Find(id);
            CWFuneralHome cwTheirHome = db.CWFuneralHomes.Find(competitorId);

            //DateTime old = DateTime.Now.AddYears(-10);
            //CWObituary toDelete = db.CWObituary.Where(d => d.DeathDate < old).FirstOrDefault();
            //db.Entry(toDelete).State = System.Data.Entity.EntityState.Deleted;
            //db.SaveChanges();
            CompareViewModel cvm = new CompareViewModel();

            if (cwYourHome != null && cwTheirHome != null)
            {
                cvm.AvgAge           = cwYourHome.CWObituary.Where(o => o.Age != 0).Average(o => o.Age);
                cvm.CompetitorAvgAge = cwTheirHome.CWObituary.Where(o => o.Age != 0).Average(o => o.Age);
                CompetitorWatchHelper.GenerateCompetiveLineChart(cwYourHome, cwTheirHome, ref cvm);
            }
            return(View(cvm));
        }