public void PostSale(SaleModel sale, string cashierId)
{
List <SaleDetailDataModel> saleDetails = new List <SaleDetailDataModel>();
ProductData productData = new ProductData();
var taxRate = ConfigHelper.GetTaxRate();
foreach (var item in sale.SaleDetails)
{
var details = new SaleDetailDataModel
{
ProductId = item.ProductId,
Quantity = item.Quantity
};
var productInfo = productData.GetProductById(item.ProductId);
if (productInfo == null)
{
throw new Exception($"The product WHERE id = {item.ProductId} is null");
}
details.PurchasePrice = productInfo.RetailPrice * details.Quantity;
if (productInfo.isTaxable)
{
details.Tax = details.PurchasePrice * taxRate;
}
saleDetails.Add(details);
}
SaleDataModel saleData = new SaleDataModel
{
SubTotal = saleDetails.Sum(x => x.PurchasePrice),
Tax = saleDetails.Sum(x => x.Tax),
CashierId = cashierId,
};
saleData.Total = saleData.SubTotal + saleData.Tax;
using (SqlDataAccess sql = new SqlDataAccess())
{
try
{
sql.StartTransaction("RMData");
sql.SaveDataInTransaction("dbo.spSaleInsert", saleData);
saleData.Id = sql.LoadDataInTransaction <int, dynamic>("dbo.spSaleLookup", new { saleData.CashierId, saleData.SaleDate }, "RMData").FirstOrDefault();
foreach (var item in saleDetails)
{
item.SaleId = saleData.Id;
sql.SaveDataInTransaction("dbo.spSaleDetailInsert", item);
}
}
catch
{
sql.RollBackTransaction();
throw;
}
}
}
public void SaveSale(SaleModel saleInfo, string cashierId)
{
List <SaleDetailDBModel> details = new List <SaleDetailDBModel>();
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,
};
var productInfo = products.GetProductById(item.ProductId);
if (productInfo == null)
{
throw new Exception($"The product Id of {item.ProductId} could not be found in the database");
}
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;
using (SqlDataAccess sql = new SqlDataAccess())
{
try
{
sql.StartTransaction("RMData");
sql.SaveDataInTransaction("dbo.spSale_Insert", sale);
sale.Id = sql.LoadDataInTransaction <int, dynamic>("spSale_Lookup", new { sale.CashierId, sale.SaleDate }).FirstOrDefault();
foreach (var item in details)
{
item.SaleId = sale.Id;
sql.SaveDataInTransaction("dbo.spSaleDetail_Insert", item);
}
sql.CommitTransaction();
}
catch
{
sql.RollBackTransaction();
throw;
}
}
}
public void SaveSale(SaleModel saleInfo, string userId)
{
// TODO:: Make this SOLID/DRY/BETTER
List <SaleDetailDBModel> details = new List <SaleDetailDBModel>();
ProductData product = new ProductData();
var taxRate = ConfigHelper.GetTaxRate() / 100;
foreach (var item in saleInfo.SaleDetails)
{
var detail = new SaleDetailDBModel()
{
ProductId = item.ProductId,
Quantity = item.Quantity
};
//Get information about this product
var productInfo = product.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);
}
details.Add(detail);
}
// Create the Sale model
SaleDbModel sale = new SaleDbModel()
{
SubTotal = details.Sum(x => x.PurchasePrice),
Tax = details.Sum(x => x.Tax),
CashierId = userId
};
sale.Total = sale.SubTotal + sale.Tax;
using (SqlDataAccess sql = new SqlDataAccess())
{
try
{
sql.StartTransaction("RMData");
// Save the sale model
sql.SaveDataInTransaction("dbo.spSale_Insert", sale);
// Get the ID from the sale mode
sale.Id = sql.LoadDataInTransaction <int, dynamic>(
"dbo.spSale_Lookup",
new
{
sale.CashierId,
sale.SaleDate
}).FirstOrDefault();
// Finish filling int the sale detail models
foreach (var item in details)
{
item.SaleId = sale.Id;
// Save the sale detail model
sql.SaveDataInTransaction("dbo.spSaleDetail_Insert", item);
}
sql.CommitTransaction();
}
catch (Exception)
{
sql.RollBackTransaction();
throw;
}
}
}