コード例 #1
0
        static void Main()
        {
            InitModules.PopulateProducts();

            Console.WriteLine("Parsing excel reports...");
            var excelReports = ExcelParser.ParseExcel(path);

            Console.WriteLine("Inserting sales reports...");

            foreach (var report in excelReports)
            {
                DBManager.InsertSalesReports(report);
            }

            Console.WriteLine("Generating pdf aggregated sales report.");
            DatabaseToPdfWriter pdfWriter = new DatabaseToPdfWriter();
            var reports = DBManager.RetrieveReports();
            pdfWriter.GeneratePDFAggregatedSalesReports(reports, "..\\..\\Report.pdf");

            Console.WriteLine("Generating sales by vendor XML file...");
            DatabaseToXmlWriter xmlWriter = new DatabaseToXmlWriter();
            xmlWriter.GenerateSalesReportByVendor(DBManager.RetrieveReportByVendors(), "..\\..\\Sales-by-Vendors-report.xml");
            XmlParser xmlParser = new XmlParser();
            DBManager.InsertVendorExpenses(xmlParser.ParseFile("..\\..\\Vendors-Expenses.xml"));

            Console.WriteLine("Inserting data in MongoDb...");
            Manager mongoManager = new Manager("mongodb://localhost");
            mongoManager.AddProducts(DBManager.GetMonthlyProducts());

            Console.WriteLine("Generating .xls file...");
            DBManager.RetrieveProductReport();
            DatabaseToExcelWriter.CreateExcelTable(DBManager.RetrieveTotalReport(DateTime.Now));
        }
コード例 #2
0
        public static Dictionary<DateTime, Dictionary<int, DBManager.MongoEntry>> RetrieveTotalReport()
        {
            var result = new Dictionary<DateTime, Dictionary<int, DBManager.MongoEntry>>();
            var now = DateTime.Now;

            var mgr = new Manager();
            var products = mgr.GetProducts();

            result.Add(now, new Dictionary<int, DBManager.MongoEntry>());

            foreach (var prod in products.AsQueryable().ToList())
            {
                result[now].Add(prod.ProductId, new DBManager.MongoEntry()
                {
                    ProductName = prod.Name,
                    QuantitySold = prod.QuantitySold,
                    TotatIncome = prod.Income,
                    VendorName = prod.Vendor
                });
            }

            return result;
        }