// GET: Admin
public ActionResult Index()
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var quotes = db.Quotes.ToList();
var quoteVms = new List <QuoteVm>();
foreach (var quote in quotes)
{
var quoteVm = new QuoteVm();
quoteVm.Id = quoteVm.Id;
quoteVm.FirstName = quote.FirstName;
quoteVm.LastName = quote.LastName;
quoteVm.EmailAddress = quote.EmailAddress;
quoteVm.DateOfBirth = quote.DateOfBirth.Value;
quoteVm.CarYear = quote.CarYear;
quoteVm.CarMake = quote.CarMake;
quoteVm.CarModel = quote.CarModel;
quoteVm.DUIStatus = quote.DUIStatus;
quoteVm.SpeedingTicketNum = Convert.ToInt32(quote.SpeedingTicketNum);
quoteVm.TypeOfCoverage = quote.TypeOfCoverage;
quoteVm.CustomerQuote = quote.CustomerQuote;
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
public static List <CarMakeVm> GetCarMakeList()
{
var carmakes = new List <CarMakeVm>();
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
foreach (var cm in db.carmakes)
{
CarMakeVm make = new CarMakeVm();
make.id = cm.Id;
make.car_make = cm.car_make;
carmakes.Add(make);
}
}
return(carmakes);
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
List <Quote> quotes = db.Quotes.Where(x => x.Quote1 != null).ToList();
var quoteVms = new List <QuoteVm>();
foreach (var quote in quotes)
{
var quoteVm = new QuoteVm();
quoteVm.FirstName = quote.FirstName;
quoteVm.LastName = quote.LastName;
quoteVm.EmailAddress = quote.EmailAddress;
quoteVm.Quote = Convert.ToString(quote.Quote1);
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
public List <AdminQuoteListVm> GetQuoteList(int limit = 20)
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var quotes = db.quotes.OrderByDescending(x => x.Id).Take(limit);
//var quotes = (from x in db.quotes orderby x.Id descending select x).Take(limit);
var quotelistVm = new List <AdminQuoteListVm>();
foreach (var quote in quotes)
{
var quoteVm = new AdminQuoteListVm();
quoteVm.id = quote.Id;
quoteVm.fname = quote.fname;
quoteVm.lname = quote.lname;
quoteVm.email = quote.email;
quoteVm.premium = (int)quote.premium;
quotelistVm.Add(quoteVm);
}
return(quotelistVm);
}
}
private static void AddQuoteToDb(Quote quote)
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var addquote = new quote();
addquote.fname = quote.fname;
addquote.lname = quote.lname;
addquote.email = quote.email;
addquote.dob = new DateTime(quote.doby, quote.dobm, quote.dobd);
addquote.car_year = (short)quote.caryear;
addquote.car_make = quote.carmake;
addquote.car_model = quote.carmodel;
addquote.had_dui = (quote.dui == 1) ? true : false;
addquote.sp_ticket = (short)quote.tickets;
addquote.coverage = quote.coverage;
addquote.premium = quote.premium;
db.quotes.Add(addquote);
db.SaveChanges();
}
}
public ActionResult Admin()
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var app = db.applications;
var apps = new List <application>();
foreach (var application in app)
{
var a = new application();
a.FirstName = application.FirstName;
a.LastName = application.LastName;
a.EmailAddress = application.EmailAddress;
a.Quote = application.Quote;
apps.Add(a);
}
return(View(apps));
}
}
public ActionResult Quote(string firstName, string lastName, string emailAddress, DateTime dateOfBirth, string carYear,
string carMake, string carModel, string duiStatus, int speedingTicketNum, string typeOfCoverage)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var quote = new Quote();
quote.FirstName = firstName;
quote.LastName = lastName;
quote.EmailAddress = emailAddress;
quote.DateOfBirth = Convert.ToDateTime(dateOfBirth);
quote.CarYear = carYear;
quote.CarMake = carMake;
quote.CarModel = carModel;
quote.DUIStatus = duiStatus;
quote.SpeedingTicketNum = speedingTicketNum.ToString();
quote.TypeOfCoverage = typeOfCoverage;
Calculation result = new Calculation();
quote.CustomerQuote = result.CalculateQuote(firstName, lastName, emailAddress, dateOfBirth, carYear, carMake, carModel, duiStatus, speedingTicketNum, typeOfCoverage);
db.Quotes.Add(quote);
db.SaveChanges();
var displayQuoteVm = new DisplayQuoteVm();
displayQuoteVm.CustomerQuote = result.CalculateQuote(firstName, lastName, emailAddress, dateOfBirth, carYear, carMake, carModel, duiStatus, speedingTicketNum, typeOfCoverage);
return(View("QuoteDisplay", displayQuoteVm));
}
}
}
public ActionResult GetQuote(string firstName, string lastName, string emailAddress,
string dOB, string carYear, string carMake, string carModel,
string tickets, string dUI, string insType)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) ||
string.IsNullOrEmpty(emailAddress) || string.IsNullOrEmpty(dOB) ||
string.IsNullOrEmpty(carYear) || string.IsNullOrEmpty(carMake) ||
string.IsNullOrEmpty(carModel) || string.IsNullOrEmpty(tickets) ||
string.IsNullOrEmpty(dUI) || string.IsNullOrEmpty(insType))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var quote = new Quote();
quote.FirstName = firstName;
quote.LastName = lastName;
quote.EmailAddress = emailAddress;
quote.DOB = Convert.ToDateTime(dOB);
quote.CarYear = Convert.ToInt32(carYear);
quote.CarMake = carMake;
quote.CarModel = carModel;
quote.Tickets = Convert.ToInt32(tickets);
quote.DUI = dUI;
quote.InsType = insType;
var today = DateTime.Now;
var age = today.Year - quote.DOB.Year;
decimal x = 50 + (10 * quote.Tickets);
if (age < 18)
{
x = x + 100;
}
else if (age < 18)
{
x = x + 25;
}
else if (age > 100)
{
x = x + 100;
}
if (quote.CarYear < 2000)
{
x = x + 25;
}
if (quote.CarYear > 2015)
{
x = x + 25;
}
if (quote.CarMake == "Porsche")
{
x = x + 25;
}
if (quote.CarMake == "Porsche" && quote.CarModel == "911 Carrera")
{
x = x + 25;
}
if (quote.DUI == "yes")
{
x = x + (x / 4);
}
if (quote.InsType == "full")
{
x = x + (x / 2);
}
quote.Quote1 = x;
db.Quotes.Add(quote);
db.SaveChanges();
int userid = quote.Id;
return(RedirectToAction("Success", new { Id = userid }));
}
//var quoteVMs = new List<QuoteVm>();
//foreach (var quote in quoteVMs)
//{
// var quoteVM = new QuoteVm();
// quoteVM.ID = quote.ID;
// quoteVM.FirstName = quote.FirstName;
// quoteVM.LastName = quote.LastName;
// quoteVM.Quote = quote.Quote;
// quoteVMs.Add(quoteVM);
// lastQuote = Convert.ToString(quote.Quote);
//}
}
}
public ActionResult Quote(string firstName, string lastName, string emailAddress, DateTime dob,
string carYear, string carMake, string carModel, bool dui, string speeding, string covrage)
{
using (InsuranceQuotesEntities db = new InsuranceQuotesEntities())
{
var app = new application();
app.FirstName = firstName;
app.LastName = lastName;
app.EmailAddress = emailAddress;
app.DateOfBirth = dob;
app.CarYear = Convert.ToInt32(carYear);
app.CarMake = carMake;
app.CarModel = carModel;
app.DUI = dui;
app.SpeedingTickets = Convert.ToInt32(speeding);
app.Coverage = covrage;
double quote = 50;
int month = app.DateOfBirth.Value.Month - DateTime.Now.Month;
int age = DateTime.Now.Year - app.DateOfBirth.Value.Year;
if (month > 0)
{
age--;
}
if (age < 25 || age > 100)
{
if (age < 18)
{
quote += 100;
}
else
{
quote += 25;
}
}
if (app.CarYear < 2000 || app.CarYear > 2015)
{
quote += 25;
}
if (app.CarMake.ToLower() == "porsche")
{
quote += 25;
if (app.CarModel.ToLower() == "911 carrera" || app.CarModel.ToLower() == "911carrera")
{
quote += 25;
}
}
quote += (app.SpeedingTickets.Value * 10);
if (app.DUI.Value)
{
quote += (quote * 0.25);
}
if (app.Coverage.ToLower() == "full")
{
quote += (quote * 0.5);
}
app.Quote = Convert.ToInt32(quote);
db.applications.Add(app);
db.SaveChanges();
return(View(app));
}
}
