public ActionResult GetQuote(GetQuoteModel quote)
{
// return estimated quote based on user input
DateTime Birthday = quote.Birthday;
DateTime now = DateTime.Today;
int age = now.Year - Birthday.Year;
if (now < Birthday.AddYears(age))
{
age--;
}
//age method update EstimatedQuote
var EstimatedQuote = quote.Age(age);
//car method, make model year; update EstimatedQuote
EstimatedQuote = quote.Car(EstimatedQuote, quote.CarYear, quote.CarMake.ToLower(), quote.CarModel.ToLower());
// speeding tickets method; update EstimatedQuote
EstimatedQuote = quote.Tickets(EstimatedQuote, quote.Ticket);
//dui method update EstimatedQuote
EstimatedQuote = quote.YesDui(EstimatedQuote, quote.Dui);
//coverage method update EstimatedQuote
EstimatedQuote = quote.YesCoverage(EstimatedQuote, quote.Coverage);
//instantiate entitiy object and pass in connection string to access to db
using (CarInsurance1Entities db = new CarInsurance1Entities())
{
var user = new User
{ //pass db values passed to model from UI
FirstName = quote.FirstName,
LastName = quote.LastName,
EmailAddress = quote.EmailAddress,
Birthday = quote.Birthday,
CarYear = quote.CarYear,
CarMake = quote.CarMake,
CarModel = quote.CarModel,
Dui = quote.Dui,
Ticket = quote.Ticket,
Coverage = quote.Coverage,
EstimatedQuote = Convert.ToDecimal(EstimatedQuote)
};
db.Users.Add(user); // add to db
db.SaveChanges(); //save to db
}
var getquoteVms = new List <GetQuoteVm>
{
new GetQuoteVm {
EstimatedQuote = EstimatedQuote
}
};
return(View(getquoteVms));
}
// GET: Admin
public ActionResult Index()
{
//instantiate entities object and passed into connection string to access to db
using (CarInsurance1Entities db = new CarInsurance1Entities())
{
var users = db.Users; // access db, contains all records in db
var getquoteVms = new List <GetQuoteVm>(); // create new list of viewmodels
//map the viewmodels from the model to viewmodel then pass list to view
foreach (var user in users)
{
var getquoteVm = new GetQuoteVm
{ // map db object to view model
FirstName = user.FirstName,
LastName = user.LastName,
EmailAddress = user.EmailAddress,
EstimatedQuote = Convert.ToDouble(user.EstimatedQuote)
};
getquoteVms.Add(getquoteVm);
}
return(View(getquoteVms));
}
}