public void InsertPurchaseOrderDetailInterface(DatabasePurchaseOrderReceiptDetail databaseIntegrationsInventoryAdjustment)
{
using (var connection = DatabaseConnectionFactory.GetNbxWebConnection())
{
connection.Insert(databaseIntegrationsInventoryAdjustment);
}
}
public int InsertDatabasePurchaseOrderReceiptDetail(DatabasePurchaseOrderReceiptDetail databasePurchaseOrderDetailInterface)
{
using (var connection = DatabaseConnectionFactory.GetNbxWebConnection())
{
connection.Open();
return((int)connection.Insert(databasePurchaseOrderDetailInterface));
}
}
private int ProcessPurchaseOrdersDetail(int headerId, IGrouping <string, ManhattanPerpetualInventoryTransfer> purchaseOrderGrouping, PurchaseOrderGeneralLedger firstRecordInGrouping)
{
var detail = new DatabasePurchaseOrderReceiptDetail
{
POReceiptHeaderID = headerId,
PONumber = purchaseOrderGrouping.Key,
InvoiceNumber = firstRecordInGrouping.InvoiceNumber,
NumberLineItems = purchaseOrderGrouping.Count().ToString(CultureInfo.InvariantCulture),
shippeddatetimereference = firstRecordInGrouping.Shippeddatetimereference,
IntegrationStatus = PurchaseOrderInterfaceIntegrationStatus,
DateAdded = DateTime.Now
};
return(_databaseRepository.InsertDatabasePurchaseOrderReceiptDetail(detail));
}
