public bool SaveR57_InvoiceTrailer(List <Models.Files.Invoice.R57_InvoiceTrailer> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R57_InvoiceTrailer>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "InvoiceTrailer", "InvoiceTrailer"),
(3, "SequenceNumber", "RecordSequence"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "TotalNetPrice", "TotalNetPrice"),
(6, "TotalShipping", "TotalShipping"),
(7, "TotalHandling", "TotalHandling"),
(8, "TotalGiftWrap", "TotalGiftWrap"),
(9, "TotalInvoice", "TotalInvoice"),
},
new List <string> {
"reserved038_055", "reserved079_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR46_DetailISBN13EAN(List <Models.Files.Invoice.R46_DetailISBN13OrEAN> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R46_DetailISBN13OrEAN>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "DetailISBN13OrEANRecord", "DetailISBN13OrEANRecord"),
(3, "RecordSequenceNumber", "RecordSequenceNumber"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "LineItemIDNumber", "LineItemIDNumber"),
(6, "ISBN13OrEANShipped", "ISBN13OrEANShipped"),
},
new List <string> {
"reserved057_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR95_InvoiceFileTrailer(List <Models.Files.Invoice.R95_InvoiceFileTrailer> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R95_InvoiceFileTrailer>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "InvoiceFileTrailer", "InvoiceFileTrailer"),
(3, "RecordSequenceNumber", "RecordSequenceNumber"),
(4, "TotalItems", "TotalItems"),
(5, "TotalInvoices", "TotalInvoices"),
(6, "TotalUnits", "TotalUnits"),
},
new List <string> {
"reserved036_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR50_PurchaseOrderControl(List <Models.Files.PurchaseOrder.R50_PurchaseOrderControl> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R50_PurchaseOrderControl>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "TotalPurchaseOrderRecords", "TotalPurchaseOrderRecords"),
(6, "TotalLineItemsinfile", "TotalLineItemsinfile"),
(7, "TotalUnitsOrdered", "TotalUnitsOrdered"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR16_InvoiceVendorDetail(List <Models.Files.Invoice.R16_InvoiceVendorDetail> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R16_InvoiceVendorDetail>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordType", "RecordType"),
(3, "RecordSequencenumber", "RecordSequencenumber"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "DCCode", "DCCode"),
(6, "IngramOrderEntryNumber", "IngramOrderEntryNumber"),
},
new List <string> {
"reserved028_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR34_RecipientShippingRecordCityStateZip(List <Models.Files.PurchaseOrder.R34_RecipientShippingRecordCityStateZip> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R34_RecipientShippingRecordCityStateZip>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "RecipientCity", "RecipientCity"),
(6, "RecipientStateOrProvince", "RecipientStateOrProvince"),
(7, "RecipientPostalCode", "RecipientPostalCode"),
(8, "Country", "Country"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR41_AdditionalLineItem(List <Models.Files.PurchaseOrder.R41_AdditionalLineItem> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R41_AdditionalLineItem>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
//41:
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "ClientItemListPrice", "ClientItemListPrice"),
(6, "LineLevelBackorderCancelDate", "LineLevelBackorderCancelDate"),
(7, "LineLevelGiftWrapCode", "LineLevelGiftWrapCode"),
(8, "OrderQuantity", "OrderQuantity"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveOR_ASNShipment(List <Models.Files.ShipNotice.OR_ASNShipment> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.ShipNotice.OR_ASNShipment>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "ShipmentRecordIdentifier", "ShipmentRecordIdentifier"),
(3, "PONumber", "PONumber"),
(4, "IngramOrderEntryNumber", "IngramOrderEntryNumber"),
},
new List <string> {
"reserved026_046", "reserved052_200"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveCR_ASNCompany(List <Models.Files.ShipNotice.CR_ASNCompany> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.ShipNotice.CR_ASNCompany>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "CompanyRecordIdentifier", "CompanyRecordIdentifier"),
(3, "IngramShipToAccountNumber", "IngramShipToAccountNumber"),
},
new List <string> {
"reserved010_200"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR91_FileTrailer(List <Models.Files.PurchaseAcknowledgement.R91_FileTrailer> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R91_FileTrailer>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "SequenceNumber"),
},
new List <string> {
"reserved030_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveCR_CompanyRecord(List <Models.Files.ShipNotice.CR_CompanyRecord> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.ShipNotice.CR_CompanyRecord>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "CompanyRecordIdentifier", "CompanyRecordIdentifier"),
(3, "CompanyAccountIDNumber", "CompanyAccountIDNumber"),
(4, "TotalOrderCount", "TotalOrderCount"),
(5, "FileVersionNumber", "FileVersionNumber"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR40_LineItem(List <Models.Files.PurchaseAcknowledgement.R40_LineItem> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R40_LineItem>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "SequenceNumber"),
(4, "PONumber", "PONumber"),
(5, "LineItemPONumber", "LineItemPONumber"),
(6, "ItemNumber", "ItemNumber"),
(7, "POAStatusCode", "POAStatusCode"),
(8, "DCCodeOrPrimaryDC", "DCCodeOrPrimaryDC"),
},
new List <string> {
"reserved072_076"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR46_StickerTextLines(List <Models.Files.PurchaseOrder.R46_StickerTextLines> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R46_StickerTextLines>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "SequenceNumber"),
(4, "PONumber", "PONumber"),
(5, "StickerTextLine", "StickerTextLine"),
},
new List <string> {
"reserved064_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR41_AdditionalLineItemDetail(List <Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R41_AdditionalLineItemDetail>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "SequenceNumber"),
(4, "PONumber", "PONumber"),
(5, "BackorderCancellationDate_LineLevel", "BackorderCancellationDate_LineLevel"),
(6, "OrderQuantity", "OrderQuantity"),
(7, "ClientItemNumber", "ClientItemNumber"),
},
new List <string> {
"reserved030_037", "reserved044_046", "reserved074_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR24_CustomerCost(List <Models.Files.PurchaseOrder.R24_CustomerCost> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R24_CustomerCost>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "SalesTaxPercent", "SalesTaxPercent"),
(6, "FreightTaxPercent", "FreightTaxPercent"),
(7, "FreightAmount", "FreightAmount"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveOD_ASNShipmentDetail(List <Models.Files.ShipNotice.OD_ASNShipmentDetail> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.ShipNotice.OD_ASNShipmentDetail>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "DetailRecordIdentifier", "DetailRecordIdentifier"),
(3, "LineItemIdNumber", "LineItemIdNumber"),
(4, "ISBN13OrEAN", "ISBN13OrEAN"),
(5, "QuantityPredictedtoShip", "QuantityPredictedtoShip"),
(6, "QuantityShipped", "QuantityShipped"),
(7, "IngramItemListPrice", "IngramItemListPrice"),
(8, "NetOrDiscountedPrice", "NetOrDiscountedPrice"),
},
new List <string> {
"reserved040_062", "reserved067_200"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR30_RecipientShipToName(List <Models.Files.PurchaseOrder.R30_RecipientShipToName> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R30_RecipientShipToName>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "RecipientConsumerName", "RecipientConsumerName"),
(6, "AddressValidation", "AddressValidation"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR32_RecipientShipToAdditionalShippingInformation(List <Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R32_RecipientShipToAdditionalShippingInformation>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "RecipientAddressLine", "RecipientAddressLine"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR35_DropShipDetail(List <Models.Files.PurchaseOrder.R35_DropShipDetail> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R35_DropShipDetail>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "GiftWrapFeeAmount", "GiftWrapFeeAmount"),
(6, "SendConsumerEmail", "SendConsumerEmail"),
(7, "OrderLevelGiftIndicator", "OrderLevelGiftIndicator"),
(8, "SuppressPriceIndicator", "SuppressPriceIndicator"),
(9, "OrderLevelGiftWrapCode", "OrderLevelGiftWrapCode"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR41_AdditionalDetail(List <Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R41_AdditionalDetail>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "AvailabilityDate", "AvailabilityDate"),
(6, "DCInventoryInformation", "DCInventoryInformation"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR42_LineItemGiftMessage(List <Models.Files.PurchaseOrder.R42_LineItemGiftMessage> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R42_LineItemGiftMessage>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "LineLevelGiftMessage", "LineLevelGiftMessage"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR42_AdditionalLineItem(List <Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R42_AdditionalLineItem>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "Title", "Title"),
(6, "Author", "Author"),
(7, "BindingCode", "BindingCode"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR15_InvoiceHeader(List <Models.Files.Invoice.R15_InvoiceHeader> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R15_InvoiceHeader>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "InvoiceHeader", "InvoiceHeader"),
(3, "RecordSequenceNumber", "RecordSequenceNumber"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "PurchaseOrderNumber", "PurchaseOrderNumber"),
(6, "IngramShipToAccountNumber", "IngramShipToAccountNumber"),
(7, "StoreNumber", "StoreNumber"),
(8, "DCSAN", "DCSAN"),
(9, "InvoiceDate", "InvoiceDate"),
},
new List <string> {
"reserved016_021", "reserved063_065", "reserved074_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR43_AdditionalLineItem(List <Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R43_AdditionalLineItem>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "PublisherName", "PublisherName"),
(6, "PublicationOrReleaseDate", "PublicationOrReleaseDate"),
(7, "OriginalSeqNumber", "OriginalSeqNumber"),
(8, "TotalQtyPredictedtoShipPrimary", "TotalQtyPredictedtoShipPrimary"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR45_InvoiceDetail(List <Models.Files.Invoice.R45_InvoiceDetail> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R45_InvoiceDetail>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "InvoiceDetail", "InvoiceDetail"),
(3, "RecordSequenceNumber", "RecordSequenceNumber"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "PONumber", "PONumber"),
(6, "QuantityShipped", "QuantityShipped"),
(7, "IngramItemListPrice", "IngramItemListPrice"),
(8, "DiscountPercent", "DiscountPercent"),
(9, "NetPriceOrCost", "NetPriceOrCost"),
},
new List <string> {
"reserved016_021", "reserved056", "reserved061", "reserved070_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR44_ItemNumberOrPrice(List <Models.Files.PurchaseAcknowledgement.R44_ItemNumberOrPrice> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseAcknowledgement.R44_ItemNumberOrPrice>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "NetPrice", "NetPrice"),
(6, "ItemNumberType", "ItemNumberType"),
(7, "DiscountedListPrice", "DiscountedListPrice"),
(8, "TotalLineOrderQty", "TotalLineOrderQty"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR48_DetailTotal(List <Models.Files.Invoice.R48_DetailTotal> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R48_DetailTotal>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "DetailTotal", "DetailTotal"),
(3, "RecordSequenceNumber", "RecordSequenceNumber"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "Title", "Title"),
(6, "CustomerPONumber", "CustomerPONumber"),
},
new List <string> {
"reserved016_020", "reeserved06_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR20_FixedSpecialHandlingInstructions(List <Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.PurchaseOrder.R20_FixedSpecialHandlingInstructions>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "RecordCode", "RecordCode"),
(3, "SequenceNumber", "RecordSequence"),
(4, "PONumber", "PONumber"),
(5, "SpecialHandlingCodes", "SpecialHandlingCodes"),
},
new List <string> {
""
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR01_InvoiceFileHeader(List <Models.Files.Invoice.R01_InvoiceFileHeader> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R01_InvoiceFileHeader>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string ColumnSource, string ColumnDesc)>
{
(1, "BatchId", "BatchId"),
(2, "InvoiceFileHeader", "InvoiceFileHeader"),
(3, "RecordSequenceNumber", "RecordSequenceNumber"),
(4, "IngramSAN", "IngramSAN"),
(5, "FileSource", "FileSource"),
(6, "CreationDate", "CreationDate"),
(7, "FileName", "FileName"),
},
new List <string> {
"Reserved061_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
public bool SaveR55_InvoiceTotals(List <Models.Files.Invoice.R55_InvoiceTotals> items, int batchnumber)
{
bool result = false;
try
{
using (SaveTableSql save = new SaveTableSql())
{
result = save.SaveTable <Models.Files.Invoice.R55_InvoiceTotals>
(
batchnumber, items, FileFormat, ActionType, items.GetType().Name,
new List <(int order, string source, string dest)>
{
(1, "BatchId", "BatchId"),
(2, "InvoiceControlShippingRecord", "InvoiceControlShippingRecord"),
(3, "SequenceNumber", "RecordSequence"),
(4, "InvoiceNumber", "InvoiceNumber"),
(5, "InvoiceRecordCount", "InvoiceRecordCount"),
(6, "NumberofTitles", "NumberofTitles"),
(7, "TotalNumberofUnits", "TotalNumberofUnits"),
(8, "BillofLadingNumber", "BillofLadingNumber"),
(9, "TotalInvoiceWeight", "TotalInvoiceWeight"),
},
new List <string> {
"reserved016_020", "reserved057_080"
}
);
}
}
catch (Exception ex)
{
log.Error(ex);
}
return(result);
}
