public void SaveSale(SaleModel saleInfo, string cashierId, List <SaleDetailDBModel> details) { //Start filling in the sale detail models we will save to the database ProductData products = new ProductData(); var taxRate = ConfigHelper.GetTaxRate() / 100; foreach (var item in saleInfo.SaleDetails) { var detail = new SaleDetailDBModel { ProductId = item.ProductId, Quantity = item.Quantity }; //Get the info about this product var productInfo = products.GetProductById(detail.ProductId); if (productInfo == null) { throw new Exception($"The product Id of {detail.ProductId} could not be found in the database"); } detail.PurchasePrice = (productInfo.RetailPrice * detail.Quantity); if (productInfo.IsTaxable) { detail.Tax = (detail.PurchasePrice * taxRate); } //update the products quantity in database int refreshQuantity = productInfo.QuantityInStock - detail.Quantity; products.UpdateProductQuantitity(detail.ProductId, refreshQuantity); details.Add(detail); } //Create the Sale model SaleDBModel sale = new SaleDBModel { SubTotal = details.Sum(x => x.PurchasePrice), Tax = details.Sum(x => x.Tax), CashierId = cashierId }; sale.Total = sale.SubTotal + sale.Tax; using (SqlDataAccess sql = new SqlDataAccess()) { try { sql.StartTransaction("TRMData"); //Save the sale model sql.SaveDataInTransaction("dbo.spSale_Insert", sale); //Get the ID from the sale model sale.Id = sql.LoadDataInTransaction <int, dynamic>("spSale_Lookup", new { sale.CashierId, sale.SaleDate }).FirstOrDefault(); //Finish filling in the sale detail models foreach (var item in details) { item.SaleId = sale.Id; //Save the sale detail models sql.SaveDataInTransaction("dbo.spSaleDetail_Insert", item); } sql.CommitTransaction(); //using statement can also take care of doing it at the close of curly bracket } catch { sql.RollBackTransaction(); throw; } } }