private void LoadReceipt(string No)
{
reportViewer1.LocalReport.DataSources.Clear();
Orders v = new Orders();
Customer c = new Customer();
Company y = new Company();
v = Orders.SelectNo(No);
y = Company.Select();
/**Company Customer***/
Microsoft.Reporting.WinForms.ReportParameter rp = new Microsoft.Reporting.WinForms.ReportParameter("image", Helper.CompanyImage);
this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { rp });
Coverage er = new Coverage(); //.Select(ItemID);
er = Coverage.SelectType(v.CustomerID, "Primary");
Microsoft.Reporting.WinForms.ReportParameter rps = new Microsoft.Reporting.WinForms.ReportParameter("medicaid", er.No);
this.reportViewer1.LocalReport.SetParameters(new Microsoft.Reporting.WinForms.ReportParameter[] { rps });
MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM delivery WHERE no='" + No + "'", MySQL.Conn);
DataSet ds = new DataSet();
da.Fill(ds);
MySql.Data.MySqlClient.MySqlDataAdapter da3 = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM customer WHERE id='" + v.CustomerID + "'", MySQL.Conn);
DataSet ds3 = new DataSet();
da3.Fill(ds3);
MySql.Data.MySqlClient.MySqlDataAdapter da2 = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT product.name AS itemID ,product.code AS self,product.description AS tax,casetransaction.cost,casetransaction.date as date,casetransaction.no as no,casetransaction.total as total,casetransaction.qty as qty,casetransaction.cost,casetransaction.created,casetransaction.sync,casetransaction.height,casetransaction.limits,casetransaction.weight,casetransaction.setting,casetransaction.instruction,casetransaction.period FROM casetransaction LEFT join product ON casetransaction.itemID = product.id WHERE casetransaction.no='" + No + "'", MySQL.Conn);
DataSet ds2 = new DataSet();
da2.Fill(ds2);
MySql.Data.MySqlClient.MySqlDataAdapter da4 = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM practitioner WHERE id='" + v.PractitionerID + "'", MySQL.Conn);
DataSet ds4 = new DataSet();
da4.Fill(ds4);
ReportDataSource datasource = new ReportDataSource("DataSet1", ds.Tables[0]);
ReportDataSource datasource2 = new ReportDataSource("DataSet2", ds2.Tables[0]);
ReportDataSource datasource3 = new ReportDataSource("DataSet3", ds3.Tables[0]);
ReportDataSource datasource4 = new ReportDataSource("DataSet4", ds4.Tables[0]);
reportViewer1.LocalReport.DataSources.Add(datasource);
reportViewer1.LocalReport.DataSources.Add(datasource2);
reportViewer1.LocalReport.DataSources.Add(datasource3);
reportViewer1.LocalReport.DataSources.Add(datasource4);
reportViewer1.RefreshReport();
}
