public ActionResult Admin() { QuotesEntities db = new QuotesEntities(); var customers = db.Customers; return(View(customers)); }
// GET: Admin public ActionResult Index() { using (QuotesEntities db = new QuotesEntities()) { var carQuotes = db.CarQuotes; var carQuoteVms = new List <CarQuoteVm>(); foreach (var carQuote in carQuotes) { var carQuoteVm = new CarQuoteVm(); carQuoteVm.Id = carQuote.Id; carQuoteVm.FirstName = carQuote.FirstName; carQuoteVm.LastName = carQuote.LastName; carQuoteVm.EmailAddress = carQuote.EmailAddress; carQuoteVm.DateOfBirth = carQuote.DateOfBirth; carQuoteVm.Quote = carQuote.Quote; carQuoteVm.DateOfQuote = carQuote.DateOfQuote; carQuoteVm.CarMake = carQuote.CarMake; carQuoteVm.CarModel = carQuote.CarModel; carQuoteVm.CarYear = carQuote.CarYear; carQuoteVm.DUI = carQuote.DUI; carQuoteVm.NumberOfSpeedingTickets = carQuote.NumberOfSpeedingTickets; carQuoteVm.CoverageType = carQuote.CoverageType; carQuoteVms.Add(carQuoteVm); } return(View(carQuoteVms)); } }
public ActionResult Remove(int Id) { using (QuotesEntities db = new QuotesEntities()) { var quote = db.Quotes.Find(Id); quote.Removed = DateTime.Now; db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult InsuranceQuote(string firstName, string lastName, string emailAddress, DateTime birthDate, int carYear, string carMake, string carModel, bool dui, int speedingTicket, bool fullCoverage, decimal quote) { if (string.IsNullOrEmpty(emailAddress)) { return(View("~/Views/Shared/Error.cshtml")); } else { using (QuotesEntities db = new QuotesEntities()) { quote = 50m; var request = new InsuranceQuote(); request.FirstName = firstName; request.LastName = lastName; request.EmailAddress = emailAddress; request.DateOfBirth = birthDate; int age = Convert.ToInt16(DateTime.Now - birthDate); if (age >= 18 && age <= 25 || age > 100) { quote = quote + 25m; } if (age > 18) { quote = quote + 100m; } request.CarYear = carYear; request.CarMake = carMake; request.CarModel = carModel; request.DUI = dui; request.SpeedingTicket = speedingTicket; request.FullCoverage = fullCoverage; //needs to create formulas for quote here request.Quote = quote; db.InsuranceQuotes.Add(request); db.SaveChanges(); } } return(View("Quote")); }
// GET: Admin public ActionResult Index() { using (QuotesEntities db = new QuotesEntities()) { var quotes = db.Users.ToList(); var quoteVMs = new List <QuoteVM>(); foreach (var quote in quotes) { var quoteVM = new QuoteVM(); quoteVM.Id = quote.Id; quoteVM.FirstName = quote.First_Name; quoteVM.LastName = quote.Last_Name; quoteVM.EmailAddress = quote.Email_Address; quoteVM.Quote = quote.Quote.GetValueOrDefault(); quoteVMs.Add(quoteVM); } return(View(quoteVMs)); } }
// GET: Admin public ActionResult Index() { using (QuotesEntities db = new QuotesEntities()) {; var quotes = db.Quotes; var quoteVms = new List <QuoteVm>(); foreach (var Quotes in quoteVms) { //var is named "Quotes" rather than "Quote" because the title //of the edmx table couldn't be the same as the parameter "Quote". var quoteVm = new QuoteVm(); quoteVm.Id = Quotes.Id; quoteVm.Quote = Convert.ToDouble(Quotes.Quote); quoteVm.FirstName = Quotes.FirstName; quoteVm.LastName = Quotes.LastName; quoteVm.EmailAddress = Quotes.EmailAddress; quoteVms.Add(quoteVm); } return(View(quoteVms)); } }
public ActionResult GetQuote(string firstName, string lastName, string emailAddress, System.DateTime dateOfBirth, int carYear, string carMake, string carModel, string dUIHistory, int totalTickets, string fullCoverage) { int dUI = dUIHistory == "no" ? 0 : 1; int coverage = fullCoverage == "no" ? 0 : 1; myMethods instance = new myMethods(); using (QuotesEntities db = new QuotesEntities()) { var customer = new Customer(); customer.FirstName = firstName; customer.LastName = lastName; customer.EmailAddress = emailAddress; customer.DateOfBirth = dateOfBirth; customer.CarYear = carYear; customer.CarMake = carMake; customer.CarModel = carModel; customer.DUIHistory = dUI; customer.TotalTickets = totalTickets; customer.FullCoverage = coverage; customer.Quote = instance.getQuote(dateOfBirth, carYear, carMake, carModel, totalTickets, dUIHistory, fullCoverage); db.Customers.Add(customer); db.SaveChanges(); } return(Redirect("Admin")); }
public ActionResult Quote(string FirstName, string LastName, string EmailAddress, string DateOfBirth, string CarYear, string CarMake, string CarModel, string SpeedingTickets, string DUI, string Coverage) { if (string.IsNullOrEmpty(FirstName) || string.IsNullOrEmpty(LastName) || string.IsNullOrEmpty(EmailAddress) || string.IsNullOrEmpty(DateOfBirth) || string.IsNullOrEmpty(CarYear) || string.IsNullOrEmpty(CarMake) || string.IsNullOrEmpty(CarModel) || string.IsNullOrEmpty(SpeedingTickets) || string.IsNullOrEmpty(DUI) || string.IsNullOrEmpty(Coverage)) { return(View("~/Views/Shared/Error.cshtml")); } else { DateTime Dob = Convert.ToDateTime(DateOfBirth); int age = 0; age = DateTime.Now.Year - Dob.Year; if (DateTime.Now.DayOfYear < Dob.DayOfYear) { age = age - 1; } double total = 50; bool under25orOver100 = age < 25 || age > 100; if (under25orOver100) { total = total + 25; } bool under18 = age < 18; if (under18) { total = total + 100; } else { total = total; } int carYear = Convert.ToInt32(CarYear); if (carYear < 2000 || carYear > 2015) { total = total + 25; } else { total = total; } if (CarMake == "porsche" || CarMake == "Porsche") { total = total + 25; } else { total = total; } if (CarMake == "porsche" && CarModel == "911 Carrera" || CarMake == "Porsche" && CarModel == "911 Carrera") { total = total + 25; } else { total = total; } int tickets = Convert.ToInt32(SpeedingTickets); int ticketTotal = tickets * 10; total = total + ticketTotal; bool Dui = DUI == "yes" || DUI == "Yes"; if (Dui) { total = total + (total * .25); } else { total = total; } bool FullCoverage = Coverage == "full coverage" || Coverage == "full" || Coverage == "Full Coverage" || Coverage == "Full"; if (FullCoverage) { total = total + (total * .5); } else { total = total; } double Quote = total; ViewBag.Quote = "$" + Quote; using (QuotesEntities db = new QuotesEntities()) { var Quotes = new Quotes(); Quotes.FirstName = FirstName; Quotes.LastName = LastName; Quotes.EmailAddress = EmailAddress; string Quote1 = Convert.ToString(Quote); Quotes.Quote = Quote1; db.Quotes.Add(Quotes); db.SaveChanges(); } return(View("Success")); } }
public ActionResult QuoteInfo(string firstName, string lastName, string emailAddress, DateTime dob, string carYear, string carMake, string carModel, string dui, int speedTickets, string coverage) { decimal total = 50; int age = FindAge(dob); if (age < 18) { total += 100; } else if (age < 25) { total += 25; } else if (age > 100) { total += 25; } int convertedCarYear = Convert.ToInt32(carYear); if (convertedCarYear < 2000) { total += 25; } if (convertedCarYear > 2015) { total += 25; } string lowerCarMake = carMake.ToLower(); if (lowerCarMake == "porsche") { total += 25; } if (lowerCarMake == "porsche" && carModel == "911") { total += 25; } for (int i = 0; i < speedTickets; i++) { total += 10; } if (dui == "Yes") { var totalInt = Convert.ToInt32(total); var answer = totalInt * .25; total += Convert.ToDecimal(answer); } if (coverage == "Full Coverage") { var totalInt = Convert.ToInt32(total); var answer = totalInt * .5; total += Convert.ToDecimal(answer); } // Adds entry to db using (QuotesEntities db = new QuotesEntities()) { var user = new User { First_Name = firstName, Last_Name = lastName, Email_Address = emailAddress, DOB = dob, DUI = dui, Speeding_Tickets = speedTickets, Coverage = coverage, Quote = total }; db.Users.Add(user); db.SaveChanges(); var car = new Car { Car_Make = carMake, Car_Model = carModel, Car_Year = carYear }; db.Cars.Add(car); db.SaveChanges(); return(View(user)); } }
public ActionResult CarQuote(string firstName, string lastName, string emailAddress, string DOB, int carYear, string carMake, string carModel, bool DUI, int numberOfSpeedingTickets, string coverageType) { double quoteFinal = 50; // base price // calculate age and modify quote as needed DateTime dateOfBirth = DateTime.Parse(DOB); DateTime currentDate = DateTime.Now; int age = currentDate.Year - dateOfBirth.Year; if (dateOfBirth.DayOfYear > currentDate.DayOfYear) { age--; } if (age < 25 && age >= 18) { quoteFinal += 25; } if (age < 18) { quoteFinal += 100; } if (age >= 100) { quoteFinal += 25; } // modify quote dependent upon car year if (carYear < 2000) { quoteFinal += 25; } if (carYear >= 2015) { quoteFinal += 25; } // modify quote dependent upon car model if (carMake.ToLower() == "porsche") { quoteFinal += 25; } if (carMake.ToLower() == "porsche" && carModel.ToLower() == "911 carrera") { quoteFinal += 25; } // modify quote dependent upon number of speeding tickets if (numberOfSpeedingTickets > 0) { quoteFinal += 10 * numberOfSpeedingTickets; } // increase price if had DUI in past if (DUI) { quoteFinal *= 1.25; } // increase again if full coverage if (coverageType == "full") { quoteFinal *= 1.5; } ViewBag.Quote = Convert.ToDecimal(quoteFinal); // add to database using (QuotesEntities db = new QuotesEntities()) { var carQuote = new CarQuote(); carQuote.Quote = Convert.ToDecimal(quoteFinal); carQuote.DateOfQuote = currentDate; carQuote.FirstName = firstName; carQuote.LastName = lastName; carQuote.EmailAddress = emailAddress; carQuote.DateOfBirth = dateOfBirth; carQuote.CarMake = carMake; carQuote.CarModel = carModel; carQuote.CarYear = carYear; carQuote.CoverageType = coverageType; carQuote.DUI = DUI.ToString(); carQuote.NumberOfSpeedingTickets = numberOfSpeedingTickets; db.CarQuotes.Add(carQuote); db.SaveChanges(); } return(View()); }
public ActionResult ProcessQuote(string firstName, string lastName, string emailAddress, DateTime dateOfBirth, int carYear, string carMake, string carModel, bool?DUI, int speedingTickets, bool?coverageType) { using (QuotesEntities db = new QuotesEntities()) { var Quotes = new Insuree(); Quotes.FirstName = firstName; Quotes.LastName = lastName; Quotes.EmailAddress = emailAddress; Quotes.DateOfBirth = dateOfBirth; Quotes.CarYear = carYear; Quotes.CarMake = carMake; Quotes.CarModel = carModel; if (Request.Form["DUI"] == "Yes") { Quotes.DUI = true; } else { Quotes.DUI = false; } Quotes.SpeedingTickets = speedingTickets; if (Request.Form["CoverageType"] == "Full Coverage") { Quotes.CoverageType = true; } else { Quotes.CoverageType = false; } db.Insurees.Add(Quotes); db.SaveChanges(); var quoteProcessed = new QuotesProcessed(); var quotesProcessed = new List <QuotesProcessed>(); int finalQuote = 50; CarQuote.CalculateQuote(Quotes, out finalQuote); quoteProcessed.FirstName = Quotes.FirstName; quoteProcessed.LastName = Quotes.LastName; quoteProcessed.EmailAddress = Quotes.EmailAddress; quoteProcessed.DateOfBirth = Quotes.DateOfBirth; quoteProcessed.CarYear = Quotes.CarYear; quoteProcessed.CarMake = Quotes.CarMake; quoteProcessed.CarModel = Quotes.CarModel; quoteProcessed.DUI = Quotes.DUI; quoteProcessed.SpeedingTickets = Quotes.SpeedingTickets; quoteProcessed.CoverageType = Quotes.CoverageType; quoteProcessed.FinalQuote = finalQuote; quotesProcessed.Add(quoteProcessed); return(View("YourQuote", quotesProcessed)); } }