private static void InsertIntoMongoProductReport(ProductReport currentReport, int check) { var mongoClient = new MongoClient("mongodb://localhost/"); var mongoServer = mongoClient.GetServer(); var productReporstDb = mongoServer.GetDatabase("Supermarket"); var collection = productReporstDb.GetCollection<ProductReport>("ProductReports"); if (check == 0) { collection.RemoveAll(); } else { collection.Save(currentReport); } }
private static void CreateJsonObject(CatalogContext db) { using (db) { var productReport = db.Sales .Include("Product") .Include("Product.Vendor") .Select(x => new { x.Sum, x.Quantity, x.ProductID, x.Product.ProductName, x.Product.Vendor.Name } ) .GroupBy(x => x.ProductID); int count = 0; foreach (var item in productReport) { Console.WriteLine("ID: {0} Name: {1} Vendor: {2} Quantity: {3} Sum: {4}", item.Key, item.First().ProductName, item.First().Name, item.Sum(x => x.Quantity), item.Sum(x => x.Sum) ); ProductReport currentReport = new ProductReport(item.Key, item.First().ProductName, item.First().Name, Convert.ToDouble(item.Sum(x => x.Quantity)), item.Sum(x => x.Sum)); InsertIntoMongoProductReport(currentReport, count); count++; } } }