public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PayslipOLAX_Letter_RPT rpt = new PayslipOLAX_Letter_RPT();
rpt.Site = this.Site;
return(rpt);
}
private void cmdDisplay_Click(object sender, EventArgs e)
{
Int32 progressBarCount = 0;
Decimal DecPercentage = 0;
Boolean boolDataAvailable = true;
lblPer.Text = "0%";
LblProgress.Text = "";
if (chkPrePrinted.Checked)
{
if (!chkMultiCrop.Checked)
{
#region OneCropTea
//try
//{
DataSet dataSetReport = new DataSet();
DataSet dsEmp = new DataSet();
DataTable dt = null;
dsEmp = myReports.GetAllEmployeeListForPayslip(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
progressBarCount = dsEmp.Tables[0].Rows.Count;
if (progressBarCount > 0)
{
progressBar1.Maximum = progressBarCount + 1;
progressBar1.Value = 1;
foreach (DataRow drow in dsEmp.Tables[0].Rows)
{
if (dt == null)
{
dt = myReports.getSalarySlipsPrePrintedBPLOLAX_APL_Tea(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), false, drow[0].ToString());
}
else
{
dt.Merge(myReports.getSalarySlipsPrePrintedBPLOLAX_APL_Tea(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), false, drow[0].ToString()));
}
progressBar1.Value++;
DecPercentage = (progressBar1.Value * 100) / progressBarCount;
lblPer.Text = DecPercentage + "%";
LblProgress.Text = "EmpNo:" + drow[0].ToString() + " Is Processed...";
Application.DoEvents();
}
}
else
{
boolDataAvailable = false;
}
//if (rbtnCashWork.Checked)
//{
// //if (chkOlaxPayslip.Checked)
// // dt = myReports.getSalarySlipsPrePrintedCWOLAX(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()),true);
//}
//else
//{
// if (chkOlaxPayslip.Checked)
//dt = myReports.getSalarySlipsPrePrintedBPLOLAX(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), false);
//}
progressBar1.Value = progressBarCount + 1;
dt.TableName = "PaySlips";
dataSetReport.Tables.Add(dt);
dataSetReport.WriteXml("PaySlips.xml");
lblPer.Text = "100%";
LblProgress.Text = "";
//PaySlipOLAXRPT myaclist = new PaySlipOLAXRPT();
if (chkPrePrinted.Checked)
{
if (rbtnA4.Checked)
{
PayslipOLAX_A4_RPT myaclist = new PayslipOLAX_A4_RPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
//myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
myaclist.SetParameterValue("DivisionID", myDivision.GetDivisionName(cmbDivision.SelectedValue.ToString()).Tables[0].Rows[0][0].ToString() + " - " + " Month of " + cmbMonth.Text + " " + cmbYear.Text);
myaclist.SetParameterValue("Title", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
dt.Dispose();
progressBar1.Value = 0;
}
else if (rbtnLetter.Checked)
{
PayslipOLAX_Letter_RPT myaclist = new PayslipOLAX_Letter_RPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
myaclist.SetParameterValue("DivisionID", myDivision.GetDivisionName(cmbDivision.SelectedValue.ToString()).Tables[0].Rows[0][0].ToString() + " - " + " Month of " + cmbMonth.Text + " " + cmbYear.Text);
myaclist.SetParameterValue("Title", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
dt.Dispose();
progressBar1.Value = 0;
}
else
{
PayslipOLAX_USFanfold_Preprinted_RPT myaclist = new PayslipOLAX_USFanfold_Preprinted_RPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
myaclist.SetParameterValue("DivisionID", myDivision.GetDivisionName(cmbDivision.SelectedValue.ToString()).Tables[0].Rows[0][0].ToString() + " - " + " Month of " + cmbMonth.Text + " " + cmbYear.Text);
myaclist.SetParameterValue("Title", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
dt.Dispose();
progressBar1.Value = 0;
}
/*End*/
}
#endregion
}
else
{
#region MultiCropPayslip
//try
//{
DataSet dataSetReport = new DataSet();
DataSet dsEmp = new DataSet();
DataTable dt = null;
dsEmp = myReports.GetAllEmployeeListForPayslip(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
progressBarCount = dsEmp.Tables[0].Rows.Count;
if (progressBarCount > 0)
{
progressBar1.Maximum = progressBarCount + 1;
progressBar1.Value = 1;
foreach (DataRow drow in dsEmp.Tables[0].Rows)
{
if (dt == null)
{
dt = myReports.getSalarySlipsPrePrintedBPLOLAX_APL_MultiCrop(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), false, drow[0].ToString());
}
else
{
dt.Merge(myReports.getSalarySlipsPrePrintedBPLOLAX_APL_MultiCrop(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), false, drow[0].ToString()));
}
progressBar1.Value++;
DecPercentage = (progressBar1.Value * 100) / progressBarCount;
lblPer.Text = DecPercentage + "%";
LblProgress.Text = "EmpNo:" + drow[0].ToString() + " Is Processed...";
Application.DoEvents();
}
}
else
{
boolDataAvailable = false;
}
//if (rbtnCashWork.Checked)
//{
// //if (chkOlaxPayslip.Checked)
// // dt = myReports.getSalarySlipsPrePrintedCWOLAX(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()),true);
//}
//else
//{
// if (chkOlaxPayslip.Checked)
//dt = myReports.getSalarySlipsPrePrintedBPLOLAX(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, cmbEmployeeCategory.Text, Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()), false);
//}
progressBar1.Value = progressBarCount + 1;
dt.TableName = "PaySlips";
dataSetReport.Tables.Add(dt);
dataSetReport.WriteXml("PaySlips.xml");
lblPer.Text = "100%";
LblProgress.Text = "";
//PaySlipOLAXRPT myaclist = new PaySlipOLAXRPT();
if (chkPrePrinted.Checked)
{
if (rbtnA4.Checked)
{
PayslipOLAX_A4_RPT myaclist = new PayslipOLAX_A4_RPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
myaclist.SetParameterValue("DivisionID", myDivision.GetDivisionName(cmbDivision.SelectedValue.ToString()).Tables[0].Rows[0][0].ToString() + " - " + " Month of " + cmbMonth.Text + " " + cmbYear.Text);
myaclist.SetParameterValue("Title", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
dt.Dispose();
progressBar1.Value = 0;
}
else if (rbtnLetter.Checked)
{
PayslipOLAX_Letter_RPT myaclist = new PayslipOLAX_Letter_RPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
myaclist.SetParameterValue("DivisionID", myDivision.GetDivisionName(cmbDivision.SelectedValue.ToString()).Tables[0].Rows[0][0].ToString() + " - " + " Month of " + cmbMonth.Text + " " + cmbYear.Text);
myaclist.SetParameterValue("Title", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
dt.Dispose();
progressBar1.Value = 0;
}
else
{
PayslipOLAX_USFanfold_Preprinted_MultiCrop_RTP myaclist = new PayslipOLAX_USFanfold_Preprinted_MultiCrop_RTP();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
myaclist.SetParameterValue("DivisionID", myDivision.GetDivisionName(cmbDivision.SelectedValue.ToString()).Tables[0].Rows[0][0].ToString() + " - " + " Month of " + cmbMonth.Text + " " + cmbYear.Text);
myaclist.SetParameterValue("Title", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
dt.Dispose();
progressBar1.Value = 0;
}
/*End*/
#endregion
}
}
}
}