public Sale CreateSale(Sale sale) { try { using (TransactionScope transactionScope = new TransactionScope()) { using (SqlConnection sqlConnection = SQLDatabaseConnector.OpenConnection()) { sale = InsertSale(sale, sqlConnection); sale = InsertSaleLineItemsInSale(sale, sqlConnection); } transactionScope.Complete(); } } catch (Exception e) { throw new CantCreateSaleException("", e); } return(sale); }
public string DeleteSale(Sale sale) { try { using (TransactionScope transactionScope = new TransactionScope()) { using (SqlConnection sqlConnection = SQLDatabaseConnector.OpenConnection()) { DeleteSaleLineItemsFromSale(sale, sqlConnection); DeleteSale(sale, sqlConnection); } transactionScope.Complete(); } } catch (Exception e) { throw new CantDeleteSaleException("", e); } return("Sale deleted"); }