private static void FillData(ExcelWorksheet worksheet, string defaultStockImageUrl, int startRow, CarInfoFormViewModel drRow) { CarExcelInfoViewModel carExcelInfoViewModel = drRow.ConvertToCarExcelViewInfo(defaultStockImageUrl); worksheet.SetValue(startRow, 1, carExcelInfoViewModel.ModelYear.ToString()); worksheet.SetValue(startRow, 2, carExcelInfoViewModel.Make.ToString()); worksheet.SetValue(startRow, 3, carExcelInfoViewModel.Model.ToString()); worksheet.SetValue(startRow, 4, carExcelInfoViewModel.StockNumber.ToString()); worksheet.SetValue(startRow, 5, carExcelInfoViewModel.Vin.ToString()); worksheet.SetValue(startRow, 6, carExcelInfoViewModel.Mileage.ToString()); worksheet.SetValue(startRow, 7, carExcelInfoViewModel.ExteriorColor.ToString()); worksheet.SetValue(startRow, 8, carExcelInfoViewModel.SalePrice.ToString()); worksheet.SetValue(startRow, 9, carExcelInfoViewModel.Days); worksheet.SetValue(startRow, 10, carExcelInfoViewModel.imagesNum); }
public static CarExcelInfoViewModel ConvertToCarExcelViewInfo(this CarInfoFormViewModel drRow, string defaultStockImageUrl) { string imagesNum = GetImageNum(drRow.CarImageUrl, drRow.DefaultImageUrl, defaultStockImageUrl); CarExcelInfoViewModel carExcelInfoViewModel = new CarExcelInfoViewModel() { Days = DateTime.Now.Subtract(drRow.DateInStock.Value).Days, ExteriorColor = drRow.ExteriorColor, imagesNum = imagesNum, Make = drRow.Make, Mileage = drRow.Mileage, Model = drRow.Model, ModelYear = drRow.ModelYear.ToString(), SalePrice = drRow.SalePrice, StockNumber = drRow.StockNumber, Vin = drRow.Vin, Reconstatus = drRow.Reconstatus }; return(carExcelInfoViewModel); }