public void ReadExcelIntoTempObjects(string fileName, string productNum)
{
TempProducts.Clear();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(fileName)))
{
var firstSheet = package.Workbook.Worksheets["Configured Options"];
int row = 1, j = 1;
for (row = 2; row < firstSheet.Dimension.Rows; row++)
{
ExcelProduct ep = new ExcelProduct();
ep.ProductName = firstSheet.Cells[row, 1].Text;
ep.ProductNumber = firstSheet.Cells[row, 2].Text;
ep.FeatureName = firstSheet.Cells[row, 3].Text;
ep.FeatureRequired = firstSheet.Cells[row, 4].Text;
ep.FeatureCSROnly = firstSheet.Cells[row, 5].Text;
ep.OptionGroupName = firstSheet.Cells[row, 6].Text;
ep.OptionGroupRequired = firstSheet.Cells[row, 7].Text;
ep.OptionGroupCSRonly = firstSheet.Cells[row, 8].Text;
ep.SubOptionGroupName = firstSheet.Cells[row, 9].Text;
ep.SubOptionGroupRequired = firstSheet.Cells[row, 10].Text;
ep.OptionName = firstSheet.Cells[row, 11].Text;
ep.OptionCode = firstSheet.Cells[row, 12].Text;
ep.HCPCS = firstSheet.Cells[row, 13].Text;
ep.OptionRequired = firstSheet.Cells[row, 14].Text;
ep.OptionCSROnly = firstSheet.Cells[row, 15].Text;
ep.WorkTicketInput = firstSheet.Cells[row, 16].Text;
TempProducts.Add(ep);
}
}
}
public void ExportProductsToExcelFilesByBrands(string brand)
{
List <ExcelProduct> excelProducts = new List <ExcelProduct>();
List <Product> brandProducts = products.Where(p => p.ProductManufacturerMapping?.FirstOrDefault()?.Manufacturer?.Name == brand).ToList();
foreach (Product product in brandProducts)
{
log.Info("Product " + product.Sku + "is being processed ");
ExcelProduct excelProduct = ExcelProductUtil.GenerateExcelProductFromProduct(product);
excelProducts.Add(excelProduct);
}
_excelProductService.GenerateExcelSheetfromExcelProductsByBrand(excelProducts, brand);
}
public static AppProduct ConvertExcelProductToAppProduct(ExcelProduct excelProduct)
{
return(new AppProduct()
{
Name = excelProduct.ProductTitle?.TrimStart().TrimEnd(),
LogoKodu = excelProduct.PartnerSKUUnique,
KatalogKodu = excelProduct.PartnerSKUUnique,
CategoryID = 325,
Marka = excelProduct.BrandName,
//Stok = ConversionUtil.ConvertStringToIntNotParsable0(excelProduct.Quantity_Stock),
BulletPoint1 = excelProduct.FeatureBullet1,
BulletPoint2 = excelProduct.FeatureBullet2,
BulletPoint3 = excelProduct.FeatureBullet3,
BulletPoint4 = excelProduct.FeatureBullet4,
BulletPoint5 = excelProduct.FeatureBullet5,
GTIN = excelProduct.GTIN
});
}
public void ReadExcelIntoObjects(string fileName, string productNum)
{
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage(new FileInfo(fileName)))
{
var firstSheet = package.Workbook.Worksheets["Configured Options"];
int row = 1, j = 1;
for (row = 1; row < 5000; row++)
{
//if (row > 1 && firstSheet.Cells[row, 2].Text != productNum)
// break;
ExcelProduct ep = new ExcelProduct();
ep.ProductName = firstSheet.Cells[row, 1].Text;
ep.ProductNumber = firstSheet.Cells[row, 2].Text;
ep.FeatureName = firstSheet.Cells[row, 3].Text;
ep.FeatureRequired = firstSheet.Cells[row, 4].Text;
ep.FeatureCSROnly = firstSheet.Cells[row, 5].Text;
ep.OptionGroupName = firstSheet.Cells[row, 6].Text;
ep.OptionGroupRequired = firstSheet.Cells[row, 7].Text;
ep.OptionGroupCSRonly = firstSheet.Cells[row, 8].Text;
ep.SubOptionGroupName = firstSheet.Cells[row, 9].Text;
ep.SubOptionGroupRequired = firstSheet.Cells[row, 10].Text;
ep.OptionName = firstSheet.Cells[row, 11].Text;
ep.OptionCode = firstSheet.Cells[row, 12].Text;
ep.HCPCS = firstSheet.Cells[row, 13].Text;
ep.OptionRequired = firstSheet.Cells[row, 14].Text;
ep.OptionCSROnly = firstSheet.Cells[row, 15].Text;
ep.WorkTicketInput = firstSheet.Cells[row, 16].Text;
ProductList.Add(ep);
// for (j = 1; j < firstSheet.Dimension.Columns; j++)
// {
// }
}
Console.WriteLine("Sheet 1 Data");
}
}
public static Product CreateInsertProductModel(ExcelProduct excelProduct)
{
Product product = new Product();
product.ProductTypeId = 5;
product.ParentGroupedProductId = 0;
product.VisibleIndividually = false;
product.Name = excelProduct.ProductTitle?.TrimEnd().TrimStart();
product.ProductTemplateId = 1;
product.VendorId = 0;
product.ShowOnHomePage = false;
product.AllowCustomerReviews = false;
product.ApprovedRatingSum = 0;
product.NotApprovedRatingSum = 0;
product.ApprovedTotalReviews = 0;
product.NotApprovedTotalReviews = 0;
product.SubjectToAcl = false;
product.LimitedToStores = false;
product.IsGiftCard = false;
product.GiftCardTypeId = 0;
product.RequireOtherProducts = false;
product.AutomaticallyAddRequiredProducts = false;
product.IsDownload = false;
product.DownloadId = 0;
product.UnlimitedDownloads = false;
product.MaxNumberOfDownloads = 0;
product.DownloadActivationTypeId = 0;
product.HasSampleDownload = false;
product.SampleDownloadId = 0;
product.HasUserAgreement = false;
product.IsRecurring = false;
product.RecurringCycleLength = 0;
product.RecurringCyclePeriodId = 0;
product.RecurringTotalCycles = 0;
product.IsRental = false;
product.RentalPriceLength = 0;
product.RentalPricePeriodId = 0;
product.IsShipEnabled = false;
product.IsFreeShipping = false;
product.ShipSeparately = false;
product.AdditionalShippingCharge = 0;
product.DeliveryDateId = 0;
product.IsTaxExempt = false;
product.TaxCategoryId = 0;
product.IsTelecommunicationsOrBroadcastingOrElectronicServices = false;
product.ManageInventoryMethodId = 0;
product.ProductAvailabilityRangeId = 0;
product.UseMultipleWarehouses = false;
product.WarehouseId = 0;
product.StockQuantity = 20;
product.DisplayStockAvailability = false;
product.DisplayStockQuantity = false;
product.MinStockQuantity = 20;
product.LowStockActivityId = 0;
product.NotifyAdminForQuantityBelow = 1;
product.BackorderModeId = 0;
product.AllowBackInStockSubscriptions = false;
product.OrderMinimumQuantity = 1;
product.OrderMaximumQuantity = 100;
product.AllowAddingOnlyExistingAttributeCombinations = false;
product.NotReturnable = false;
product.DisableBuyButton = false;
product.DisableWishlistButton = false;
product.AvailableForPreOrder = false;
product.CallForPrice = false;
product.Price = 0;
product.OldPrice = 0;
product.ProductCost = 0;
product.CustomerEntersPrice = false;
product.MinimumCustomerEnteredPrice = 0;
product.MaximumCustomerEnteredPrice = 0;
product.BasepriceEnabled = false;
product.BasepriceAmount = 0;
product.BasepriceUnitId = 0;
product.BasepriceBaseAmount = 0;
product.BasepriceBaseUnitId = 0;
product.MarkAsNew = false;
product.HasTierPrices = false;
product.HasDiscountsApplied = false;
product.Weight = 0;
product.Length = 0;
product.Width = 0;
product.Height = 0;
product.DisplayOrder = 0;
product.Published = true;
product.Deleted = false;
product.CreatedOnUtc = DateTime.Now;
product.UpdatedOnUtc = DateTime.Now;
product.ParcelDesi = 0;
product.ParcelWeight = 0;
product.AbroadDesi = 0;
product.Sku = excelProduct.PartnerSKUUnique;
product.ManufacturerPartNumber = excelProduct.GTIN;
product.FullDescription = product.FullDescription?.TrimEnd().TrimStart();
product.Gtin = excelProduct.GTIN;
product.BulletPoint1 = excelProduct.FeatureBullet1;
product.BulletPoint2 = excelProduct.FeatureBullet2;
product.BulletPoint3 = excelProduct.FeatureBullet3;
product.BulletPoint4 = excelProduct.FeatureBullet4;
product.BulletPoint5 = excelProduct.FeatureBullet5;
return(product);
}
public static Product CreateUpdateProductModelFromExcelProduct(Product product, ExcelProduct excelProduct)
{
product.Name = string.IsNullOrEmpty(excelProduct.ProductTitle) ? product.Name : excelProduct.ProductTitle.TrimEnd().TrimStart();
product.UpdatedOnUtc = DateTime.Now;
product.FullDescription = string.IsNullOrEmpty(excelProduct.LongDescription) ? product.FullDescription : excelProduct.ProductTitle.TrimEnd().TrimStart();
product.Gtin = excelProduct.GTIN;
product.BulletPoint1 = excelProduct.FeatureBullet1;
product.BulletPoint2 = excelProduct.FeatureBullet2;
product.BulletPoint3 = excelProduct.FeatureBullet3;
product.BulletPoint4 = excelProduct.FeatureBullet4;
product.BulletPoint5 = excelProduct.FeatureBullet5;
return(product);
}
public List <ExcelProduct> FindAllExcelProducts(FileInfo fileInfo)
{
List <ExcelProduct> excelProducts = new List <ExcelProduct>();
try
{
string path = @"MyTest.txt";
if (!File.Exists(path))
{
File.CreateText(path);
}
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int rowCount = worksheet.Dimension.Rows;
int colCount = worksheet.Dimension.Columns;
DataTable dataTable = new DataTable();
for (int column = 1; column <= colCount; column++)
{
dataTable.Columns.Add(worksheet.Cells[1, column]?.Value?.ToString());
}
for (int row = 2; row <= rowCount; row++)
{
DataRow newRow = dataTable.NewRow();
for (int column = 1; column <= colCount; column++)
{
try {
newRow[dataTable.Columns[column - 1]] = worksheet.Cells[row, column]?.Value?.ToString();
}catch (Exception)
{
}
}
dataTable.Rows.Add(newRow);
}
foreach (DataRow dataRow in dataTable.Rows)
{
ExcelProduct excelProduct = new ExcelProduct();
excelProduct.GTIN = dataRow.Table.Columns.Contains("GTIN") ? dataRow["GTIN"]?.ToString() : null;
excelProduct.SeasonCode = dataRow.Table.Columns.Contains("Season Code") ? dataRow["Season Code"]?.ToString() : null;
excelProduct.Year = dataRow.Table.Columns.Contains("Year") ? dataRow["Year"]?.ToString() : null;
excelProduct.StyleorPartNumber = dataRow.Table.Columns.Contains("Style or Part Number") ? dataRow["Style or Part Number"]?.ToString() : null;
excelProduct.PartnerSKUUnique = dataRow.Table.Columns.Contains("Partner SKU Unique") ? dataRow["Partner SKU Unique"]?.ToString() : null;
using (StreamWriter sw = File.AppendText(path))
{
sw.WriteLine(excelProduct.PartnerSKUUnique);
sw.Flush();
}
excelProduct.ParentSKU = dataRow.Table.Columns.Contains("Parent SKU") ? dataRow["Parent SKU"]?.ToString() : null;
excelProduct.BrandName = dataRow.Table.Columns.Contains("Brand Name") ? dataRow["Brand Name"]?.ToString() : null;
excelProduct.ProductTitle = dataRow.Table.Columns.Contains("Product Title") ? dataRow["Product Title"]?.ToString() : null;
excelProduct.Department = dataRow.Table.Columns.Contains("Department") ? dataRow["Department"]?.ToString() : null;
excelProduct.ProductType = dataRow.Table.Columns.Contains("Product Type") ? dataRow["Product Type"]?.ToString() : null;
excelProduct.ProductSubtype = dataRow.Table.Columns.Contains("Product Subtype") ? dataRow["Product Subtype"]?.ToString() : null;
excelProduct.SportType = dataRow.Table.Columns.Contains("Sport Type") ? dataRow["Sport Type"]?.ToString() : null;
excelProduct.CountryofOrigin = dataRow.Table.Columns.Contains("Country of Origin") ? dataRow["Country of Origin"]?.ToString() : null;
excelProduct.StyleorPartName = dataRow.Table.Columns.Contains("Style or Part Name") ? dataRow["Style or Part Name"]?.ToString() : null;
excelProduct.ColourName = dataRow.Table.Columns.Contains("Colour Name") ? dataRow["Colour Name"]?.ToString() : null;
excelProduct.ColourFamily = dataRow.Table.Columns.Contains("Colour Family") ? dataRow["Colour Family"]?.ToString() : null;
excelProduct.Size = dataRow.Table.Columns.Contains("Size") ? dataRow["Size"]?.ToString() : null;
excelProduct.SizingStandard = dataRow.Table.Columns.Contains("Sizing Standard") ? dataRow["Sizing Standard"]?.ToString() : null;
excelProduct.TargetAgeRange = dataRow.Table.Columns.Contains("Target Age Range") ? dataRow["Target Age Range"]?.ToString() : null;
excelProduct.SpecialSizeType = dataRow.Table.Columns.Contains("Special Size Type") ? dataRow["Special Size Type"]?.ToString() : null;
excelProduct.Material = dataRow.Table.Columns.Contains("Material") ? dataRow["Material"]?.ToString() : null;
excelProduct.LiningMaterial = dataRow.Table.Columns.Contains("Lining Material") ? dataRow["Lining Material"]?.ToString() : null;
excelProduct.Neckline = dataRow.Table.Columns.Contains("Neckline") ? dataRow["Neckline"]?.ToString() : null;
excelProduct.SleeveType = dataRow.Table.Columns.Contains("Sleeve Type") ? dataRow["Sleeve Type"]?.ToString() : null;
excelProduct.Fit = dataRow.Table.Columns.Contains("Fit") ? dataRow["Fit"]?.ToString() : null;
excelProduct.Occasion = dataRow.Table.Columns.Contains("Occasion") ? dataRow["Occasion"]?.ToString() : null;
excelProduct.SkirtDressLength = dataRow.Table.Columns.Contains("Skirt/Dress Length") ? dataRow["Skirt/Dress Length"]?.ToString() : null;
excelProduct.WaistType = dataRow.Table.Columns.Contains("Waist Type") ? dataRow["Waist Type"]?.ToString() : null;
excelProduct.BraSupport = dataRow.Table.Columns.Contains("Bra Support") ? dataRow["Bra Support"]?.ToString() : null;
excelProduct.CareInstructions = dataRow.Table.Columns.Contains("Care Instructions") ? dataRow["Care Instructions"]?.ToString() : null;
excelProduct.AttributeKey1 = dataRow.Table.Columns.Contains("Attribute Key 1") ? dataRow["Attribute Key 1"]?.ToString() : null;
excelProduct.AttributeValue1 = dataRow.Table.Columns.Contains("Attribute Value 1") ? dataRow["Attribute Value 1"]?.ToString() : null;
excelProduct.AttributeKey2 = dataRow.Table.Columns.Contains("Attribute Key 2") ? dataRow["Attribute Key 2"]?.ToString() : null;
excelProduct.AttributeValue2 = dataRow.Table.Columns.Contains("Attribute Value 2") ? dataRow["Attribute Value 2"]?.ToString() : null;
excelProduct.AttributeKey3 = dataRow.Table.Columns.Contains("Attribute Key 3") ? dataRow["Attribute Key 3"]?.ToString() : null;
excelProduct.AttributeValue3 = dataRow.Table.Columns.Contains("Attribute Value 3") ? dataRow["Attribute Value 3"]?.ToString() : null;
excelProduct.AttributeKey4 = dataRow.Table.Columns.Contains("Attribute Key 4") ? dataRow["Attribute Key 4"]?.ToString() : null;
excelProduct.AttributeValue4 = dataRow.Table.Columns.Contains("Attribute Value 4") ? dataRow["Attribute Value 4"]?.ToString() : null;
excelProduct.AttributeKey5 = dataRow.Table.Columns.Contains("Attribute Key 5") ? dataRow["Attribute Key 5"]?.ToString() : null;
excelProduct.AttributeValue5 = dataRow.Table.Columns.Contains("Attribute Value 5") ? dataRow["Attribute Value 5"]?.ToString() : null;
excelProduct.LongDescription = dataRow.Table.Columns.Contains("Long Description") ? dataRow["Long Description"]?.ToString() : null;
excelProduct.FeatureBullet1 = dataRow.Table.Columns.Contains("Feature/Bullet 1") ? dataRow["Feature/Bullet 1"]?.ToString() : null;
excelProduct.FeatureBullet2 = dataRow.Table.Columns.Contains("Feature/Bullet 2") ? dataRow["Feature/Bullet 2"]?.ToString() : null;
excelProduct.FeatureBullet3 = dataRow.Table.Columns.Contains("Feature/Bullet 3") ? dataRow["Feature/Bullet 3"]?.ToString() : null;
excelProduct.FeatureBullet4 = dataRow.Table.Columns.Contains("Feature/Bullet 4") ? dataRow["Feature/Bullet 4"]?.ToString() : null;
excelProduct.FeatureBullet5 = dataRow.Table.Columns.Contains("Feature/Bullet 5") ? dataRow["Feature/Bullet 5"]?.ToString() : null;
excelProduct.ImageURL1 = dataRow.Table.Columns.Contains("Image URL 1") ? dataRow["Image URL 1"]?.ToString() : null;
excelProduct.ImageURL2 = dataRow.Table.Columns.Contains("Image URL 2") ? dataRow["Image URL 2"]?.ToString() : null;
excelProduct.ImageURL3 = dataRow.Table.Columns.Contains("Image URL 3") ? dataRow["Image URL 3"]?.ToString() : null;
excelProduct.ImageURL4 = dataRow.Table.Columns.Contains("Image URL 4") ? dataRow["Image URL 4"]?.ToString() : null;
excelProduct.ImageURL5 = dataRow.Table.Columns.Contains("Image URL 5") ? dataRow["Image URL 5"]?.ToString() : null;
excelProduct.ImageURL6 = dataRow.Table.Columns.Contains("Image URL 6") ? dataRow["Image URL 6"]?.ToString() : null;
excelProduct.ImageURL7 = dataRow.Table.Columns.Contains("Image URL 7") ? dataRow["Image URL 7"]?.ToString() : null;
excelProduct.ShippingLengthcm = dataRow.Table.Columns.Contains("Shipping Length (cm)") ? dataRow["Shipping Length (cm)"]?.ToString() : null;
excelProduct.ShippingHeightcm = dataRow.Table.Columns.Contains("Shipping Height (cm)") ? dataRow["Shipping Height (cm)"]?.ToString() : null;
excelProduct.ShippingWidthDepthcm = dataRow.Table.Columns.Contains("Shipping Width/Depth (cm)") ? dataRow["Shipping Width/Depth (cm)"]?.ToString() : null;
excelProduct.ShippingWeightKG = dataRow.Table.Columns.Contains("Shipping Weight (KG)") ? dataRow["Shipping Weight (KG)"]?.ToString() : null;
excelProduct.ShippingDestination = dataRow.Table.Columns.Contains("Shipping Destination") ? dataRow["Shipping Destination"]?.ToString() : null;
excelProduct.QuantityStock = dataRow.Table.Columns.Contains("Quantity/Stock") ? dataRow["Quantity/Stock"]?.ToString() : null;
excelProduct.FulfilmentMethod = dataRow.Table.Columns.Contains("Fulfilment Method") ? dataRow["Fulfilment Method"]?.ToString() : null;
excelProduct.ProcessingTime = dataRow.Table.Columns.Contains("Processing Time") ? dataRow["Processing Time"]?.ToString() : null;
excelProduct.MSRPAE = dataRow.Table.Columns.Contains("MSRP AE") ? dataRow["MSRP AE"]?.ToString() : null;
excelProduct.MSRPSA = dataRow.Table.Columns.Contains("MSRP SA") ? dataRow["MSRP SA"]?.ToString() : null;
excelProduct.MSRPEG = dataRow.Table.Columns.Contains("MSRP EG") ? dataRow["MSRP EG"]?.ToString() : null;
excelProduct.CostAED = dataRow.Table.Columns.Contains("Cost (AED)") ? dataRow["Cost (AED)"]?.ToString() : null;
excelProduct.SellingPriceAED = dataRow.Table.Columns.Contains("Selling Price (AED)") ? dataRow["Selling Price (AED)"]?.ToString() : null;
excelProduct.SellingPriceSAR = dataRow.Table.Columns.Contains("Selling Price (SAR)") ? dataRow["Selling Price (SAR)"]?.ToString() : null;
excelProduct.SellingPriceEGP = dataRow.Table.Columns.Contains("Selling Price (EGP)") ? dataRow["Selling Price (EGP)"]?.ToString() : null;
excelProduct.PromotionalPriceAED = dataRow.Table.Columns.Contains("Promotional Price (AED)") ? dataRow["Promotional Price (AED)"]?.ToString() : null;
excelProduct.PromotionalPriceSAR = dataRow.Table.Columns.Contains("Promotional Price (SAR)") ? dataRow["Promotional Price (SAR)"]?.ToString() : null;
excelProduct.PromotionalPriceEGP = dataRow.Table.Columns.Contains("Promotional Price (EGP)") ? dataRow["Promotional Price (EGP)"]?.ToString() : null;
excelProduct.HSCode = dataRow.Table.Columns.Contains("HS Code") ? dataRow["HS Code"]?.ToString() : null;
excelProduct.ModelNumber = dataRow.Table.Columns.Contains("Model Number") ? dataRow["Model Number"]?.ToString() : null;
excelProduct.ModelName = dataRow.Table.Columns.Contains("Model Name") ? dataRow["Model Name"]?.ToString() : null;
excelProduct.ProductLength = dataRow.Table.Columns.Contains("Product Length") ? dataRow["Product Length"]?.ToString() : null;
excelProduct.LengthUnit = dataRow.Table.Columns.Contains("Length Unit") ? dataRow["Length Unit"]?.ToString() : null;
excelProduct.ProductHeight = dataRow.Table.Columns.Contains("Product Height") ? dataRow["Product Height"]?.ToString() : null;
excelProduct.HeightUnit = dataRow.Table.Columns.Contains("Height Unit") ? dataRow["Height Unit"]?.ToString() : null;
excelProduct.ProductWidthDepth = dataRow.Table.Columns.Contains("Product Width/Depth") ? dataRow["Product Width/Depth"]?.ToString() : null;
excelProduct.WidthDepthUnit = dataRow.Table.Columns.Contains("Width/Depth Unit") ? dataRow["Width/Depth Unit"]?.ToString() : null;
excelProduct.ProductWeight = dataRow.Table.Columns.Contains("Product Weight") ? dataRow["Product Weight"]?.ToString() : null;
excelProduct.WeightUnit = dataRow.Table.Columns.Contains("Weight Unit") ? dataRow["Weight Unit"]?.ToString() : null;
excelProduct.Capacity = dataRow.Table.Columns.Contains("Capacity") ? dataRow["Capacity"]?.ToString() : null;
excelProduct.CapacityUnit = dataRow.Table.Columns.Contains("Capacity Unit") ? dataRow["Capacity Unit"]?.ToString() : null;
excelProduct.NumberofPieces = dataRow.Table.Columns.Contains("Number of Pieces") ? dataRow["Number of Pieces"]?.ToString() : null;
excelProduct.SizeUnit = dataRow.Table.Columns.Contains("Size Unit") ? dataRow["Size Unit"]?.ToString() : null;
excelProduct.ExteriorMaterial = dataRow.Table.Columns.Contains("Exterior Material") ? dataRow["Exterior Material"]?.ToString() : null;
excelProduct.InteriorMaterial = dataRow.Table.Columns.Contains("Interior Material") ? dataRow["Interior Material"]?.ToString() : null;
excelProduct.StrapMaterial = dataRow.Table.Columns.Contains("Strap Material") ? dataRow["Strap Material"]?.ToString() : null;
excelProduct.CompatibleWith = dataRow.Table.Columns.Contains("Compatible With") ? dataRow["Compatible With"]?.ToString() : null;
excelProduct.BaseMaterial = dataRow.Table.Columns.Contains("Base Material") ? dataRow["Base Material"]?.ToString() : null;
excelProduct.SecondaryMaterial = dataRow.Table.Columns.Contains("Secondary Material") ? dataRow["Secondary Material"]?.ToString() : null;
excelProduct.MaterialFinish = dataRow.Table.Columns.Contains("Material Finish") ? dataRow["Material Finish"]?.ToString() : null;
excelProduct.TypesofShowerHead = dataRow.Table.Columns.Contains("Types of Shower Head") ? dataRow["Types of Shower Head"]?.ToString() : null;
excelProduct.TypesofDispenser = dataRow.Table.Columns.Contains("Types of Dispenser") ? dataRow["Types of Dispenser"]?.ToString() : null;
excelProduct.NumberofSpraySettings = dataRow.Table.Columns.Contains("Number of Spray Settings") ? dataRow["Number of Spray Settings"]?.ToString() : null;
excelProduct.AssemblyRequired = dataRow.Table.Columns.Contains("Assembly Required") ? dataRow["Assembly Required"]?.ToString() : null;
excelProduct.SetIncludes = dataRow.Table.Columns.Contains("Set Includes") ? dataRow["Set Includes"]?.ToString() : null;
excelProduct.FillingMaterial = dataRow.Table.Columns.Contains("Filling Material") ? dataRow["Filling Material"]?.ToString() : null;
excelProduct.ComfortLevel = dataRow.Table.Columns.Contains("Comfort Level") ? dataRow["Comfort Level"]?.ToString() : null;
excelProduct.SheetType = dataRow.Table.Columns.Contains("Sheet Type") ? dataRow["Sheet Type"]?.ToString() : null;
excelProduct.PackSize = dataRow.Table.Columns.Contains("Pack Size") ? dataRow["Pack Size"]?.ToString() : null;
excelProduct.Formation = dataRow.Table.Columns.Contains("Formation") ? dataRow["Formation"]?.ToString() : null;
excelProduct.TargetUseApplication = dataRow.Table.Columns.Contains("Target Use/Application") ? dataRow["Target Use/Application"]?.ToString() : null;
excelProduct.TargetSkinType = dataRow.Table.Columns.Contains("Target Skin Type") ? dataRow["Target Skin Type"]?.ToString() : null;
excelProduct.UVProtection = dataRow.Table.Columns.Contains("UV Protection") ? dataRow["UV Protection"]?.ToString() : null;
excelProduct.BatterySize = dataRow.Table.Columns.Contains("Battery Size") ? dataRow["Battery Size"]?.ToString() : null;
excelProduct.BatterySizeUnit = dataRow.Table.Columns.Contains("Battery Size Unit") ? dataRow["Battery Size Unit"]?.ToString() : null;
excelProduct.BrandCompatibility = dataRow.Table.Columns.Contains("Brand Compatibility") ? dataRow["Brand Compatibility"]?.ToString() : null;
excelProduct.ConnectionType = dataRow.Table.Columns.Contains("Connection Type") ? dataRow["Connection Type"]?.ToString() : null;
excelProduct.CaseType = dataRow.Table.Columns.Contains("Case Type") ? dataRow["Case Type"]?.ToString() : null;
excelProduct.ChargingType = dataRow.Table.Columns.Contains("Charging Type") ? dataRow["Charging Type"]?.ToString() : null;
excelProduct.PhoneCaseMaterial = dataRow.Table.Columns.Contains("Phone Case Material") ? dataRow["Phone Case Material"]?.ToString() : null;
excelProduct.AudioHeadphoneType = dataRow.Table.Columns.Contains("Audio Headphone Type") ? dataRow["Audio Headphone Type"]?.ToString() : null;
excelProduct.WarrantyYears = dataRow.Table.Columns.Contains("Warranty Years") ? dataRow["Warranty Years"]?.ToString() : null;
excelProduct.FrameColour = dataRow.Table.Columns.Contains("Frame Colour") ? dataRow["Frame Colour"]?.ToString() : null;
excelProduct.FrameColourFamily = dataRow.Table.Columns.Contains("Frame Colour Family") ? dataRow["Frame Colour Family"]?.ToString() : null;
excelProduct.LensColour = dataRow.Table.Columns.Contains("Lens Colour") ? dataRow["Lens Colour"]?.ToString() : null;
excelProduct.LensColourFamily = dataRow.Table.Columns.Contains("Lens Colour Family") ? dataRow["Lens Colour Family"]?.ToString() : null;
excelProduct.FrameShapeStyle = dataRow.Table.Columns.Contains("Frame Shape/Style") ? dataRow["Frame Shape/Style"]?.ToString() : null;
excelProduct.LensFocalType = dataRow.Table.Columns.Contains("Lens Focal Type") ? dataRow["Lens Focal Type"]?.ToString() : null;
excelProduct.LensMagnification = dataRow.Table.Columns.Contains("Lens Magnification") ? dataRow["Lens Magnification"]?.ToString() : null;
excelProduct.LensType = dataRow.Table.Columns.Contains("Lens Type") ? dataRow["Lens Type"]?.ToString() : null;
excelProduct.WidthProfile = dataRow.Table.Columns.Contains("Width Profile") ? dataRow["Width Profile"]?.ToString() : null;
excelProduct.UpperMaterial = dataRow.Table.Columns.Contains("Upper Material") ? dataRow["Upper Material"]?.ToString() : null;
excelProduct.SoleMaterial = dataRow.Table.Columns.Contains("Sole Material") ? dataRow["Sole Material"]?.ToString() : null;
excelProduct.HeelType = dataRow.Table.Columns.Contains("Heel Type") ? dataRow["Heel Type"]?.ToString() : null;
excelProduct.HeelProfile = dataRow.Table.Columns.Contains("Heel Profile") ? dataRow["Heel Profile"]?.ToString() : null;
excelProduct.HeelHeight = dataRow.Table.Columns.Contains("Heel Height") ? dataRow["Heel Height"]?.ToString() : null;
excelProduct.HeelHeightUnit = dataRow.Table.Columns.Contains("Heel Height Unit") ? dataRow["Heel Height Unit"]?.ToString() : null;
excelProduct.BootShaftHeight = dataRow.Table.Columns.Contains("Boot Shaft Height") ? dataRow["Boot Shaft Height"]?.ToString() : null;
excelProduct.BootShaftHeightUnit = dataRow.Table.Columns.Contains("Boot Shaft Height Unit") ? dataRow["Boot Shaft Height Unit"]?.ToString() : null;
excelProduct.BootCircumference = dataRow.Table.Columns.Contains("Boot Circumference") ? dataRow["Boot Circumference"]?.ToString() : null;
excelProduct.BootCircumferenceUnit = dataRow.Table.Columns.Contains("Boot Circumference Unit") ? dataRow["Boot Circumference Unit"]?.ToString() : null;
excelProduct.ClosureFastener = dataRow.Table.Columns.Contains("Closure/Fastener") ? dataRow["Closure/Fastener"]?.ToString(): null;
excelProduct.WardrobeDesign = dataRow.Table.Columns.Contains("Wardrobe Design") ? dataRow["Wardrobe Design"]?.ToString() : null;
excelProduct.UpholsteryType = dataRow.Table.Columns.Contains("Upholstery Type") ? dataRow["Upholstery Type"]?.ToString() : null;
excelProduct.SeatFilling = dataRow.Table.Columns.Contains("Seat Filling") ? dataRow["Seat Filling"]?.ToString() : null;
excelProduct.SeatCushion = dataRow.Table.Columns.Contains("Seat Cushion") ? dataRow["Seat Cushion"]?.ToString() : null;
excelProduct.WoodType = dataRow.Table.Columns.Contains("Wood Type") ? dataRow["Wood Type"]?.ToString() : null;
excelProduct.WoodTone = dataRow.Table.Columns.Contains("Wood Tone") ? dataRow["Wood Tone"]?.ToString() : null;
excelProduct.Shape = dataRow.Table.Columns.Contains("Shape") ? dataRow["Shape"]?.ToString() : null;
excelProduct.NumberofDrawers = dataRow.Table.Columns.Contains("Number of Drawers") ? dataRow["Number of Drawers"]?.ToString() : null;
excelProduct.NumberofDoors = dataRow.Table.Columns.Contains("Number of Doors") ? dataRow["Number of Doors"]?.ToString() : null;
excelProduct.NumberofShelves = dataRow.Table.Columns.Contains("Number of Shelves") ? dataRow["Number of Shelves"]?.ToString() : null;
excelProduct.NumberofSeats = dataRow.Table.Columns.Contains("Number of Seats") ? dataRow["Number of Seats"]?.ToString() : null;
excelProduct.NumberofPanels = dataRow.Table.Columns.Contains("Number of Panels") ? dataRow["Number of Panels"]?.ToString() : null;
excelProduct.Installation = dataRow.Table.Columns.Contains("Installation") ? dataRow["Installation"]?.ToString() : null;
excelProduct.EnergyUsed = dataRow.Table.Columns.Contains("Energy Used") ? dataRow["Energy Used"]?.ToString() : null;
excelProduct.AdditionalFeature1 = dataRow.Table.Columns.Contains("Additional Feature 1") ? dataRow["Additional Feature 1"]?.ToString() : null;
excelProduct.AdditionalFeature2 = dataRow.Table.Columns.Contains("Additional Feature 2") ? dataRow["Additional Feature 2"]?.ToString() : null;
excelProduct.AdditionalFeature3 = dataRow.Table.Columns.Contains("Additional Feature 3") ? dataRow["Additional Feature 3"]?.ToString() : null;
excelProduct.Pattern = dataRow.Table.Columns.Contains("Pattern") ? dataRow["Pattern"]?.ToString() : null;
excelProduct.MatsRugsCarpetDesign = dataRow.Table.Columns.Contains("Mats, Rugs & Carpet Design") ? dataRow["Mats, Rugs & Carpet Design"]?.ToString() : null;
excelProduct.Technique = dataRow.Table.Columns.Contains("Technique") ? dataRow["Technique"]?.ToString() : null;
excelProduct.StyleofCurtainLining = dataRow.Table.Columns.Contains("Style of Curtain Lining") ? dataRow["Style of Curtain Lining"]?.ToString() : null;
excelProduct.DispenserType = dataRow.Table.Columns.Contains("Dispenser Type") ? dataRow["Dispenser Type"]?.ToString() : null;
excelProduct.ScentsNotes = dataRow.Table.Columns.Contains("Scents/Notes") ? dataRow["Scents/Notes"]?.ToString() : null;
excelProduct.AromatherapyType = dataRow.Table.Columns.Contains("Aromatherapy Type") ? dataRow["Aromatherapy Type"]?.ToString() : null;
excelProduct.FineLuxuryMaterial = dataRow.Table.Columns.Contains("Fine/Luxury Material") ? dataRow["Fine/Luxury Material"]?.ToString() : null;
excelProduct.BaseMaterialType = dataRow.Table.Columns.Contains("Base Material Type") ? dataRow["Base Material Type"]?.ToString() : null;
excelProduct.StoneGem = dataRow.Table.Columns.Contains("Stone/Gem") ? dataRow["Stone/Gem"]?.ToString() : null;
excelProduct.CaratWeight = dataRow.Table.Columns.Contains("Carat Weight") ? dataRow["Carat Weight"]?.ToString() : null;
excelProduct.ClosureFastening = dataRow.Table.Columns.Contains("Closure/Fastening") ? dataRow["Closure/Fastening"]?.ToString() : null;
excelProduct.ProductFeatures1 = dataRow.Table.Columns.Contains("Product Features 1") ? dataRow["Product Features 1"]?.ToString() : null;
excelProduct.ProductFeatures2 = dataRow.Table.Columns.Contains("Product Features 2") ? dataRow["Product Features 2"]?.ToString() : null;
excelProduct.ProductFeatures3 = dataRow.Table.Columns.Contains("Product Features 3") ? dataRow["Product Features 3"]?.ToString() : null;
excelProduct.ProductFeatures4 = dataRow.Table.Columns.Contains("Product Features 4") ? dataRow["Product Features 4"]?.ToString() : null;
excelProduct.ProductFeatures5 = dataRow.Table.Columns.Contains("Product Features 5") ? dataRow["Product Features 5"]?.ToString() : null;
excelProduct.InkColourFamily = dataRow.Table.Columns.Contains("Ink Colour Family") ? dataRow["Ink Colour Family"]?.ToString() : null;
excelProduct.PenMaterial = dataRow.Table.Columns.Contains("Pen Material") ? dataRow["Pen Material"]?.ToString() : null;
excelProduct.PointorNibType = dataRow.Table.Columns.Contains("Point or Nib Type") ? dataRow["Point or Nib Type"]?.ToString() : null;
excelProduct.PointSize = dataRow.Table.Columns.Contains("Point Size") ? dataRow["Point Size"]?.ToString() : null;
excelProduct.PointSizeUnit = dataRow.Table.Columns.Contains("Point Size Unit") ? dataRow["Point Size Unit"]?.ToString() : null;
excelProduct.Refillable = dataRow.Table.Columns.Contains("Refillable") ? dataRow["Refillable"]?.ToString() : null;
excelProduct.WatchBandColour = dataRow.Table.Columns.Contains("Watch Band Colour") ? dataRow["Watch Band Colour"]?.ToString() : null;
excelProduct.WatchBandColourFamily = dataRow.Table.Columns.Contains("Watch Band Colour Family") ? dataRow["Watch Band Colour Family"]?.ToString() : null;
excelProduct.BandLength = dataRow.Table.Columns.Contains("Band Length") ? dataRow["Band Length"]?.ToString() : null;
excelProduct.BandLengthUnit = dataRow.Table.Columns.Contains("Band Length Unit") ? dataRow["Band Length Unit"]?.ToString() : null;
excelProduct.WatchBandMaterial = dataRow.Table.Columns.Contains("Watch Band Material") ? dataRow["Watch Band Material"]?.ToString() : null;
excelProduct.WatchDialFaceType = dataRow.Table.Columns.Contains("Watch Dial/Face Type") ? dataRow["Watch Dial/Face Type"]?.ToString() : null;
excelProduct.DialFaceDiameter = dataRow.Table.Columns.Contains("Dial/Face Diameter") ? dataRow["Dial/Face Diameter"]?.ToString() : null;
excelProduct.DialFaceDiameterUnit = dataRow.Table.Columns.Contains("Dial/Face Diameter Unit") ? dataRow["Dial/Face Diameter Unit"]?.ToString() : null;
excelProduct.WatchDialFaceColour = dataRow.Table.Columns.Contains("Watch Dial/Face Colour") ? dataRow["Watch Dial/Face Colour"]?.ToString() : null;
excelProduct.WatchDialFaceColourFamily = dataRow.Table.Columns.Contains("Watch Dial/Face Colour Family") ? dataRow["Watch Dial/Face Colour Family"]?.ToString() : null;
excelProduct.WatchMovement = dataRow.Table.Columns.Contains("Watch Movement") ? dataRow["Watch Movement"]?.ToString() : null;
excelProduct.WatchCaseShape = dataRow.Table.Columns.Contains("Watch Case Shape") ? dataRow["Watch Case Shape"]?.ToString() : null;
excelProduct.WatchBandClosure = dataRow.Table.Columns.Contains("Watch Band Closure") ? dataRow["Watch Band Closure"]?.ToString() : null;
excelProduct.InterchangeableDialFace = dataRow.Table.Columns.Contains("Interchangeable Dial/Face") ? dataRow["Interchangeable Dial/Face"]?.ToString() : null;
excelProduct.InterchangeableStrap = dataRow.Table.Columns.Contains("Interchangeable Strap") ? dataRow["Interchangeable Strap"]?.ToString() : null;
excelProducts.Add(excelProduct);
}
}
}
catch (Exception ex)
{
log.Error("Errror Occured While Reading Watches Excel Document : " + ex.StackTrace);
}
return(excelProducts);
}
