public ActionResult Index()
{
var UserList = new List <AdminViewModel>();
using (InsuranceEntities db = new InsuranceEntities())
{
var users = db.Users;
foreach (var user in users)
{
var userInfo = new AdminViewModel();
var cars = from c in db.Cars
where c.UserId == user.Id
select c;
userInfo.FirstName = user.FirstName;
userInfo.LastName = user.LastName;
userInfo.UserEmail = user.Email;
userInfo.NumCars = cars.Count();
userInfo.TotalRate = user.CompleteQuote;
UserList.Add(userInfo);
}
}
return(View(UserList));
}
public ActionResult GetQuote(string firstName, string lastName, string emailAddress, DateTime dateOfBirth,
int carYear, string carMake, string carModel, bool driveIntoxicated, int speedingTicket, bool fullCoverage)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress) ||
string.IsNullOrEmpty(carMake) || string.IsNullOrEmpty(carModel))
{
return(View("~/ViewStartPage/Shared/Error.cshtml"));
}
else
{
using (InsuranceEntities db = new InsuranceEntities())
{
var customer = new CustomerInfo();
customer.FirstName = firstName;
customer.LastName = lastName;
customer.EmailAddress = emailAddress;
customer.DateOfBirth = dateOfBirth;
customer.CarYear = carYear;
customer.CarMake = carMake;
customer.CarModel = carModel;
customer.DriveIntoxicated = driveIntoxicated;
customer.SpeedingTicket = speedingTicket;
customer.FullCoverage = fullCoverage;
db.CustomerInfoes.Add(customer);
db.SaveChanges();
}
return(View("Quote"));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
// using LINQ as Jesse described will help reduce the amount of code needed to query the db
var insurees = (from c in db.Insurees
where c.Id > 0
select c).ToList();
// instantiate a new object and call it by using the View Model for reference
var insureeVms = new List <Insuree>();
foreach (Insuree insuree in insurees)
{
var insureeVm = new Insuree();
insureeVm.Id = insuree.Id;
insureeVm.FirstName = insuree.FirstName;
insureeVm.LastName = insuree.LastName;
insureeVm.EmailAddress = insuree.EmailAddress;
insureeVm.Quote = insuree.Quote;
insureeVms.Add(insureeVm);
}
return(View(insureeVms));
}
}
public ActionResult Quote(string FirstName, string LastName, string EmailAddress, string DateOfBirth, int CarYear, string CarMake,
string CarModel, string DUI, int Tickets, string Coverage, decimal TotalQuote)
{
if (string.IsNullOrEmpty(FirstName))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (InsuranceEntities db = new InsuranceEntities())
{
var signup = new Quote();
signup.FirstName = FirstName;
signup.LastName = LastName;
signup.EmailAddress = EmailAddress;
signup.DateOfBirth = DateOfBirth;
signup.CarYear = CarYear;
signup.CarMake = CarMake;
signup.CarModel = CarModel;
signup.DUI = DUI;
signup.Tickets = Tickets;
signup.Coverage = Coverage;
signup.TotalQuote = TotalQuote;
db.Quotes.Add(signup);
db.SaveChanges();
}
return(View("Success"));
}
}
public ActionResult Evaluate(string FirstName, string LastName, string EmailAddress, DateTime DateOfBirth, string CarYear, string CarMake, string CarModel, string DUI, string Tickets, string Coverage)
{
bool go = string.IsNullOrEmpty(FirstName) || string.IsNullOrEmpty(LastName) || string.IsNullOrEmpty(EmailAddress) || !(int.TryParse(CarYear, out int Year)) || string.IsNullOrEmpty(CarMake) ||
string.IsNullOrEmpty(CarModel) || string.IsNullOrEmpty(DUI) || string.IsNullOrEmpty(Tickets) || string.IsNullOrEmpty(Coverage);
if (go)
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quote = new Quote();
quote.FirstName = FirstName;
quote.LastName = LastName;
quote.EmailAddress = EmailAddress;
quote.DateOfBirth = DateOfBirth;
quote.CarYear = Convert.ToInt32(CarYear);
quote.CarMake = CarMake;
quote.CarModel = CarModel;
quote.DUI = !(DUI == "0");
quote.Tickets = Convert.ToInt32(Tickets);
quote.Coverage = Coverage;
quote.Price = Calculate.Calculator(DateOfBirth, Convert.ToInt32(CarYear), CarMake, CarModel, Convert.ToInt32(Tickets), !(DUI == "0"), Coverage);
db.Quotes.Add(quote);
db.SaveChanges();
return(View("Success", quote.Price));
}
}
}
public ActionResult Index()
{
using (
InsuranceEntities db = new InsuranceEntities())
{
var theirquotes = (from x in db.Tables
where x.Id > 0
select x).ToList();
var quoteforAdmin = new List <CustomerQuotes>();
foreach (var quote in theirquotes)
{
var adminlist = new CustomerQuotes
{
FirstName = quote.FirstName,
LastName = quote.LaststName,
EmailAddress = quote.EmailAddress,
Quote = (int)quote.Quote
};
quoteforAdmin.Add(adminlist);
}
return(View(quoteforAdmin));
}
}
public ActionResult Admin()
{
using (InsuranceEntities db = new InsuranceEntities())
{
return(View(db.Insurees.ToList()));
}
}
private void AddQuoteAndCar(User user, string make, string model, int year, string coverage)
{
using (InsuranceEntities db = new InsuranceEntities())
{
//create car object
var tempCar = new Car();
tempCar.Make = make.ToLower();
tempCar.Model = model.ToLower();
tempCar.Year = year;
//Calculate Points
var Tickets = db.Tickets;
var userTickets = db.Tickets.Where(x => x.UserId == user.Id).ToList();
int points = userTickets.Count(x => (DateTime.Now - x.IssueDate).Days <= 1095);
//find rate on car
decimal rate = CalcCarQuote(user, tempCar, points, coverage);
//create quote object and add to db
var tempQuote = new Quote();
tempQuote.Rate = rate;
tempQuote.CoverageType = coverage;
tempQuote.IssueDate = DateTime.Now;
db.Quotes.Add(tempQuote);
db.SaveChanges();
//add foreign keys to car object and save car to db
tempCar.UserId = user.Id;
tempCar.QuoteId = tempQuote.Id;
db.Cars.Add(tempCar);
db.SaveChanges();
}
}
public ActionResult Admin()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var users = db.Users.ToList();
return(View(users));
}
}
public ActionResult LookupRate(string lookupEmail)
{
if (string.IsNullOrEmpty(lookupEmail))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (InsuranceEntities db = new InsuranceEntities())
{
var Users = db.Users;
var FoundUsers = Users.Where(x => x.Email == lookupEmail).ToList();
if (FoundUsers.Count() < 1)
{
return(View("NoAccountError"));
}
else
{
var userInfo = new LookupViewModel();
User user = FoundUsers.FirstOrDefault();
var cars = from c in db.Cars
where c.UserId == user.Id
select c;
var listCars = new List <CarViewModel>();
foreach (Car car in cars)
{
var tempcar = new CarViewModel();
tempcar.Make = car.Make;
tempcar.Model = car.Model;
tempcar.Year = car.Year;
tempcar.Rate = db.Quotes.Where(x => x.Id == car.QuoteId).ToList().FirstOrDefault().Rate;
tempcar.IssueDate = db.Quotes.Where(x => x.Id == car.QuoteId).ToList().FirstOrDefault().IssueDate;
listCars.Add(tempcar);
}
//Calculate Points
var Tickets = db.Tickets;
var userTickets = db.Tickets.Where(x => x.UserId == user.Id).ToList();
int points = userTickets.Count(x => (DateTime.Now - x.IssueDate).Days <= 1095);
userInfo.FirstName = user.FirstName;
userInfo.LastName = user.LastName;
userInfo.UserEmail = user.Email;
userInfo.NumCars = cars.Count();
userInfo.Points = points;
userInfo.Dui = (user.DuiActive == 1) ? true : false;
userInfo.TotalRate = user.CompleteQuote;
userInfo.Cars = listCars;
return(View(userInfo));
}
}
}
}
//Calculate Insurance Quote
public ActionResult CalcQuote(int Id)
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insuree = db.Insurees.Find(Id);
var dateOfBirth = insuree.DateOfBirth;
var carYear = insuree.CarYear;
var carModel = insuree.CarModel;
var carMake = insuree.CarMake;
var speedingTickets = insuree.SpeedingTickets;
var dui = insuree.DUI;
var coverageType = insuree.CoverageType;
var monthlyInsuraneQuote = 50.0m;
if (dateOfBirth.Year >= 2003)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 100.0m;
}
else if (dateOfBirth.Year <= 2011 && dateOfBirth.Year >= 1996)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 50.0m;
}
else if (dateOfBirth.Year < 1996)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 25.0m;
}
if (carYear < 2000)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 25.0m;
}
else if (carYear > 2015)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 25.0m;
}
if (carMake.ToLower() == "porsche")
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 25.0m;
if (carModel.ToLower() == "911 carerra")
{
monthlyInsuraneQuote = monthlyInsuraneQuote + 25.0m;
}
}
monthlyInsuraneQuote = monthlyInsuraneQuote + (speedingTickets * 10);
if (dui == true)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + (monthlyInsuraneQuote * 0.25m);
}
if (coverageType == true)
{
monthlyInsuraneQuote = monthlyInsuraneQuote + (monthlyInsuraneQuote * 0.50m);
}
insuree.Quote = monthlyInsuraneQuote;
db.SaveChanges();
}
return(View("Index"));
}
public ActionResult CancelPolicy(int Id)
{
using (InsuranceEntities db = new InsuranceEntities()) // creates connection to the Db
{
var quote = db.AutoInsuranceQuotes.Find(Id); // quote is able to find a specific record by Id in the Db
quote.Removed = DateTime.Now; // changes the Removed column to DateTime.Now so column is no longer Null
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Cancel(int Id)
{
using (InsuranceEntities db = new InsuranceEntities())
{
var signup = db.Tables.Find(Id);
signup.Removed = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Remove(int Id)
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quote = db.Quotes.Find(Id);
quote.Removed = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insuree = (from c in db.Insurees
where c.Quote != 0.00m
select c).ToList();
return(View(insuree));
}
}
public ActionResult GetQuote(string firstName, string lastName, string emailAddress, DateTime dateOfBirth,
int carYear, string carMake, string carModel, int speedingTickets,
bool driveIntoxicated = false, bool fullCoverage = false)
{
decimal ageFee = GetFeesForAge(dateOfBirth);
decimal carFee = CarFee(carYear, carMake, carModel);
decimal tixFee = SpeedTix(speedingTickets);
decimal subtotalFee = ageFee + carFee + tixFee;
decimal extraFeeDUI = 0;
decimal extraFeeFC = 0;
if (driveIntoxicated == true)
{
extraFeeDUI = subtotalFee * (decimal).25;
}
if (fullCoverage == true)
{
extraFeeFC = subtotalFee * (decimal).5;
}
decimal insQuote = extraFeeDUI + extraFeeFC + subtotalFee;
using (InsuranceEntities db = new InsuranceEntities())
{
var customer = new CustomerInfo();
customer.FirstName = firstName;
customer.LastName = lastName;
customer.EmailAddress = emailAddress;
customer.DateOfBirth = dateOfBirth;
customer.CarYear = carYear;
customer.CarMake = carMake;
customer.CarModel = carModel;
customer.SpeedingTickets = speedingTickets;
customer.DriveIntoxicated = driveIntoxicated;
customer.FullCoverage = fullCoverage;
customer.InsQuote = Convert.ToDecimal(insQuote);
db.CustomerInfoes.Add(customer);
db.SaveChanges();
}
ViewBag.insQuote = insQuote;
ViewBag.firstName = firstName;
ViewBag.lastName = lastName;
return(View("Quote"));
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quotes = db.Tables;
var quotesVMs = new List <QuotesVM>();
foreach (var quote in quotesVMs)
{
var quoteVM = new QuotesVM();
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quotesVMs.Add(quoteVM);
}
return(View(quotesVMs));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quotes = db.InsuranceQuotes;
var quoteVms = new List <Quote>();
foreach (var quote in quotes)
{
var quoteVm = new Quote();
quoteVm.FirstName = quote.FirstName;
quoteVm.LastName = quote.LastName;
quoteVm.Email = quote.Email;
quoteVm.Rate = quote.Rate;
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quoteVMs = new List <QuoteVM>();
foreach (var quote in db.Quotes)
{
var quoteVM = new QuoteVM();
quoteVM.Id = quote.Id;
quoteVM.FirstName = quote.FirstName;
quoteVM.LastName = quote.LastName;
quoteVM.EmailAddress = quote.EmailAddress;
quoteVM.MonthlyFee = (int)quote.MonthlyFee;
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
//Admin view page
public ActionResult Admin()
{
using (InsuranceEntities dataBase = new InsuranceEntities())
{
var customers = dataBase.Customers.ToList();
var QuotaVms = new List <QuotaVm>();
foreach (var customer in customers)
{
var QuotaVm = new QuotaVm();
QuotaVm.Quote = Convert.ToDouble(customer.Quote);
QuotaVm.FirstName = customer.FirstName;
QuotaVm.LastName = customer.LastName;
QuotaVm.EmailAddress = customer.EmailAddress;
QuotaVms.Add(QuotaVm);
}
return(View(QuotaVms));
}
}
// GET: Insuree/Admin
public ActionResult Admin()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insurees = db.Insurees;
var quoteVMs = new List <QuoteVM>();
foreach (var insuree in insurees)
{
var quoteVM = new QuoteVM();
quoteVM.FirstName = insuree.FirstName;
quoteVM.LastName = insuree.LastName;
quoteVM.EmailAddress = insuree.EmailAddress;
quoteVM.Quote = insuree.Quote;
quoteVMs.Add(quoteVM);
}
return(View(quoteVMs));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insurees = db.Insurees;
var quoteVms = new List <QuoteVm>();
foreach (var insuree in insurees)
{
var quoteVm = new QuoteVm();
quoteVm.FirstName = insuree.FirstName;
quoteVm.LastName = insuree.LastName;
quoteVm.EmailAddress = insuree.EmailAddress;
quoteVm.Quote = Math.Round(insuree.Quote, 2);
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var quotes = db.Quotes;
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.Price = Convert.ToInt32(quote.Price);
quoteVms.Add(quoteVm);
}
return(View(quoteVms));
}
}
public ActionResult Admin()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insurees = db.Insurees.Where(x => x.CarModel == null).ToList(); //Lambda expression of getting specified data
/*var signups = (from c in db.SignUps where c.Removed == null select c).ToList(); */ //Linq Method of getting specified data
var insurers = new List <Insuree>();
foreach (var insuree in insurees)
{
var insurer = new Insuree();
insuree.Id = insurer.Id;
insuree.FirstName = insurer.FirstName;
insuree.LastName = insurer.LastName;
insuree.EmailAddress = insurer.EmailAddress;
//insuree.Add(insurees);
}
return(View(insurees));
}
}
// GET: Admin
public ActionResult Index()
{
List <InsureeVM> insureeVMs = new List <InsureeVM>();
using (InsuranceEntities db = new InsuranceEntities())
{
var insurees = db.Insurees;
foreach (var insuree in insurees)
{
var insureeVM = new InsureeVM();
insureeVM.FirstName = insuree.FirstName;
insureeVM.LastName = insuree.LastName;
insureeVM.EmailAddress = insuree.EmailAddress;
insureeVM.Quote = insuree.Quote;
insureeVMs.Add(insureeVM);
}
}
return(View(insureeVMs));
}
public ActionResult Admin(int?id)
{
using (InsuranceEntities db = new InsuranceEntities())
{
var tables = db.Tables.Where(x => x.Id != null).ToList();
var tableVms = new List <TableVm>();
foreach (var x in tables)
{
var tableVm = new TableVm();
tableVm.FirstName = x.FirstName;
tableVm.LastName = x.LastName;
tableVm.EmailAddress = x.EmailAddress;
tableVm.Quote = x.Quote;
tableVms.Add(tableVm);
}
return(View(tableVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insurees = db.Insurees.ToList();
var insureeVms = new List <InsureeVM>();
foreach (var insuree in insurees)
{
var insureeVm = new InsureeVM();
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()) // creates connection to the Db
{
var insurancequotes = db.AutoInsuranceQuotes.Where(x => x.Removed == null).ToList();
var insuranceQuotesVms = new List <InsuranceVM>();
foreach (var quote in insurancequotes)
{
var insuranceVm = new InsuranceVM();
insuranceVm.Id = quote.Id;
insuranceVm.FirstName = quote.FirstName;
insuranceVm.LastName = quote.LastName;
insuranceVm.EmailAddress = quote.EmailAddress;
insuranceVm.Total = Convert.ToInt32(quote.Total);
insuranceQuotesVms.Add(insuranceVm);
}
return(View(insuranceQuotesVms));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var insuredNow = new List <Insuree>();
foreach (var insuree in db.Insurees)
{
var insured = new Insuree();
insured.FirstName = insuree.FirstName;
insured.LastName = insuree.LastName;
insured.EmailAddress = insuree.EmailAddress;
insuree.Quote = decimal.Round(insuree.Quote, 2);
insured.Quote = insuree.Quote;
insuredNow.Add(insured);
}
return(View(insuredNow));
}
}
// GET: Admin
public ActionResult Index()
{
using (InsuranceEntities db = new InsuranceEntities())
{
var customers = db.CustomerInfoes.ToList(); //pulling database info to a new list
var customersVms = new List <InsuranceVm>(); //instantiating list
foreach (var customer in customers) //looping through list to add customer info to list
{
var customersVm = new InsuranceVm();
customersVm.FirstName = customer.FirstName;
customersVm.LastName = customer.LastName;
customersVm.EmailAddress = customer.EmailAddress;
customersVm.InsQuote = customer.InsQuote;
customersVms.Add(customersVm);
}
return(View(customersVms));
}
}