public void SaveSale(SaleModel saleInfo, string cashierId)
{
List <SaleDetailDBModel> details = new List <SaleDetailDBModel>();
var taxRate = ConfigHelper.GetTaxtRate() / 100;
foreach (var item in saleInfo.SaleDetails)
{
var detail = new SaleDetailDBModel
{
ProductId = item.ProductId,
Quantity = item.Quantity,
};
var productInfo = _productData.GetProductById(item.ProductId);
if (productInfo == null)
{
throw new Exception($"{item.ProductId} brak w bazie");
}
detail.PurchasePrice = productInfo.RetailPrice * detail.Quantity;
if (productInfo.IsTaxable)
{
detail.Tax = detail.PurchasePrice * taxRate;
}
details.Add(detail);
}
SaleDBModel sale = new SaleDBModel
{
SubTotal = details.Sum(x => x.PurchasePrice),
Tax = details.Sum(x => x.Tax),
CashierId = cashierId
};
sale.Total = sale.SubTotal + sale.Tax;
try
{
_sqlDataAccess.StartTransaction("RMData");
_sqlDataAccess.SavedData <SaleDBModel>("dbo.sqlSale_Insert", sale, "RMData");
sale.Id = _sqlDataAccess.LoadDataInTransaction <int, dynamic>("sqlSale_Lookup", new { sale.CashierId, sale.SaleDate }).FirstOrDefault();
foreach (var item in details)
{
item.SaleId = sale.Id;
_sqlDataAccess.SavedDataInTransaction("dbo.sqlSaleDetail_Insert", item);
}
_sqlDataAccess.ComitTransaction();
}
catch
{
_sqlDataAccess.RollBackTransaction();
throw;
}
}
