public static void UpdatePOFineLine(this POFineLineOutput pofineline, MMSPOEvent model) { pofineline.PurchaseOrder = model.PONumber; pofineline.Currency = model.CurrencyCode; pofineline.StatusCode = model.StatusCode; pofineline.SubVendorNumber = model.SubVendorNumber; }
public static void UpdatePOFineLinePoSkuData(this POFineLineOutput pofineline, List <POSkus> poskus) { if (poskus != null && poskus.Count > 0) { List <POFineLineSkuOutput> poskustobeaddedtoPO = new List <POFineLineSkuOutput>(); pofineline.POSkus.ForEach(x => { var skutobeupdatefrom = poskus.Find(y => y.SKU == x.SKUNumber); if (skutobeupdatefrom != null) { x.PurchaseOrderDate = skutobeupdatefrom.CreateDate != null ? skutobeupdatefrom.CreateDate.Value : new DateTime?(); x.PurchaseOrderReviseDate = skutobeupdatefrom.ModifiedDate != null ? skutobeupdatefrom.ModifiedDate.Value : new DateTime?(); x.OrderQuantity = (skutobeupdatefrom.BuyQuantity == null) ? 0 : skutobeupdatefrom.BuyQuantity.Value; x.StatusCode = skutobeupdatefrom.StatusCode; } }); //add the poskus if applicable var poskustobeadded = poskus.Where(x => !pofineline.POSkus.Any(y => y.SKUNumber == x.SKU)); poskustobeadded?.ToList().ForEach(y => { poskustobeaddedtoPO.Add(new POFineLineSkuOutput { SKUNumber = y.SKU, PurchaseOrderDate = y.CreateDate != null ? y.CreateDate.Value : new DateTime?(), PurchaseOrderReviseDate = y.ModifiedDate != null ? y.ModifiedDate.Value : new DateTime?(), OrderQuantity = (y.BuyQuantity == null) ? 0 : y.BuyQuantity.Value, StatusCode = y.StatusCode, }); }); if (poskustobeadded?.ToList().Count > 0) { pofineline.POSkus.AddRange(poskustobeaddedtoPO); } } }
/// <summary> /// Mehod to compare 2 FineLine objects and return the POskulines that contains the data we want in our final output /// </summary> public POFineLineOutput CompareFineLineData(POFineLineOutput poskusOutputcurrent, POFineLineOutput poskusOutputprev, List <string> memberstoInclude) { try { //if the PO is closed, we won't be including it, even if it's changed if (poskusOutputcurrent.StatusCode == "CL") { return(new POFineLineOutput()); } if (poskusOutputcurrent.POSkus != null && poskusOutputcurrent.POSkus.Count > 0) { //Deliberately set the activty code for poskus to null. It will then //be set appropriately on each sku we decide we want to include poskusOutputcurrent.POSkus.ForEach(y => { y.ActivityCode = null; }); } else { _logger.LogInformation($"CompareFineLineData - Skipping output for PO - {poskusOutputcurrent.PurchaseOrder}; no SKUs were found."); return(new POFineLineOutput()); } int propertyCount = typeof(POFineLineOutput).GetProperties().Length; CompareLogic basicComparison = new CompareLogic() { Config = new ComparisonConfig() { MaxDifferences = propertyCount, MembersToInclude = memberstoInclude } }; List <Difference> diffs = basicComparison.Compare(poskusOutputcurrent, poskusOutputprev).Differences; //None of the values we care about have changed on this PO, so we won't send it. if (diffs == null || diffs.Count() == 0) { bool poUpdated = (diffs.Where(x => x.ParentPropertyName == string.Empty).Count() > 0); poskusOutputcurrent.POSkus.ForEach(y => CompareFinelinePOSkuData(y, poUpdated, poskusOutputprev, basicComparison)); var finalupdatedprod = poskusOutputcurrent.POSkus.Where(posku => posku.ActivityCode != null); if (finalupdatedprod == null || (finalupdatedprod != null && finalupdatedprod.Count() == 0)) { return(new POFineLineOutput()); } } ///See if it's been cancelled at the PO level if (poskusOutputcurrent.StatusCode == "CN" || poskusOutputcurrent.StatusCode == "VD") { //If it was previously cancelled, don't send if (poskusOutputprev.StatusCode == "CN" || poskusOutputprev.StatusCode == "VD") { return(new POFineLineOutput()); } //Tag first sku with an activity code of "C" and leave the rest null //(we'll only need to send one line for all skus on the PO in this scenario) var first = poskusOutputcurrent.POSkus.FirstOrDefault(); if (first != null) { first.ActivityCode = "C"; } } else { //Determine if there were any differences on PO level, and then validate each sku line for inclusion bool poUpdated = (diffs.Where(x => x.ParentPropertyName == string.Empty).Count() > 0); poskusOutputcurrent.POSkus.ForEach(y => CompareFinelinePOSkuData(y, poUpdated, poskusOutputprev, basicComparison)); } //Now that we're done tagging, all the ones with a non-null ActivityCode are the ones we want in our output file var finalupdated = poskusOutputcurrent.POSkus.Where(posku => posku.ActivityCode != null); if (finalupdated == null || (finalupdated != null && finalupdated.Count() == 0)) { return(new POFineLineOutput()); } var POFineLineOutputtobesent = new POFineLineOutput { PurchaseOrder = poskusOutputcurrent.PurchaseOrder, Currency = poskusOutputcurrent.Currency, StatusCode = poskusOutputcurrent.StatusCode, SubVendorNumber = poskusOutputcurrent.SubVendorNumber, POSkus = finalupdated.ToList() }; return(POFineLineOutputtobesent); } catch (Exception ex) { _logger.LogError("Method Name -- CompareFineLineData : {Reason}", ex.Message); return(new POFineLineOutput()); } }
/// <summary> /// For a given posku, this will determine if it should be sent through and, if so, sets the ActivityCode appropriately /// </summary> private void CompareFinelinePOSkuData(POFineLineSkuOutput currentSku, bool parentPOUpdated, POFineLineOutput priorPO, CompareLogic comparisson) { POFineLineSkuOutput poskutobecompared = null; if (priorPO.POSkus != null && priorPO.POSkus.Count > 0) { //grab the previously sent version for this sku poskutobecompared = priorPO.POSkus.Find(posku => posku.SKUNumber == currentSku.SKUNumber); } else { _logger.LogInformation($"CompareFinelinePOSkuData - Skipping output for PO - {priorPO.PurchaseOrder}; no SKUs were found."); return; } ////grab the previously sent version for this sku //var poskutobecompared = priorPO.POSkus.Find(posku => posku.SKUNumber == currentSku.SKUNumber); if (poskutobecompared == null) { //Never sent before. Only send if its status is open if (currentSku.StatusCode == "OP") { currentSku.ActivityCode = ""; } } else if (currentSku.StatusCode == "CN" || currentSku.StatusCode == "VD") { //Cancelled/voided. Send as "X", but only if it wasn't cancelled or voided when we last sent it if (poskutobecompared.StatusCode != "CN" && poskutobecompared.StatusCode != "VD") { currentSku.ActivityCode = "X"; } } else if (parentPOUpdated) { //Parent PO was modified, so all the child skus are considered modified currentSku.ActivityCode = ""; } else { //Parent PO hasn't changed. See if this sku line was itself modified var diffposkus = comparisson.Compare(currentSku, poskutobecompared).Differences; var diffpoproduct = comparisson.Compare(currentSku.POProduct, poskutobecompared.POProduct).Differences; if (diffposkus?.Count > 0 || diffpoproduct?.Count > 0) { currentSku.ActivityCode = ""; } } }
public static bool CheckPoStatus(this POFineLineOutput POFineLineOutput) { return(POFineLineOutput.StatusCode == "OP"); }
public async Task <POFineLineOutput> UpdatePOObject(POFineLineOutput poobject, MMSProductEvent product, POSkus posku) { try { var prodhierarchy = await _lookUpService.GetProductHierarchy(product.SubClass); var productlabel = await _lookUpService.GetProductLabelDescription(product.LabelType); //check if exists if (poobject.POSkus != null && poobject.POSkus.Count > 0 && poobject.POSkus.Exists(y => y.SKUNumber == posku.SKU)) { var poskutobeupdated = poobject.POSkus.Find(y => y.SKUNumber == posku.SKU); poskutobeupdated.POProduct.SKUDescription = product?.SkuDescShrt; poskutobeupdated.POProduct.SubClassID = product?.SubClass; poskutobeupdated.POProduct.TicketType = productlabel?.Code; poskutobeupdated.POProduct.TicketDescription = productlabel?.Description; poskutobeupdated.POProduct.VendorNumber = posku.POProduct?.APVendor; poskutobeupdated.POProduct.Size = product?.Size; poskutobeupdated.POProduct.ISOCountryCode = product.ProductVendors?.Find(y => y.Sku == posku.SKU)?.CountryOfOrigin; poskutobeupdated.POProduct.ClassID = prodhierarchy?.Find(y => y.SubClass == product?.SubClass)?.Class; poskutobeupdated.POProduct.ClassDescription = prodhierarchy?.Find(y => y.SubClass == product?.SubClass)?.Description; poskutobeupdated.POProduct.VendorStyleNumber = product.ProductVendors?.Find(y => y.Sku == posku.SKU)?.VendorSkuCode; poskutobeupdated.POProduct.SubClassDescription = prodhierarchy?.Find(y => y.SubClass == product?.SubClass)?.SubclassDescription; poskutobeupdated.POProduct.SubVendorNumber = product.ProductVendors?.Find(y => y.Sku == posku.SKU)?.SubVendor; poskutobeupdated.POProduct.TicketRetail = posku.GetRetailPrice(); return(poobject); } else { POFineLineProductOutput poFLProductOutput = new POFineLineProductOutput { VendorNumber = posku.POProduct?.APVendor, SubVendorNumber = product.ProductVendors?.Find(y => y.Sku == posku.SKU)?.SubVendor, SKUDescription = product?.SkuDescShrt, VendorStyleNumber = product.ProductVendors?.Find(y => y.Sku == posku.SKU)?.VendorSkuCode, TicketType = productlabel?.Code, TicketDescription = productlabel?.Description, ClassID = prodhierarchy?.Find(y => y.SubClass == product?.SubClass)?.Class, ClassDescription = prodhierarchy?.Find(y => y.SubClass == product?.SubClass)?.Description, SubClassID = product?.SubClass, SubClassDescription = prodhierarchy?.Find(y => y.SubClass == product?.SubClass)?.SubclassDescription, Size = product?.Size, ISOCountryCode = product.ProductVendors?.Find(y => y.Sku == posku.SKU)?.CountryOfOrigin, TicketRetail = posku.GetRetailPrice() }; POFineLineSkuOutput POFLSkusOutput = new POFineLineSkuOutput { SKUNumber = posku.SKU, PurchaseOrderDate = posku.CreateDate != null ? posku.CreateDate.Value : new DateTime?(), PurchaseOrderReviseDate = posku.ModifiedDate != null ? posku.ModifiedDate.Value : new DateTime?(), OrderQuantity = posku.BuyQuantity != null?Convert.ToInt32(posku.BuyQuantity) : 0, POProduct = poFLProductOutput, StatusCode = posku.StatusCode, }; if (poobject.POSkus == null) { poobject.POSkus = new System.Collections.Generic.List <POFineLineSkuOutput>(); } poobject.POSkus.Add(POFLSkusOutput); return(poobject); } } catch (Exception ex) { _logger.LogError(ex, "UpdatePOObject - Failed Updating FineLinePO: {Reason} -- {PONumber} -- {Sku }", ex.Message, poobject.PurchaseOrder, posku.SKU); return(null); } }
public static POFineLineOutput MapEventtoOutput(this MMSPOSkuEvent entity, POFineLineOutput pofineline) { //POSkuevent will not come so this will never be called //pofineline.UpdatePOFineLinePoSkuData(entity); return(pofineline); }
public static POFineLineOutput MapEventtoOutput(this MMSPOEvent entity, POFineLineOutput pofineline) { pofineline.UpdatePOFineLine(entity); return(pofineline); }