private void view_report(int nReport, String sCompany, String sCustomerID, bool nView)
{
DataSet ds1;
Signature.Data.MySQL oMySql = new Signature.Data.MySQL(); // Sql Open
switch (nReport)
{
case 1:
ds1 = oMySql.get_summary_by_classes(sCompany, sCustomerID);
summary_by_classes oRpt2 = new summary_by_classes();
oRpt2.SetDataSource(ds1);
if (nView)
{
cReport.ReportSource = oRpt2;
this.Text = "Summary by Classes";
this.Show();
}
else
{
oRpt2.PrintToPrinter(1, true, 1, 100);
}
break;
case 2:
ds1 = oMySql.get_ranking_by_student(sCompany, sCustomerID, this.Selection);
SummaryReport oRpt1 = new SummaryReport();
oRpt1.SetDataSource(ds1);
if (nView)
{
cReport.ReportSource = oRpt1;
this.Text = "Ranking by Student";
this.Show();
}
else
{
oRpt1.PrintToPrinter(1, true, 1, 100);
}
break;
case 3:
ds1 = oMySql.get_summary_of_products_by_brochure(sCompany, sCustomerID);
summary_of_products_by_brochure oRpt3 = new summary_of_products_by_brochure();
oRpt3.SetDataSource(ds1);
if (nView)
{
cReport.ReportSource = oRpt3;
this.Text = "Summary of Products by Brochure";
this.Show();
}
else
{
oRpt3.PrintToPrinter(1, true, 1, 100);
}
break;
case 5:
ds1 = oMySql.get_detail_by_student(sCompany, sCustomerID);
detail_by_student oRpt5 = new detail_by_student();
oRpt5.SetDataSource(ds1);
if (nView)
{
cReport.ReportSource = oRpt5;
this.Text = "Order Detail by Student";
this.Show();
}
else
{
oRpt5.PrintToPrinter(1, true, 1, 100);
}
break;
case 6:
ds1 = oMySql.get_prize_summary_by_student_by_class(sCompany, sCustomerID);
prize_summary_by_student_by_class oRpt6 = new prize_summary_by_student_by_class();
oRpt6.SetDataSource(ds1);
if (nView)
{
cReport.ReportSource = oRpt6;
this.Text = "Prize Summary by Student by Class";
this.Show();
}
else
{
oRpt6.PrintToPrinter(1, true, 1, 100);
}
break;
/*
* case 7:
* ds1 = oMySql.get_summary_reps_sales(sCompany);
* if (ds1 == null)
* MessageBox.Show("BAD");
* summary_reps_sales oRpt7 = new summary_reps_sales();
* Customer oCustomer = new Customer();
* Brochure oBrochure = new Brochure(Global.CurrrentCompany);
* foreach (DataRow row in ds1.Tables["Summary"].Rows)
* {
* if (oCustomer.Find(row["CustomerID"].ToString()))
* {
* if (oBrochure.Find(oCustomer.BrochureID))
* {
* row["BrochureID"] = oCustomer.BrochureID;
* row["Description"] = oBrochure.Description;
* }
* if (oBrochure.Find(oCustomer.BrochureID_2))
* {
* row["BrochureID_2"] = oCustomer.BrochureID_2;
* row["Description_2"] = oBrochure.Description;
* }
* }
* }
*
* oRpt7.SetDataSource(ds1);
* //ds1.WriteXml("..\\Reports\\dataset14.xml", XmlWriteMode.WriteSchema);
* if (nView)
* {
* this.Text = "Summary Rep Sales";
* cReport.ReportSource = oRpt7;
* this.Show();
* }
* else
* oRpt7.PrintToPrinter(1, true, 1, 100);
* break;
*
*/
/*
* case 14:
* {
* ds1 = oMySql.GetPOReceive(sCompany,sParameter_1);
* if (ds1 == null)
* MessageBox.Show("Please check the database");
* // ds1.WriteXml("dataset29.xml", XmlWriteMode.WriteSchema);
* POReceive oRpt = new POReceive();
*
* oRpt.SetDataSource(ds1);
*
* if (nView)
* {
* this.Text = "PO Receive";
* cReport.ReportSource = oRpt;
* this.Show();
* }
* else
* oRpt.PrintToPrinter(1, true, 1, 100);
*
*
* }
* break;
*/
/*
* case 15:
* {
* ds1 = oMySql.GetPOReceive(sCompany, sParameter_1);
* if (ds1 == null)
* MessageBox.Show("Please check the database");
* // ds1.WriteXml("dataset29.xml", XmlWriteMode.WriteSchema);
* POReceive oRpt = new POReceive();
*
* oRpt.SetDataSource(ds1);
*
* if (nView)
* {
* this.Text = "PO Receive";
* cReport.ReportSource = oRpt;
* this.Show();
* }
* else
* oRpt.PrintToPrinter(1, true, 1, 100);
*
*
* }
* break;
*/
default:
break;
}
//oMySql.Close();
}