public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SuppDetailsPrint rpt = new SuppDetailsPrint(); rpt.Site = this.Site; return(rpt); }
private void PrintDetails_Load(object sender, EventArgs e) { Payroll pr = new Payroll(); Customer cr = new Customer(); string MyConnectionString; MySqlConnection con; //MySqlDataReader rdr; MyConnectionString = "Server=localhost;Database=csms;Uid=corpinfo;Pwd=kvvk;"; con = new MySqlConnection(MyConnectionString); con.Open(); if (Test_GUI_for_Inventory_App.Validations.flagReport == "Emp") { string stm = "SELECT * from employee_details where emp_id='" + payroll_emp_id + "'"; MySqlCommand cmd = new MySqlCommand(stm, con); //csmsDataSet ds = new csmsDataSet(); DataSet ds = new DataSet(); MySqlDataAdapter myDataAdapter = new MySqlDataAdapter(); myDataAdapter.SelectCommand = cmd; myDataAdapter.Fill(ds, "employee_details"); //ds.Fill(ds, "Product"); //MessageBox.Show(ds.Tables[1].Rows.Count.ToString()); //con.Close(); EmpDetailsPrint objRpt = new EmpDetailsPrint(); objRpt.SetDataSource(ds); crystalReportViewer1.ReportSource = objRpt; crystalReportViewer1.Refresh(); } else if (Test_GUI_for_Inventory_App.Validations.flagReport == "Cust") { string stm = "SELECT * from cust_details where cust_id='" + customer_cust_id + "'"; MySqlCommand cmd = new MySqlCommand(stm, con); //csmsDataSet ds = new csmsDataSet(); DataSet ds = new DataSet(); MySqlDataAdapter myDataAdapterCust = new MySqlDataAdapter(); myDataAdapterCust.SelectCommand = cmd; myDataAdapterCust.Fill(ds, "cust_details"); //ds.Fill(ds, "Product"); //MessageBox.Show(ds.Tables[1].Rows.Count.ToString()); //con.Close(); CustDetailsPrint objRpt = new CustDetailsPrint(); objRpt.SetDataSource(ds); crystalReportViewer1.ReportSource = objRpt; crystalReportViewer1.Refresh(); } else if (Test_GUI_for_Inventory_App.Validations.flagReport == "Supp") { string stm = "SELECT * from dealer_details where dealer_id='" + supplier_supp_id + "'"; MySqlCommand cmd = new MySqlCommand(stm, con); //csmsDataSet ds = new csmsDataSet(); DataSet ds = new DataSet(); MySqlDataAdapter myDataAdapterCust = new MySqlDataAdapter(); myDataAdapterCust.SelectCommand = cmd; myDataAdapterCust.Fill(ds, "dealer_details"); //ds.Fill(ds, "Product"); //MessageBox.Show(ds.Tables[1].Rows.Count.ToString()); //con.Close(); SuppDetailsPrint objRpt = new SuppDetailsPrint(); objRpt.SetDataSource(ds); crystalReportViewer1.ReportSource = objRpt; crystalReportViewer1.Refresh(); } else if (Test_GUI_for_Inventory_App.Validations.flagReport == "Bill") { //string stm = "SELECT a.model_id, a.amount, a.quantity, b.total_amount from sale_item a, cust_bill b where a.sale_order_id=b.sale_order_id and a.sale_order_id='" + bill_order_id + "'"; string stm = "SELECT model_id, amount, quantity, sale_order_id from sale_item where sale_order_id='" + bill_order_id + "'"; MySqlCommand cmd = new MySqlCommand(stm, con); //csmsDataSet ds = new csmsDataSet(); DataSet ds = new DataSet(); //DataSet ds1 = new DataSet(); MySqlDataAdapter myDataAdapterCust = new MySqlDataAdapter(); myDataAdapterCust.SelectCommand = cmd; myDataAdapterCust.Fill(ds, "sale_item"); //myDataAdapterCust.Fill(ds1, "cust_bill"); //ds.Fill(ds, "Product"); //MessageBox.Show(ds.Tables[1].Rows.Count.ToString()); //con.Close(); Invoice objRpt = new Invoice(); objRpt.SetDataSource(ds); //objRpt.SetDataSource(ds1); crystalReportViewer1.ReportSource = objRpt; crystalReportViewer1.Refresh(); } }