private void DATA_GRID_REPORT_UPDATE() { if (ReportCombo.Text.Equals("Product_Sales")) { using (PUYO_WAREHOUSE_ENTITY db = new PUYO_WAREHOUSE_ENTITY()) { DisplayDataGrid.DataSource = db.GET_PRODUCT_SALES(Store_Combo.Text, DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text + " For " + Store_Combo.Text; } } else if (ReportCombo.Text.Equals("Average_Sales")) { using (PUYO_WAREHOUSE_AVG_ENTITY db = new PUYO_WAREHOUSE_AVG_ENTITY()) { DisplayDataGrid.DataSource = db.GET_AVERAGE_SALES_FORECAST(Store_Combo.Text, DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text + " For " + Store_Combo.Text; } } else if (ReportCombo.Text.Equals("Product_Sales_All")) { using (PUYO_WAREHOUSE_ALL_ENTITY db = new PUYO_WAREHOUSE_ALL_ENTITY()) { DisplayDataGrid.DataSource = db.GET_PRODUCT_SALES_ALL(DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text; } } else if (ReportCombo.Text.Equals("Expired_Products")) { using (PUYO_WAREHOUSE_EXP_ENTITY db = new PUYO_WAREHOUSE_EXP_ENTITY()) { DisplayDataGrid.DataSource = db.GET_EXPIRED_PRODUCTS(Store_Combo.Text, DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text + " For " + Store_Combo.Text; } } else if (ReportCombo.Text.Equals("Expired_Products_All")) { using (PUYO_WAREHOUSE_EXP1_ALL_ENTITY db = new PUYO_WAREHOUSE_EXP1_ALL_ENTITY()) { DisplayDataGrid.DataSource = db.GET_EXPIRED_PRODUCTS_ALL(DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text; } } else if (ReportCombo.Text.Equals("Restocking_Single_Store")) { using (PUYO_WAREHOUSE_RESTOCK1_ENTITY db = new PUYO_WAREHOUSE_RESTOCK1_ENTITY()) { DisplayDataGrid.DataSource = db.RESTOCKING(Store_Combo.Text, DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text + " For " + Store_Combo.Text; } } else if (ReportCombo.Text.Equals("Restocking_All")) { using (PUYO_WAREHOUSE_RESTOCK1_ALL_ENTITY db = new PUYO_WAREHOUSE_RESTOCK1_ALL_ENTITY()) { DisplayDataGrid.DataSource = db.RESTOCKING_ALL(DateFromPicker.Value.Date, DateToPicker.Value.Date); ReportTypeText.Text = "Report Type: " + ReportCombo.Text; } } }
private void button1_Click(object sender, EventArgs e) { Console.WriteLine(DateFromPicker.Value.Date); Console.WriteLine(DateToPicker.Value.Date); if (ReportCombo.Text.Equals("Product_Sales")) { using (PUYO_WAREHOUSE_ENTITY db = new PUYO_WAREHOUSE_ENTITY()) { GET_PRODUCT_SALESBindingSource.DataSource = db.GET_PRODUCT_SALES(Store_Combo.Text, DateFromPicker.Value.Date, DateToPicker.Value.Date); Microsoft.Reporting.WinForms.ReportParameter[] parameters = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("StoreID", Store_Combo.Text), new Microsoft.Reporting.WinForms.ReportParameter("FromDate", DateFromPicker.Value.Date.ToShortDateString()), new Microsoft.Reporting.WinForms.ReportParameter("ToDate", DateToPicker.Value.Date.ToShortDateString()) }; GenerateReportViewer.LocalReport.SetParameters(parameters); GenerateReportViewer.RefreshReport(); DisplayDataGrid.DataSource = GET_PRODUCT_SALESBindingSource; } } else if (ReportCombo.Text.Equals("Average_Sales")) { using (PUYO_WAREHOUSE_AVG_ENTITY db = new PUYO_WAREHOUSE_AVG_ENTITY()) { GET_AVERAGE_SALESBindingSource.DataSource = db.GET_AVERAGE_SALES_FORECAST(Store_Combo.Text, DateFromPicker.Value.Date, DateToPicker.Value.Date); Microsoft.Reporting.WinForms.ReportParameter[] parameters = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("StoreID", Store_Combo.Text), new Microsoft.Reporting.WinForms.ReportParameter("FromDate", DateFromPicker.Value.Date.ToShortDateString()), new Microsoft.Reporting.WinForms.ReportParameter("ToDate", DateToPicker.Value.Date.ToShortDateString()) }; GenerateReportViewer.LocalReport.SetParameters(parameters); GenerateReportViewer.RefreshReport(); DisplayDataGrid.DataSource = GET_AVERAGE_SALESBindingSource; } } }