Пример #1
0
        private void RestockByMachineCSV_Click(object sender, EventArgs e)
        {
            List <Machine> machineList;
            ReportManager  report = new ReportManager();

            machineList = this.database.SelectAllMachine();
            DataTable subtotals = report.reportRestockByMachine(machineList);

            Export export = new Export();

            export.ExportToCSV(subtotals, "RestockMachineGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();

            csvOK.Show();
        }
Пример #2
0
        private void button13_Click(object sender, EventArgs e)
        {
            List <Transactions> data;
            ReportManager       report = new ReportManager();

            data = this.database.SelectAllTransactions();

            DataTable subtotals = report.reportSalesByMachine(data);

            Export export = new Export();

            export.ExportToCSV(subtotals, "SalesMachineGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();

            csvOK.Show();
        }
Пример #3
0
        private void button11_Click(object sender, EventArgs e)
        {
            List <Product> data;
            ReportManager  report = new ReportManager();

            data = this.database.SelectAllProduct();

            DataTable subtotals = report.reportInventoryCostItem(data);

            Export export = new Export();

            export.ExportToCSV(subtotals, "InventoryProductGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();

            csvOK.Show();
        }
Пример #4
0
        private void SalesByMachineProduct_Click(object sender, EventArgs e)
        {
            List <Transactions> data;
            List <Machine>      machineList;
            ReportManager       report = new ReportManager();

            data        = this.database.SelectAllTransactions();
            machineList = this.database.SelectAllMachine();
            DataTable subtotals = report.reportSalesByProductPerMachine(data, machineList);

            Export export = new Export();

            export.ExportToCSV(subtotals, "SalesMachineProductGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();

            csvOK.Show();
        }
Пример #5
0
        private void button11_Click(object sender, EventArgs e)
        {
            List<Product> data;
            ReportManager report = new ReportManager();
            data = this.database.SelectAllProduct();

            DataTable subtotals = report.reportInventoryCostItem(data);

            Export export = new Export();
            export.ExportToCSV(subtotals, "InventoryProductGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();
            csvOK.Show();
        }
Пример #6
0
        private void SalesByMachineProduct_Click(object sender, EventArgs e)
        {
            List<Transactions> data;
            List<Machine> machineList;
            ReportManager report = new ReportManager();
            data = this.database.SelectAllTransactions();
            machineList = this.database.SelectAllMachine();
            DataTable subtotals = report.reportSalesByProductPerMachine(data, machineList);

            Export export = new Export();
            export.ExportToCSV(subtotals, "SalesMachineProductGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();
            csvOK.Show();
        }
Пример #7
0
        private void RestockByMachineCSV_Click(object sender, EventArgs e)
        {
            List<Machine> machineList;
            ReportManager report = new ReportManager();
            machineList = this.database.SelectAllMachine();
            DataTable subtotals = report.reportRestockByMachine(machineList);

            Export export = new Export();
            export.ExportToCSV(subtotals, "RestockMachineGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();
            csvOK.Show();
        }
Пример #8
0
        private void CSVSalesByProduct_Click(object sender, EventArgs e)
        {
            List<Transactions> data;
            ReportManager report = new ReportManager();
            data = this.database.SelectAllTransactions();

            DataTable subtotals = report.reportSalesByItem(data);

            Export export = new Export();
            export.ExportToCSV(subtotals, "SalesProductGrid.csv");

            CSVCreatedDialog csvOK = new CSVCreatedDialog();
            csvOK.Show();
        }