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