public SalesView()
{
SalesProductInfo = new SalesProductInfo();
SalesInfos = new List <SalesInfo>();
Customer = new Customer();
Product = new Product();
Category = new Category();
SalesInfos = new List <SalesInfo>();
ProductSelectListItems = new List <SelectListItem>();
ProductName = new List <string>();
ProductCode = new List <string>();
TotalPrices = new List <string>();
}
private void AddSalesProductReport(SalesProductInfo salesProduct, List <SalesReportView> aList, DateTime startDate, DateTime endDate)
{
var costPrice = CostPrice(salesProduct, endDate);
aList.Add(new SalesReportView()
{
Product = salesProduct.Product.Name,
Code = salesProduct.Product.Code,
Category = salesProduct.Product.Category.Name,
SoldQuantity = salesProduct.Quantity,
CostPrice = costPrice.Average() * salesProduct.Quantity,
SalesPrice = salesProduct.PayableAmount * salesProduct.Quantity,
Profit = ((salesProduct.PayableAmount * salesProduct.Quantity) - (costPrice.Average() * salesProduct.Quantity))
});
}
private List <double> CostPrice(SalesProductInfo salesProduct, DateTime endDate)
{
var purchaseProductList = _dbContext.PurchaseProductInfos
.Include(c => c.PurchaseInfo)
.Include(c => c.Product)
.Include(c => c.Product.Category)
.Where(c => c.PurchaseInfo.Date <= endDate)
.ToList();
List <double> costPrice = new List <double>();
foreach (var product in purchaseProductList)
{
if (product.ProductId == salesProduct.ProductId)
{
costPrice.Add(product.UnitPrice);
}
}
return(costPrice);
}
