public async Task EditDraftFeatureValue(Guid tenderGuid, FeatureValueDTO featureValueDTO) { var savedFeature = await Context.DraftFeatureValues.FirstOrDefaultAsync(m => m.Id == featureValueDTO.Id); Context.Entry(savedFeature).CurrentValues.SetValues(featureValueDTO); await Context.SaveChangesAsync(); }
public static string GetFeatureValue(FeatureValueDTO featureValue) { if (featureValue != null) { return(featureValue.Value); } return(null); }
public async Task AddDraftFeatureValue(Guid tenderGuid, string featureId, FeatureValueDTO featureValueDTO) { var feature = await Context.DraftFeatures .FirstOrDefaultAsync(m => m.Tender.Guid == tenderGuid && m.StringId == featureId); feature.Values.Add(featureValueDTO.ToDraft()); await Context.SaveChangesAsync(); }
public async Task <int> AddFeatureValue(Guid tenderGuid, string featureId, FeatureValueDTO featureValueDTO) { throw new NotImplementedException(); //var mapper = new FeatureValueMapper(); //var featureValue = mapper.Map(featureValueDTO); //Context.FeatureValues.Add(featureValue); //await Context.SaveChangesAsync(); //return featureValue.Id; }
public static IList <ExcelWFSProductUSViewModel> GetItemsFor(IUnitOfWork db, IMarketCategoryService categoryService, ExportToExcelMode exportMode, IList <FBAItemInfo> fbaItems, ParentItemDTO parent, IList <ItemExDTO> children, UseStyleImageModes useStyleImageMode, out string filename) { var models = new List <ExcelWFSProductUSViewModel>(); filename = null; var defaultChild = children.OrderByDescending(ch => ch.IsExistOnAmazon).ThenBy(ch => ch.Id).FirstOrDefault(); if (!children.Any() && exportMode != ExportToExcelMode.Normal) { return(models); } FeatureValueDTO defaultChildSubLicense = null; var defaultChildItemStyle = String.Empty; var defaultChildGender = String.Empty; var defaultChildBrand = String.Empty; StyleEntireDto firstChildStyle = null; string mainBrandName = null; decimal? childListPrice = null; string childDepartment = null; string childSize = null; string childStyleString = null; IList <string> defaultChildFeatures = new List <string>(); if (defaultChild != null && defaultChild.StyleId.HasValue) { defaultChildSubLicense = db.FeatureValues.GetValueByStyleAndFeatureId(defaultChild.StyleId.Value, StyleFeatureHelper.SUB_LICENSE1); defaultChildItemStyle = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(defaultChild.StyleId.Value, StyleFeatureHelper.ITEMSTYLE)); defaultChildGender = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(defaultChild.StyleId.Value, StyleFeatureHelper.GENDER)); defaultChildBrand = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(defaultChild.StyleId.Value, StyleFeatureHelper.BRAND)); mainBrandName = StringHelper.GetFirstNotEmpty(parent.BrandName, defaultChild.BrandName, defaultChildBrand); defaultChildFeatures = !String.IsNullOrEmpty(defaultChild.Features) ? defaultChild.Features.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList() : new List <string>(); childListPrice = defaultChild.ListPrice; childDepartment = defaultChild.Department; childSize = defaultChild.Size; childStyleString = defaultChild.StyleString; if (defaultChild.StyleId.HasValue) { firstChildStyle = db.Styles.GetByStyleIdAsDto(defaultChild.StyleId.Value); } } if (parent != null) { var variationType = ItemExportHelper.GetVariationType(children != null ? children.Select(ch => ch.Color).ToList() : null); //For simplicity, w can just use for parent SKU (unless it exist) style-%parentASIN%. string parentSku = parent.SKU; if (String.IsNullOrEmpty(parentSku)) { //NOTE: removed ASIN part (I guess it could be used for preventing listings mix) parentSku = childStyleString;// + "-" + parent.ASIN; } var mainGender = StringHelper.GetFirstNotEmpty(childDepartment, parent.Department, defaultChildGender); var sizeType = ItemExportHelper.GetSizeType(childSize); var categoryInfo = categoryService.GetCategory((MarketType)parent.Market, parent.MarketplaceId, defaultChildItemStyle, mainGender, sizeType); //var type = ItemExportHelper.GetItemType(itemStyle); var mainItemType = categoryInfo.Key1;// ItemExportHelper.ItemTypeConverter(childSize ?? "", type, itemStyle, gender); var mainDepartment = StringHelper.GetFirstNotEmpty(categoryInfo.Key2, ItemExportHelper.DepartmentConverter(mainGender, mainItemType, sizeType)); var parentImage = ItemExportHelper.ImageConverter(StringHelper.GetFirstNotEmpty( parent.LargeImage != null ? parent.LargeImage.Image : null, parent.ImageSource)); string clothingType = categoryInfo.Key3; var searchTerms = (parent.SearchKeywords ?? "").Replace(";", ", "); searchTerms = ItemExportHelper.PrepareSearchTerms(searchTerms); var mainMsrp = firstChildStyle != null && firstChildStyle.MSRP.HasValue ? firstChildStyle.MSRP.Value.ToString("G") : (childListPrice.HasValue ? Math.Round(childListPrice.Value / 100).ToString("G") : ""); var mainDescription = firstChildStyle?.Description ?? parent.Description; models.Add(new ExcelWFSProductUSViewModel { SKU = parentSku, Title = parent.AmazonName, ASIN = parent.ASIN, ProductId = "ASIN", BrandName = mainBrandName, Description = mainDescription, Type = mainItemType, Update = "Update", StandardPrice = "", SuggestedPrice = mainMsrp, Currency = childListPrice.HasValue ? "USD" : "", Quantity = "", KeyProductFeatures1 = defaultChildFeatures.Count > 0 ? defaultChildFeatures[0] : String.Empty, KeyProductFeatures2 = defaultChildFeatures.Count > 1 ? defaultChildFeatures[1] : String.Empty, KeyProductFeatures3 = defaultChildFeatures.Count > 2 ? defaultChildFeatures[2] : String.Empty, KeyProductFeatures4 = defaultChildFeatures.Count > 3 ? defaultChildFeatures[3] : String.Empty, KeyProductFeatures5 = defaultChildFeatures.Count > 4 ? defaultChildFeatures[4] : String.Empty, SearchTerms1 = searchTerms, //SearchTerms1 = searchTermList.Count > 0 ? searchTermList[0] : String.Empty, //SearchTerms2 = searchTermList.Count > 1 ? searchTermList[1] : String.Empty, //SearchTerms3 = searchTermList.Count > 2 ? searchTermList[2] : String.Empty, //SearchTerms4 = searchTermList.Count > 3 ? searchTermList[3] : String.Empty, //SearchTerms5 = searchTermList.Count > 4 ? searchTermList[4] : String.Empty, MainImageURL = parentImage, Parentage = ExcelHelper.ParentageParent, VariationTheme = variationType, Department = mainDepartment, Color = "", FeedProductType = clothingType, }); foreach (var child in children) { var childStyleImages = child.StyleId.HasValue ? db.StyleImages .GetAllAsDto() .Where(im => im.StyleId == child.StyleId.Value && im.Type != (int)StyleImageType.Swatch) .ToList() .OrderByDescending(im => ImageHelper.GetSortIndex(im.Category)) .ThenByDescending(im => im.IsDefault) .ThenBy(im => im.Id) .ToList() : null; var childStyleGenderValue = child.StyleId.HasValue ? db.StyleFeatureValues.GetAllWithFeature() .FirstOrDefault(st => st.StyleId == child.StyleId.Value && st.FeatureId == StyleFeatureHelper.GENDER)?.Value : null; var childStyle = child.StyleId.HasValue ? db.Styles.GetByStyleIdAsDto(child.StyleId.Value) : null; var msrp = childStyle != null && childStyle.MSRP.HasValue ? childStyle.MSRP.Value.ToString("G") : (child.ListPrice.HasValue ? Math.Round(child.ListPrice.Value / 100).ToString("G") : ""); var description = childStyle?.Description ?? parent.Description; var fbaInfo = fbaItems != null?fbaItems.FirstOrDefault(f => f.SKU == child.SKU) : null; if (exportMode == ExportToExcelMode.FBA) { if (fbaInfo == null) { throw new ArgumentNullException("fbaInfo", "for SKU=" + child.SKU); } } IList <string> features = !String.IsNullOrEmpty(child.Features) ? child.Features.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList() : new List <string>(); if (!String.IsNullOrEmpty(childStyle.BulletPoint1)) { features = StringHelper.ToArray(childStyle.BulletPoint1, childStyle.BulletPoint2, childStyle.BulletPoint3, childStyle.BulletPoint4, childStyle.BulletPoint5); } var childImage = ItemExportHelper.ImageConverter(StringHelper.GetFirstNotEmpty( child.LargeImageUrl, child.ImageUrl)); var childImage1 = ""; var childImage2 = ""; var childImage3 = ""; if (useStyleImageMode == UseStyleImageModes.Auto) { if (String.IsNullOrEmpty(childImage)) { if (childStyleImages != null && childStyleImages.Any()) { childImage = childStyleImages.First().Image; } } else { if (childStyleImages != null && childStyleImages.Any(im => im.Type == (int)StyleImageType.HiRes)) { childImage = childStyleImages.First(im => im.Type == (int)StyleImageType.HiRes).Image; } } } if (useStyleImageMode == UseStyleImageModes.StyleImage || (useStyleImageMode == UseStyleImageModes.ListingImage && String.IsNullOrEmpty(childImage))) { if (childStyleImages != null && childStyleImages.Any()) { childImage = childStyleImages.First().Image; childImage1 = childStyleImages.Count > 1 ? childStyleImages[1].Image : ""; childImage2 = childStyleImages.Count > 2 ? childStyleImages[2].Image : ""; childImage3 = childStyleImages.Count > 3 ? childStyleImages[3].Image : ""; } } if (useStyleImageMode == UseStyleImageModes.ListingImage) { //Nothing } var hasAmazonUpdates = child.IsExistOnAmazon == true; var displaySize = String.IsNullOrEmpty(child.Size) ? "" : ("Size " + child.Size); models.Add(new ExcelWFSProductUSViewModel { Id = child.Id, StyleId = child.StyleId, StyleItemId = child.StyleItemId, IsExistOnAmazon = hasAmazonUpdates, SKU = ItemExportHelper.PrepareSKU(child.SKU, exportMode), Title = hasAmazonUpdates ? child.Name : StringHelper.Join(", ", child.Name, child.Color, displaySize), ASIN = hasAmazonUpdates ? child.ASIN : child.Barcode, ProductId = hasAmazonUpdates ? "ASIN" : "UPC", BrandName = mainBrandName, Description = description, Type = mainItemType, Update = hasAmazonUpdates ? "PartialUpdate" : "Update", StandardPrice = (child.CurrentPrice + (exportMode == ExportToExcelMode.FBA || exportMode == ExportToExcelMode.FBP ? 5 : 0)).ToString("G"), SuggestedPrice = msrp, Currency = child.ListPrice.HasValue ? "USD" : "", Quantity = exportMode == ExportToExcelMode.FBA ? fbaInfo.Quantity.ToString("G") : child.RealQuantity.ToString("G"), KeyProductFeatures1 = features.Count > 0 ? features[0] : String.Empty, KeyProductFeatures2 = features.Count > 1 ? features[1] : String.Empty, KeyProductFeatures3 = features.Count > 2 ? features[2] : String.Empty, KeyProductFeatures4 = features.Count > 3 ? features[3] : String.Empty, KeyProductFeatures5 = features.Count > 4 ? features[4] : String.Empty, SearchTerms1 = searchTerms, //SearchTerms1 = searchTermList.Count > 0 ? searchTermList[0] : String.Empty, //SearchTerms2 = searchTermList.Count > 1 ? searchTermList[1] : String.Empty, //SearchTerms3 = searchTermList.Count > 2 ? searchTermList[2] : String.Empty, //SearchTerms4 = searchTermList.Count > 3 ? searchTermList[3] : String.Empty, //SearchTerms5 = searchTermList.Count > 4 ? searchTermList[4] : String.Empty, MainImageURL = childImage, OtherImageUrl1 = childImage1, OtherImageUrl2 = childImage2, OtherImageUrl3 = childImage3, Parentage = ExcelHelper.ParentageChild, ParentSKU = parentSku, RelationshipType = "Variation", VariationTheme = variationType, Department = mainDepartment, Color = child.Color, Size = child.Size, //SpecialSize = child.SpecialSize, FulfillmentCenterID = exportMode == ExportToExcelMode.FBA ? "AMAZON_NA" : null, PackageHeight = exportMode == ExportToExcelMode.FBA && fbaInfo.PackageHeight.HasValue ? fbaInfo.PackageHeight.ToString() : null, PackageWidth = exportMode == ExportToExcelMode.FBA && fbaInfo.PackageWidth.HasValue ? fbaInfo.PackageWidth.ToString() : null, PackageLength = exportMode == ExportToExcelMode.FBA && fbaInfo.PackageLength.HasValue ? fbaInfo.PackageLength.ToString() : null, PackageLengthUnitOfMeasure = exportMode == ExportToExcelMode.FBA ? "IN" : null, PackageWeight = exportMode == ExportToExcelMode.FBA ? child.Weight.ToString() : null, PackageWeightUnitOfMeasure = exportMode == ExportToExcelMode.FBA ? "OZ" : null, SupplierDeclaredDgHzRegulation1 = "Not Applicable", BatteriesRequired = "FALSE", FeedProductType = clothingType, MerchantShippingGroupName = child.IsPrime ? AmazonTemplateHelper.PrimeTemplate : (child.Weight > 16 ? AmazonTemplateHelper.OversizeTemplate : null), }); } //Copy to parent child Type if (children.Count > 0) { models[0].Type = models[1].Type; } if (children.Count > 0 && useStyleImageMode == UseStyleImageModes.StyleImage) { models[0].MainImageURL = models[1].MainImageURL; } } filename = models[0].SKU + "_" + (defaultChildSubLicense != null ? defaultChildSubLicense.Value : "none") + "_US" + Path.GetExtension(USTemplatePath); return(models); }
public static IList <ExcelProductCAViewModel> GetItemsFor(ILogService log, ITime time, IMarketCategoryService categoryService, IHtmlScraperService htmlScraper, IMarketApi marketApi, IUnitOfWork db, CompanyDTO company, string parentAsin, MarketType market, string marketplaceId, UseStyleImageModes useStyleImageMode, out string filename) { var caExchangeRate = PriceHelper.CADtoUSD; var today = time.GetAppNowTime(); var models = new List <ExcelProductCAViewModel>(); var items = ItemExportHelper.GetParentItemAndChilds(log, time, htmlScraper, marketApi, db, company, parentAsin, null, ExportToExcelMode.Normal, market, marketplaceId); var parent = items.Item1; // db.ParentItems.GetAsDTO(asin); var children = items.Item2; // db.Items.GetAllActualExAsDto().Where(i => i.ParentASIN == asin).ToList(); var firstChild = children.FirstOrDefault(); FeatureValueDTO subLicense = null; string itemStyle = null; if (firstChild != null && firstChild.StyleId.HasValue) { //style = db.Styles.Get(parent.StyleId.Value); subLicense = db.FeatureValues.GetValueByStyleAndFeatureId(firstChild.StyleId.Value, StyleFeatureHelper.SUB_LICENSE1); itemStyle = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(firstChild.StyleId.Value, StyleFeatureHelper.ITEMSTYLE)); } if (parent != null) { var variationType = ItemExportHelper.GetVariationType(children != null ? children.Select(ch => ch.Color).ToList() : null); string childBrandName = null; decimal? childListPrice = null; string childDepartment = null; string childSize = null; string childStyleString = null; IList <string> childFeatures = new List <string>(); if (firstChild != null) { childBrandName = children.Select(c => c.BrandName).FirstOrDefault(); childFeatures = !String.IsNullOrEmpty(firstChild.Features) ? firstChild.Features.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList() : new List <string>(); childListPrice = firstChild.ListPrice; childDepartment = firstChild.Department; childSize = firstChild.Size; childStyleString = firstChild.StyleString; } //For simplicity, w can just use for parent SKU (unless it exist) style-%parentASIN%. string parentSku = parent.SKU; if (String.IsNullOrEmpty(parentSku)) { parentSku = childStyleString + "-" + parent.ASIN; } var gender = (childDepartment ?? parent.Department ?? ""); var sizeType = ItemExportHelper.GetSizeType(childSize); var categoryInfo = categoryService.GetCategory(market, marketplaceId, itemStyle, gender, sizeType); //var itemType = ItemExportHelper.GetItemType(itemStyle); var newItemType = categoryInfo.Key1;// ItemExportHelper.ItemTypeConverter(childSize ?? "", itemType, itemStyle, gender); var newDepartment = StringHelper.GetFirstNotEmpty(categoryInfo.Key2, ItemExportHelper.DepartmentConverter(gender, newItemType, sizeType)); var parentImage = ItemExportHelper.ImageConverter(StringHelper.GetFirstNotEmpty( parent.LargeImage != null ? parent.LargeImage.Image : null, parent.ImageSource)); models.Add(new ExcelProductCAViewModel { SKU = parentSku,// parent.StyleString, Title = parent.AmazonName, ASIN = parent.ASIN, ProductId = "ASIN", ClothingType = "sleepwear", Manufacturer = parent.BrandName ?? childBrandName, BrandName = parent.BrandName ?? childBrandName, Description = parent.Description, Type = newItemType, Update = "Update", StandardPrice = "", SuggestedPrice = childListPrice.HasValue ? Math.Round(PriceHelper.Convert(childListPrice.Value / 100, caExchangeRate, true)).ToString("G") : "", Currency = childListPrice.HasValue ? "CAD" : "", Quantity = "", KeyProductFeatures1 = childFeatures.Count > 0 ? childFeatures[0] : String.Empty, KeyProductFeatures2 = childFeatures.Count > 1 ? childFeatures[1] : String.Empty, KeyProductFeatures3 = childFeatures.Count > 2 ? childFeatures[2] : String.Empty, KeyProductFeatures4 = childFeatures.Count > 3 ? childFeatures[3] : String.Empty, KeyProductFeatures5 = childFeatures.Count > 4 ? childFeatures[4] : String.Empty, RecommendedBrowseNodes1 = ExcelProductCAViewModel.GetRecommendedBrowseNodes1(newDepartment, childSize, newItemType), MainImageURL = parentImage, Parentage = "Parent", VariationTheme = variationType, Department = newDepartment, Color = "", }); foreach (var child in children) { var styleImages = child.StyleId.HasValue ? db.StyleImages .GetAllAsDto() .Where(im => im.StyleId == child.StyleId.Value && im.Type != (int)StyleImageType.Swatch) .ToList() .OrderByDescending(im => ImageHelper.GetSortIndex(im.Category)) .ThenByDescending(im => im.IsDefault) .ThenBy(im => im.Id) .ToList() : null; IList <string> features = !String.IsNullOrEmpty(child.Features) ? child.Features.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList() : new List <string>(); var childImage = ItemExportHelper.ImageConverter(StringHelper.GetFirstNotEmpty( child.LargeImageUrl, child.ImageUrl)); if (useStyleImageMode == UseStyleImageModes.StyleImage) { if (styleImages != null && styleImages.Any()) { childImage = styleImages.First().Image; } } var itemPrice = child.SalePrice.HasValue && child.SaleStartDate < today ? child.SalePrice.Value : child.CurrentPrice; models.Add(new ExcelProductCAViewModel { StyleId = child.StyleId, StyleItemId = child.StyleItemId, SKU = child.SKU, Title = child.Name, ASIN = child.ASIN, ProductId = "ASIN", ClothingType = "sleepwear", Manufacturer = child.BrandName, BrandName = child.BrandName, Description = parent.Description, Type = newItemType, Update = "Update", //StandardPrice = child.Price.ToString("G"), StandardPrice = CorrectCAPrice(PriceHelper.Convert(itemPrice, caExchangeRate, true)).ToString("G"), //SalePrice = child.SalePrice.HasValue && child.SaleStartDate < today ? CorrectCAPrice(PriceHelper.Convert(child.SalePrice.Value, caExchangeRate, true)).ToString("G") : null, SuggestedPrice = child.ListPrice.HasValue ? Math.Round(PriceHelper.Convert(child.ListPrice.Value / 100, caExchangeRate, true)).ToString("G") : "", Currency = child.ListPrice.HasValue ? "CAD" : "", Quantity = child.RealQuantity.ToString("G"),// "1", // i.Quantity.ToString("G"), KeyProductFeatures1 = features.Count > 0 ? features[0] : String.Empty, KeyProductFeatures2 = features.Count > 1 ? features[1] : String.Empty, KeyProductFeatures3 = features.Count > 2 ? features[2] : String.Empty, KeyProductFeatures4 = features.Count > 3 ? features[3] : String.Empty, KeyProductFeatures5 = features.Count > 4 ? features[4] : String.Empty, RecommendedBrowseNodes1 = ExcelProductCAViewModel.GetRecommendedBrowseNodes1(newDepartment, child.Size, newItemType), MainImageURL = childImage, Parentage = "Child", ParentSKU = parentSku, RelationshipType = "Variation", VariationTheme = variationType, Department = newDepartment, Color = child.Color, Size = child.Size, SpecialSize = child.SpecialSize, }); } //Copy to parent child Type if (children.Count > 0) { models[0].Type = models[1].Type; } if (children.Count > 0 && useStyleImageMode == UseStyleImageModes.StyleImage) { models[0].MainImageURL = models[1].MainImageURL; } } filename = models[0].SKU + "_" + (subLicense != null ? subLicense.Value : "none") + "_CA.xls"; return(models); }
public static DraftFeatureValue ToDraft(this FeatureValueDTO source) { return(source == null ? null : new DraftFeatureValue(source)); }
public static IList <ExcelProductUKViewModel> GetItemsFor(ILogService log, ITime time, IMarketCategoryService categoryService, IHtmlScraperService htmlScraper, IMarketApi marketApi, IUnitOfWork db, CompanyDTO company, string asin, MarketType market, string marketplaceId, UseStyleImageModes useStyleImageMode, out string filename) { var gbpExchangeRate = PriceHelper.GBPtoUSD; var today = time.GetAppNowTime(); var models = new List <ExcelProductUKViewModel>(); var items = ItemExportHelper.GetParentItemAndChilds(log, time, htmlScraper, marketApi, db, company, asin, null, ExportToExcelMode.Normal, market, marketplaceId); var parent = items.Item1; // db.ParentItems.GetAsDTO(asin); var children = items.Item2; // db.Items.GetAllActualExAsDto().Where(i => i.ParentASIN == asin).ToList(); var firstChild = children.FirstOrDefault(); FeatureValueDTO subLicense = null; string material = null; string materialComposition = null; string itemStyle = null; if (firstChild != null && firstChild.StyleId.HasValue) { subLicense = db.FeatureValues.GetValueByStyleAndFeatureId(firstChild.StyleId.Value, StyleFeatureHelper.SUB_LICENSE1); itemStyle = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(firstChild.StyleId.Value, StyleFeatureHelper.ITEMSTYLE)); material = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(firstChild.StyleId.Value, StyleFeatureHelper.MATERIAL)); materialComposition = ItemExportHelper.GetFeatureValue(db.FeatureValues.GetValueByStyleAndFeatureId(firstChild.StyleId.Value, StyleFeatureHelper.MATERIAL_COMPOSITION)); } if (parent != null) { var variationType = ItemExportHelper.GetVariationType(children != null ? children.Select(ch => ch.Color).ToList() : null); string childBrandName = null; decimal?childListPrice = null; string childDepartment = null; string childSize = null; string childStyleString = null; IList <string> childFeatures = new List <string>(); //IList<string> searchTermList = new List<string>(); //if (!String.IsNullOrEmpty(parent.SearchKeywords)) // searchTermList = parent.SearchKeywords.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList(); var searchTerms = (parent.SearchKeywords ?? "").Replace(";", ", "); searchTerms = ItemExportHelper.PrepareSearchTerms(searchTerms); if (firstChild != null) { childBrandName = children.Select(c => c.BrandName).FirstOrDefault(); childFeatures = !String.IsNullOrEmpty(firstChild.Features) ? firstChild.Features.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList() : new List <string>(); childListPrice = firstChild.ListPrice; childDepartment = firstChild.Department; childSize = firstChild.Size; childStyleString = firstChild.StyleString; } //For simplicity, w can just use for parent SKU (unless it exist) style-%parentASIN%. string parentSku = parent.SKU; if (String.IsNullOrEmpty(parentSku)) { parentSku = childStyleString + "-" + parent.ASIN; } var gender = childDepartment ?? parent.Department ?? ""; var sizeType = ItemExportHelper.GetSizeType(childSize); var categoryInfo = categoryService.GetCategory(market, marketplaceId, itemStyle, gender, sizeType); //var itemType = ItemExportHelper.GetItemType(itemStyle); var newItemType = categoryInfo.Key1;// ItemExportHelper.ItemTypeConverter(childSize ?? "", itemType, itemStyle, gender); var newDepartment = StringHelper.GetFirstNotEmpty(categoryInfo.Key2, ItemExportHelper.DepartmentConverter(gender, newItemType, sizeType)); string clothingType = categoryInfo.Key3; var parentImage = ItemExportHelper.ImageConverter(StringHelper.GetFirstNotEmpty( parent.LargeImage != null ? parent.LargeImage.Image : null, parent.ImageSource)); var replaces = new Dictionary <string, string>() { { "Nightgown", "Nighty" }, { "Nightys", "Nighties" }, { "nightgown", "nighty" }, { "nighty", "nighties" }, { "pajama", "pyjama" }, { "Pajama", "Pyjama" }, }; var hasCotton = StringHelper.GetInOneOfStrings("Cotton", new List <string>() { searchTerms, parent.AmazonName, parent.Description, firstChild != null ? firstChild.Features : null }); if (String.IsNullOrEmpty(materialComposition)) { if (hasCotton) { materialComposition = "Cotton"; } else { materialComposition = "Polyester"; } } models.Add(new ExcelProductUKViewModel { SKU = parentSku, Title = StringHelper.Replaces(parent.AmazonName, replaces), ASIN = parent.ASIN, UPC = "", ProductId = "",// "ASIN", BrandName = parent.BrandName ?? childBrandName, Description = parent.Description, ClothingType = clothingType, Update = "Update", StandardPrice = "", //SuggestedPrice = childListPrice.HasValue ? PriceHelper.Convert(childListPrice.Value / 100, gbpExchangeRate, false).ToString("G") : "", Currency = "", // childListPrice.HasValue ? "GBP" : "", Quantity = "", RecommendedBrowseNodes1 = ExcelProductUKViewModel.GetRecommendedBrowseNodes1(newDepartment, childSize, newItemType), KeyProductFeatures1 = childFeatures.Count > 0 ? childFeatures[0] : String.Empty, KeyProductFeatures2 = childFeatures.Count > 1 ? childFeatures[1] : String.Empty, KeyProductFeatures3 = childFeatures.Count > 2 ? childFeatures[2] : String.Empty, KeyProductFeatures4 = childFeatures.Count > 3 ? childFeatures[3] : String.Empty, KeyProductFeatures5 = childFeatures.Count > 4 ? childFeatures[4] : String.Empty, SearchTerms1 = searchTerms, //SearchTerms2 = searchTermList.Count > 1 ? searchTermList[1] : String.Empty, //SearchTerms3 = searchTermList.Count > 2 ? searchTermList[2] : String.Empty, //SearchTerms4 = searchTermList.Count > 3 ? searchTermList[3] : String.Empty, //SearchTerms5 = searchTermList.Count > 4 ? searchTermList[4] : String.Empty, MainImageURL = parentImage, Parentage = "Parent", VariationTheme = variationType, MaterialComposition = materialComposition, Department = newDepartment, Color = "", }); foreach (var child in children) { var styleImages = child.StyleId.HasValue ? db.StyleImages .GetAllAsDto() .Where(im => im.StyleId == child.StyleId.Value && im.IsDefault) .ToList() : null; IList <string> features = !String.IsNullOrEmpty(child.Features) ? child.Features.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList() : new List <string>(); var childImage = ItemExportHelper.ImageConverter(StringHelper.GetFirstNotEmpty( child.LargeImageUrl, child.ImageUrl)); if (useStyleImageMode == UseStyleImageModes.StyleImage) { if (styleImages != null && styleImages.Any()) { childImage = styleImages.First().Image; } } var itemPrice = child.SalePrice.HasValue && child.SaleStartDate < today ? child.SalePrice.Value : child.CurrentPrice; models.Add(new ExcelProductUKViewModel { StyleId = child.StyleId, StyleItemId = child.StyleItemId, SKU = child.SKU, Title = StringHelper.Replaces(child.Name, replaces), ASIN = child.ASIN, UPC = child.Barcode, ProductId = "UPC",// "ASIN", BrandName = child.BrandName, Description = parent.Description, ClothingType = clothingType, Update = "Update", StandardPrice = CorrectUKPrice(PriceHelper.Convert(itemPrice, gbpExchangeRate, true)).ToString("G"), //SuggestedPrice = child.ListPrice.HasValue ? PriceHelper.Convert(child.ListPrice.Value / 100, gbpExchangeRate, false).ToString("G") : "", Currency = "GBP", Quantity = child.RealQuantity.ToString("G"),// "1", // i.Quantity.ToString("G"), KeyProductFeatures1 = features.Count > 0 ? features[0] : String.Empty, KeyProductFeatures2 = features.Count > 1 ? features[1] : String.Empty, KeyProductFeatures3 = features.Count > 2 ? features[2] : String.Empty, KeyProductFeatures4 = features.Count > 3 ? features[3] : String.Empty, KeyProductFeatures5 = features.Count > 4 ? features[4] : String.Empty, SearchTerms1 = searchTerms, //SearchTerms2 = searchTermList.Count > 1 ? searchTermList[1] : String.Empty, //SearchTerms3 = searchTermList.Count > 2 ? searchTermList[2] : String.Empty, //SearchTerms4 = searchTermList.Count > 3 ? searchTermList[3] : String.Empty, //SearchTerms5 = searchTermList.Count > 4 ? searchTermList[4] : String.Empty, RecommendedBrowseNodes1 = ExcelProductUKViewModel.GetRecommendedBrowseNodes1(newDepartment, childSize, newItemType), MainImageURL = childImage, Parentage = "Child", ParentSKU = parentSku, RelationshipType = "Variation", VariationTheme = variationType, Department = newDepartment, Color = child.Color, MaterialComposition = materialComposition, Size = ItemExportHelper.PrepareSize(ExcelProductUKViewModel.SizeConverter(child.Size, material), gender), }); } if (children.Count > 0 && useStyleImageMode == UseStyleImageModes.StyleImage) { models[0].MainImageURL = models[1].MainImageURL; } } filename = models[0].SKU + "_" + (subLicense != null ? subLicense.Value : "none") + "_UK.xls"; return(models); }
public Task EditFeatureValue(Guid viewModelTenderGuid, FeatureValueDTO toDTO) { throw new NotImplementedException(); }