public void SetAsProcessed(InventorySyncProcessing inventorySyncProcessing)
{
const string updateInventorySyncProcessing = @"UPDATE [dbo].[InventorySyncProcessing]
SET ProcessedDate = @ProcessedDate
WHERE TransactionNumber = @TransactionNumber";
using (var connection = DatabaseConnectionFactory.GetWarehouseManagementTransactionConnection())
{
connection.Open();
connection.Execute(updateInventorySyncProcessing, inventorySyncProcessing);
}
}
public void SetAsReceived(InventorySyncProcessing inventorySyncProcessing)
{
using (var connection = DatabaseConnectionFactory.GetWarehouseManagementTransactionConnection())
{
var parameter = new
{
inventorySyncProcessing.TransactionNumber,
inventorySyncProcessing.ReceivedDate,
inventorySyncProcessing.ManhattanDateCreated,
inventorySyncProcessing.ManhattanTimeCreated
};
connection.Open();
connection.Execute("sp_InsertInventorySyncProcessing", parameter, commandType: CommandType.StoredProcedure);
}
}