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);
}
