private void btnPrint_Click(object sender, EventArgs e) { rpReports report = new rpReports(); report.HeaderDataset.Clear(); report.HeaderDataset.CompanyInfo.Merge(DataHelper.GetTableData("CompanyInfo").Tables[0]); report.HeaderDataset.CompanyInfo.Rows[0]["ReportName"] = "Policy Deposit# " + cmbPolicy.Text; if (gridView1.RowCount > 0) { report.AddGrid(dgMembersDeposite); report.ShowPreviewDialog(); } }
private void btnPrint_Click(object sender, EventArgs e) { rpReports report = new rpReports(); report.HeaderDataset.Clear(); report.HeaderDataset.CompanyInfo.Merge(DataHelper.GetTableData("CompanyInfo").Tables[0]); report.HeaderDataset.CompanyInfo.Rows[0]["ReportName"] = "Daily Collecton"; if (dtpFromDate.DateTime.ToShortDateString() == dtpToDate.DateTime.ToShortDateString()) { report.HeaderDataset.CompanyInfo.Rows[0]["Date"] = dtpFromDate.DateTime.ToShortDateString(); } else { report.HeaderDataset.CompanyInfo.Rows[0]["Date"] = dtpFromDate.DateTime.ToShortDateString() + " to " + dtpToDate.DateTime.ToShortDateString(); } report.AddGrid(dgCashBook); report.ShowPreviewDialog(); }
private void cmbExport_SelectedIndexChanged(object sender, EventArgs e) { if (cmbExport.EditValue == null) { return; } try { rpReports report = new rpReports(); string _ReportName = "Cash Book"; report.HeaderDataset.Clear(); report.HeaderDataset.CompanyInfo.Merge(DataHelper.GetTableData("CompanyInfo").Tables[0]); report.HeaderDataset.CompanyInfo.Rows[0]["ReportName"] = _ReportName; if (dtpFromDate.DateTime.ToShortDateString() == dtpToDate.DateTime.ToShortDateString()) { report.HeaderDataset.CompanyInfo.Rows[0]["Date"] = dtpFromDate.DateTime.ToShortDateString(); } else { report.HeaderDataset.CompanyInfo.Rows[0]["Date"] = dtpFromDate.DateTime.ToShortDateString() + " to " + dtpToDate.DateTime.ToShortDateString(); } report.AddGrid(dgCashBook); if (cmbExport.EditValue == "Excel") { FolderBrowserDialog fd = new FolderBrowserDialog(); fd.ShowDialog(); string location = fd.SelectedPath; if (location != "") { string FileName = _ReportName + DateTime.Now.Year.ToString().Substring(2) + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + ".xls"; report.ExportToXls(location + "\\" + FileName); } } else if (cmbExport.EditValue == "Word") { FolderBrowserDialog fd = new FolderBrowserDialog(); fd.ShowDialog(); string location = fd.SelectedPath; if (location != "") { string FileName = _ReportName + DateTime.Now.Year.ToString().Substring(2) + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + ".doc"; report.ExportToRtf(location + "\\" + FileName); } } else if (cmbExport.EditValue == "PDF") { FolderBrowserDialog fd = new FolderBrowserDialog(); fd.ShowDialog(); string location = fd.SelectedPath; if (location != "") { string FileName = _ReportName + DateTime.Now.Year.ToString().Substring(2) + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + ".pdf"; report.ExportToPdf(location + "\\" + FileName); } } cmbExport.EditValue = null; } catch (Exception ex) { } MessageBox.Show("Data Export successfully", "Export document", MessageBoxButtons.OK, MessageBoxIcon.Information); }