public Models.Files.PurchaseAcknowledgement.DataSequence.V3 ReadFile(string filename, int batchnumber)
{
List <Models.Files.PurchaseAcknowledgement.R02_FileHeader> r02 = null;
List <Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader> r11 = null;
List <Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor> r21 = null;
List <Models.Files.PurchaseAcknowledgement.R30_RecipientShipToNameAndAddress> r30 = null;
List <Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation> r32 = null;
List <Models.Files.PurchaseAcknowledgement.R34_RecipientShipToCityStateAndZip> r34 = null;
List <Models.Files.PurchaseAcknowledgement.R40_LineItem> r40 = null;
List <Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail> r41 = null;
List <Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem> r42 = null;
List <Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem> r43 = null;
List <Models.Files.PurchaseAcknowledgement.R44_ItemNumberOrPrice> r44 = null;
List <Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals> r59 = null;
List <Models.Files.PurchaseAcknowledgement.R91_FileTrailer> r91 = null;
//
Models.Files.PurchaseAcknowledgement.DataSequence.V3 file = null;
Models.Files.PurchaseAcknowledgement.DataSequence.LineItem item = null;
//
string typename = string.Empty;
int itemCount = 0;
bool savedokay = false;
try
{
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseAcknowledgement.R02_FileHeader),
typeof(Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader),
typeof(Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor),
typeof(Models.Files.PurchaseAcknowledgement.R30_RecipientShipToNameAndAddress),
typeof(Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation),
typeof(Models.Files.PurchaseAcknowledgement.R34_RecipientShipToCityStateAndZip),
typeof(Models.Files.PurchaseAcknowledgement.R40_LineItem),
typeof(Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail),
typeof(Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R44_ItemNumberOrPrice),
typeof(Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals),
typeof(Models.Files.PurchaseAcknowledgement.R91_FileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.PurchaseAcknowledgement.Selectors.V3.Custom)
};
var res = engine.ReadFile(filename);
if (res != null && res.Length > 0)
{
file = new Models.Files.PurchaseAcknowledgement.DataSequence.V3();
foreach (var rec in res)
{
typename = rec.GetType().Name.ToUpper();
switch (typename)
{
case "R02_FILEHEADER":
Common.Initialize(ref r02);
r02.Add((Models.Files.PurchaseAcknowledgement.R02_FileHeader)rec);
file.FileHeaderRecord = r02.LastItem();
break;
case "R11_PURCHASEORDERHEADER":
Common.Initialize(ref r11);
r11.Add((Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader)rec);
file.PurchaseOrderHeaderRecord = r11.LastItem();
break;
case "R21_FREEFORMVENDOR":
Common.Initialize(ref r21);
r21.Add((Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor)rec);
if (file.FreeFormVendor == null)
{
file.FreeFormVendor = new List <Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor>();
}
if (file.FreeFormVendor.Count < file.Maxes[typename])
{
file.FreeFormVendor.Add(r21.LastItem());
}
break;
case "R30_RECIPIENTSHIPTONAMEANDADDRESS":
Common.Initialize(ref r30);
r30.Add((Models.Files.PurchaseAcknowledgement.R30_RecipientShipToNameAndAddress)rec);
file.RecipShipToNameAndAddressRecord = r30.LastItem();
break;
case "R32_RECIPIENTSHIPTOADDITIONALSHIPPINGINFORMATION":
Common.Initialize(ref r32);
r32.Add((Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation)rec);
if (file.RecipShipToAdditionalShippingInfo == null)
{
file.RecipShipToAdditionalShippingInfo = new List <Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation>();
}
if (file.RecipShipToAdditionalShippingInfo.Count < file.Maxes[typename])
{
file.RecipShipToAdditionalShippingInfo.Add(r32.LastItem());
}
break;
case "R34_RECIPIENTSHIPTOCITYSTATEANDZIP":
Common.Initialize(ref r34);
r34.Add((Models.Files.PurchaseAcknowledgement.R34_RecipientShipToCityStateAndZip)rec);
file.RecipShipToCityStateAndZipRecord = r34.LastItem();
break;
case "R40_LINEITEM":
Common.Initialize(ref r40);
r40.Add((Models.Files.PurchaseAcknowledgement.R40_LineItem)rec);
if (itemCount > 0)
{
if (item != null)
{
file.LineItems.Add(item);
item = null;
}
}
if (file.LineItems == null)
{
file.LineItems = new List <Models.Files.PurchaseAcknowledgement.DataSequence.LineItem>();
}
item = new Models.Files.PurchaseAcknowledgement.DataSequence.LineItem();
itemCount++;
item.LineItemRecord = r40.LastItem();
break;
case "R41_ADDITIONALDETAIL":
Common.Initialize(ref r41);
r41.Add((Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail)rec);
item.AdditionalDetailRecord = r41.LastItem();
break;
case "R42_ADDITIONALLINEITEM":
Common.Initialize(ref r42);
r42.Add((Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem)rec);
item.AddtionalLineItemTitleRecord = r42.LastItem();
break;
case "R43_ADDITIONALLINEITEM":
Common.Initialize(ref r43);
r43.Add((Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem)rec);
item.AdditionalLineItemPublisherRecord = r43.LastItem();
break;
case "R44_ITEMNUMBERORPRICE":
Common.Initialize(ref r44);
r44.Add((Models.Files.PurchaseAcknowledgement.R44_ItemNumberOrPrice)rec);
item.ItemNumberOrPriceRecord = r44.LastItem();
break;
case "R59_PURCHASEORDERCONTROLTOTALS":
Common.Initialize(ref r59);
r59.Add((Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals)rec);
file.PurchaseOrderControlTotalsRecord = r59.LastItem();
break;
case "R91_FILETRAILER":
Common.Initialize(ref r91);
r91.Add((Models.Files.PurchaseAcknowledgement.R91_FileTrailer)rec);
file.FileTrailerRecord = r91.LastItem();
break;
}
}
if (item != null)
{
file.LineItems.Add(item);
item = null;
itemCount = 0;
}
using (SQL sql = new SQL(batchnumber, r02, r11, r21, r30, r32, r34, r40, r41, r42, r43, r44, r59, r91)) { savedokay = sql.Successful; }
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(file);
}
public bool WriteFile(string filename, Models.Files.PurchaseAcknowledgement.DataSequence.V3 data)
{
List <object> writelist = new List <object>();
bool success = false;
try
{
//build list
writelist.Add(data.FileHeaderRecord);
if (Common.IsValid(data.PurchaseOrderHeaderRecord))
{
writelist.Add(data.PurchaseOrderHeaderRecord);
}
if (data.FreeFormVendor != null && data.FreeFormVendor.Count > 0)
{
foreach (Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor item in data.FreeFormVendor)
{
if (Common.IsValid(item))
{
writelist.Add(item);
}
}
}
if (Common.IsValid(data.RecipShipToNameAndAddressRecord))
{
writelist.Add(data.RecipShipToNameAndAddressRecord);
}
if (data.RecipShipToAdditionalShippingInfo != null && data.RecipShipToAdditionalShippingInfo.Count > 0)
{
foreach (Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation item in data.RecipShipToAdditionalShippingInfo)
{
if (Common.IsValid(item))
{
writelist.Add(item);
}
}
}
if (Common.IsValid(data.RecipShipToCityStateAndZipRecord))
{
writelist.Add(data.RecipShipToCityStateAndZipRecord);
}
if (data.LineItems != null && data.LineItems.Count > 0)
{
foreach (Models.Files.PurchaseAcknowledgement.DataSequence.LineItem item in data.LineItems)
{
if (Common.IsValid(item.LineItemRecord))
{
writelist.Add(item.LineItemRecord);
}
if (Common.IsValid(item.AdditionalDetailRecord))
{
writelist.Add(item.AdditionalDetailRecord);
}
if (Common.IsValid(item.AddtionalLineItemTitleRecord))
{
writelist.Add(item.AddtionalLineItemTitleRecord);
}
if (Common.IsValid(item.AdditionalLineItemPublisherRecord))
{
writelist.Add(item.AdditionalLineItemPublisherRecord);
}
if (Common.IsValid(item.ItemNumberOrPriceRecord))
{
writelist.Add(item.ItemNumberOrPriceRecord);
}
}
}
if (Common.IsValid(data.PurchaseOrderControlTotalsRecord))
{
writelist.Add(data.PurchaseOrderControlTotalsRecord);
}
if (Common.IsValid(data.FileTrailerRecord))
{
writelist.Add(data.FileTrailerRecord);
}
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseAcknowledgement.R02_FileHeader),
typeof(Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader),
typeof(Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor),
typeof(Models.Files.PurchaseAcknowledgement.R30_RecipientShipToNameAndAddress),
typeof(Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation),
typeof(Models.Files.PurchaseAcknowledgement.R34_RecipientShipToCityStateAndZip),
typeof(Models.Files.PurchaseAcknowledgement.R40_LineItem),
typeof(Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail),
typeof(Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R44_ItemNumberOrPrice),
typeof(Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals),
typeof(Models.Files.PurchaseAcknowledgement.R91_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 Models.Files.PurchaseAcknowledgement.DataSequence.V3 ReadFile(string filename, int batchnumber)
{
List <Models.Files.PurchaseAcknowledgement.R02_FileHeader> r02 = null;
List <Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader> r11 = null;
List <Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor> r21 = null;
List <Models.Files.PurchaseAcknowledgement.R40_LineItem> r40 = null;
List <Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail> r41 = null;
List <Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem> r42 = null;
List <Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem> r43 = null;
List <Models.Files.PurchaseAcknowledgement.R44_Item_NumberOrPrice> r44 = null;
List <Models.Files.PurchaseAcknowledgement.R45_AdditionalLineItem> r45 = null;
List <Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals> r59 = null;
List <Models.Files.PurchaseAcknowledgement.R91_FileTrailer> r91 = null;
//
Models.Files.PurchaseAcknowledgement.DataSequence.V3 file = null;
Models.Files.PurchaseAcknowledgement.DataSequence.AcknowledgementItem acknowledgement = null;
//
string typename = string.Empty;
int acknowledgementCount = 0;
bool savedokay = false;
try
{
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.PurchaseAcknowledgement.R02_FileHeader),
typeof(Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader),
typeof(Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor),
typeof(Models.Files.PurchaseAcknowledgement.R40_LineItem),
typeof(Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail),
typeof(Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R44_Item_NumberOrPrice),
typeof(Models.Files.PurchaseAcknowledgement.R45_AdditionalLineItem),
typeof(Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals),
typeof(Models.Files.PurchaseAcknowledgement.R91_FileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.PurchaseAcknowledgement.Selectors.V3.Custom)
};
var res = engine.ReadFile(filename);
if (res != null && res.Length > 0)
{
file = new Models.Files.PurchaseAcknowledgement.DataSequence.V3();
foreach (var rec in res)
{
typename = rec.GetType().Name.ToUpper();
switch (typename)
{
case "R02_FILEHEADER":
Common.Initialize(ref r02);
r02.Add((Models.Files.PurchaseAcknowledgement.R02_FileHeader)rec);
file.FileHeaderRecord = r02.LastItem();
break;
case "R11_PURCHASEORDERHEADER":
Common.Initialize(ref r11);
r11.Add((Models.Files.PurchaseAcknowledgement.R11_PurchaseOrderHeader)rec);
file.PurchaseOrderHeaderRecord = r11.LastItem();
break;
case "R21_FREEFORMVENDOR":
Common.Initialize(ref r21);
r21.Add((Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor)rec);
if (file.FreeFormVendor == null)
{
file.FreeFormVendor = new List <Models.Files.PurchaseAcknowledgement.R21_FreeFormVendor>();
}
if (file.FreeFormVendor.Count <= file.Maxes[typename])
{
file.FreeFormVendor.Add(r21.LastItem());
}
break;
case "R40_LINEITEM":
Common.Initialize(ref r40);
r40.Add((Models.Files.PurchaseAcknowledgement.R40_LineItem)rec);
if (acknowledgementCount == 0)
{
file.AcknowledgementItems = new List <Models.Files.PurchaseAcknowledgement.DataSequence.AcknowledgementItem>();
}
else
{
file.AcknowledgementItems.Add(acknowledgement);
acknowledgement = new Models.Files.PurchaseAcknowledgement.DataSequence.AcknowledgementItem();
}
acknowledgementCount++;
acknowledgement = new Models.Files.PurchaseAcknowledgement.DataSequence.AcknowledgementItem
{
LineItemRecord = r40.LastItem()
};
break;
case "R41_ADDITIONALDETAIL":
Common.Initialize(ref r41);
r41.Add((Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail)rec);
acknowledgement.AdditionalDetailRecord = r41.LastItem();
break;
case "R42_ADDITIONALLINEITEM":
Common.Initialize(ref r42);
r42.Add((Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem)rec);
acknowledgement.AddtionalLineItemTitle = r42.LastItem();
break;
case "R43_ADDITIONALLINEITEM":
Common.Initialize(ref r43);
r43.Add((Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem)rec);
acknowledgement.AdditionalLineItemPublisher = r43.LastItem();
break;
case "R44_ITEM_NUMBERORPRICE":
Common.Initialize(ref r44);
r44.Add((Models.Files.PurchaseAcknowledgement.R44_Item_NumberOrPrice)rec);
acknowledgement.ItemNumberOrPriceRecord = r44.LastItem();
break;
case "R45_ADDITIONALLINEITEM":
Common.Initialize(ref r45);
r45.Add((Models.Files.PurchaseAcknowledgement.R45_AdditionalLineItem)rec);
acknowledgement.AdditionalLineItemClient = r45.LastItem();
break;
case "R59_PURCHASEORDERCONTROLTOTALS":
Common.Initialize(ref r59);
r59.Add((Models.Files.PurchaseAcknowledgement.R59_PurchaseOrderControlTotals)rec);
if (acknowledgement != null)
{
file.AcknowledgementItems.Add(acknowledgement);
acknowledgement = null;
}
file.PurchaseOrderControlTotalsRecord = r59.LastItem();
break;
case "R91_FILETRAILER":
Common.Initialize(ref r91);
r91.Add((Models.Files.PurchaseAcknowledgement.R91_FileTrailer)rec);
file.FileTrailerRecord = r91.LastItem();
break;
}
}
using (SQL sql = new SQL(batchnumber, r02, r11, r21, r40, r41, r42, r43, r44, r45, r59, r91)) { savedokay = sql.Successful; }
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(file);
}