public bool WriteFileAddingSequence(string filename, Models.Files.PurchaseOrder.DataSequence.V3 data, bool checkseq)
{
List <object> writelist = new List <object>();
List <(string code, Type type)> used = new List <(string code, Type type)>();
bool success = false;
short seqnum = 1;
try
{
//build list
data.FileHeaderRecord.SequenceNumber = seqnum++;
writelist.Add(data.FileHeaderRecord);
if ((from u in used where u.code == data.FileHeaderRecord.RecordCode select u.code).Count() == 0)
{
used.Add((data.FileHeaderRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R00_ClientFileHeader)));
}
if (data.PurchaseOrders != null && data.PurchaseOrders.Count > 0)
{
foreach (Models.Files.PurchaseOrder.DataSequence.PurchaseOrder item in data.PurchaseOrders)
{
item.ClientHeaderRecord.SequenceNumber = seqnum++;
writelist.Add(item.ClientHeaderRecord);
if ((from u in used where u.code == item.ClientHeaderRecord.RecordCode select u.code).Count() == 0)
{
used.Add((item.ClientHeaderRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R10_ClientHeader)));
}
if (Common.IsValid(item.FixedHandlingInstructionsRecord, checkseq) && !string.IsNullOrEmpty(item.FixedHandlingInstructionsRecord.PONumber))
{
item.FixedHandlingInstructionsRecord.SequenceNumber = seqnum++;
writelist.Add(item.FixedHandlingInstructionsRecord);
if ((from u in used where u.code == item.FixedHandlingInstructionsRecord.RecordCode select u.code).Count() == 0)
{
used.Add((item.FixedHandlingInstructionsRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions)));
}
}
if (Common.IsValid(item.PurchaseOrderOptionsRecord, checkseq))
{
item.PurchaseOrderOptionsRecord.SequenceNumber = seqnum++;
writelist.Add(item.PurchaseOrderOptionsRecord);
if ((from u in used where u.code == item.PurchaseOrderOptionsRecord.RecordCode select u.code).Count() == 0)
{
used.Add((item.PurchaseOrderOptionsRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R21_PurchaseOrderOptions)));
}
}
if (item.PurchaseOrderDetails != null && item.PurchaseOrderDetails.Count > 0)
{
foreach (Models.Files.PurchaseOrder.DataSequence.PurchaseOrderDetail detail in item.PurchaseOrderDetails)
{
if (Common.IsValid(detail.LineItemDetail, checkseq))
{
detail.LineItemDetail.SequenceNumber = seqnum++;
writelist.Add(detail.LineItemDetail);
if ((from u in used where u.code == detail.LineItemDetail.RecordCode select u.code).Count() == 0)
{
used.Add((detail.LineItemDetail.RecordCode, typeof(Models.Files.PurchaseOrder.R40_LineItemDetail)));
}
}
if (Common.IsValid(detail.AdditionalLineItemDetail, checkseq))
{
detail.AdditionalLineItemDetail.SequenceNumber = seqnum++;
writelist.Add(detail.AdditionalLineItemDetail);
if ((from u in used where u.code == detail.AdditionalLineItemDetail.RecordCode select u.code).Count() == 0)
{
used.Add((detail.AdditionalLineItemDetail.RecordCode, typeof(Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail)));
}
}
if (detail.Imprint != null && detail.Imprint.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R45_Imprint imprint in detail.Imprint)
{
if (Common.IsValid(imprint, checkseq) && !string.IsNullOrEmpty(imprint.PONumber))
{
imprint.SequenceNumber = seqnum++;
writelist.Add(imprint);
if ((from u in used where u.code == imprint.RecordCode select u.code).Count() == 0)
{
used.Add((imprint.RecordCode, typeof(Models.Files.PurchaseOrder.R45_Imprint)));
}
}
}
}
if (Common.IsValid(detail.StickerBarcodeDataRecord, checkseq) && !string.IsNullOrEmpty(detail.StickerBarcodeDataRecord.PONumber))
{
detail.StickerBarcodeDataRecord.SequenceNumber = seqnum++;
writelist.Add(detail.StickerBarcodeDataRecord);
if ((from u in used where u.code == detail.StickerBarcodeDataRecord.RecordCode select u.code).Count() == 0)
{
used.Add((detail.StickerBarcodeDataRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R46_StickerBarcodeData)));
}
}
if (detail.StickerTextLines != null && detail.StickerTextLines.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R46_StickerTextLines text in detail.StickerTextLines)
{
if (Common.IsValid(text, checkseq) && !string.IsNullOrEmpty(text.PONumber))
{
text.SequenceNumber = seqnum++;
writelist.Add(text);
if ((from u in used where u.code == text.RecordCode select u.code).Count() == 0)
{
used.Add((text.RecordCode, typeof(Models.Files.PurchaseOrder.R46_StickerBarcodeData)));
}
}
}
}
}
}
}
}
if (Common.IsValid(data.PurchaseOrderTrailerRecord, checkseq))
{
data.PurchaseOrderTrailerRecord.SequenceNumber = seqnum++;
writelist.Add(data.PurchaseOrderTrailerRecord);
if ((from u in used where u.code == data.PurchaseOrderTrailerRecord.RecordCode select u.code).Count() == 0)
{
used.Add((data.PurchaseOrderTrailerRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R50_PurchaseOrderTrailer)));
}
}
if (Common.IsValid(data.FileTrailerRecord, checkseq))
{
data.FileTrailerRecord.SequenceNumber = seqnum++;
writelist.Add(data.FileTrailerRecord);
if ((from u in used where u.code == data.FileTrailerRecord.RecordCode select u.code).Count() == 0)
{
used.Add((data.FileTrailerRecord.RecordCode, typeof(Models.Files.PurchaseOrder.R90_FileTrailer)));
}
}
MultiRecordEngine engine = new MultiRecordEngine
(
(from u in used
orderby u.code
select u.type).Distinct().ToArray()
)
{
RecordSelector = new RecordTypeSelector(Models.Files.Invoice.Selectors.V3.Custom)
};
engine.WriteFile(filename, writelist.ToArray());
success = true;
}
catch (Exception ex)
{
log.Error(ex);
success = false;
}
return(success);
}
public Models.Files.PurchaseOrder.DataSequence.V3 ReadFile(string filename, int batchnumber)
{
List <Models.Files.PurchaseOrder.R00_ClientFileHeader> r00 = null;
List <Models.Files.PurchaseOrder.R10_ClientHeader> r10 = null;
List <Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions> r20 = null;
List <Models.Files.PurchaseOrder.R21_PurchaseOrderOptions> r21 = null;
List <Models.Files.PurchaseOrder.R40_LineItemDetail> r40 = null;
List <Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail> r41 = null;
List <Models.Files.PurchaseOrder.R45_Imprint> r45 = null;
List <Models.Files.PurchaseOrder.R46_StickerBarcodeData> r46barcode = null;
List <Models.Files.PurchaseOrder.R46_StickerTextLines> r46text = null;
List <Models.Files.PurchaseOrder.R50_PurchaseOrderTrailer> r50 = null;
List <Models.Files.PurchaseOrder.R90_FileTrailer> r90 = null;
//
Models.Files.PurchaseOrder.DataSequence.V3 file = null;
Models.Files.PurchaseOrder.DataSequence.PurchaseOrder order = null;
Models.Files.PurchaseOrder.DataSequence.PurchaseOrderDetail orderdetail = null;
//
string typename = string.Empty;
int orderdetailCount = 0;
int orderCount = 0;
bool savedokay = false;
try
{
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseOrder.R00_ClientFileHeader),
typeof(Models.Files.PurchaseOrder.R10_ClientHeader),
typeof(Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions),
typeof(Models.Files.PurchaseOrder.R21_PurchaseOrderOptions),
typeof(Models.Files.PurchaseOrder.R40_LineItemDetail),
typeof(Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail),
typeof(Models.Files.PurchaseOrder.R45_Imprint),
typeof(Models.Files.PurchaseOrder.R46_StickerBarcodeData),
typeof(Models.Files.PurchaseOrder.R46_StickerTextLines),
typeof(Models.Files.PurchaseOrder.R50_PurchaseOrderTrailer),
typeof(Models.Files.PurchaseOrder.R90_FileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.PurchaseOrder.Selectors.V3.Custom)
};
var res = engine.ReadFile(filename);
if (res != null && res.Length > 0)
{
file = new Models.Files.PurchaseOrder.DataSequence.V3();
foreach (var rec in res)
{
typename = rec.GetType().Name.ToUpper();
switch (typename)
{
case "R00_CLIENTFILEHEADER":
Common.Initialize(ref r00);
r00.Add((Models.Files.PurchaseOrder.R00_ClientFileHeader)rec);
file.FileHeaderRecord = r00.LastItem();
break;
case "R10_CLIENTHEADER":
Common.Initialize(ref r10);
r10.Add((Models.Files.PurchaseOrder.R10_ClientHeader)rec);
if (orderCount > 0)
{
if (file.PurchaseOrders == null)
{
file.PurchaseOrders = new List <Models.Files.PurchaseOrder.DataSequence.PurchaseOrder>();
}
if (order != null)
{
file.PurchaseOrders.Add(order);
}
}
orderCount++;
order = new Models.Files.PurchaseOrder.DataSequence.PurchaseOrder
{
ClientHeaderRecord = r10.LastItem()
};
break;
case "R20_FIXEDSPECIALHANDLINGINSTRUCTIONS":
Common.Initialize(ref r20);
r20.Add((Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions)rec);
order.FixedHandlingInstructionsRecord = r20.LastItem();
break;
case "R21_PURCHASEORDEROPTIONS":
Common.Initialize(ref r21);
r21.Add((Models.Files.PurchaseOrder.R21_PurchaseOrderOptions)rec);
order.PurchaseOrderOptionsRecord = r21.LastItem();
break;
case "R40_LINEITEMDETAIL":
Common.Initialize(ref r40);
r40.Add((Models.Files.PurchaseOrder.R40_LineItemDetail)rec);
if (orderdetailCount > 0)
{
if (order.PurchaseOrderDetails == null)
{
order.PurchaseOrderDetails = new List <Models.Files.PurchaseOrder.DataSequence.PurchaseOrderDetail>();
}
if (orderdetail != null)
{
order.PurchaseOrderDetails.Add(orderdetail);
}
}
orderdetailCount++;
orderdetail = new Models.Files.PurchaseOrder.DataSequence.PurchaseOrderDetail
{
LineItemDetail = r40.LastItem()
};
break;
case "R41_ADDITIONALLINEITEMDETAIL":
Common.Initialize(ref r41);
r41.Add((Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail)rec);
orderdetail.AdditionalLineItemDetail = r41.LastItem();
break;
case "R45_IMPRINT":
Common.Initialize(ref r45);
r45.Add((Models.Files.PurchaseOrder.R45_Imprint)rec);
if (orderdetail.Imprint == null)
{
orderdetail.Imprint = new List <Models.Files.PurchaseOrder.R45_Imprint>();
}
if (file.Maxes.ContainsKey(typename) && orderdetail.Imprint.Count < file.Maxes[typename])
{
orderdetail.Imprint.Add(r45.LastItem());
}
break;
case "R46_STICKERBARCODEDATA":
Common.Initialize(ref r46barcode);
r46barcode.Add((Models.Files.PurchaseOrder.R46_StickerBarcodeData)rec);
orderdetail.StickerBarcodeDataRecord = r46barcode.LastItem();
break;
case "R46_STICKERTEXTLINES":
Common.Initialize(ref r46text);
r46text.Add((Models.Files.PurchaseOrder.R46_StickerTextLines)rec);
if (orderdetail.StickerTextLines == null)
{
orderdetail.StickerTextLines = new List <Models.Files.PurchaseOrder.R46_StickerTextLines>();
}
if (file.Maxes.ContainsKey(typename) && orderdetail.StickerTextLines.Count < file.Maxes[typename])
{
orderdetail.StickerTextLines.Add(r46text.LastItem());
}
break;
case "R50_PURCHASEORDERTRAILER":
Common.Initialize(ref r50);
r50.Add((Models.Files.PurchaseOrder.R50_PurchaseOrderTrailer)rec);
file.PurchaseOrderTrailerRecord = r50.LastItem();
if (orderdetail != null)
{
if (order.PurchaseOrderDetails == null)
{
order.PurchaseOrderDetails = new List <Models.Files.PurchaseOrder.DataSequence.PurchaseOrderDetail>();
}
order.PurchaseOrderDetails.Add(orderdetail);
}
file.PurchaseOrders.Add(order);
break;
case "R90_FILETRAILER":
Common.Initialize(ref r90);
r90.Add((Models.Files.PurchaseOrder.R90_FileTrailer)rec);
file.FileTrailerRecord = r90.LastItem();
break;
}
}
using (SQL sql = new SQL(batchnumber, r00, r10, r20, r21, r40, r41, r45, r46barcode, r46text, r50, r90)) { savedokay = sql.Successful; }
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(file);
}
public Models.Files.PurchaseOrder.DataSequence.V3 ReadFile(string filename, int batchnumber)
{
List <Models.Files.PurchaseOrder.R00_FileHeader> r00 = null;
List <Models.Files.PurchaseOrder.R10_ClientHeader> r10 = null;
List <Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions> r20 = null;
List <Models.Files.PurchaseOrder.R21_PurchaseOrderOptions> r21 = null;
List <Models.Files.PurchaseOrder.R24_CustomerCost> r24 = null;
List <Models.Files.PurchaseOrder.R25_CustomerBillToName> r25 = null;
List <Models.Files.PurchaseOrder.R26_CustomerBillToPhoneNumber> r26 = null;
List <Models.Files.PurchaseOrder.R27_CustomerBillToAddressLine> r27 = null;
List <Models.Files.PurchaseOrder.R29_CustomerBillToCityStateZip> r29 = null;
List <Models.Files.PurchaseOrder.R30_RecipientShipToName> r30 = null;
List <Models.Files.PurchaseOrder.R31_RecipientShipToPhone> r31 = null;
List <Models.Files.PurchaseOrder.R32_ShippingRecordRecipientAddressLine> r32 = null;
List <Models.Files.PurchaseOrder.R34_RecipientShippingRecordCityStateZip> r34 = null;
List <Models.Files.PurchaseOrder.R35_DropShipDetail> r35 = null;
List <Models.Files.PurchaseOrder.R36_SpecialDeliveryInstructions> r36 = null;
List <Models.Files.PurchaseOrder.R37_MarketingMessage> r37 = null;
List <Models.Files.PurchaseOrder.R38_GiftMessage> r38 = null;
List <Models.Files.PurchaseOrder.R40_LineItem> r40 = null;
List <Models.Files.PurchaseOrder.R41_AdditionalLineItem> r41 = null;
List <Models.Files.PurchaseOrder.R42_LineItemGiftMessage> r42 = null;
List <Models.Files.PurchaseOrder.R45_Imprint> r45 = null;
List <Models.Files.PurchaseOrder.R50_PurchaseOrderControl> r50 = null;
List <Models.Files.PurchaseOrder.R90_FileTrailer> r90 = null;
//
Models.Files.PurchaseOrder.DataSequence.V3 file = null;
Models.Files.PurchaseOrder.DataSequence.PurchaseOrder order = null;
Models.Files.PurchaseOrder.DataSequence.Item item = null;
//
string typename = string.Empty;
int orderCount = 0;
int itemCount = 0;
bool savedokay = false;
try
{
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseOrder.R00_FileHeader),
typeof(Models.Files.PurchaseOrder.R10_ClientHeader),
typeof(Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions),
typeof(Models.Files.PurchaseOrder.R21_PurchaseOrderOptions),
typeof(Models.Files.PurchaseOrder.R24_CustomerCost),
typeof(Models.Files.PurchaseOrder.R25_CustomerBillToName),
typeof(Models.Files.PurchaseOrder.R26_CustomerBillToPhoneNumber),
typeof(Models.Files.PurchaseOrder.R27_CustomerBillToAddressLine),
typeof(Models.Files.PurchaseOrder.R29_CustomerBillToCityStateZip),
typeof(Models.Files.PurchaseOrder.R30_RecipientShipToName),
typeof(Models.Files.PurchaseOrder.R31_RecipientShipToPhone),
typeof(Models.Files.PurchaseOrder.R32_ShippingRecordRecipientAddressLine),
typeof(Models.Files.PurchaseOrder.R34_RecipientShippingRecordCityStateZip),
typeof(Models.Files.PurchaseOrder.R35_DropShipDetail),
typeof(Models.Files.PurchaseOrder.R36_SpecialDeliveryInstructions),
typeof(Models.Files.PurchaseOrder.R37_MarketingMessage),
typeof(Models.Files.PurchaseOrder.R38_GiftMessage),
typeof(Models.Files.PurchaseOrder.R40_LineItem),
typeof(Models.Files.PurchaseOrder.R41_AdditionalLineItem),
typeof(Models.Files.PurchaseOrder.R42_LineItemGiftMessage),
typeof(Models.Files.PurchaseOrder.R45_Imprint),
typeof(Models.Files.PurchaseOrder.R50_PurchaseOrderControl),
typeof(Models.Files.PurchaseOrder.R90_FileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.PurchaseOrder.Selectors.V3.Custom)
};
var res = engine.ReadFile(filename);
if (res != null && res.Length > 0)
{
file = new Models.Files.PurchaseOrder.DataSequence.V3();
foreach (var rec in res)
{
typename = rec.GetType().Name.ToUpper();
switch (typename)
{
case "R00_FILEHEADER":
Common.Initialize(ref r00);
r00.Add((Models.Files.PurchaseOrder.R00_FileHeader)rec);
file.FileHeaderRecord = r00.LastItem();
break;
case "R10_CLIENTHEADER":
Common.Initialize(ref r10);
r10.Add((Models.Files.PurchaseOrder.R10_ClientHeader)rec);
if (orderCount > 0)
{
if (file.PurchaseOrders == null)
{
file.PurchaseOrders = new List <Models.Files.PurchaseOrder.DataSequence.PurchaseOrder>();
}
if (order != null)
{
file.PurchaseOrders.Add(order);
order = null;
}
}
orderCount++;
order = new Models.Files.PurchaseOrder.DataSequence.PurchaseOrder
{
ClientHeaderRecord = r10.LastItem()
};
break;
case "R20_FIXEDSPECIALHANDLINGINSTRUCTIONS":
Common.Initialize(ref r20);
r20.Add((Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions)rec);
order.FixedHandlingInstructionsRecord = r20.LastItem();
break;
case "R21_PURCHASEORDEROPTIONS":
Common.Initialize(ref r21);
r21.Add((Models.Files.PurchaseOrder.R21_PurchaseOrderOptions)rec);
order.PurchaseOrderOptionsRecord = r21.LastItem();
break;
case "R24_CUSTOMERCOST":
Common.Initialize(ref r24);
r24.Add((Models.Files.PurchaseOrder.R24_CustomerCost)rec);
order.CustomerCostRecord = r24.LastItem();
break;
case "R25_CUSTOMERBILLTONAME":
Common.Initialize(ref r25);
r25.Add((Models.Files.PurchaseOrder.R25_CustomerBillToName)rec);
order.CustomerBillToNameRecord = r25.LastItem();
break;
case "R26_CUSTOMERBILLTOPHONENUMBER":
Common.Initialize(ref r26);
r26.Add((Models.Files.PurchaseOrder.R26_CustomerBillToPhoneNumber)rec);
order.CustomerBillToPhoneNumberRecord = r26.LastItem();
break;
case "R27_CUSTOMERBILLTOADDRESSLINE":
Common.Initialize(ref r27);
r27.Add((Models.Files.PurchaseOrder.R27_CustomerBillToAddressLine)rec);
if (order.CustomerBillToAddressLine == null)
{
order.CustomerBillToAddressLine = new List <Models.Files.PurchaseOrder.R27_CustomerBillToAddressLine>();
}
if (order.CustomerBillToAddressLine.Count < file.Maxes[typename])
{
order.CustomerBillToAddressLine.Add(r27.LastItem());
}
break;
case "R29_CUSTOMERBILLTOCITYSTATEZIP":
Common.Initialize(ref r29);
r29.Add((Models.Files.PurchaseOrder.R29_CustomerBillToCityStateZip)rec);
order.CustomerBillToCityStateZipRecord = r29.LastItem();
break;
case "R30_RECIPIENTSHIPTONAME":
Common.Initialize(ref r30);
r30.Add((Models.Files.PurchaseOrder.R30_RecipientShipToName)rec);
order.RecipientShipToNameRecord = r30.LastItem();
break;
case "R31_RECIPIENTSHIPTOPHONE":
Common.Initialize(ref r31);
r31.Add((Models.Files.PurchaseOrder.R31_RecipientShipToPhone)rec);
order.RecipientShipToPhoneRecord = r31.LastItem();
break;
case "R32_SHIPPINGRECORDRECIPIENTADDRESSLINE":
Common.Initialize(ref r32);
r32.Add((Models.Files.PurchaseOrder.R32_ShippingRecordRecipientAddressLine)rec);
if (order.ShipRecordRecipientAddressLine == null)
{
order.ShipRecordRecipientAddressLine = new List <Models.Files.PurchaseOrder.R32_ShippingRecordRecipientAddressLine>();
}
if (order.ShipRecordRecipientAddressLine.Count < file.Maxes[typename])
{
order.ShipRecordRecipientAddressLine.Add(r32.LastItem());
}
break;
case "R34_RECIPIENTSHIPPINGRECORDCITYSTATEZIP":
Common.Initialize(ref r34);
r34.Add((Models.Files.PurchaseOrder.R34_RecipientShippingRecordCityStateZip)rec);
order.RecipShippingRecordCityStateZipRecord = r34.LastItem();
break;
case "R35_DROPSHIPDETAIL":
Common.Initialize(ref r35);
r35.Add((Models.Files.PurchaseOrder.R35_DropShipDetail)rec);
order.DropShipDetailRecord = r35.LastItem();
break;
case "R36_SPECIALDELIVERYINSTRUCTIONS":
Common.Initialize(ref r36);
r36.Add((Models.Files.PurchaseOrder.R36_SpecialDeliveryInstructions)rec);
if (order.SpecialDeliveryInstructions == null)
{
order.SpecialDeliveryInstructions = new List <Models.Files.PurchaseOrder.R36_SpecialDeliveryInstructions>();
}
if (order.SpecialDeliveryInstructions.Count < file.Maxes[typename])
{
order.SpecialDeliveryInstructions.Add(r36.LastItem());
}
break;
case "R37_MARKETINGMESSAGE":
Common.Initialize(ref r37);
r37.Add((Models.Files.PurchaseOrder.R37_MarketingMessage)rec);
if (order.MarketingMessage == null)
{
order.MarketingMessage = new List <Models.Files.PurchaseOrder.R37_MarketingMessage>();
}
if (order.MarketingMessage.Count < file.Maxes[typename])
{
order.MarketingMessage.Add(r37.LastItem());
}
break;
case "R38_GIFTMESSAGE":
Common.Initialize(ref r38);
r38.Add((Models.Files.PurchaseOrder.R38_GiftMessage)rec);
if (order.GiftMessage == null)
{
order.GiftMessage = new List <Models.Files.PurchaseOrder.R38_GiftMessage>();
}
if (order.GiftMessage.Count < file.Maxes[typename])
{
order.GiftMessage.Add(r38.LastItem());
}
break;
case "R40_LINEITEM":
Common.Initialize(ref r40);
r40.Add((Models.Files.PurchaseOrder.R40_LineItem)rec);
if (itemCount > 0)
{
if (order.Items == null)
{
order.Items = new List <Models.Files.PurchaseOrder.DataSequence.Item>();
}
if (item != null)
{
order.Items.Add(item);
item = null;
}
}
itemCount++;
item = new Models.Files.PurchaseOrder.DataSequence.Item
{
LineItemRecord = r40.LastItem()
};
break;
case "R41_ADDITIONALLINEITEM":
Common.Initialize(ref r41);
r41.Add((Models.Files.PurchaseOrder.R41_AdditionalLineItem)rec);
item.AdditionalLineItemRecord = r41.LastItem();
break;
case "R42_LINEITEMGIFTMESSAGE":
Common.Initialize(ref r42);
r42.Add((Models.Files.PurchaseOrder.R42_LineItemGiftMessage)rec);
if (item.LineItemGiftMessage.Count < file.Maxes[typename])
{
item.LineItemGiftMessage.Add(r42.LastItem());
}
break;
case "R45_IMPRINT":
Common.Initialize(ref r45);
r45.Add((Models.Files.PurchaseOrder.R45_Imprint)rec);
if (item.Imprint == null)
{
item.Imprint = new List <Models.Files.PurchaseOrder.R45_Imprint>();
}
if (item.Imprint.Count < file.Maxes[typename])
{
item.Imprint.Add(r45.LastItem());
}
break;
case "R50_PURCHASEORDERCONTROL":
Common.Initialize(ref r50);
r50.Add((Models.Files.PurchaseOrder.R50_PurchaseOrderControl)rec);
order.PurchaseOrderControlRecord = r50.LastItem();
file.PurchaseOrders.Add(order);
if (item != null)
{
if (file.PurchaseOrders[file.PurchaseOrders.Count - 1].Items == null)
{
file.PurchaseOrders[file.PurchaseOrders.Count - 1].Items = new List <Models.Files.PurchaseOrder.DataSequence.Item>();
}
file.PurchaseOrders[file.PurchaseOrders.Count - 1].Items.Add(item);
item = null;
}
order = null;
break;
case "R90_FILETRAILER":
Common.Initialize(ref r90);
r90.Add((Models.Files.PurchaseOrder.R90_FileTrailer)rec);
file.FileTrailerRecord = r90.LastItem();
break;
}
}
if (order != null)
{
file.PurchaseOrders.Add(order);
if (item != null)
{
if (file.PurchaseOrders[file.PurchaseOrders.Count - 1].Items == null)
{
file.PurchaseOrders[file.PurchaseOrders.Count - 1].Items = new List <Models.Files.PurchaseOrder.DataSequence.Item>();
}
file.PurchaseOrders[file.PurchaseOrders.Count - 1].Items.Add(item);
item = null;
}
order = null;
}
using (SQL sql = new SQL(batchnumber, r00, r10, r20, r21, r24, r25, r26, r27, r29, r30, r31, r32, r34, r35, r36, r37, r38, r40, r41, r42, r45, r50, r90)) { savedokay = sql.Successful; }
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(file);
}
public bool WriteFile(string filename, Models.Files.PurchaseOrder.DataSequence.V3 data, bool checkseq)
{
List <object> writelist = new List <object>();
bool success = false;
try
{
//build list
writelist.Add(data.FileHeaderRecord);
if (data.PurchaseOrders != null && data.PurchaseOrders.Count > 0)
{
foreach (Models.Files.PurchaseOrder.DataSequence.PurchaseOrder item in data.PurchaseOrders)
{
writelist.Add(item.ClientHeaderRecord);
if (Common.IsValid(item.FixedHandlingInstructionsRecord, checkseq))
{
writelist.Add(item.FixedHandlingInstructionsRecord);
}
if (Common.IsValid(item.PurchaseOrderOptionsRecord, checkseq))
{
writelist.Add(item.PurchaseOrderOptionsRecord);
}
if (item.PurchaseOrderDetails != null && item.PurchaseOrderDetails.Count > 0)
{
foreach (Models.Files.PurchaseOrder.DataSequence.PurchaseOrderDetail detail in item.PurchaseOrderDetails)
{
if (Common.IsValid(detail.LineItemDetail, checkseq))
{
writelist.Add(detail.LineItemDetail);
}
if (Common.IsValid(detail.AdditionalLineItemDetail, checkseq))
{
writelist.Add(detail.AdditionalLineItemDetail);
}
if (detail.Imprint != null && detail.Imprint.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R45_Imprint imprint in detail.Imprint)
{
if (Common.IsValid(imprint, checkseq))
{
writelist.Add(imprint);
}
}
}
if (Common.IsValid(detail.StickerBarcodeDataRecord, checkseq))
{
writelist.Add(detail.StickerBarcodeDataRecord);
}
if (detail.StickerTextLines != null && detail.StickerTextLines.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R46_StickerTextLines text in detail.StickerTextLines)
{
if (Common.IsValid(text, checkseq))
{
writelist.Add(text);
}
}
}
}
}
}
}
if (Common.IsValid(data.PurchaseOrderTrailerRecord, checkseq))
{
writelist.Add(data.PurchaseOrderTrailerRecord);
}
if (Common.IsValid(data.FileTrailerRecord, checkseq))
{
writelist.Add(data.FileTrailerRecord);
}
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseOrder.R00_ClientFileHeader),
typeof(Models.Files.PurchaseOrder.R10_ClientHeader),
typeof(Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions),
typeof(Models.Files.PurchaseOrder.R21_PurchaseOrderOptions),
typeof(Models.Files.PurchaseOrder.R40_LineItemDetail),
typeof(Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail),
typeof(Models.Files.PurchaseOrder.R45_Imprint),
typeof(Models.Files.PurchaseOrder.R46_StickerBarcodeData),
typeof(Models.Files.PurchaseOrder.R46_StickerTextLines),
typeof(Models.Files.PurchaseOrder.R50_PurchaseOrderTrailer),
typeof(Models.Files.PurchaseOrder.R90_FileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.Invoice.Selectors.V3.Custom)
};
engine.WriteFile(filename, writelist.ToArray());
success = true;
}
catch (Exception ex)
{
log.Error(ex);
success = false;
}
return(success);
}
public bool WriteFile(string filename, Models.Files.PurchaseOrder.DataSequence.V3 data)
{
List <object> writelist = new List <object>();
bool success = false;
try
{
//build list
writelist.Add(data.FileHeaderRecord);
if (data.PurchaseOrders != null && data.PurchaseOrders.Count > 0)
{
foreach (Models.Files.PurchaseOrder.DataSequence.PurchaseOrder item in data.PurchaseOrders)
{
writelist.Add(item.ClientHeaderRecord);
if (Common.IsValid(item.FixedHandlingInstructionsRecord))
{
writelist.Add(item.FixedHandlingInstructionsRecord);
}
if (Common.IsValid(item.PurchaseOrderOptionsRecord))
{
writelist.Add(item.PurchaseOrderOptionsRecord);
}
if (Common.IsValid(item.CustomerCostRecord))
{
writelist.Add(item.CustomerCostRecord);
}
if (Common.IsValid(item.CustomerBillToNameRecord))
{
writelist.Add(item.CustomerBillToNameRecord);
}
if (Common.IsValid(item.CustomerBillToPhoneNumberRecord))
{
writelist.Add(item.CustomerBillToPhoneNumberRecord);
}
if (item.CustomerBillToAddressLine != null && item.CustomerBillToAddressLine.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R27_CustomerBillToAddressLine detail in item.CustomerBillToAddressLine)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
if (Common.IsValid(item.CustomerBillToCityStateZipRecord))
{
writelist.Add(item.CustomerBillToCityStateZipRecord);
}
if (Common.IsValid(item.RecipientShipToNameRecord))
{
writelist.Add(item.RecipientShipToNameRecord);
}
if (Common.IsValid(item.RecipientShipToPhoneRecord))
{
writelist.Add(item.RecipientShipToPhoneRecord);
}
if (item.ShipRecordRecipientAddressLine != null && item.ShipRecordRecipientAddressLine.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R32_ShippingRecordRecipientAddressLine detail in item.ShipRecordRecipientAddressLine)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
if (Common.IsValid(item.RecipShippingRecordCityStateZipRecord))
{
writelist.Add(item.RecipShippingRecordCityStateZipRecord);
}
if (Common.IsValid(item.DropShipDetailRecord))
{
writelist.Add(item.DropShipDetailRecord);
}
if (item.SpecialDeliveryInstructions != null && item.SpecialDeliveryInstructions.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R36_SpecialDeliveryInstructions detail in item.SpecialDeliveryInstructions)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
if (item.MarketingMessage != null && item.MarketingMessage.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R37_MarketingMessage detail in item.MarketingMessage)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
if (item.GiftMessage != null && item.GiftMessage.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R38_GiftMessage detail in item.GiftMessage)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
if (item.Items != null && item.Items.Count > 0)
{
foreach (Models.Files.PurchaseOrder.DataSequence.Item lineitem in item.Items)
{
if (Common.IsValid(lineitem.LineItemRecord))
{
writelist.Add(lineitem.LineItemRecord);
}
if (Common.IsValid(lineitem.AdditionalLineItemRecord))
{
writelist.Add(lineitem.AdditionalLineItemRecord);
}
if (lineitem.LineItemGiftMessage != null && lineitem.LineItemGiftMessage.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R42_LineItemGiftMessage detail in lineitem.LineItemGiftMessage)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
if (lineitem.Imprint != null && lineitem.Imprint.Count > 0)
{
foreach (Models.Files.PurchaseOrder.R45_Imprint detail in lineitem.Imprint)
{
if (Common.IsValid(detail))
{
writelist.Add(detail);
}
}
}
}
}
if (Common.IsValid(item.PurchaseOrderControlRecord))
{
writelist.Add(item.PurchaseOrderControlRecord);
}
}
}
if (Common.IsValid(data.FileTrailerRecord))
{
writelist.Add(data.FileTrailerRecord);
}
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseOrder.R00_FileHeader),
typeof(Models.Files.PurchaseOrder.R10_ClientHeader),
typeof(Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions),
typeof(Models.Files.PurchaseOrder.R21_PurchaseOrderOptions),
typeof(Models.Files.PurchaseOrder.R24_CustomerCost),
typeof(Models.Files.PurchaseOrder.R25_CustomerBillToName),
typeof(Models.Files.PurchaseOrder.R26_CustomerBillToPhoneNumber),
typeof(Models.Files.PurchaseOrder.R27_CustomerBillToAddressLine),
typeof(Models.Files.PurchaseOrder.R29_CustomerBillToCityStateZip),
typeof(Models.Files.PurchaseOrder.R30_RecipientShipToName),
typeof(Models.Files.PurchaseOrder.R31_RecipientShipToPhone),
typeof(Models.Files.PurchaseOrder.R32_ShippingRecordRecipientAddressLine),
typeof(Models.Files.PurchaseOrder.R34_RecipientShippingRecordCityStateZip),
typeof(Models.Files.PurchaseOrder.R35_DropShipDetail),
typeof(Models.Files.PurchaseOrder.R36_SpecialDeliveryInstructions),
typeof(Models.Files.PurchaseOrder.R37_MarketingMessage),
typeof(Models.Files.PurchaseOrder.R38_GiftMessage),
typeof(Models.Files.PurchaseOrder.R40_LineItem),
typeof(Models.Files.PurchaseOrder.R41_AdditionalLineItem),
typeof(Models.Files.PurchaseOrder.R42_LineItemGiftMessage),
typeof(Models.Files.PurchaseOrder.R45_Imprint),
typeof(Models.Files.PurchaseOrder.R50_PurchaseOrderControl),
typeof(Models.Files.PurchaseOrder.R90_FileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.Invoice.Selectors.V3.Custom)
};
engine.WriteFile(filename, writelist.ToArray());
success = true;
}
catch (Exception ex)
{
log.Error(ex);
success = false;
}
return(success);
}
