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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}