public ActionResult Admin()
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
return(View(db.users.ToList()));
}
}
public ActionResult Admin()
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var quoteVMs = new List <QuoteVM>();
foreach (var quote in quoteVMs)
{
var quoteVM = new QuoteVM();
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var userinfos = db.UserInfoes.ToList();
var userinfoVms = new List <UserinfoVm>();
foreach (var userinfo in userinfos)
{
var userinfoVm = new UserinfoVm();
userinfoVm.FirstName = userinfo.FirstName;
userinfoVm.LastName = userinfo.LastName;
userinfoVm.EmailAddress = userinfo.EmailAddress;
userinfoVm.Total = Convert.ToInt32(userinfo.Total);
userinfoVms.Add(userinfoVm);
}
return(View(userinfoVms));
}
}
public ActionResult Admin(QuoteData dB)
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var quotes = new List <AdminVm>();
foreach (var quote in db.QuoteDatas)
{
AdminVm adminVm = new AdminVm();
adminVm.FirstName = quote.FirstName;
adminVm.LastName = quote.LastName;
adminVm.Email = quote.EmailAddress;
adminVm.Quote = Math.Round(quote.Quote, 2);
quotes.Add(adminVm);
}
return(View(quotes));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var quotes = db.VehicleQuotes; // All records in the database
var carQuoteVms = new List <CarQuoteVm>(); // Instantiate and populate list of view models for each record in the db
foreach (var quote in quotes)
{
var carQuoteVm = new CarQuoteVm
{
Id = quote.Id,
FirstName = quote.FirstName,
LastName = quote.LastName,
EmailAddress = quote.EmailAddress,
Quote = quote.Quote
};
carQuoteVms.Add(carQuoteVm);
}
return(View(carQuoteVms));
}
}
public ActionResult GetQuote(string FirstName, string LastName, string EmailAddress, string DOB, string CarMake, string CarYear, string CarModel, string SpeedingTickets, string DUI, string coverage)
{
if (string.IsNullOrEmpty(FirstName) || string.IsNullOrEmpty(LastName) || string.IsNullOrEmpty(EmailAddress) || string.IsNullOrEmpty(DOB) || string.IsNullOrEmpty(CarMake) || string.IsNullOrEmpty(CarYear) || string.IsNullOrEmpty(CarModel) || string.IsNullOrEmpty(SpeedingTickets) || string.IsNullOrEmpty(DUI) || string.IsNullOrEmpty(coverage))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (var db = new InsuranceQuoteEntities())
{
var user = new user();
//Assigning entered info into DB
user.FirstName = FirstName;
user.LastName = LastName;
user.EmailAddress = EmailAddress;
user.DOB = Convert.ToDateTime(DOB);
user.CarMake = CarMake;
user.CarYear = Convert.ToInt32(CarYear);
user.CarModel = CarModel;
user.SpeedingTickets = Convert.ToInt16(SpeedingTickets);
if (DUI == "Yes")
{
user.DUI = true;
}
else
{
user.DUI = false;
}
if (coverage == "FullCoverage")
{
user.FullCoverage = true;
}
// Quote Calculation
double quote = 50;
int age = new DateTime(DateTime.Now.Subtract(Convert.ToDateTime(user.DOB)).Ticks).Year - 1;
if (age < 25 && age > 18 || age > 100)
{
quote += 25;
}
else if (age < 18)
{
quote += 100;
}
if (user.CarYear < 2000 || user.CarYear > 2015)
{
quote += 25;
}
if (user.CarMake == "Porsche")
{
quote += 25;
}
else if (user.CarMake == "Porsche" && user.CarModel == "911 Carrera")
{
quote += 25;
}
quote += Convert.ToInt32(user.SpeedingTickets) * 10;
if (Convert.ToBoolean(user.DUI))
{
quote += quote * 0.25;
}
if (Convert.ToBoolean(user.FullCoverage))
{
quote += quote * 0.5;
}
user.Quote = quote;
db.users.Add(user);
db.SaveChanges();
return(View(user));
}
}
}
public ActionResult Quote(DateTime DateOfBirth, int CarYear, string CarMake, string CarModel,
int SpeedingTickets, string FirstName, string LastName, string Email,
bool DUI = false, bool FullCoverage = false)
{
decimal Quote = 50.0m;
int dob = DateOfBirth.Year;
int thisYear = DateTime.Now.Year;
int birthYear = thisYear - dob;
int age = thisYear = birthYear;
if (age < 18)
{
Quote += 100m;
}
else if (age > 18 && age < 25)
{
Quote += 25m;
}
else if (age > 100)
{
Quote += 25m;
}
if (CarYear < 2000)
{
Quote += 25m;
}
else if (CarYear > 2015)
{
Quote += 25m;
}
if (CarMake == "Porsche")
{
Quote += 25m;
}
if (CarMake == "Porsche" && CarModel == "911 Carrera")
{
Quote += 25m;
}
for (int i = 0; i < SpeedingTickets; i++)
{
Quote += 10m;
}
if (DUI)
{
Quote += (Quote * 0.25m);
}
if (FullCoverage)
{
Quote += (Quote * 0.50m);
}
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var insuranceDb = new QuoteData();
insuranceDb.FirstName = FirstName;
insuranceDb.LastName = LastName;
insuranceDb.EmailAddress = Email;
insuranceDb.DateOfBirth = DateOfBirth;
insuranceDb.CarYear = CarYear;
insuranceDb.CarMake = CarMake;
insuranceDb.CarModel = CarModel;
insuranceDb.SpeedingTickets = SpeedingTickets;
insuranceDb.DUI = DUI;
insuranceDb.FullCoverage = FullCoverage;
insuranceDb.Quote = Quote;
db.QuoteDatas.Add(insuranceDb);
db.SaveChanges();
}
QuoteVm quoteVm = new QuoteVm();
quoteVm.FirstName = FirstName;
quoteVm.LastName = LastName;
quoteVm.Email = Email;
quoteVm.Quote = Math.Round(Quote, 2);
return(View(quoteVm));
}
public ActionResult QuoteRequest(string firstName, string lastName, string emailAddress, DateTime dateOfBirth, int carYear, string carMake, string carModel, bool dui, string speedingTickets, string coverageType)
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
// Map user input to model properties
var quote = new VehicleQuote()
{
FirstName = firstName,
LastName = lastName,
EmailAddress = emailAddress,
DOB = Convert.ToDateTime(dateOfBirth),
CarYear = carYear,
CarMake = carMake,
CarModel = carModel,
DUI = dui,
SpeedingTickets = Convert.ToInt32(speedingTickets),
CoverageType = coverageType,
};
// Calculates insurance quote based on parameters
decimal quoteAmount = 50;
int age = DateTime.Now.Year - quote.DOB.Year;
if (age > 100)
{
quoteAmount += 25;
}
if (age < 25)
{
quoteAmount += 25;
}
if (age < 18)
{
quoteAmount += 75; // This adds to the user being under 25, for a total of $100
}
if (quote.CarYear < 2000 || quote.CarYear > 2015)
{
quoteAmount += 25;
}
if (quote.CarMake.ToLower() == "porsche")
{
quoteAmount += 25;
}
if (quote.CarMake.ToLower() == "porsche" && quote.CarModel.ToLower() == "911 carrera")
{
quoteAmount += 25;
}
if (quote.SpeedingTickets > 0)
{
quoteAmount += quote.SpeedingTickets * 10;
}
if (quote.DUI)
{
quoteAmount += quoteAmount * 25 / 100; // Add 25% to rate if they have a DUI
}
if (quote.CoverageType == "full")
{
quoteAmount += quoteAmount * 50 / 100;
}
quote.Quote = quoteAmount;
db.VehicleQuotes.Add(quote);
db.SaveChanges();
ViewBag.endQuote = quoteAmount.ToString("C"); // Display quote amount to user upon form submission
return(View("Quote"));
}
}
public ActionResult InsuranceQuote(string firstName, string lastName, string emailAddress, DateTime dateOfBirth,
int carYear, string carMake, string carModel, string dui, int speedTicket, string coverage)
{
using (InsuranceQuoteEntities db = new InsuranceQuoteEntities())
{
var userinfo = new UserInfo();
userinfo.FirstName = firstName;
userinfo.LastName = lastName;
userinfo.EmailAddress = emailAddress;
userinfo.DateOfBirth = dateOfBirth;
userinfo.CarYear = carYear;
userinfo.CarMake = carMake;
userinfo.CarModel = carModel;
userinfo.Dui = dui;
userinfo.SpeedTicket = speedTicket;
userinfo.Coverage = coverage;
userinfo.Total = 50;
var today = DateTime.Today;
var age = today.Year - dateOfBirth.Year;
if (age < 25 && age >= 18)
{
userinfo.Total += 25;
}
else if (age < 18)
{
userinfo.Total += 100;
}
else if (age > 100)
{
userinfo.Total += 25;
}
if (userinfo.CarYear < 2000)
{
userinfo.Total += 25;
}
else if (userinfo.CarYear > 2015)
{
userinfo.Total += 25;
}
if (userinfo.CarMake.ToLower() == "porche")
{
userinfo.Total += 25;
}
if (userinfo.CarMake.ToLower() == "porche" && userinfo.CarModel.ToLower() == "911 carrera")
{
userinfo.Total += 25;
}
if (userinfo.SpeedTicket > 0)
{
for (int i = 1; i <= userinfo.SpeedTicket; i++)
{
userinfo.Total += 10;
}
}
if (userinfo.Dui == "Yes")
{
int p = Convert.ToInt32(userinfo.Total) * 25 / 100;
userinfo.Total += p;
}
if (userinfo.Coverage == "Full Coverage")
{
int p = Convert.ToInt32(userinfo.Total) * 50 / 100;
userinfo.Total += p;
}
db.UserInfoes.Add(userinfo);
db.SaveChanges();
return(View("Quote", userinfo));
}
}
