/// <summary>
/// Processes a quote
/// </summary>
/// <param name="id">The ID of the quote to process</param>
private void LoadExistingQuote(int id)
{
var db = new QuotesDBEntities();
this.Quote = db.Quotes.Single(i => i.ID == id);
this.ShowCustomerInformation();
this.ShowPriceSummary();
}
public string[] GetVehicleModel(string prefixText, int count)
{
var db = new QuotesDBEntities();
var model =
(from q in db.Vehicles
where q.Model.StartsWith(prefixText)
select q.Model).Distinct().Take(count).OrderBy(name => name);
return model.ToArray();
}
public string[] GetCarriersList(string prefixText, int count)
{
var db = new QuotesDBEntities();
var carriers =
(from q in db.Quotes
where q.PreviousCarrier.StartsWith(prefixText)
select q.PreviousCarrier).Distinct().Take(count).OrderBy(name => name);
return carriers.ToArray();
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.User.IsInRole("Manager"))
{
var db = new QuotesDBEntities();
var url = db.Configs.Single(c => c.Name == "SharePointListURL").Value;
var manageQuotes = new MenuItem("Manage Quotes", null, null, url);
var manageUsers = new MenuItem("Manage Users", null, null, "~/Admin/ManageUsers.aspx");
NavigationMenu.Items.Add(manageQuotes);
NavigationMenu.Items.Add(manageUsers);
}
}
protected void IncompleteQuoteGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
int index = Convert.ToInt32(e.CommandArgument);
var quoteId = IncompleteQuoteGridView.DataKeys[index].Value;
if (e.CommandName == "EditIncomplete")
{
Response.Redirect(string.Format("Create.aspx?id={0}", quoteId.ToString()));
}
else if (e.CommandName == "DeleteIncomplete")
{
var db = new QuotesDBEntities();
var quote = db.Quotes.Single(q => q.ID == (int)quoteId);
db.DeleteObject(quote);
db.SaveChanges();
this.RefreshIncompleteGrid();
}
}
private void CopyDrivers(Quote oldQuote, int newQuoteId)
{
var db = new QuotesDBEntities();
var driverList = db.Drivers.Select(d => d).Where(d => d.QuoteID == oldQuote.ID);
foreach (var oldDriver in driverList)
{
var newDriver = new Driver
{
FirstName = oldDriver.FirstName,
LastName = oldDriver.LastName,
Ssn = oldDriver.Ssn,
DateOfBirth = oldDriver.DateOfBirth,
DriverLicenseNumber = oldDriver.DriverLicenseNumber,
DLState = oldDriver.DLState,
SafeDrivingSchool = oldDriver.SafeDrivingSchool,
QuoteID = newQuoteId
};
db.Drivers.AddObject(newDriver);
}
db.SaveChanges();
}
private int CopyQuoteInfo(Quote oldQuote)
{
var db = new QuotesDBEntities();
var newQuote = new Quote
{
UserId = (Guid)Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey,
CustomerFirstName = oldQuote.CustomerFirstName,
CustomerLastName = oldQuote.CustomerLastName,
Address = oldQuote.Address,
City = oldQuote.City,
StateId = oldQuote.StateId,
Ssn = oldQuote.Ssn,
Zip = oldQuote.Zip,
DateOfBirth = oldQuote.DateOfBirth,
DateCreated = DateTime.Now,
Incomplete = true,
ClaimsInPast5Yrs = oldQuote.ClaimsInPast5Yrs,
ForceMultiCarDiscount = oldQuote.ForceMultiCarDiscount,
HasLessThan3YrsDriving = oldQuote.HasLessThan3YrsDriving,
HasMovingViolations = oldQuote.HasMovingViolations
};
db.Quotes.AddObject(newQuote);
db.SaveChanges();
return newQuote.ID;
}
private void copyExistingQuote(int id)
{
var db = new QuotesDBEntities();
var oldQuote = db.Quotes.Single(q => q.ID == id);
var newQuoteId = CopyQuoteInfo(oldQuote);
CopyDrivers(oldQuote, newQuoteId);
CopyVehicles(oldQuote, newQuoteId);
Response.Redirect(string.Format("Create.aspx?id={0}", newQuoteId));
}
private void RefreshIncompleteGrid()
{
var userId = (Guid)Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey;
var db = new QuotesDBEntities();
var quotes = from u in db.vw_Quotes where u.Incomplete && u.UserId == userId select u;
IncompleteQuoteGridView.DataSource = quotes;
IncompleteQuoteGridView.DataBind();
}
private void CopyVehicles(Quote oldQuote, int newQuoteId)
{
var db = new QuotesDBEntities();
var vehicleList = db.Vehicles.Select(d => d).Where(v => v.QuoteId == oldQuote.ID);
foreach (var vehicle in vehicleList)
{
// TODO: Find a better way to copy the primary driver info than compare the driver license number
// Find the driver's licence number of the primary driver of the original vehicle
var a = db.Drivers.Single(d => d.ID == vehicle.PrimaryDriver).DriverLicenseNumber;
// Find the ID of the driver in the new quote that has the same licence number as the original one
var b = db.Quotes.Single(q => q.ID == newQuoteId).Drivers.Single(d => d.DriverLicenseNumber == a).ID;
var newVehicle = new Vehicle
{
Vin = vehicle.Vin,
Make = vehicle.Make,
Model = vehicle.Model,
Year = vehicle.Year,
CurrentValue = vehicle.CurrentValue,
PrimaryDriver = b,
AnnualMileage = vehicle.AnnualMileage,
DaysDrivenPerWeek = vehicle.DaysDrivenPerWeek,
MilesDrivenToWork = vehicle.MilesDrivenToWork,
AntiTheft = vehicle.AntiTheft,
AntiLock = vehicle.AntiLock,
DaytimeRunningLights = vehicle.DaytimeRunningLights,
DifferentGarageAddress = vehicle.DifferentGarageAddress,
PassiveRestraints = vehicle.PassiveRestraints,
ReducedUsedDiscount = vehicle.ReducedUsedDiscount,
QuoteId = newQuoteId
};
db.Vehicles.AddObject(newVehicle);
}
db.SaveChanges();
}
/// <summary>
/// Loads a previously saved, incomplete quote
/// </summary>
/// <param name="id">The ID of the quote to load</param>
private void LoadExistingQuote(int id)
{
if (CurrentQuote == null || CurrentQuote.ID != id)
{
var db = new QuotesDBEntities();
this.CurrentQuote = db.Quotes.Single(i => i.ID == id);
ucCustomerInfo.Read(CurrentQuote);
}
// TODO: Make sure the quote is incomplete, we don't want to load a completed quote
CompleteCustomerInfo();
}
