// GET: Admin public ActionResult Admin() { using (InsuranceEntities db = new InsuranceEntities()) { var insurees = (from x in db.Insurees select x).ToList(); var insureeVms = new List <InsureeVm>(); foreach (var insuree in insurees) { var insureeVm = new InsureeVm(); insureeVm.Id = insuree.Id; insureeVm.FirstName = insuree.FirstName; insureeVm.LastName = insuree.LastName; insureeVm.EmailAddress = insuree.EmailAddress; insureeVm.Quote = insuree.Quote; } return(View(insureeVms)); } }
// GET: Admin public ActionResult Index() { using (Insurance_5Entities db = new Insurance_5Entities()) { //var signups = db.SignUps.Where(x => x.Removed == null).ToList(); // var signups = (from c in db.SignUps where c.Removed == null select c).ToList(); var insures = db.Insurees; var InsureVms = new List <InsureeVm>(); foreach (var insur in insures) { var insureVm = new InsureeVm(); insureVm.Id = insur.Id; insureVm.FirstName = insur.FirstName; insureVm.LastName = insur.LastName; insureVm.EmailAddress = insur.EmailAddress; insureVm.Quote = insur.Quote; InsureVms.Add(insureVm); } return(View(InsureVms)); } }
// GET: Admin public ActionResult Index() { using (InsuranceEntities db = new InsuranceEntities()) { var insurees = db.Tables.Where(x => x.Removed == null).ToList(); //ViewModel var insureeVms = new List <InsureeVm>(); foreach (var insuree in insurees) { var insureeVm = new InsureeVm(); insureeVm.Id = insuree.Id; insureeVm.Quote = insuree.Quote; insureeVm.FirstName = insuree.FirstName; insureeVm.LastName = insuree.LastName; insureeVm.EmailAddress = insuree.EmailAddress; insureeVms.Add(insureeVm); } return(View(insureeVms)); } }
// GET: Admin public ActionResult Index() { using (InsuranceEntities db = new InsuranceEntities()) { // setting up access to database list var insurees = db.Tables.ToList(); // empty list to add all info into later and then return to vies var insureeVms = new List <InsureeVm>(); // for each loop foreach (var insuree in insurees) { insuree.Quote = 50; var insureeVm = new InsureeVm(); // checking insuree age. if 18 or below, goes through first if, if 19-25, goes through else if, all others goes through final else var insureeAge = (insuree.DateOfBirth - DateTime.Now).TotalDays / 365; if (insureeAge < 19) { insuree.Quote += 100; } else if (insureeAge >= 19 && insureeAge < 26) { insuree.Quote += 50; } else { insuree.Quote += 25; } // checks if car year is below 200 or above 2015 if (insuree.CarYear < 2000 || insuree.CarYear > 2015) { insuree.Quote += 25; } //checks car make and model for porsche and carerra if (insuree.CarMake == "Porsche" && insuree.CarModel == "911 Carerra") { insuree.Quote += 50; } else if (insuree.CarMake == "Porsche") { insuree.Quote += 25; } // checks if speedingtickets are greater than zero, then adds 10 times how many tickets to the quote total if (insuree.SpeedingTickets > 0) { insuree.Quote += 10 * insuree.SpeedingTickets; } //if user had DUI, multiplies quote value and sets it to that if (insuree.DUI == true) { insuree.Quote *= (Decimal)1.25; } // if user selects full coverage, adds 50% to total if (insuree.CoverageType == true) { insuree.Quote *= (Decimal)1.5; } insureeVm.FirstName = insuree.FirstName; insureeVm.LastName = insuree.LastName; insureeVm.EmailAddress = insuree.EmailAddress; insureeVm.Quote = insuree.Quote; insureeVms.Add(insureeVm); } return(View(insureeVms)); } }