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));
}
}
