/// <summary> /// On 'Print' button click /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { try { if (dgvContraReport.RowCount > 0) { DataSet ds = new DataSet(); CompanySP spCompany = new CompanySP(); frmReport reportobj = new frmReport(); ContraMasterSP spContraMaster = new ContraMasterSP(); DataTable dtblCompany = spCompany.CompanyViewDataTable(1); DataTable dtblCotraReport = spContraMaster.ContraReport(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbVoucherType.Text, cmbCashOrBank.Text, strType); ds.Tables.Add(dtblCompany); ds.Tables.Add(dtblCotraReport); reportobj.MdiParent = formMDI.MDIObj; reportobj.ContraVoucherReport(ds); } else { MessageBox.Show("No data found", "Oneaccount", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { formMDI.infoError.ErrorString = "CRT12:" + ex.Message; } }
/// <summary> /// Function to fill Datagridview /// </summary> public void GridFill() { try { ContraMasterSP spContraMaster = new ContraMasterSP(); DataTable dtbl = new DataTable(); if (rbtnDeposit.Checked) { strType = "Deposit"; } else { strType = "Withdraw"; } dtbl = spContraMaster.ContraReport(Convert.ToDateTime(dtpFromDate.Value.ToString()), Convert.ToDateTime(dtpToDate.Value.ToString()), cmbVoucherType.Text, cmbCashOrBank.Text, strType); dgvContraReport.DataSource = dtbl; } catch (Exception ex) { formMDI.infoError.ErrorString = "CRT3:" + ex.Message; } }