public ODataShipment GetAPIShipment(SOShipment shipment, SOPackageDetail package, PXResultset <SOLine> lines)
{
var wrapper = new ODataShipment();
var apiShipment = new KCAPIShipment()
{
ShippedDateUtc = shipment.ShipDate,
TrackingNumber = package?.TrackNumber,
ShippingCarrier = shipment.ShipVia,
ShippingClass = shipment.ShipVia,
DeliveryStatus = "Complete"
};
var apiItems = new List <KCAPIShipmentItem>();
foreach (PXResult <SOLine> line in lines)
{
SOLine soLine = line.GetItem <SOLine>();
SOShipLine shipLine = line.GetItem <SOShipLine>();
DAC.KNSIKCInventoryItem kcInventoryItem = line.GetItem <DAC.KNSIKCInventoryItem>();
InventoryItem inventoryItem = line.GetItem <InventoryItem>();
InventoryItemPCExt inventoryItemPcExt = inventoryItem.GetExtension <InventoryItemPCExt>();
SOLinePCExt soLinePcExt = soLine.GetExtension <SOLinePCExt>();
int quantity = Convert.ToInt32(shipLine.ShippedQty.GetValueOrDefault());
if ((soLine.LineNbr != soLinePcExt?.UsrKNMasterLineNbr && ParentIsGrouped(lines, soLinePcExt)) ||
(inventoryItemPcExt?.UsrKNCompositeType == KCConstants.ConfigurableProduct && soLine.LineNbr == soLinePcExt?.UsrKNMasterLineNbr))
{
continue;
}
if (inventoryItemPcExt?.UsrKNCompositeType == KCConstants.GroupedProduct && quantity == 0)
{
SOShipLine childItem = lines.Where(x => x.GetItem <SOLine>().GetExtension <SOLinePCExt>().UsrKNMasterLineNbr == soLine.LineNbr &&
x.GetItem <SOLine>().LineNbr != soLine.LineNbr).RowCast <SOShipLine>().FirstOrDefault();
if (childItem != null)
{
KCDataExchangeMaint graph = PXGraph.CreateInstance <KCDataExchangeMaint>();
List <KNSIGroupedItems> origChildItems = graph.GroupedChildItems.Select(inventoryItem.InventoryID).RowCast <KNSIGroupedItems>().ToList();
quantity = Convert.ToInt32(childItem.ShippedQty / origChildItems.Where(x => x.MappedInventoryID == childItem.InventoryID).FirstOrDefault().Quantity);
}
else
{
throw new KCCorruptedShipmentException();
}
}
apiItems.Add(new KCAPIShipmentItem
{
ProductID = kcInventoryItem?.UsrKCCAID.ToString(),
OrderItemID = soLine?.GetExtension <KCSOLineExt>()?.UsrKCOrderItemID.ToString(),
Quantity = shipLine == null ? 0 : Convert.ToInt32(quantity)
});
}
apiShipment.Items = apiItems;
wrapper.Value = apiShipment;
return(wrapper);
}
protected virtual void SOShipLine_RowUpdated(PXCache sender, PXRowUpdatedEventArgs e, PXRowUpdated baseHandler)
{
if (!(e.Row is SOShipLine))
{
return;
}
baseHandler?.Invoke(sender, e);
SOShipLine row = e.Row as SOShipLine;
SOLine soLine = KCSOLineByLineNbrAndOrderNbr.SelectSingle(row.OrigLineNbr, row.OrigOrderNbr);
int? UsrKNMasterLineNbr = soLine?.GetExtension <SOLinePCExt>().UsrKNMasterLineNbr;
if (soLine != null && soLine.GetExtension <SOLinePCExt>().UsrKNMasterLineNbr == soLine.LineNbr && row.LocationID == null)
{
SOShipLine childLine = KCSOLineByMasterLineAndOrderNbr.Select(UsrKNMasterLineNbr, row.OrigOrderNbr).RowCast <SOLine>().Where(x => x.LineNbr != soLine.LineNbr).FirstOrDefault();
SOShipLine childShipLine = Base.Transactions.Select().RowCast <SOShipLine>().Where(x => x.OrigLineNbr == childLine?.LineNbr).FirstOrDefault();
row.LocationID = childShipLine?.LocationID;
}
}
protected virtual void SOShipLine_RowInserted(PXCache sender, PXRowInsertedEventArgs e, PXRowInserted baseHandler)
{
if (!(e.Row is SOShipLine))
{
return;
}
baseHandler?.Invoke(sender, e);
SOShipLine row = e.Row as SOShipLine;
SOLine soLine = KCSOLineByLineNbrAndOrderNbr.SelectSingle(row.OrigLineNbr, row.OrigOrderNbr);
if (soLine != null && row.OrigOrderQty != soLine.Qty)
{
row.OrigOrderQty = soLine.Qty;
row.BaseOrigOrderQty = soLine.Qty;
Base.Transactions.Update(row);
}
var extrows = Base.Transactions.Cache.GetExtension <SOShipLinePCExt>(row);
if (extrows.UsrKNMasterLineNbr == row.OrigLineNbr)
{
extrows.UsrKNCompositeInventory = KCMessages.CompositeItemLinePlaceholder;
}
}
public virtual ARTran CreateTranFromShipLine(ARInvoice newdoc, SOOrderType ordertype, string operation, SOLine orderline, ref SOShipLine shipline, CreateTranFromShipLineDelegate baseMethod)
{
ARTran tran = baseMethod(newdoc, ordertype, operation, orderline, ref shipline);
SOLine line = PXSelect <SOLine, Where <SOLine.orderType, Equal <Required <SOLine.orderType> >,
And <SOLine.orderNbr, Equal <Required <SOLine.orderNbr> >,
And <SOLine.lineNbr, Equal <Required <SOLine.lineNbr> > > > > > .Select(Base, orderline.OrderType, orderline.OrderNbr, orderline.LineNbr);
SOLineRUTROT lineRR = PXCache <SOLine> .GetExtension <SOLineRUTROT>(line);
ARTranRUTROT tranRR = PXCache <ARTran> .GetExtension <ARTranRUTROT>(tran);
tranRR.IsRUTROTDeductible = lineRR.IsRUTROTDeductible;
tranRR.RUTROTItemType = lineRR.RUTROTItemType;
tranRR.RUTROTWorkTypeID = lineRR.RUTROTWorkTypeID;
return(tran);
}
public virtual void AmazonSubmitFeed(List <ProjectionShipmentDAC> list, SubmitFeedFilter currentFilter)
{
SOPartialMaint logGraph = PXGraph.CreateInstance <SOPartialMaint>();
int? processId = list.Count > 0 ? SOLogService.LogSubmitCount(logGraph, currentFilter.IntegrationID, list.Count) : null;
if (!(processId > 0))
{
return;
}
SubmitFeedParamaters objSubmitFeedParams = null;
StringBuilder sbXmlFeedData = new StringBuilder();
objEnvelope = new AmazonEnvelope();
objHeader = new Header();
objHeader.DocumentVersion = SOConstants.documentVersion;
objEnvelope.MessageType = SOConstants.orderFulfillment;
objEnvelope.Header = objHeader;
List <Message> liMsgContent = new List <Message>();
UTF8Encoding encoding = new UTF8Encoding();
double megaBytesLength = 0.0d;
bool isErrorOccured = false;
Regex xmlEmptytagsRemove = new Regex(@"(\s)*<(\w:\w|\w)*(\s)*/>");
AMSubmitFeedServiceCall.AmazonEnvelope resAMEnv = null;
List <Item> listItems = null;
foreach (ProjectionShipmentDAC currentRecord in list)
{
SOAmazonSetup objSOAmazonSetup = null;
Item objitem = null;
SOHelper.MarketplaceConfigurations(logGraph, currentFilter.IntegrationID, out objSOAmazonSetup);
objHeader.MerchantIdentifier = objSOAmazonSetup.SellerId;
objSubmitFeedParams = new SubmitFeedParamaters();
listItems = new List <Item>();
try
{
logGraph.Clear();
foreach (PXResult <SOShipment, SOShipLine, Carrier, SOPackageDetail> result in PXSelectJoin <SOShipment, InnerJoin <SOShipLine, On <SOShipment.shipmentType, Equal <SOShipLine.shipmentType>,
And <SOShipment.shipmentNbr, Equal <SOShipLine.shipmentNbr> > >,
InnerJoin <Carrier, On <SOShipment.shipVia, Equal <Carrier.carrierID> >,
LeftJoin <SOPackageDetail, On <SOPackageDetail.shipmentNbr, Equal <SOShipLine.shipmentNbr> > > > >,
Where <SOShipLine.shipmentNbr, Equal <Required <SOShipLine.shipmentNbr> > >,
OrderBy <Desc <SOPackageDetail.lineNbr> > > .Select(logGraph, currentRecord.ShipmentNbr))
{
SOShipment objShipment = (SOShipment)result;
SOShipLine objShipLine = (SOShipLine)result;
Carrier objCarrier = (Carrier)result;
SOPackageDetail objPackageDetails = (SOPackageDetail)result;
objitem = null;
if (objShipment != null && objShipLine != null && objPackageDetails != null && objPackageDetails.Confirmed != null && objPackageDetails.Confirmed == true && !string.IsNullOrEmpty(objPackageDetails.TrackNumber))
{
SOShipmentAmazonExt objShipmentExt = PXCache <SOShipment> .GetExtension <SOShipmentAmazonExt>(objShipment);
objSubmitFeedParams.soType = objShipLine.OrigOrderType;
objSubmitFeedParams.acmOrderNbr = objShipLine.OrigOrderNbr;
objSubmitFeedParams.shipmentType = objShipment.ShipmentType;
objSubmitFeedParams.shipmentNbr = objShipment.ShipmentNbr;
objSubmitFeedParams.shipmentDate = objShipment.ShipDate;
objSubmitFeedParams.carrierCode = !String.IsNullOrEmpty(objShipmentExt.UsrAmazonCarrierCode) ?
objShipmentExt.UsrAmazonCarrierCode : objShipment.ShipVia;
objSubmitFeedParams.shipVia = (objCarrier == null || String.IsNullOrEmpty(objCarrier.PluginMethod)) ?
objShipment.ShipVia : objCarrier.PluginMethod;
objSubmitFeedParams.trackingNbr = objPackageDetails.TrackNumber;
SOShipLineAmazonExt objShLineExt = objShipLine.GetExtension <SOShipLineAmazonExt>();
objSubmitFeedParams.amazonOrderID = objShLineExt != null && !string.IsNullOrEmpty(objShLineExt.UsrAmazonOrderID) ?
objShLineExt.UsrAmazonOrderID : string.Empty;
objitem = new Item();
objitem.AmazonOrderItemCode = objShLineExt != null && !string.IsNullOrEmpty(objShLineExt.UsrAMOrderItemID) ?
objShLineExt.UsrAMOrderItemID : string.Empty;
objitem.Quantity = objShipLine != null?Convert.ToInt32(objShipLine.ShippedQty) : 0;
listItems.Add(objitem);
}
else
{
throw new PXException(SOMessages.shipmentDetailsMissing);
}
}
objSubmitFeedParams.objPartialMaint = logGraph;
objSubmitFeedParams.indexOfCurrentOrder = list.IndexOf(currentRecord);
objSubmitFeedParams.objSOAmazonSetup = objSOAmazonSetup;
objSubmitFeedParams.processID = processId;
if (listItems != null && listItems.Count > 0)
{
objSubmitFeedParams.liShipItem = listItems;
}
Message objMessage = GetListOfMessagesContent(objSubmitFeedParams);
if (objMessage.MessageID != null)
{
liMsgContent.Add(objMessage);
}
}
catch (Exception ex)
{
isErrorOccured = true;
objSubmitFeedParams.feedMessage = ex.Message;
objSubmitFeedParams.importOrderStatus = false;
objSubmitFeedParams.xmlMessage = string.Empty;
SOLogService.LogSubmitStatus(objSubmitFeedParams);
PXProcessing <ProjectionShipmentDAC> .SetError(list.IndexOf(currentRecord), ex.Message);
}
}
objEnvelope.MessageBody = SOConstants.messagebody;
string resultFeed = SOHelper.ObjectToXMLConversion(objEnvelope, SOConstants.amazonEnvelope, false);
if (liMsgContent.Count > 0)
{
foreach (Message listobj in liMsgContent)
{
if (megaBytesLength >= SOConstants.feedSize)
{
break;
}
sbXmlFeedData.Append(SOHelper.ObjectToXMLConversion(listobj, SOConstants.messageBody, true) + SOConstants.getNewLine);
var byteData = encoding.GetBytes(sbXmlFeedData.ToString());
megaBytesLength = (byteData.Length / 1024f) / 1024f;
}
string xmlFeedContent = xmlEmptytagsRemove.Replace(resultFeed.Replace(SOConstants.msgbodyTag, Convert.ToString(sbXmlFeedData)), string.Empty);
PXTrace.WriteInformation(xmlFeedContent);
resAMEnv = new AMSubmitFeedServiceCall(clientFeed).InvokeServicesCalls(objSubmitFeedParams, xmlFeedContent);
}
if (resAMEnv != null && resAMEnv.Message != null && resAMEnv.Message.ProcessingReport != null && resAMEnv.Message.ProcessingReport.ProcessingSummary != null &&
resAMEnv.Message.ProcessingReport.ProcessingSummary.MessagesProcessed == resAMEnv.Message.ProcessingReport.ProcessingSummary.MessagesSuccessful &&
resAMEnv.Message.ProcessingReport.ProcessingSummary.MessagesWithError == 0)
{
foreach (ProjectionShipmentDAC currentRecord in list)
{
UpdateSubmitLogDetails(list, objSubmitFeedParams, currentRecord, null);
}
}
else if (resAMEnv != null && resAMEnv.Message != null && resAMEnv.Message.ProcessingReport != null &&
(resAMEnv.Message.ProcessingReport.ProcessingSummary.MessagesWithError > 0 ||
resAMEnv.Message.ProcessingReport.ProcessingSummary.MessagesSuccessful > 0))
{
bool isSubmitted;
foreach (ProjectionShipmentDAC currentRecord in list)
{
isSubmitted = false;
foreach (var item in resAMEnv.Message.ProcessingReport.Result.AsEnumerable().Where(x => x.MessageID == currentRecord.ShipmentNbr))
{
isSubmitted = true;
isErrorOccured = true;
UpdateSubmitLogDetails(list, objSubmitFeedParams, currentRecord, item);
}
if (!isSubmitted)
{
UpdateSubmitLogDetails(list, objSubmitFeedParams, currentRecord, null);
}
}
}
if (isErrorOccured)
{
throw new PXException(SOMessages.showErrorMsgFeeds);
}
}
