public ActionResult Index(string reference, string name, string telephone, string renewalDate, string lastAnnualPremium, string thisYearsPremium, string alternativePremium, string claimsMade, string premium, string quoteSource, string quoteDate, string coverDate) { ViewBag.Reference = reference; ViewBag.name = name; ViewBag.telephone = telephone; ViewBag.renewalDate = renewalDate; ViewBag.lastAnnualPremium = lastAnnualPremium; ViewBag.thisYearsPremium = thisYearsPremium; ViewBag.alternativePremium = alternativePremium; ViewBag.claimsMade = claimsMade; ViewBag.premium = premium; ViewBag.quoteSource = quoteSource; ViewBag.quoteDate = quoteDate; ViewBag.coverDate = coverDate; Phone_SystemEntities30 db = new Phone_SystemEntities30(); CallOutcome model = new CallOutcome { Outcomes = new SelectList(db.CallOutcomeLists.ToList(), "OutcomeID", "Name") }; return(View(model)); }
public ActionResult RenewalsReturned(string Lowerdate, string Upperdate) { Phone_SystemEntities30 _contextTwo = new Phone_SystemEntities30(); DateTime lowerdate = Convert.ToDateTime(Lowerdate); DateTime upperdate = Convert.ToDateTime(Upperdate); IEnumerable renewals = _contextTwo.pr_RenewalListtest(lowerdate, upperdate); return(View(renewals)); }
public ActionResult RetrieveClient(string reference) { Phone_SystemEntities30 db = new Phone_SystemEntities30(); pr_RenewalListtest_Result model = new pr_RenewalListtest_Result(); var dateOne = DateTime.Now; var datethree = dateOne.AddYears(100); var datetwo = dateOne.AddYears(-30); model = db.pr_RenewalListtest(datetwo, datethree).Where(x => x.Reference == reference).FirstOrDefault(); return(View("RetrieveClient", model)); }
public ActionResult Index(CallOutcome model) { Phone_SystemEntities30 db = new Phone_SystemEntities30(); if (!ModelState.IsValid) { model.Outcomes = new SelectList(db.CallOutcomeLists.ToList(), "OutcomeID", "Name"); return(View(model)); } string reference = model.Reference; CallOutcome model2 = db.CallOutcomes.FirstOrDefault(x => x.Reference == reference); if (model2 == null) { model.LastCalled = DateTime.Now; db.CallOutcomes.Add(model); db.SaveChanges(); model.Outcomes = new SelectList(db.CallOutcomeLists.ToList(), "OutcomeID", "Name"); ViewBag.Message = "Client Record Updated"; return(Redirect("~/Home/Index")); } if (model.Reference == model2.Reference) { model.Reference = model2.Reference; model.Id = model2.Id; model.LastCalled = DateTime.Now; db.CallOutcomes.Add(model); db.CallOutcomes.Remove(model2); db.SaveChanges(); } return(Redirect("~/Home/Index")); }