public ActionResult Admin()
{
string queryString = @"SELECT id, firstName, lastName, emailAddress, dob, carYear, carMake, carModel, dui, tickets, fullCoverage, quotedPrice FROM quotes";
List <QuoteSubmission> submissions = new List <QuoteSubmission>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
var submission = new QuoteSubmission();
submission.id = Convert.ToInt32(reader["id"]);
submission.firstName = reader["firstName"].ToString();
submission.lastName = reader["lastName"].ToString();
submission.emailAddress = reader["emailAddress"].ToString();
submission.dob = Convert.ToDateTime(reader["dob"]).Date;
submission.carYear = Convert.ToInt32(reader["carYear"]);
submission.carMake = reader["carMake"].ToString();
submission.carModel = reader["carModel"].ToString();
submission.dui = Convert.ToBoolean(reader["dui"]);
submission.tickets = Convert.ToInt32(reader["tickets"]);
submission.fullCoverage = Convert.ToBoolean(reader["fullCoverage"]);
submission.quotedPrice = Math.Round(Convert.ToDecimal(reader["quotedPrice"]), 2);
submissions.Add(submission);
}
}
var adminVms = new List <AdminVM>();
foreach (var signup in submissions)
{
var adminVm = new AdminVM();
adminVm.ID = signup.id;
adminVm.FirstName = signup.firstName;
adminVm.LastName = signup.lastName;
adminVm.EmailAddress = signup.emailAddress;
adminVm.DOB = signup.dob.Date;
adminVm.CarYear = signup.carYear;
adminVm.CarMake = signup.carMake;
adminVm.CarModel = signup.carModel;
adminVm.Dui = signup.dui;
adminVm.tickets = signup.tickets;
adminVm.fullCoverage = signup.fullCoverage;
adminVm.quotedPrice = Convert.ToString(signup.quotedPrice);
adminVms.Add(adminVm);
}
return(View(adminVms));
}
public ActionResult Quote(string firstName, string lastName, string emailAddress, DateTime dob, int carYear, string carMake, string carModel, int tickets, Boolean fullCoverage = false, Boolean dui = false)
{
QuoteSubmission quoteApp = new QuoteSubmission();
quoteApp.firstName = firstName;
quoteApp.lastName = lastName;
quoteApp.emailAddress = emailAddress;
quoteApp.dob = dob;
quoteApp.carYear = carYear;
quoteApp.carMake = carMake;
quoteApp.carModel = carModel;
quoteApp.dui = dui;
quoteApp.tickets = tickets;
quoteApp.fullCoverage = fullCoverage;
//Make sure all necessary fields are filled
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress) || dob.Equals(null) || string.IsNullOrEmpty(carMake) || string.IsNullOrEmpty(carModel))
{
return(View("/Views/Shared/Error.cshtml"));
}
//Check that they aren't trying to cheat the system with negative values
if (tickets < 0 || carYear < 1800)
{
return(View("/Views/Shared/Error.cshtml"));
}
//calculate quote with submission
else
{
quoteApp.quotedPrice = QuoteCalculator.calculateQuote(quoteApp);
string queryString = @"INSERT INTO quotes (firstName, lastName, emailAddress, dob, carYear, carMake, carModel, dui, tickets, fullCoverage, quotedPrice) VALUES
(@firstName, @lastName, @emailAddress, @dob, @carYear, @carMake, @carModel, @dui, @tickets, @fullCoverage, @quotedPrice)";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.Add("@firstName", SqlDbType.VarChar);
command.Parameters.Add("@lastName", SqlDbType.VarChar);
command.Parameters.Add("@emailAddress", SqlDbType.VarChar);
command.Parameters.Add("@dob", SqlDbType.Date);
command.Parameters.Add("@carYear", SqlDbType.Int);
command.Parameters.Add("@carMake", SqlDbType.VarChar);
command.Parameters.Add("@carModel", SqlDbType.VarChar);
command.Parameters.Add("@dui", SqlDbType.Bit);
command.Parameters.Add("@tickets", SqlDbType.Int);
command.Parameters.Add("@fullCoverage", SqlDbType.Bit);
command.Parameters.Add("@quotedPrice", SqlDbType.Decimal);
command.Parameters["@firstName"].Value = firstName;
command.Parameters["@lastName"].Value = lastName;
command.Parameters["@emailAddress"].Value = emailAddress;
command.Parameters["@dob"].Value = dob;
command.Parameters["@carYear"].Value = carYear;
command.Parameters["@carMake"].Value = carMake;
command.Parameters["@carModel"].Value = carModel;
command.Parameters["@dui"].Value = dui;
command.Parameters["@tickets"].Value = tickets;
command.Parameters["@fullCoverage"].Value = fullCoverage;
command.Parameters["@quotedPrice"].Value = Math.Round(quoteApp.quotedPrice, 2);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(View(new QuoteVM(quoteApp.quotedPrice)));
}
}
public ActionResult Quote(string firstName, string lastName, string emailAddress, DateTime DOB, int carYear, string carMake, string carModel, int tickets, Boolean fullCoverage = false, bool dui = false, int quote = 1)
{
List <QuoteSubmission> submission = new List <QuoteSubmission>();
var adminVms = new List <AdminVm>();
foreach (var signup in submission)
{
var adminVm = new AdminVm();
adminVm.Id = signup.Id;
adminVm.FirstName = signup.FirstName;
adminVm.LastName = signup.LastName;
adminVm.EmailAddress = signup.EmailAddress;
adminVm.DOB = signup.Dob.Date;
adminVm.CarYear = signup.CarYear;
adminVm.CarMake = signup.CarMake;
adminVm.CarModel = signup.CarModel;
adminVm.Dui = signup.Dui;
adminVm.Tickets = signup.Tickets;
adminVm.FullCoverabe = signup.FullCoverage;
adminVm.QuotedPrice = signup.QuotedPrice;
adminVms.Add(adminVm);
return(View(adminVms));
}
QuoteSubmission quoteApp = new QuoteSubmission();
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || DOB.Equals(null) || string.IsNullOrEmpty(carMake) || string.IsNullOrEmpty(carModel))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else if (carYear < 0 || tickets < 0)
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
quoteApp.FirstName = firstName;
quoteApp.LastName = lastName;
quoteApp.EmailAddress = emailAddress;
quoteApp.Dob = DOB;
quoteApp.CarMake = carMake;
quoteApp.CarModel = carModel;
quoteApp.CarYear = carYear;
quoteApp.Dui = dui;
quoteApp.Tickets = tickets;
quoteApp.FullCoverage = fullCoverage;
using (QuoteSubmission db = new QuoteSubmission())
{
var signup = new Table();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
signup.DateofBirth = DOB;
signup.CarMake = carMake;
signup.CarModel = carModel;
signup.CarYear = carYear;
signup.DUI = dui;
signup.SpeedingTickets = tickets;
signup.CoverageType = fullCoverage;
quoteApp.QuotedPrice = Calculator.CalculateQuote(quoteApp);
signup.QUOTE = quoteApp.QuotedPrice;
db.Tables.Add(signup);
db.SaveChanges();
}
return(View(new QuoteVm(quoteApp.QuotedPrice)));
}
}
