private void CreateJson(ProductTotalSale currentProduct)
{
var context = this.marketContext;
var actualPath = this.outputPath;// + "Json-Reports";
if (!Directory.Exists(actualPath))
{
Directory.CreateDirectory(actualPath);
}
var writer = new StreamWriter(string.Format("{0}\\{1}.json", actualPath, currentProduct.ProductId));
using (writer)
{
var json = new Newtonsoft.Json.JsonSerializer();
json.Serialize(writer, currentProduct);
}
}
public IEnumerable<ProductTotalSale> GetDataFromSqlServer(DateTime startDate, DateTime endDate)
{
var result = new List<ProductTotalSale>();
var context = new ChainOfSupermarketsContext();
var allSales = context.Sales
.Where(s => s.DateOfSale >= startDate && s.DateOfSale <= endDate)
.ToList();
foreach (var pr in context.Products)
{
var currentProducts = allSales.Where(x => x.Product.Id == pr.Id);
double totalQuantityForProduct = 0.0;
double totalMoneyForProduct = 0.0;
int prodId = 0;
foreach (var currentProduct in currentProducts)
{
totalQuantityForProduct += (double)currentProduct.Quantity;
totalMoneyForProduct +=
(double)currentProduct.Quantity * (double)currentProduct.PricePerUnit;
prodId = currentProduct.ProductId;
}
var reportForCurrentProduct = new ProductTotalSale()
{
ProductId = prodId,
ProductName = pr.ProductName,
VendorName = pr.Vendors.VendorName,
QuantitySold = totalQuantityForProduct,
TotalIncomes = totalMoneyForProduct
};
result.Add(reportForCurrentProduct);
}
return result;
}