private void cmdDisplay1_Click(object sender, EventArgs e)
{
try
{
String strDivisionID = cmbDivision.SelectedValue.ToString();
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getCheckRollReconcilation(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), (cmbDivision.SelectedValue.ToString()));
dataSetReport.WriteXml("CheckRollReconcilation.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
CheckRollReconcilationRPT1 myaclist = new CheckRollReconcilationRPT1();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Division Name", myDiv.EstateDivision(strDivisionID).Tables[0].Rows[0][0].ToString());
myaclist.SetParameterValue("Period", "Month of " + cmbMonth.Text + "/" + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CheckRollReconcilationRPT1 rpt = new CheckRollReconcilationRPT1();
rpt.Site = this.Site;
return(rpt);
}
private void btnView_Click(object sender, EventArgs e)
{
try
{
String strMonth = cmbMonth.Text;
for (int month = 1; month <= 12; month++)
{
if (strMonth == myMonth.ListMonths().Rows[month - 1][1].ToString())
{
DataTable dt = new DataTable();
dt = myRe.GetReconciliation(cmbYear.Text, month);
if (dt.Rows.Count > 0)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml("ChkReconciliation.xml");
CheckRollReconcilationRPT1 myaclist = new CheckRollReconcilationRPT1();
myaclist.SetDataSource(ds);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", "Estate :" + myDiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Period", "Month of " + cmbMonth.Text + "/" + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error Occurred..!" + ex);
}
}