public List <ProductDto> GetProductsWithFilter(List <int> productListIDs)
{
List <ProductDto> ProductList = new List <ProductDto>();
var repo1 = Scope.Repository <AssortmentContentView>();
var repo2 = Scope.Repository <ProductDescription>();
var connector = Repository <Connector>().GetSingle(c => c.ConnectorID == Client.User.ConnectorID);
ContentLogic logic = new ContentLogic(Scope, Client.User.ConnectorID.Value);
foreach (var item in productListIDs)
{
ProductDto dto = new ProductDto();
var product1 = repo1.GetSingle(a => a.ProductID == item);
var product2 = repo2.GetSingle(b => b.ProductID == item);
dto.ProductID = product1.ProductID;
dto.Name = product2 == null ? "n/a" : product2.ProductName;
dto.Description = product1.ShortDescription;
dto.Price = logic.CalculatePrice(item, 1, connector, Enumerations.PriceRuleType.UnitPrice);
dto.Stock = product1.QuantityOnHand;
dto.Expected = product1.QuantityToReceive.ToString();
ProductList.Add(dto);
}
return(ProductList);
}
public override DirectShipmentRequest GetDirectShipmentOrder(Concentrator.Objects.Models.Orders.Order order, List <Concentrator.Objects.Models.Orders.OrderLine> orderLines, Vendor administrativeVendor, Vendor vendor)
{
var customer = order.ShippedToCustomer;
using (var unit = ServiceLocator.Current.GetInstance <IUnitOfWork>())
{
Dictionary <int, string> customItemNumbers = new Dictionary <int, string>();
Dictionary <int, VendorAssortment> VendorAssortments = new Dictionary <int, VendorAssortment>();
Dictionary <string, string> additionalItems = new Dictionary <string, string>();
ContentLogic logic = new ContentLogic(unit.Scope);
foreach (var l in orderLines)
{
if (l.Product != null)
{
string customItemNumber1 = logic.GetVendorItemNumber(l.Product, l.CustomerItemNumber, administrativeVendor.VendorID);
var customItemNumber = l.Product.VendorAssortments.Where(x => x.VendorID == administrativeVendor.VendorID && x.Product == l.Product).Select(x => x.CustomItemNumber).FirstOrDefault();
//l.ProductID.HasValue ? ContentLogic.GetVendorProductID(l.ProductID.Value, administrativeVendor.VendorID, l.CustomerItemNumber) : l.CustomerItemNumber;
customItemNumbers.Add(l.ProductID.Value, customItemNumber);
var vass = l.Product.VendorAssortments.Where(x => x.VendorID == vendor.VendorID).Select(x => x).FirstOrDefault();
VendorAssortments.Add(l.ProductID.Value, vass);
}
else
{
var additionalOrderProduct = (from aop in unit.Scope.Repository <AdditionalOrderProduct>().GetAllAsQueryable()
where aop.ConnectorID == l.Order.ConnectorID &&
aop.ConnectorProductID == l.CustomerItemNumber &&
aop.VendorID == administrativeVendor.VendorID
select aop).FirstOrDefault();
if (additionalOrderProduct != null && !additionalItems.ContainsKey(l.CustomerItemNumber))
{
additionalItems.Add(l.CustomerItemNumber, additionalOrderProduct.VendorProductID);
}
}
}
var administrativeVendorSettings = administrativeVendor.PreferredConnectorVendors.Where(x => x.ConnectorID == order.ConnectorID).FirstOrDefault();
var connectorVendorSettings = vendor.PreferredConnectorVendors.Where(x => x.ConnectorID == order.ConnectorID).FirstOrDefault();
DirectShipmentRequest directShipmentOrder = new DirectShipmentRequest()
{
bskIdentifier = !string.IsNullOrEmpty(administrativeVendorSettings.VendorIdentifier) ? administrativeVendorSettings.VendorIdentifier : order.BSKIdentifier.ToString(),
Version = "1.0",
DirectShipmentCustomer = new DirectShipmentCustomer()
{
DirectShipmentCustomerAddress = new DirectShipmentCustomerAddress()
{
AddressLine1 = order.ShippedToCustomer.CustomerAddressLine1,
AddressLine2 = order.ShippedToCustomer.CustomerAddressLine2,
AddressLine3 = order.ShippedToCustomer.CustomerAddressLine3,
City = order.ShippedToCustomer.City,
Country = order.ShippedToCustomer.Country,
Name = order.ShippedToCustomer.CustomerName,
ZipCode = order.ShippedToCustomer.PostCode,
Number = order.ShippedToCustomer.HouseNumber
},
DirectShipmentCustomerContact = new DirectShipmentCustomerContact()
{
Email = order.ShippedToCustomer.CustomerEmail,
Name = order.ShippedToCustomer.CustomerName
}
},
DirectShipmentLines = (from l in orderLines
let customItemNumber = l.Product != null ? customItemNumbers[l.ProductID.Value] : additionalItems[l.CustomerItemNumber]
let vendorAss = l.Product != null ? VendorAssortments[l.ProductID.Value] : null
let description = l.Product != null ? (l.Product.ProductDescriptions.Where(x => x.LanguageID == (int)LanguageTypes.English).Select(x => x.ShortContentDescription).FirstOrDefault() != null ?
l.Product.ProductDescriptions.Where(x => x.LanguageID == (int)LanguageTypes.English).Select(x => x.ShortContentDescription).FirstOrDefault() : l.Product.Contents.Where(x => x.ConnectorID == order.ConnectorID).Select(x => x.ShortDescription).FirstOrDefault()) : "Additional Item"
let unitCost = (l.ProductID.HasValue ? logic.CalculatePrice(l.ProductID.Value, l.GetDispatchQuantity(), l.Order.Connector, PriceRuleType.CostPrice) : (decimal)l.Price.Value)
let unitPrice = (l.ProductID.HasValue ? logic.CalculatePrice(l.ProductID.Value, l.GetDispatchQuantity(), l.Order.Connector, PriceRuleType.UnitPrice) : (decimal)l.Price.Value)
select new DirectShipmentLine
{
ItemNumber = customItemNumber,
Price = l.Price.HasValue ? l.Price.Value.ToString() : vendorAss.VendorPrices.FirstOrDefault().Price.Value.ToString(),
Product = (l.ProductID.HasValue ? new Concentrator.Web.Objects.EDI.DirectShipment.Product()
{
BrandCode = l.Product.Brand.BrandVendors.Where(x => x.VendorID == administrativeVendorSettings.Vendor.VendorID).Select(x => x.VendorBrandCode).FirstOrDefault(),
Description = string.IsNullOrEmpty(description) ? vendorAss.ShortDescription : description,
Description2 = string.Empty,
EAN = l.Product.ProductBarcodes.FirstOrDefault() != null ? (l.Product.ProductBarcodes.FirstOrDefault().Barcode.Length == 13 ? l.Product.ProductBarcodes.FirstOrDefault().Barcode : string.Empty) : string.Empty,
UPC = l.Product.ProductBarcodes.FirstOrDefault() != null ? (l.Product.ProductBarcodes.FirstOrDefault().Barcode.Length == 12 ? l.Product.ProductBarcodes.FirstOrDefault().Barcode : string.Empty) : string.Empty,
ModelNumber = string.Empty,
VendorItemNumber = l.Product != null ? l.Product.VendorItemNumber : string.Empty,
UnitCost = unitCost > 0 ? unitCost : (vendorAss != null ?
(vendorAss.VendorPrices.FirstOrDefault().CostPrice.HasValue ? vendorAss.VendorPrices.FirstOrDefault().CostPrice.Value : (vendorAss.VendorPrices.FirstOrDefault().Price.HasValue ? vendorAss.VendorPrices.FirstOrDefault().Price.Value : 0))
: 0),
UnitPrice = new Concentrator.Web.Objects.EDI.DirectShipment.ProductUnitPrice()
{
HighTaxRate = true,
LowTaxRate = false,
Text = new string[] { unitPrice > 0 ? unitPrice.ToString() : (l.Price.HasValue ? l.Price.Value.ToString() : (vendorAss.VendorPrices.FirstOrDefault().Price.HasValue ? vendorAss.VendorPrices.FirstOrDefault().Price.Value.ToString() : "0")) }
}
} : new Concentrator.Web.Objects.EDI.DirectShipment.Product()
{
}),
Quantity = l.GetDispatchQuantity(),
Reference = !string.IsNullOrEmpty(order.ShippedToCustomer.CustomerName) ? order.ShippedToCustomer.CustomerName : string.Empty,
RequestDate = order.ReceivedDate,
ShipToNumber = order.ShippedToCustomer.EANIdentifier,
SupplierNumber = (connectorVendorSettings != null && !string.IsNullOrEmpty(connectorVendorSettings.VendorIdentifier)) ? connectorVendorSettings.VendorIdentifier : string.Empty,
SupplierSalesOrder = l.OrderID,
WebsiteNumber = order.WebSiteOrderNumber,
Remark = l.Remarks //,
//SupplierSalesOrder = order.OrderID
}).ToArray()
};
return(directShipmentOrder);
}
}
public List <AssortmentStockPriceProduct> GetStockAndPrices()
{
var cStatuses = _db.Query <ConnectorProductStatus>("SELECT * FROM ConnectorProductStatus WHERE ConnectorID = @0", connectorID).ToList();
ProductStatusConnectorMapper mapper = new ProductStatusConnectorMapper(connectorID, cStatuses);
ContentLogic logic = new ContentLogic(_db, connectorID);
logic.FillRetailStock(_db);
var relatedProductTypeList = _db.Query <RelatedProductType>("SELECT * FROM RelatedProductType").ToDictionary(x => x.RelatedProductTypeID, y => y);
var calculatedPrices = _db.Query <Concentrator.Objects.Models.Prices.CalculatedPriceView>(
@"EXECUTE GetCalculatedPriceView @0", connectorID);
logic.FillPriceInformation(calculatedPrices);
var recordsSource = _db.Query <AssortmentContentView>("EXECUTE GetAssortmentContentView @0", connectorID).Where(x => x.BrandID > 0);
if (_productID.HasValue)
{
int id = _productID.Value;
if (id > 0)
{
recordsSource = recordsSource.Where(x => x.ProductID == id);
}
}
var records = recordsSource.ToList();
int totalRecords = records.Count;
var vendorstocktypes = _db.Query <VendorStockType>("SELECT * FROM VendorStockTypes").ToList();
var relatedProductsList = GetRelatedProducts();
SynchronizedCollection <AssortmentStockPriceProduct> assortmentList = new SynchronizedCollection <AssortmentStockPriceProduct>();
ParallelOptions options = new ParallelOptions()
{
MaxDegreeOfParallelism = 8
};
Parallel.ForEach(Partitioner.Create(0, totalRecords), options, (range, loopState) =>
{
List <AssortmentStockPriceProduct> list = new List <AssortmentStockPriceProduct>();
for (int idx = range.Item1; idx < range.Item2; idx++)
{
var a = records[idx];
var stockRetail = logic.RetailStock(a.ProductID, _connector);
var prices = logic.CalculatePrice(a.ProductID);
var relatedProducts = relatedProductsList.ContainsKey(a.ProductID) ? relatedProductsList[a.ProductID] : new List <RelatedProduct>();
list.Add(new AssortmentStockPriceProduct
{
RelatedProducts = (from rp in relatedProducts.Distinct()
where rp.IsConfigured
select new AssortmentRelatedProduct()
{
IsConfigured = rp.IsConfigured,
RelatedProductID = rp.RelatedProductID,
TypeID = rp.RelatedProductTypeID,
Type = relatedProductTypeList[rp.RelatedProductTypeID].Type,
Index = rp.Index,
MapsToMagentoTypeID = relatedProductTypeList[rp.RelatedProductTypeID].TypeMapsToMagentoTypeID
}).ToList(),
Visible = a.Visible,
ProductID = a.ProductID,
ManufacturerID = a.VendorItemNumber.Trim(),
IsNonAssortmentItem = a.IsNonAssortmentItem ?? false,
IsConfigurable = a.IsConfigurable,
CustomProductID = a.CustomItemNumber,
Stock = new AssortmentStock()
{
QuantityToReceive = a.QuantityToReceive ?? 0,
InStock = a.QuantityOnHand,
StockStatus = a.ConnectorStatus,
PromisedDeliveryDate = a.PromisedDeliveryDate
},
RetailStock = (from rs in stockRetail
select new AssortmentRetailStock()
{
CostPrice = rs.UnitCost ?? 0,
VendorCode = rs.BackendVendorCode,
InStock = rs.QuantityOnHand,
StockStatus = mapper.GetForConnector(rs.ConcentratorStatusID),
Name = rs.VendorStockTypeID == 1 ? rs.vendorName : vendorstocktypes.Where(x => x.VendorStockTypeID == rs.VendorStockTypeID).Select(x => x.StockType).FirstOrDefault(),
PromisedDeliveryDate = rs.PromisedDeliveryDate,
QuantityToReceive = rs.QuantityToReceive ?? 0
}).ToList(),
Prices = (from p in prices
select new AssortmentPrice()
{
CommercialStatus = p.CommercialStatus,
CostPrice = p.CostPrice ?? 0,
SpecialPrice = p.SpecialPrice,
MinimumQuantity = p.MinimumQuantity ?? 0,
TaxRate = p.TaxRate ?? 21,
UnitPrice = p.Price
}).ToList()
});
}
foreach (var item in list)
{
assortmentList.Add(item);
}
}); return(assortmentList.Distinct().ToList());
}
public List <AssortmentProductInfo> GetAssortment(bool importFullContent, bool shopInformation, string customerID, bool showProductGroups, int languageID, bool showRelatedProducts = true)
{
var inactiveGroups = GetInactiveGroupsAndTheirChilds(connectorID);
string mappingsToExcludeStatement = string.IsNullOrEmpty(inactiveGroups) ? "" : string.Format(" and MasterGroupMappingID not in ({0})", inactiveGroups);
var productGroupsQuery = string.Format("SELECT * FROM ContentProductGroup WHERE ConnectorID = {0} and IsExported = 1 AND MasterGroupMappingID is NOT NULL {1}", connectorID, mappingsToExcludeStatement);
var productGroups = _db.Query <ContentProductGroup>(productGroupsQuery).GroupBy(c => c.ProductID).ToDictionary(c => c.Key, c => c.ToList());
var cStatuses = _db.Query <ConnectorProductStatus>("SELECT * FROM ConnectorProductStatus WHERE ConnectorID = @0", connectorID).ToList();
ProductStatusConnectorMapper mapper = new ProductStatusConnectorMapper(connectorID, cStatuses);
ContentLogic logic = new ContentLogic(_db, connectorID);
logic.FillRetailStock(_db);
var calculatedPrices = _db.Query <Concentrator.Objects.Models.Prices.CalculatedPriceView>(
@"EXECUTE GetCalculatedPriceView @0", connectorID);
logic.FillPriceInformation(calculatedPrices);
var connectorSystem = _db.Single <ConnectorSystem>("SELECT * FROM ConnectorSystem WHERE ConnectorSystemID = @0", _connector.ConnectorSystemID.Value);
bool magento = _connector.ConnectorSystemID.HasValue && connectorSystem.Name == "Magento";
var defaultLanguage = _db.FirstOrDefault <ConnectorLanguage>("SELECT * FROM ConnectorLanguage WHERE ConnectorID = @0", connectorID);
defaultLanguage.ThrowIfNull("No default Language specified for connector");
if (languageID == 0)
{
//languageID = EntityExtensions.GetValueByKey(con.ConnectorSettings, "LanguageID", 2);
var language = _db.FirstOrDefault <ConnectorLanguage>("SELECT * FROM ConnectorLanguage WHERE ConnectorID = @0", connectorID);
language.ThrowIfNull("No Language specified for connector");
languageID = language.LanguageID;
}
var recordsSource = _db.Query <AssortmentContentView>("EXECUTE GetAssortmentContentView @0", connectorID).Where(x => x.BrandID > 0);
if (_productID.HasValue)
{
int id = _productID.Value;
if (id > 0)
{
recordsSource = recordsSource.Where(x => x.ProductID == id);
}
}
var records = recordsSource.ToList();
var barcodes = _db.Query <ProductBarcodeView>("SELECT * FROM ProductBarcodeView WHERE ConnectorID = @0 and BarcodeType = @1", connectorID, (int)BarcodeTypes.Default).ToList();
var brands = _db.Query <Brand>("SELECT * FROM Brand").ToList();
List <ImageView> productImages = new List <ImageView>();
if (importFullContent)
{
productImages = _db.Query <ImageView>("SELECT * FROM ImageView WHERE ConnectorID = @0 AND ImageType = @1", connectorID, "Product").ToList();
}
int totalRecords = records.Count;
List <CrossLedgerclass> crossLedgerClasses = null;
if (shopInformation)
{
crossLedgerClasses = _db.Query <CrossLedgerclass>("SELECT * FROM CrossLedgerClass WHERE ConnectorID = @0", connectorID).ToList();
}
var vendorstocktypes = _db.Query <VendorStockType>("SELECT * FROM VendorStockTypes").ToList();
List <MasterGroupMapping> mappingslist = null;
Dictionary <int, List <MasterGroupMappingMedia> > mappingMediaList = new Dictionary <int, List <MasterGroupMappingMedia> >();
List <MasterGroupMapping> parentMappingList = new List <MasterGroupMapping>();
if (showProductGroups)
{
string mappingListQuery = string.Format("SELECT * FROM MasterGroupMapping WHERE ConnectorID = {0} {1}", connectorID, mappingsToExcludeStatement);
mappingslist = _db.Query <MasterGroupMapping>(mappingListQuery).ToList();
string mappingMediaQuery = @"SELECT MGMM.*
FROM MasterGroupMapping MGM
LEFT JOIN MasterGroupMappingMedia MGMM ON MGM.MasterGroupMappingID = MGMM.MasterGroupMappingID
WHERE MasterGroupMappingMediaID IS NOT NULL AND MGM.ConnectorID = {0} {1}";
foreach (var masterGroupMappingMedia in _db.Query <MasterGroupMappingMedia>(string.Format(mappingMediaQuery, connectorID, mappingsToExcludeStatement)))
{
if (!mappingMediaList.ContainsKey(masterGroupMappingMedia.MasterGroupMappingID))
{
mappingMediaList.Add(masterGroupMappingMedia.MasterGroupMappingID, new List <MasterGroupMappingMedia>());
}
mappingMediaList[masterGroupMappingMedia.MasterGroupMappingID].Add(masterGroupMappingMedia);
}
if (_connector.ParentConnectorID.HasValue)
{
string parentMappingListQuery = string.Format("SELECT * FROM MasterGroupMapping WHERE ConnectorID = {0} {1}", _connector.ParentConnectorID.Value, mappingsToExcludeStatement);
parentMappingList = _db.Query <MasterGroupMapping>(parentMappingListQuery).ToList();
foreach (var masterGroupMappingMedia in _db.Query <MasterGroupMappingMedia>(string.Format(mappingMediaQuery, _connector.ParentConnectorID.Value, mappingsToExcludeStatement)))
{
if (!mappingMediaList.ContainsKey(masterGroupMappingMedia.MasterGroupMappingID))
{
mappingMediaList.Add(masterGroupMappingMedia.MasterGroupMappingID, new List <MasterGroupMappingMedia>());
}
mappingMediaList[masterGroupMappingMedia.MasterGroupMappingID].Add(masterGroupMappingMedia);
}
}
}
var preferredVendor = _db.FirstOrDefault <PreferredConnectorVendor>("SELECT * FROM PreferredConnectorVendor WHERE ConnectorID = @0 AND IsPreferred = 1", connectorID);
int?vendorid = null;
if (preferredVendor != null)
{
vendorid = preferredVendor.VendorID;
}
var relatedProductTypeList = _db.Query <RelatedProductType>("SELECT * FROM RelatedProductType").ToDictionary(x => x.RelatedProductTypeID, y => y);
var styleType = relatedProductTypeList.Where(c => c.Value.Type == "Style").FirstOrDefault();
var relatedProductsList = GetRelatedProducts();
var configAttributesListSource = _db.Query <ProductAttributeMetaData>(
@"SELECT ProductID, PAMD.*
FROM ProductAttributeConfiguration PAC
INNER JOIN ProductAttributeMetaData PAMD ON (PAC.AttributeID = PAMD.AttributeID)"
);
var configAttributesList = (from f in configAttributesListSource
group f by f.ProductID into grouped
select grouped).ToDictionary(x => x.Key, y => y.ToList());
var productGroupNames = _db.Query <MasterGroupMappingLanguage>("SELECT * FROM MasterGroupMappingLanguage WHERE LanguageID = @0", languageID).Select(c => new { c.MasterGroupMappingID, c.Name }).ToDictionary(c => c.MasterGroupMappingID, c => c.Name);
var productGroupNamesDefault = _db.Query <MasterGroupMappingLanguage>("SELECT * FROM MasterGroupMappingLanguage WHERE LanguageID = @0", defaultLanguage.LanguageID).Select(c => new { c.MasterGroupMappingID, c.Name }).ToDictionary(c => c.MasterGroupMappingID, c => c.Name);
var productGroupDescriptions = _db.Query <MasterGroupMappingDescription>("SELECT * FROM MasterGroupMappingDescription WHERE LanguageID = @0", languageID).Select(c => new { c.MasterGroupMappingID, c.Description }).ToDictionary(c => c.MasterGroupMappingID, c => c.Description);
var productGroupCustomLabelsForThisConnector
= _db.Query <MasterGroupMappingCustomLabel>("SELECT * FROM MasterGroupMappingCustomLabel WHERE LanguageID = @0 AND ConnectorID = @1", languageID, connectorID).Select(c => new { c.MasterGroupMappingID, c.CustomLabel }).ToDictionary(c => c.MasterGroupMappingID, c => c.CustomLabel);
var productGroupCustomLabelsForDefaultConnector = _db.Query <MasterGroupMappingCustomLabel>(@"SELECT * FROM MasterGroupMappingCustomLabel WHERE LanguageID = @0 AND ConnectorID is null", languageID).Select(c => new { c.MasterGroupMappingID, c.CustomLabel }).ToDictionary(c => c.MasterGroupMappingID, c => c.CustomLabel);
var magentoLayouts = _db.Query <MagentoPageLayout>("SELECT * FROM MagentoPageLayout").Select(c => new { c.LayoutID, c.LayoutCode }).ToDictionary(c => c.LayoutID, c => c.LayoutCode);
var magentoSettingModels = _db.Query <MagentoProductGroupSetting>("SELECT * FROM MagentoProductGroupSetting WHERE MasterGroupMappingID is NOT NULL").ToList();
var seoTextsModel = new SortedList <int, List <SeoTexts> >(_db.Query <SeoTexts>("SELECT * FROM SeoTexts WHERE MasterGroupMappingID is NOT NULL").GroupBy(c => c.MasterGroupMappingID).ToDictionary(c => c.Key, c => c.ToList()));
//refactor in a nicer way
var presaleProducts = _db.Query <int>("select distinct productid from productattributevalue where attributeid in (select attributeid from productattributemetadata where attributecode= 'btf') and value = 'true'").ToList();
presaleProducts.Sort();
var supportsCompleteTheLookFunctionality = _db.FirstOrDefault <bool>("Select * from connectorsetting where connectorid = @0 and settingkey = 'CompleteTheLookConnector'", connectorID);
var masterGroupMappingSettingsQuery = @";WITH OptionValues AS
(
SELECT MGMS.MasterGroupMappingSettingID, MGMSV.MasterGroupMappingID, MGMSO.Value
FROM MasterGroupMappingSetting MGMS
INNER JOIN MasterGroupMappingSettingValue MGMSV ON MGMS.MasterGroupMappingSettingID = MGMSV.MasterGroupMappingSettingID
INNER JOIN MasterGroupMappingSettingOption MGMSO ON MGMSV.Value = MGMSO.OptionID
WHERE MGMS.Type = 'option'
)
SELECT MGMS.Name, MGMS.[Group], MGMS.[Type], MGMSV.MasterGroupMappingID
, CASE WHEN OV.MasterGroupMappingSettingID IS NOT NULL THEN OV.Value ELSE MGMSV.Value END AS Value
FROM MasterGroupMappingSettingValue MGMSV
INNER JOIN MasterGroupMappingSetting MGMS ON MGMS.MasterGroupMappingSettingID = MGMSV.MasterGroupMappingSettingID
INNER JOIN MasterGroupMapping MGM ON MGMSV.MasterGroupMappingID = MGM.MasterGroupMappingID
LEFT JOIN OptionValues OV ON MGMS.MasterGroupMappingSettingID = OV.MasterGroupMappingSettingID AND MGMSV.MasterGroupMappingID = OV.MasterGroupMappingID
WHERE MGM.ConnectorID = {0} {1}";
var parentConnectorFilter = string.Empty;
if (_connector.ParentConnectorID.HasValue)
{
parentConnectorFilter = string.Format("OR MGM.ConnectorID = {0}", _connector.ParentConnectorID);
}
var masterGroupMappingSettings = _db.Query <MasterGroupMappingSettingResult>(string.Format(masterGroupMappingSettingsQuery, connectorID, parentConnectorFilter));
var masterGroupMappingSettingsDictionary = new Dictionary <int, List <MasterGroupMappingSettingResult> >();
foreach (var masterGroupMappingSetting in masterGroupMappingSettings)
{
if (!masterGroupMappingSettingsDictionary.ContainsKey(masterGroupMappingSetting.MasterGroupMappingID))
{
masterGroupMappingSettingsDictionary.Add(masterGroupMappingSetting.MasterGroupMappingID, new List <MasterGroupMappingSettingResult>());
}
masterGroupMappingSettingsDictionary[masterGroupMappingSetting.MasterGroupMappingID].Add(masterGroupMappingSetting);
}
SynchronizedCollection <AssortmentProductInfo> assortmentList = new SynchronizedCollection <AssortmentProductInfo>();
ParallelOptions options = new ParallelOptions()
{
MaxDegreeOfParallelism = 8
};
#if DEBUG
options = new ParallelOptions()
{
MaxDegreeOfParallelism = 8
};
#endif
Parallel.ForEach(Partitioner.Create(0, totalRecords), options, (range, loopState) =>
{
List <AssortmentProductInfo> list = new List <AssortmentProductInfo>();
for (int idx = range.Item1; idx < range.Item2; idx++)
{
var a = records[idx];
if (a.IsConfigurable)
{
var lis = relatedProductsList[a.ProductID].Where(c => c.IsConfigured).Select(c => c.RelatedProductID).ToList();
if (!records.Any(rp => lis.Contains(rp.ProductID)))
{
continue;
}
}
var productBarcodes = barcodes.Where(x => x.ProductID == a.ProductID).Select(c => c.Barcode).ToList();
var images = productImages.Where(x => x.ProductID == a.ProductID).ToList();
var configAttributes = configAttributesList.ContainsKey(a.ProductID) ? configAttributesList[a.ProductID] : new List <ProductAttributeMetaData>();
var relatedProducts = relatedProductsList.ContainsKey(a.ProductID) ? relatedProductsList[a.ProductID] : new List <RelatedProduct>();
if (supportsCompleteTheLookFunctionality)
{
if (a.IsConfigurable && a.ParentProductID != null)
{
//this is color level
//get from the relatedProductsList the ParentProduct related products.
var parentProductRelatedProducts = relatedProductsList.ContainsKey(a.ParentProductID.Value) ? relatedProductsList[a.ParentProductID.Value] : new List <RelatedProduct>();
parentProductRelatedProducts = parentProductRelatedProducts.Where(c => c.RelatedProductTypeID == 9).ToList();
//foreach related product:
//if related product is artikel (IsConfigurable && ParentProductID == null) then find all colors of that artikel (get products where parentproductid is productid of artikel item)
// the found color items are the related products.
//else
// if related product is color level than this is the related product
foreach (var prp in parentProductRelatedProducts)
{
if (prp.PP_IsConfigurable && prp.PP_ParentProductID == null)
{
//Is Artikel product
var artikelRelatedProducts = relatedProductsList.ContainsKey(prp.ProductID)
? relatedProductsList[prp.ProductID]
: new List <RelatedProduct>();
//TODO: fix the types
foreach (var rp in artikelRelatedProducts.Where(c => c.RelatedProductTypeID == 9 || c.RelatedProductTypeID == 10).ToList())
{
var colorItem = relatedProductsList[rp.RelatedProductID].Where(t => t.RelatedProductTypeID == styleType.Key);
var rangeRelatedProducts = (from ci in colorItem
where !relatedProducts.Any(c => c.RelatedProductID == ci.RelatedProductID)
select new RelatedProduct()
{
ProductID = a.ProductID,
RelatedProductID = ci.RelatedProductID,
RelatedProductTypeID = 9,
Index = rp.Index,
IsConfigured = false
}).ToList();
relatedProducts.AddRange(rangeRelatedProducts);
}
//relatedProducts.AddRange(artikelRelatedProducts.Distinct());
}
else
{
relatedProducts.Add(prp);
}
}
}
}
var prices = logic.CalculatePrice(a.ProductID);
var stockRetail = logic.RetailStock(a.ProductID, _connector);
var productProductGroups = productGroups.ContainsKey(a.ProductID) ? productGroups[a.ProductID] : new List <ContentProductGroup>();
list.Add(new AssortmentProductInfo
{
Visible = a.Visible,
Content = new AssortmentContent()
{
ProductName = !string.IsNullOrEmpty(a.ProductName.ToString()) ? a.ProductName.ToString() : a.ShortDescription,
ShortDescription = a.ShortDescription ?? string.Empty,
LongDescription = a.LongDescription ?? string.Empty
},
ProductID = a.ProductID,
ManufacturerID = a.VendorItemNumber.Trim(),
IsNonAssortmentItem = a.IsNonAssortmentItem ?? false,
RelatedProducts = (from rp in relatedProducts.Distinct().OrderBy(c => c.RelatedProductID)
select new AssortmentRelatedProduct()
{
IsConfigured = rp.IsConfigured,
RelatedProductID = rp.RelatedProductID,
TypeID = rp.RelatedProductTypeID,
Type = relatedProductTypeList[rp.RelatedProductTypeID].Type,
Index = rp.Index,
MapsToMagentoTypeID = relatedProductTypeList[rp.RelatedProductTypeID].TypeMapsToMagentoTypeID
}).ToList(),
IsConfigurable = a.IsConfigurable,
CustomProductID = a.CustomItemNumber,
PresaleProduct = presaleProducts.Contains(a.ProductID),
Stock = new AssortmentStock()
{
QuantityToReceive = a.QuantityToReceive ?? 0,
InStock = a.QuantityOnHand,
StockStatus = a.ConnectorStatus,
PromisedDeliveryDate = a.PromisedDeliveryDate
},
RetailStock = (from rs in stockRetail.OrderBy(c => c.VendorStockTypeID)
select new AssortmentRetailStock()
{
CostPrice = rs.UnitCost ?? 0,
VendorCode = rs.BackendVendorCode,
InStock = rs.QuantityOnHand,
StockStatus = mapper.GetForConnector(rs.ConcentratorStatusID),
Name = rs.VendorStockTypeID == 1 ? rs.vendorName : vendorstocktypes.Where(x => x.VendorStockTypeID == rs.VendorStockTypeID).Select(x => x.StockType).FirstOrDefault(),
PromisedDeliveryDate = rs.PromisedDeliveryDate,
QuantityToReceive = rs.QuantityToReceive ?? 0
}).ToList(),
Prices = (from p in prices.OrderBy(c => c.VendorAssortmentID)
select new AssortmentPrice()
{
CommercialStatus = p.CommercialStatus,
CostPrice = p.CostPrice ?? 0,
SpecialPrice = p.SpecialPrice,
MinimumQuantity = p.MinimumQuantity ?? 0,
TaxRate = p.TaxRate ?? 19,
UnitPrice = p.Price
}).ToList(),
ConfigurableAttributes = (from ca in configAttributes
select new AssortmentConfigurableAttribute()
{
AttributeCode = ca.AttributeCode,
AttributeID = ca.AttributeID,
ConfigurablePosition = ca.ConfigurablePosition ?? 0
}).ToList(),
Barcodes = productBarcodes,
Images = (from img in images.OrderBy(c => c.mediaid)
select new AssortmentProductImage()
{
Sequence = img.Sequence ?? 0,
Path = img.ImagePath
}).ToList(),
Brand = GetAssortmentBrandHierarchy(a.BrandID, a.VendorBrandCode, brands),
ProductGroups =
(from p in productProductGroups.OrderBy(c => c.ContentProductGroupID)
select GetAssortmentProductGroupHierarchy(
p.MasterGroupMappingID.Value
, languageID
, defaultLanguage.LanguageID
, mappingslist
, mappingMediaList
, masterGroupMappingSettingsDictionary
, productGroupNames
, productGroupNamesDefault
, productGroupDescriptions
, productGroupCustomLabelsForThisConnector
//, productGroupModels
, magentoLayouts
, magentoSettingModels
, parentMappingList
, productGroupCustomLabelsForDefaultConnector
, seoTextsModel))
.ToList().OrderBy(x => x.Index).ToList()
,
LineType = a.LineType
,
ShopInfo = new AssortmentShopInformation()
{
LedgerClass = a.LedgerClass,
ProductDesk = a.ProductDesk,
ExtendedCatalog = a.ExtendedCatalog ?? false,
OriginalLedgerClass = a.LedgerClass
},
DeliveryHours = a.DeliveryHours,
CutOffTime = a.CutOffTime
});
}
foreach (var item in list)
{
assortmentList.Add(item);
}
});
return(assortmentList.Distinct().ToList());
}