/// <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(); }