//-------------------------------------------------------------------------------------- //POLICY NEWARAL AND DUE REPORT public ActionResult PolicyDueReport() { ReportFeature report = new ReportFeature(); CustomerpolicyDAORequest request = new CustomerpolicyDAORequest(); List <CustomerpolicyViewModel> list = request.GetLapsePolicy(DateTime.Today); foreach (var item in list) { item.active = false; request.Update(item); } //one month due Policy //date of last month DateTime oneMonthLaterDate = DateTime.Today.AddMonths(1); ViewBag.duePolicy = report.ShowPolicyDue(oneMonthLaterDate); //Lapsed Policy ViewBag.lapsedPolicy = report.ShowLapsedPolicyDue(false); return(View()); }