//PDFGenerator.GeneratePDF();
static void ProductReportsToJsonAndMongo()
{
ParadiseSupermarketChainEntities sqlCon = new ParadiseSupermarketChainEntities();
var query =
from product in sqlCon.Products
join vendor in sqlCon.Vendors on
product.VendorId equals vendor.Id
join sale in sqlCon.Sales on
product.Id equals sale.ProductId
join date in sqlCon.Dates on
sale.DateId equals date.Id
orderby product.Id
select new
{
Id = product.Id,
Name = product.Name,
Quantity = sale.Quantity,
Sum = sale.Sum,
VendorName = vendor.Name,
Date = date.Date
};
Dictionary<int, Tuple<string, int, decimal, string, DateTime>> collection = new Dictionary<int, Tuple<string, int, decimal, string, DateTime>>();
foreach (var item in query)
{
if (!collection.ContainsKey(item.Id))
{
collection.Add(item.Id, new Tuple<string, int, decimal, string, DateTime>((string)item.Name, (int)item.Quantity, (decimal)item.Sum, (string)item.VendorName, (DateTime)item.Date));
continue;
}
int newQuantity = collection[item.Id].Item2 + (int)item.Quantity;
decimal newSum = collection[item.Id].Item3 + item.Sum;
collection[item.Id] = new Tuple<string, int, decimal, string, DateTime>((string)item.Name, newQuantity, newSum, (string)item.VendorName, (DateTime)item.Date);
}
foreach (var item in collection)
{
JSON.Extract(item.Key, item.Value.Item1, item.Value.Item4, item.Value.Item2, item.Value.Item3);
MongoWriter mongoWriter = new MongoWriter("Products");
mongoWriter.WriteProduct(item.Key, item.Value.Item1, item.Value.Item4, item.Value.Item2, item.Value.Item3, item.Value.Item5);
}
}
static void LoadVendor()
{
ParadiseSupermarketChainEntities sqlCon = new ParadiseSupermarketChainEntities();
using (sqlCon)
{
MongoWriter mongo = new MongoWriter("Expenses");
XmlReader reader = new XmlReader("E:\\Vendor-Expenses.xml");
while (reader.ReadNextSale())
{
while (reader.ReadNextExpenses())
{
mongo.WriteExpenses(reader.Vendor, reader.Month, reader.Expenses);
var expence = new EntityFramework.Data.Expenses()
{
Expenses1 = decimal.Parse(reader.Expenses),
ExpensesDate = DateTime.Parse(reader.Month)
};
int vendorIdd = 1;
var VendorId =
from vendor in sqlCon.Vendors
where vendor.Name == reader.Vendor
select new
{
Id = vendor.Id
};
var vendorIdc = sqlCon.Vendors.Where(v => v.Name == reader.Vendor).FirstOrDefault();
expence.VendorId = vendorIdd;
sqlCon.Expenses.Add(expence);
sqlCon.SaveChanges();
}
}
}
}
