public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
GetAllProductsByClientReport rpt = new GetAllProductsByClientReport();
rpt.Site = this.Site;
return(rpt);
}
private void btnShowResults_Click(object sender, EventArgs e)
{
crystalReportViewer1.ReportSource = null;
string fromDate = dtpFromDate.Value.ToString();
string toDate = dtpToDate.Value.ToString();
DateTime from = DateTime.Parse(fromDate);
DateTime to = DateTime.Parse(toDate);
var sum = 0.0;
if (txtSum.Text.ToString() != "" && txtSum.Text.ToString() != null)
{
sum = double.Parse(txtSum.Text.ToString());
}
string clientName = "";
if (txtClientName.Text.ToString() != "" && txtClientName.Text.ToString() != null)
{
clientName = txtClientName.Text.ToString();
}
PizzariaDataSet pizzariaDataSet = new PizzariaDataSet();
// reports
ClientsWithoutOrdersReport clientsWithoutOrdersReport = new ClientsWithoutOrdersReport();
ClientsWithBiggerSumReport clientsWithBiggerSumReport = new ClientsWithBiggerSumReport();
TopTenSoldProductsReport topTenSoldProductsReport = new TopTenSoldProductsReport();
ProductsWithMaxSumOfOrdersReport productsWithMaxSumOfOrdersReport = new ProductsWithMaxSumOfOrdersReport();
GetAllProductsByClientReport getAllProductsByClientReport = new GetAllProductsByClientReport();
GetAllOrdersWithBiggerSumReport getAllOrdersWithBiggerSumReport = new GetAllOrdersWithBiggerSumReport();
GetDetailedOrderReport getDetailedOrderReport = new GetDetailedOrderReport();
// adapters
ClientsWithoutOrdersTableAdapter clientsWithoutOrdersAdapter = new ClientsWithoutOrdersTableAdapter();
ClientsWithSumOfOrdersBiggerThanSpecifiedSumTableAdapter clientsWithSumAdapter = new ClientsWithSumOfOrdersBiggerThanSpecifiedSumTableAdapter();
TopTenSoldProductsTableAdapter topTenSoldProducts = new TopTenSoldProductsTableAdapter();
ProductsWithMaxSumOfOrdersTableAdapter productsWithMaxSum = new ProductsWithMaxSumOfOrdersTableAdapter();
GetAllProductsByClientTableAdapter getAllProductsByClientAdapter = new GetAllProductsByClientTableAdapter();
GetAllOrdersWithBiggerSumTableAdapter getAllOrdersWithBiggerSumAdapter = new GetAllOrdersWithBiggerSumTableAdapter();
GetDetailedOrderTableAdapter getDetailedOrderTableAdapter = new GetDetailedOrderTableAdapter();
int selectedIndex = cmbAllReports.SelectedIndex;
using (PizzariaEntities db = new PizzariaEntities())
{
using (pizzariaDataSet)
{
switch (selectedIndex)
{
case 0:
topTenSoldProducts.Fill(pizzariaDataSet.TopTenSoldProducts, from, to);
topTenSoldProductsReport.SetDataSource(pizzariaDataSet);
topTenSoldProductsReport.SetParameterValue("fromDate", from);
topTenSoldProductsReport.SetParameterValue("toDate", to);
crystalReportViewer1.ReportSource = topTenSoldProductsReport;
break;
case 1:
productsWithMaxSum.Fill(pizzariaDataSet.ProductsWithMaxSumOfOrders, from, to);
productsWithMaxSumOfOrdersReport.SetDataSource(pizzariaDataSet);
productsWithMaxSumOfOrdersReport.SetParameterValue("fromDate", from);
productsWithMaxSumOfOrdersReport.SetParameterValue("toDate", to);
crystalReportViewer1.ReportSource = productsWithMaxSumOfOrdersReport;
break;
case 2:
clientsWithoutOrdersAdapter.Fill(pizzariaDataSet.ClientsWithoutOrders, from, to);
clientsWithoutOrdersReport.SetDataSource(pizzariaDataSet);
clientsWithoutOrdersReport.SetParameterValue("fromDate", from);
clientsWithoutOrdersReport.SetParameterValue("toDate", to);
crystalReportViewer1.ReportSource = clientsWithoutOrdersReport;
break;
case 3:
clientsWithSumAdapter.Fill(pizzariaDataSet.ClientsWithSumOfOrdersBiggerThanSpecifiedSum,
from, to, Convert.ToDecimal(sum));
clientsWithBiggerSumReport.SetDataSource(pizzariaDataSet);
clientsWithBiggerSumReport.SetParameterValue("fromDate", from);
clientsWithBiggerSumReport.SetParameterValue("toDate", to);
clientsWithBiggerSumReport.SetParameterValue("sum", sum);
crystalReportViewer1.ReportSource = clientsWithBiggerSumReport;
break;
case 4:
getAllProductsByClientAdapter.Fill(pizzariaDataSet.GetAllProductsByClient, clientName);
getAllProductsByClientReport.SetDataSource(pizzariaDataSet);
getAllProductsByClientReport.SetParameterValue("ClientName", clientName);
crystalReportViewer1.ReportSource = getAllProductsByClientReport;
break;
case 5:
getAllOrdersWithBiggerSumAdapter.Fill(pizzariaDataSet.GetAllOrdersWithBiggerSum, Convert.ToDecimal(sum));
getAllOrdersWithBiggerSumReport.SetDataSource(pizzariaDataSet);
getAllOrdersWithBiggerSumReport.SetParameterValue("Sum", sum);
crystalReportViewer1.ReportSource = getAllOrdersWithBiggerSumReport;
break;
case 6:
getDetailedOrderTableAdapter.Fill(pizzariaDataSet.GetDetailedOrder);
getDetailedOrderReport.SetDataSource(pizzariaDataSet);
crystalReportViewer1.ReportSource = getDetailedOrderReport;
break;
default:
MessageBox.Show("Моля изберете отчет от списъка!!", "Изберете отчет", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
break;
}
}
}
}