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