public Models.Files.Invoice.DataSequence.V3 ReadFile(string filename, int batchnumber)
{
List <Models.Files.Invoice.R01_InvoiceFileHeader> r01 = null;
List <Models.Files.Invoice.R15_InvoiceHeader> r15 = null;
List <Models.Files.Invoice.R45_InvoiceDetail> r45 = null;
List <Models.Files.Invoice.R46_InvoiceDetail> r46 = null;
List <Models.Files.Invoice.R48_DetailTotal> r48 = null;
List <Models.Files.Invoice.R49_DetailTotalOrFreightAndFees> r49 = null;
List <Models.Files.Invoice.R55_InvoiceTotals> r55 = null;
List <Models.Files.Invoice.R57_InvoiceTrailer> r57 = null;
List <Models.Files.Invoice.R95_InvoiceFileTrailer> r95 = null;
//
Models.Files.Invoice.DataSequence.V3 file = null;
Models.Files.Invoice.DataSequence.InvoiceItem invoice = null;
Models.Files.Invoice.DataSequence.InvoiceDetail detail = null;
//
string typename;
int invoiceCount = 0;
int detailCount = 0;
bool savedokay = false;
try
{
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.Invoice.R01_InvoiceFileHeader),
typeof(Models.Files.Invoice.R15_InvoiceHeader),
typeof(Models.Files.Invoice.R45_InvoiceDetail),
typeof(Models.Files.Invoice.R46_InvoiceDetail),
typeof(Models.Files.Invoice.R48_DetailTotal),
typeof(Models.Files.Invoice.R49_DetailTotalOrFreightAndFees),
typeof(Models.Files.Invoice.R55_InvoiceTotals),
typeof(Models.Files.Invoice.R57_InvoiceTrailer),
typeof(Models.Files.Invoice.R95_InvoiceFileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.Invoice.Selectors.V3.Custom)
};
var res = engine.ReadFile(filename);
if (res != null && res.Length > 0)
{
file = new Models.Files.Invoice.DataSequence.V3();
foreach (var rec in res)
{
typename = rec.GetType().Name.ToUpper();
switch (typename)
{
case "R01_INVOICEFILEHEADER":
Common.Initialize(ref r01);
r01.Add((Models.Files.Invoice.R01_InvoiceFileHeader)rec);
file.InvoiceFileHeaderRecord = r01.LastItem();
break;
case "R15_INVOICEHEADER":
Common.Initialize(ref r15);
r15.Add((Models.Files.Invoice.R15_InvoiceHeader)rec);
if (invoiceCount > 0)
{
if (invoice != null)
{
file.Invoices.Add(invoice);
invoice = null;
}
}
invoiceCount++;
if (invoice == null)
{
invoice = new Models.Files.Invoice.DataSequence.InvoiceItem();
}
invoice.InvoiceHeaderRecord = r15.LastItem();
break;
case "R45_INVOICEDETAIL":
Common.Initialize(ref r45);
r45.Add((Models.Files.Invoice.R45_InvoiceDetail)rec);
if (detailCount > 0)
{
if (detail != null)
{
invoice.InvoiceDetails.Add(detail);
detail = null;
}
}
detailCount++;
if (detail == null)
{
detail = new Models.Files.Invoice.DataSequence.InvoiceDetail();
}
detail.InvoiceDetailRecord = r45.LastItem();
break;
case "R46_INVOICEDETAIL":
Common.Initialize(ref r46);
r46.Add((Models.Files.Invoice.R46_InvoiceDetail)rec);
detail.InvoiceDetail2Record = r46.LastItem();
break;
case "R48_DETAILTOTAL":
Common.Initialize(ref r48);
r48.Add((Models.Files.Invoice.R48_DetailTotal)rec);
detail.DetailTotalRecord = r48.LastItem();
break;
case "R49_DETAILTOTALORFREIGHTANDFEES":
Common.Initialize(ref r49);
r49.Add((Models.Files.Invoice.R49_DetailTotalOrFreightAndFees)rec);
detail.DetailTotalOrFreightAndFeesRecord = r49.LastItem();
break;
case "R55_INVOICETOTALS":
Common.Initialize(ref r55);
r55.Add((Models.Files.Invoice.R55_InvoiceTotals)rec);
invoice.InvoiceTotalRecord = r55.LastItem();
if (detail != null)
{
invoice.InvoiceDetails.Add(detail);
detail = null;
}
break;
case "R57_INVOICETRAILER":
Common.Initialize(ref r57);
r57.Add((Models.Files.Invoice.R57_InvoiceTrailer)rec);
if (detail != null)
{
invoice.InvoiceDetails.Add(detail);
detail = null;
}
invoice.InvoiceTrailerRecord = r57.LastItem();
break;
case "R95_INVOICEFILETRAILER":
Common.Initialize(ref r95);
r95.Add((Models.Files.Invoice.R95_InvoiceFileTrailer)rec);
file.InvoiceFileTrailerRecord = r95.LastItem();
break;
}
}
if (invoice != null)
{
file.Invoices.Add(invoice);
invoice = null;
}
using (SQL sql = new SQL(batchnumber, r01, r15, r45, r46, r48, r49, r55, r57, r95)) { savedokay = sql.Successful; }
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(file);
}
public bool WriteFile(string filename, Models.Files.Invoice.DataSequence.V3 data)
{
List <object> writelist = new List <object>();
bool success = false;
try
{
//build list
writelist.Add(data.InvoiceFileHeaderRecord);
if (data.Invoices != null && data.Invoices.Count > 0)
{
foreach (Models.Files.Invoice.DataSequence.InvoiceItem item in data.Invoices)
{
if (Common.IsValid(item.InvoiceHeaderRecord))
{
writelist.Add(item.InvoiceHeaderRecord);
}
foreach (Models.Files.Invoice.DataSequence.InvoiceDetail detail in item.InvoiceDetails)
{
if (Common.IsValid(detail.InvoiceDetailRecord))
{
writelist.Add(detail.InvoiceDetailRecord);
}
if (Common.IsValid(detail.InvoiceDetail2Record))
{
writelist.Add(detail.InvoiceDetail2Record);
}
if (Common.IsValid(detail.DetailTotalRecord))
{
writelist.Add(detail.DetailTotalRecord);
}
if (Common.IsValid(detail.DetailTotalOrFreightAndFeesRecord))
{
writelist.Add(detail.DetailTotalOrFreightAndFeesRecord);
}
}
if (Common.IsValid(item.InvoiceTotalRecord))
{
writelist.Add(item.InvoiceTotalRecord);
}
if (Common.IsValid(item.InvoiceTrailerRecord))
{
writelist.Add(item.InvoiceTrailerRecord);
}
}
}
if (Common.IsValid(data.InvoiceFileTrailerRecord))
{
writelist.Add(data.InvoiceFileTrailerRecord);
}
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.Invoice.R01_InvoiceFileHeader),
typeof(Models.Files.Invoice.R15_InvoiceHeader),
typeof(Models.Files.Invoice.R45_InvoiceDetail),
typeof(Models.Files.Invoice.R46_InvoiceDetail),
typeof(Models.Files.Invoice.R48_DetailTotal),
typeof(Models.Files.Invoice.R49_DetailTotalOrFreightAndFees),
typeof(Models.Files.Invoice.R55_InvoiceTotals),
typeof(Models.Files.Invoice.R57_InvoiceTrailer),
typeof(Models.Files.Invoice.R95_InvoiceFileTrailer)
)
{
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.Invoice.DataSequence.V3 data)
{
List <object> writelist = new List <object>();
List <(string code, Type type)> used = new List <(string code, Type type)>();
bool success = false;
try
{
//build list
writelist.Add(data.InvoiceFileHeaderRecord);
//++if((from u in used where u.code == data.InvoiceFileHeaderRecord.InvoiceFileHeader select u.code).Count() == 0) { used.Add((data.InvoiceFileHeaderRecord.InvoiceFileHeader,typeof(Models.Files.Invoice.R01_InvoiceFileHeader)); }
if (data.Invoices != null && data.Invoices.Count > 0)
{
foreach (Models.Files.Invoice.DataSequence.InvoiceItem item in data.Invoices)
{
if (Common.IsValid(item.InvoiceHeaderRecord))
{
writelist.Add(item.InvoiceHeaderRecord);
}
if (Common.IsValid(item.InvoiceVendorDetailRecord))
{
writelist.Add(item.InvoiceVendorDetailRecord);
}
foreach (Models.Files.Invoice.DataSequence.InvoiceDetail detail in item.InvoiceDetails)
{
if (Common.IsValid(detail.InvoiceDetailRecord))
{
writelist.Add(detail.InvoiceDetailRecord);
}
if (Common.IsValid(detail.DetailISBN13OrEANRecord))
{
writelist.Add(detail.DetailISBN13OrEANRecord);
}
if (Common.IsValid(detail.DetailTotalRecord))
{
writelist.Add(detail.DetailTotalRecord);
}
}
if (Common.IsValid(item.InvoiceTotalRecord))
{
writelist.Add(item.InvoiceTotalRecord);
}
if (Common.IsValid(item.InvoiceTrailerRecord))
{
writelist.Add(item.InvoiceTrailerRecord);
}
}
}
if (Common.IsValid(data.InvoiceFileTrailer, false))
{
writelist.Add(data.InvoiceFileTrailer);
}
MultiRecordEngine engine = new MultiRecordEngine
(
typeof(Models.Files.Invoice.R01_InvoiceFileHeader),
typeof(Models.Files.Invoice.R15_InvoiceHeader),
typeof(Models.Files.Invoice.R16_InvoiceVendorDetail),
typeof(Models.Files.Invoice.R45_InvoiceDetail),
typeof(Models.Files.Invoice.R46_DetailISBN13OrEAN),
typeof(Models.Files.Invoice.R48_DetailTotal),
typeof(Models.Files.Invoice.R55_InvoiceTotals),
typeof(Models.Files.Invoice.R57_InvoiceTrailer),
typeof(Models.Files.Invoice.R95_InvoiceFileTrailer)
)
{
RecordSelector = new RecordTypeSelector(Models.Files.Invoice.Selectors.V3.Custom)
};
engine.WriteFile(filename, writelist.ToArray());
success = true;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
success = false;
}
return(success);
}
