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); } }