public JsonResult GetCarFaxReport(int appraisalId) { var carfax = new CarFaxViewModel() { Success = false }; if (Session["Dealership"] == null) { return(new DataContractJsonResult(carfax)); } var contextVinControl = new whitmanenterprisewarehouseEntities(); var targetCar = contextVinControl.whitmanenterpriseappraisals.First( (x => x.idAppraisal == appraisalId)); var dealer = (DealershipViewModel)Session["Dealership"]; carfax = CarFaxHelper.ConvertXmlToCarFaxModelAndSave(targetCar.VINNumber, dealer.CarFax, dealer.CarFaxPassword); return(new DataContractJsonResult(carfax)); }
private static string GetAppraisalName(string name) { var context = new whitmanenterprisewarehouseEntities(); var user = (from u in context.whitmanenterpriseusers where u.UserName == name select u).FirstOrDefault(); if (user != null) { return(user.Name); } else { var masterUser = (from u in context.whitmanenterprisedealergroups where u.MasterUserName == name select u).FirstOrDefault(); if (masterUser != null) { return(masterUser.DealerGroupName); } else { return(String.Empty); } } }
public static AppraisalViewFormModel GetAppraisalModelFromAppriaslId(int appraisalId) { var context = new whitmanenterprisewarehouseEntities(); var row = context.whitmanenterpriseappraisals.FirstOrDefault(x => x.idAppraisal == appraisalId); return(row == null ? new AppraisalViewFormModel() : new AppraisalViewFormModel(row)); }
void YearDropDownList_SelectedIndexChanged(object sender, EventArgs e) { var context = new whitmanenterprisewarehouseEntities(); var selectedYear = 0; int.TryParse(YearDropDownList.SelectedValue, out selectedYear); var firstMakeList = InventoryQueryHelper.GetSingleOrGroupInventory(context).Where(x => x.ModelYear == selectedYear).Select(x => x.Make).ToList(); var secondMakeList = InventoryQueryHelper.GetSingleOrGroupSoldoutInventory(context).Where(x => x.ModelYear == selectedYear).Select(x => x.Make); firstMakeList.AddRange(secondMakeList); var makeList = new List <string>(); makeList.Insert(0, string.Empty); var hashSet = new HashSet <string>(); foreach (var tmp in firstMakeList) { var makeName = tmp.ToLower(); if (!hashSet.Contains(makeName)) { makeList.Add(tmp); } hashSet.Add(makeName); } MakeDropDownList.DataSource = makeList; MakeDropDownList.DataBind(); ModelDropDownList.Items.Clear(); }
public List <KBBInfo> GetProfitManagement() { var context = new whitmanenterprisewarehouseEntities(); var result = from i in InventoryQueryHelper.GetSingleOrGroupInventory(context) join k in context.whitmanenterprisekbbs.Where(j => j.Type == Constanst.VehicleTable.Inventory) on new { i.KBBTrimId, i.VINNumber } equals new { KBBTrimId = k.TrimId, VINNumber = k.Vin } into gj from g in gj.DefaultIfEmpty() where i.NewUsed == "Used" select new KBBInfo { VIN = i.VINNumber, StockNumber = i.StockNumber, DateInStock = i.DateInStock.Value, Year = i.ModelYear ?? 0, Make = i.Make, Model = i.Model, Trim = i.Trim, WholeSale = g.WholeSale, DealerCost = String.IsNullOrEmpty(i.DealerCost) ? "NA" : i.DealerCost, DealershipName = i.DealershipName, }; var sorted = result.ToList(); foreach (var kbbInfo in sorted) { kbbInfo.DaysInInvenotry = DateTime.Now.Subtract(kbbInfo.DateInStock).Days; GetCost(kbbInfo); } return(sorted.OrderByDescending(i => i.KBBCost).ThenByDescending(i => i.Year).ThenBy(i => i.Make).ThenBy(i => i.Model).ToList()); }
private vincontroldescriptiontemplate GetTemplate(int templateId) { using (var context = new whitmanenterprisewarehouseEntities()) { return(context.vincontroldescriptiontemplates.FirstOrDefault(i => i.Id == templateId)); } }
public List <VinControlVehicleReport> GetNext7DaysBucketJumpVehicles(int dealerId) { var mProducts = new List <VinControlVehicleReport>(); var context = new whitmanenterprisewarehouseEntities(); IQueryable <whitmanenterprisedealershipinventory> avaiInventory = from e in InventoryQueryHelper.GetSingleOrGroupInventory(context) where e.NewUsed.ToLower().Equals("used") && (e.Recon == null || !((bool)e.Recon)) select e; var dtDealerSetting = InventoryQueryHelper.GetSingleOrGroupSetting(context).ToList(); var dtDealerInfo = InventoryQueryHelper.GetSingleOrGroupDealer(context).ToList(); for (int i = 1; i <= 7; i++) { foreach (var tmp in avaiInventory.OrderBy(x => x.Make)) { int daysInInvenotry = DateTime.Now.AddDays(i).Subtract(tmp.DateInStock.GetValueOrDefault()).Days; bool flag = dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).IntervalBucketJump != 0 && ((daysInInvenotry == dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).FirstTimeRangeBucketJump) || (daysInInvenotry == dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).SecondTimeRangeBucketJump) || ((daysInInvenotry - dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).SecondTimeRangeBucketJump) % dtDealerSetting.FirstOrDefault(item => tmp.DealershipId == item.DealershipId).IntervalBucketJump) == 0); if (flag) { var v = new VinControlVehicleReport { AutoId = mProducts.Count + 1, ModelYear = tmp.ModelYear.GetValueOrDefault(), Make = String.IsNullOrEmpty(tmp.Make) ? "" : tmp.Make, Model = String.IsNullOrEmpty(tmp.Model) ? "" : tmp.Model, Trim = String.IsNullOrEmpty(tmp.Trim) ? "" : tmp.Trim, StockNumber = String.IsNullOrEmpty(tmp.StockNumber) ? "" : tmp.StockNumber, Vin = String.IsNullOrEmpty(tmp.VINNumber) ? "" : tmp.VINNumber, Mileage = String.IsNullOrEmpty(tmp.Mileage) ? "" : tmp.Mileage, ExteriorColor = String.IsNullOrEmpty(tmp.ExteriorColor) ? "" : tmp.ExteriorColor, SalePrice = String.IsNullOrEmpty(tmp.SalePrice) ? "" : tmp.SalePrice, DaysInInvenotry = DateTime.Now.Subtract(tmp.DateInStock.Value).Days, DealershipName = String.IsNullOrEmpty(dtDealerInfo.FirstOrDefault(item => tmp.DealershipId == item.idWhitmanenterpriseDealership).DealershipName) ? "" : dtDealerInfo.FirstOrDefault(item => tmp.DealershipId == item.idWhitmanenterpriseDealership).DealershipName, Engine = String.IsNullOrEmpty(tmp.EngineType) ? "" : tmp.EngineType, Style = String.IsNullOrEmpty(tmp.BodyType) ? "" : tmp.BodyType, Date = new DateTime(DateTime.Now.AddDays(i).Year, DateTime.Now.AddDays(i).Month, DateTime.Now.AddDays(i).Day) }; if (v.Engine.Contains("Engine")) { v.Engine = v.Engine.Replace("Engine", ""); } mProducts.Add(v); } } } return(mProducts); }
public static BlackBookViewModel GetBBModelInDatabase(string Vin) { BlackBookViewModel dealerPrice = new BlackBookViewModel() { Vin = Vin, TrimReportList = new List <BlackBookTrimReport>() }; int status = SQLHelper.CheckVinHasBbReport(Vin); if (status == 1) { var context = new whitmanenterprisewarehouseEntities(); var list = context.whitmanenterprisebbs.Where(x => x.Vin.Equals(Vin)); foreach (whitmanenterprisebb bb in list) { BlackBookTrimReport TrimReport = new BlackBookTrimReport() { TradeInRough = CommonHelper.ConvertToCurrency(bb.TradeInFairPrice), TradeInAvg = CommonHelper.ConvertToCurrency(bb.TradeInGoodPrice), TradeInClean = CommonHelper.ConvertToCurrency(bb.TradeInVeryGoodPrice), TrimName = bb.Trim }; dealerPrice.TrimReportList.Add(TrimReport); dealerPrice.ExistDatabase = status; } } else { dealerPrice.ExistDatabase = status; } return(dealerPrice); }
public static string BuildWindowStickerInHtml() { var context = new whitmanenterprisewarehouseEntities(); var rows = InventoryQueryHelper.GetSingleOrGroupInventory(context).Where(x => x.NewUsed.ToLower().Equals("used") && (x.Recon == null || !((bool)x.Recon))); var settingRow = InventoryQueryHelper.GetSingleOrGroupSetting(context); var builder = new StringBuilder(); builder.AppendLine(" <!DOCTYPE html>"); builder.AppendLine("<html>"); builder.AppendLine("<head>"); builder.AppendLine("<title></title>"); builder.AppendLine("</head>"); builder.AppendLine("<body>"); builder.AppendLine("<font face=\"Trebuchet MS\">"); foreach (var row in rows) { BuildWindowStickerBody(builder, row, settingRow.FirstOrDefault(i => row.DealershipId == i.DealershipId)); } builder.AppendLine("</font>"); builder.AppendLine("</body>"); builder.AppendLine("</html>"); return(builder.ToString()); }
public static CarInfoFormViewModel GetVehicleInfoForEbay(int listingId, int dealershipId) { var context = new whitmanenterprisewarehouseEntities(); var row = context.whitmanenterprisedealershipinventories.First(x => x.ListingID == listingId); return(row == null ? new CarInfoFormViewModel() : new CarInfoFormViewModel(row, dealershipId)); }
public bool AllowAutoDescription(whitmanenterprisedealershipinventory inventory, int dealerId) { using (var context = new whitmanenterprisewarehouseEntities()) { var setting = context.whitmanenterprisesettings.FirstOrDefault(i => i.DealershipId == dealerId); return(inventory != null && (inventory.EnableAutoDescription.GetValueOrDefault() || inventory.EnableAutoDescription == null) && setting != null && (setting.AutoDescription.GetValueOrDefault()) ? true : false); } }
public void GenerateAutoDescription(int newListingId) { using (var context = new whitmanenterprisewarehouseEntities()) { AssignAutoDescription(newListingId); //_context.SaveChanges(); } }
private vincontroldescriptiontemplate GetRandomizedTemplate(InventoryStatus inventoryStatus) { using (var context = new whitmanenterprisewarehouseEntities()) { var random = new Random(); var status = inventoryStatus.ToString(); var activeTemplates = context.vincontroldescriptiontemplates.Where(i => i.IsActive && i.Type.Equals(status)); int randomElement = random.Next(0, activeTemplates.Count()); return(activeTemplates.ToList().ElementAt(randomElement)); } }
public static IQueryable <whitmanenterprisesetting> GetSingleOrGroupSetting(whitmanenterprisewarehouseEntities context) { if (!SessionHandler.Single) { return(context.whitmanenterprisesettings.Where( LogicHelper.BuildContainsExpression <whitmanenterprisesetting, int>( e => e.DealershipId.Value, GetDealerList(context)))); } return(context.whitmanenterprisesettings.Where(e => e.DealershipId == SessionHandler.Dealership.DealershipId)); }
public static IQueryable <vincontrolbuyerguide> GetSingleOrGroupBuyerGuide(whitmanenterprisewarehouseEntities context) { if (!SessionHandler.Single) { return(context.vincontrolbuyerguides.Where( LogicHelper.BuildContainsExpression <vincontrolbuyerguide, int>( e => e.dealershipId.Value, GetDealerList(context)))); } return(context.vincontrolbuyerguides.Where(e => e.dealershipId == SessionHandler.Dealership.DealershipId)); }
public static IEnumerable <PriceChangeItem> GetPriceChangeListForChart(string listingId, ChartTimeType type, DateTime createdDate, int inventoryStatus) { var priceChangeList = new List <PriceChangeHistory>(); using (var context = new whitmanenterprisewarehouseEntities()) { var convertedListingId = Convert.ToInt32(listingId); if (inventoryStatus == 1) { var history = context.vincontrolpricechangeshistories.Where( i => i.ListingId == convertedListingId && i.Type.ToLower().Equals("inventory")).ToList(); if (history.Count > 0) { priceChangeList = history.Select(i => new PriceChangeHistory() { AttachFile = i.AttachFile, UserStamp = i.UserStamp, DateStamp = i.DateStamp.Value, NewSalePrice = i.NewPrice.Value, OldSalePrice = i.OldPrice.Value, ListingId = i.ListingId.Value }).ToList(); } } else { var soldCard = context.whitmanenterprisedealershipinventorysoldouts.First(i => i.ListingID == convertedListingId); if (soldCard.OldListingId.GetValueOrDefault() > 0) { var history = context.vincontrolpricechangeshistories.Where( i => i.ListingId == soldCard.OldListingId && i.Type.ToLower().Equals("inventory")).ToList(); if (history.Count > 0) { priceChangeList = history.Select(i => new PriceChangeHistory() { AttachFile = i.AttachFile, UserStamp = i.UserStamp, DateStamp = i.DateStamp.Value, NewSalePrice = i.NewPrice.Value, OldSalePrice = i.OldPrice.Value, ListingId = i.ListingId.Value }).ToList(); } } } } return(GetFilter(priceChangeList, type, createdDate)); }
public bool AllowAutoDescription(int dealerId) { using (var context = new whitmanenterprisewarehouseEntities()) { var setting = context.whitmanenterprisesettings.FirstOrDefault(i => i.DealershipId == dealerId); if (setting != null) { return(setting.AutoDescriptionSubscribe.GetValueOrDefault() && setting.AutoDescription.GetValueOrDefault()); } return(false); } }
private static IEnumerable <int> GetDealerList(whitmanenterprisewarehouseEntities context) { if (SessionHandler.IsMaster) { return(from e in context.whitmanenterprisedealerships where e.DealerGroupID == SessionHandler.DealerGroup.DealershipGroupId select e.idWhitmanenterpriseDealership); } return(SessionHandler.DealerGroup.DealerList.Select(i => i.DealershipId)); }
public static IQueryable <vincontrolbannercustomer> GetSingleOrGroupTradein(whitmanenterprisewarehouseEntities context) { if (!SessionHandler.Single) { return (context.vincontrolbannercustomers.Where( LogicHelper.BuildContainsExpression <vincontrolbannercustomer, int>( e => e.DealerId.Value, GetDealerList(context)))); } return(context.vincontrolbannercustomers.Where(e => e.DealerId == SessionHandler.Dealership.DealershipId)); }
public static DateTime?GetCreatedDate(string listingId, int inventoryStatus) { using (var context = new whitmanenterprisewarehouseEntities()) { int id = int.Parse(listingId); if (inventoryStatus == 1) { return(context.whitmanenterprisedealershipinventories.Where(i => i.ListingID == id).Select(i => i.DateInStock).FirstOrDefault()); } else { return(context.whitmanenterprisedealershipinventorysoldouts.Where(i => i.ListingID == id).Select(i => i.DateInStock).FirstOrDefault()); } } }
public static IEnumerable <string> GetEmailsForInventoryNotification(int dealerId) { using (var context = new whitmanenterprisewarehouseEntities()) { var result = from e in context.whitmanenterpriseusersnotifications from et in context.whitmanenterpriseusers where e.DealershipId == dealerId && e.InventoryNotification.Value && et.Active.Value && e.UserName == et.UserName select new { et.Email, }; return(result.Select(x => x.Email).AsEnumerable()); } }
public static JavaScriptModel GetJavaScripModel(string vin, DealershipViewModel dealer) { var autoService = new ChromeAutoService(); var model = new JavaScriptModel(); if (SQLHelper.CheckVinExist(vin, dealer)) { var context = new whitmanenterprisewarehouseEntities(); var row = context.whitmanenterprisedealershipinventories.FirstOrDefault(x => x.VINNumber == vin && x.DealershipId == dealer.DealershipId); model.ListingId = row.ListingID.ToString(CultureInfo.InvariantCulture); model.Status = "Inventory"; } else if (SQLHelper.CheckVinExistInSoldOut(vin, dealer)) { var context = new whitmanenterprisewarehouseEntities(); var row = context.whitmanenterprisedealershipinventorysoldouts.FirstOrDefault(x => x.VINNumber == vin && x.DealershipId == dealer.DealershipId); model.ListingId = row.ListingID.ToString(CultureInfo.InvariantCulture); model.Status = "SoldOut"; } else if (SQLHelper.CheckVinExistInAppraisal(vin, dealer)) { var context = new whitmanenterprisewarehouseEntities(); var row = context.whitmanenterpriseappraisals.FirstOrDefault(x => x.VINNumber == vin && x.DealershipId == dealer.DealershipId); model.AppraisalId = row.idAppraisal.ToString(CultureInfo.InvariantCulture); model.Status = "Appraisal"; //return RedirectToAction("ViewProfileForAppraisal", "Appraisal", new { AppraisalId = row["AppraisalID"].ToString() }); } else { var vehicleInfo = autoService.GetVehicleInformationFromVin(vin); if (vehicleInfo != null) { model.Vin = vin; model.Status = "VinProcessing"; } else { model.Vin = vin; model.Status = "VinInvalid"; } } return(model); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var context = new whitmanenterprisewarehouseEntities(); var firstYearList = InventoryQueryHelper.GetSingleOrGroupInventory(context).Select(x => x.ModelYear).ToList(); var secondYearList = InventoryQueryHelper.GetSingleOrGroupSoldoutInventory(context).Select(x => x.ModelYear); firstYearList.AddRange(secondYearList); var yearList = new List <string>(); yearList.Insert(0, string.Empty); yearList.AddRange(firstYearList.Distinct().OrderByDescending(i => i.Value).ToList().Select(i => i.Value.ToString()).ToList()); YearDropDownList.DataSource = yearList; YearDropDownList.DataBind(); } }
public List <VehiclePriceChange> GetHistoryChanged(int dealerId, int month, int year, string make, string model, string stock, string vin) { var context = new whitmanenterprisewarehouseEntities(); var finalInventory = (context.vincontrolpricechangeshistories.Where(GetMonthQuery(month)).Join(InventoryQueryHelper.GetSingleOrGroupInventory(context).Where(i => i.DealershipId == dealerId).Where(GetYearQuery(year)).Where(GetMakeQuery(make)).Where(GetModelQuery(model)).Where(GetStockQuery(stock)).Where(GetVinQuery(vin)), p => p.ListingId, i => i.ListingID, (p, i) => new VehiclePriceChange() { Make = i.Make, Model = i.Model, Month = p.DateStamp.Value.Month, OldPrice = (long)p.OldPrice.Value, Price = (long)p.NewPrice.Value, StockNumber = i.StockNumber, UpdatedDate = p.DateStamp.Value, User = p.UserStamp, VINNumber = i.VINNumber, DealershipName = i.DealershipName, Year = i.ModelYear ?? 0 })).OrderBy(x => x.Make).ThenBy(x => x.UpdatedDate).ToList(); var soldInventory = (context.vincontrolpricechangeshistories.Where(GetMonthQuery(month)).Join(InventoryQueryHelper.GetSingleOrGroupSoldoutInventory(context).Where(i => i.DealershipId == dealerId).Where(GetYearQueryForSold(year)).Where(GetMakeQueryForSold(make)).Where(GetModelQueryForSold(model)).Where(GetStockQueryForSold(stock)).Where(GetVinQueryForSold(vin)), p => p.ListingId, i => i.OldListingId, (p, i) => new VehiclePriceChange() { Make = i.Make, Model = i.Model, Month = p.DateStamp.Value.Month, OldPrice = (long)p.OldPrice.Value, Price = (long)p.NewPrice.Value, StockNumber = i.StockNumber, UpdatedDate = p.DateStamp.Value, User = p.UserStamp, VINNumber = i.VINNumber, DealershipName = i.DealershipName, Year = i.ModelYear ?? 0 })).OrderBy(x => x.Make).ThenBy(x => x.UpdatedDate).ToList(); finalInventory.AddRange(soldInventory); return(finalInventory); }
//public static void ExportToCSV<T>(this IQueryable<T> list, string filename, string[] exclude) //{ // StringWriter sw = new StringWriter(); // bool headerPrinted = false; // foreach (var obj in list) // { // Type type = obj.GetType(); // PropertyInfo[] properties = type.GetProperties(); // string s = String.Empty; // if (!headerPrinted) // { // foreach (PropertyInfo propertyInfo in properties) // { // if (exclude.Count(x => x.Contains(propertyInfo.Name)) > 0) // continue; // if (s.Length > 0) // s = String.Join(",", new string[] { s, propertyInfo.Name }); // else // s = propertyInfo.Name; // } // sw.WriteLine(s); // headerPrinted = true; // } // s = String.Empty; // for (int idx = 0; idx < properties.Length; idx++) // { // if (exclude.Count(x => x.Contains(properties[idx].Name)) > 0) // continue; // var value = properties[idx].GetValue(obj, null); // var formattedValue = value == null ? String.Empty : value.ToString(); // if (value != null) // { // if (value.GetType() == typeof(string)) // formattedValue = "\"" + formattedValue + "\""; // } // if (s.Length > 0) // s = String.Join(",", new string[] { s, formattedValue }); // else // s = formattedValue; // } // sw.WriteLine(s); // } // HttpResponse response = System.Web.HttpContext.Current.Response; // response.AddHeader("Content-Disposition", "attachment; filename=" + filename); // response.ContentType = "application/ms-excel"; // response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); // response.Write(sw); // response.End(); //} public static byte[] ExportToCSV(List <CarInfoFormViewModel> carList, int dealerId, string Title) { var package = new ExcelPackage(); // add a new worksheet to the empty workbook var worksheet = package.Workbook.Worksheets.Add(Title); WriteHeader(worksheet); //Switch the PageLayoutView back to normal // lets set the header text worksheet.HeaderFooter.oddHeader.CenteredText = "&24&U&\"Arial,Regular Bold\"" + Title; // add the page number to the footer plus the total number of pages worksheet.HeaderFooter.oddFooter.RightAlignedText = string.Format("Page {0} of {1}", ExcelHeaderFooter.PageNumber, ExcelHeaderFooter.NumberOfPages); // add the sheet name to the footer worksheet.HeaderFooter.oddFooter.CenteredText = ExcelHeaderFooter.SheetName; // add the file path to the footer worksheet.PrinterSettings.RepeatRows = worksheet.Cells["1:1"]; worksheet.PrinterSettings.RepeatColumns = worksheet.Cells["A:G"]; package.Workbook.Properties.Title = Title; worksheet = package.Workbook.Worksheets[1]; int numberOfRow = worksheet.Dimension.End.Row - worksheet.Dimension.Start.Row; int startRow = numberOfRow + 2; var context = new whitmanenterprisewarehouseEntities(); var dtDealerSetting = context.whitmanenterprisesettings.FirstOrDefault(x => x.DealershipId == dealerId); //PlUG DATA startRow = PlugData(carList.Where(x => !x.Reconstatus).OrderBy(x => x.Make), worksheet, dtDealerSetting.DefaultStockImageUrl, startRow, false); PlugData(carList.Where(x => x.Reconstatus).OrderBy(x => x.Make), worksheet, dtDealerSetting.DefaultStockImageUrl, startRow, true); return(package.GetAsByteArray()); }
private string GetRandomizedSentence(int typeId, string dealershipName) { using (var context = new whitmanenterprisewarehouseEntities()) { var random = new Random(); if (context.vincontrolsentences.Any(i => i.typeId == typeId)) { var activeSentences = context.vincontrolsentences.Where(i => i.typeId == typeId); int randomElement = random.Next(0, activeSentences.Count()); var returnSentence = activeSentences.ToList().ElementAt(randomElement).sentence; if (returnSentence.Contains("[Dealership]")) { returnSentence = returnSentence.Replace("[Dealership]", dealershipName); } return(returnSentence); } else { return(string.Empty); } } }
public static TradeInVehicleModel GetTradeinVehicle(int id) { var context = new whitmanenterprisewarehouseEntities(); var customer = context.vincontrolbannercustomers.Where(e => e.TradeInCustomerId == id).FirstOrDefault(); decimal result; TradeInVehicleModel vehicle = new TradeInVehicleModel() { Condition = customer.Condition, CustomerEmail = customer.Email, CustomerFirstName = customer.FirstName, CustomerLastName = customer.LastName, CustomerPhone = customer.Phone, SelectedMake = customer.Make, SelectedModel = customer.Model, SelectedTrim = customer.Trim, SelectedYear = customer.Year.HasValue ? customer.Year.Value.ToString() : String.Empty, Mileage = customer.Mileage.HasValue ? customer.Mileage.Value.ToString() : String.Empty, SelectedOptionList = customer.SelectedOptions, TradeInFairPrice = decimal.TryParse(customer.TradeInFairValue, out result) ? result.ToString("c0") : customer.TradeInFairValue }; return(vehicle); }
private void UploadImage(HttpContext context, bool saveImage) { string dealerId = context.Request.QueryString["DealerId"]; string vin = context.Request.QueryString["Vin"]; int overlay = Convert.ToInt32(context.Request.QueryString["Overlay"]); string fileName = context.Request.QueryString["uploadedfile"]; string imageFileName = fileName; //string imageFileName = ListingId + "-" + FileName; ImageDirectories imageDirectories = CreateFolder(dealerId, vin); string resultFileName = imageDirectories.FullSizeDirectory.FullName + "/" + imageFileName + ".jpg"; using (FileStream fileStream = File.Create(resultFileName)) { var bytes = new byte[4096]; //100MB max int totalBytesRead; while ((totalBytesRead = context.Request.InputStream.Read(bytes, 0, bytes.Length)) != 0) { fileStream.Write(bytes, 0, totalBytesRead); } } var image = ProcessImage(dealerId, vin, overlay, imageFileName, imageDirectories.FullSizeDirectory, imageDirectories.ThumbnailDirectory); if (saveImage) { int listingId = int.Parse(context.Request.QueryString["ListingId"].ToString(CultureInfo.InvariantCulture)); using (var dbContext = new whitmanenterprisewarehouseEntities()) { var row = dbContext.whitmanenterprisedealershipinventories.FirstOrDefault(x => x.ListingID == listingId); if (row != null) { if (String.IsNullOrEmpty(row.CarImageUrl)) { row.CarImageUrl = image.FileUrl; } else { row.CarImageUrl = row.CarImageUrl + ',' + image.FileUrl; } if (String.IsNullOrEmpty(row.ThumbnailImageURL)) { row.ThumbnailImageURL = image.ThumbnailUrl; } else { row.ThumbnailImageURL = row.ThumbnailImageURL + ',' + image.ThumbnailUrl; } row.LastUpdated = DateTime.Now; dbContext.SaveChanges(); } } } var js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(image)); }
// // GET: /Switch/ public ActionResult SwitchDealership(CarInfoFormViewModel switchModel) { try { if (Session["DealerGroup"] != null) { var dealerGroup = (DealerGroupViewModel)Session["DealerGroup"]; if (switchModel.SelectedDealerTransfer.Equals("999")) { SessionHandler.Single = false; Session["DealershipName"] = dealerGroup.DealershipGroupName; return(Json("Success")); } var switchDealer = dealerGroup.DealerList.First(t => t.DealershipId.ToString(CultureInfo.InvariantCulture).Equals(switchModel.SelectedDealerTransfer)); using (var context = new whitmanenterprisewarehouseEntities()) { var setting = context.whitmanenterprisesettings.FirstOrDefault(x => x.DealershipId == switchDealer.DealershipId); switchDealer.DealerGroupId = dealerGroup.DealershipGroupId; switchDealer.InventorySorting = setting.InventorySorting; switchDealer.SoldOut = setting.SoldOut; switchDealer.DefaultStockImageUrl = setting.DefaultStockImageUrl; switchDealer.OverrideStockImage = setting.OverideStockImage.Value; switchDealer.OverrideDealerKbbReport = switchDealer.OverrideDealerKbbReport; switchDealer.DealerInfo = setting.DealerInfo; switchDealer.DealerWarranty = setting.DealerWarranty; switchDealer.TermConditon = setting.TermsAndCondition; switchDealer.EbayToken = setting.EbayToken; switchDealer.EbayInventoryUrl = setting.EbayInventoryURL; switchDealer.CreditUrl = setting.CreditURL; switchDealer.WebSiteUrl = setting.WebSiteURL; switchDealer.ContactUsUrl = setting.ContactUsURL; switchDealer.FacebookUrl = setting.FacebookURL; switchDealer.LogoUrl = setting.LogoURL; switchDealer.ContactPerson = setting.ContactUsURL; switchDealer.CarFax = setting.CarFax; switchDealer.CarFaxPassword = setting.CarFaxPassword; switchDealer.Manheim = setting.Manheim; switchDealer.ManheimPassword = setting.ManheimPassword; switchDealer.KellyBlueBook = setting.KellyBlueBook; switchDealer.KellyPassword = setting.KellyPassword; switchDealer.BlackBook = setting.BlackBook; switchDealer.BlackBookPassword = setting.BlackBookPassword; switchDealer.IntervalBucketJump = setting.IntervalBucketJump.GetValueOrDefault(); switchDealer.FirstIntervalJump = setting.FirstTimeRangeBucketJump.GetValueOrDefault(); switchDealer.SecondIntervalJump = setting.SecondTimeRangeBucketJump.GetValueOrDefault(); switchDealer.LoanerSentence = setting.LoanerSentence; switchDealer.AuctionSentence = setting.AuctionSentence; SessionHandler.Single = true; Session["Dealership"] = switchDealer; Session["DealershipName"] = switchDealer.DealershipName; } return(Json("Success")); } else { return(Json("SessionTimeOut")); } } catch (Exception ex) { return(Json(ex.ToString())); } }
public static IQueryable <whitmanenterprisedealership> GetSingleOrGroupDealer(whitmanenterprisewarehouseEntities context) { if (!SessionHandler.Single) { return(context.whitmanenterprisedealerships.Where( LogicHelper.BuildContainsExpression <whitmanenterprisedealership, int>( e => e.idWhitmanenterpriseDealership, GetDealerList(context)))); } return(context.whitmanenterprisedealerships.Where(e => e.idWhitmanenterpriseDealership == SessionHandler.Dealership.DealershipId)); }