private void button1_Click(object sender, EventArgs e)
{
try
{
if (String.IsNullOrEmpty(cmbMonth.Text))
{
MessageBox.Show("Select A Time Period.");
}
else
{
Int32 intChkAll = 0;
Int32 intPeriod = 1;
String StrAllDiv = "%";
if (cmbMonth.Text.Equals("Jan-Jun"))
{
intPeriod = 1;
}
else
{
intPeriod = 2;
}
if (chkAll.Checked)
{
intChkAll = 1;
}
if (this.chkAllDiv.Checked)
{
StrAllDiv = "%";
}
else
{
StrAllDiv = cmbDivision.SelectedValue.ToString();
}
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getEPF6Month(Convert.ToInt32(cmbYear.Text), intPeriod, intChkAll, StrAllDiv);
dataSetReport.WriteXml("ePf6MonthReport.xml");
if (intChkAll == 1)
{
EPF6MonthReportAll myEPFRep = new EPF6MonthReportAll();
myEPFRep.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myEPFRep.SetParameterValue("Estate", FTSPayRollBL.Company.getCompanyName());
myEPFRep.SetParameterValue("Period", "January/2012" + " To " + "June/2012");
myReportViewer.crystalReportViewer1.ReportSource = myEPFRep;
myReportViewer.Show();
}
else
{
EPF6MonthReport myEPFRep = new EPF6MonthReport();
myEPFRep.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myEPFRep.SetParameterValue("Estate", FTSPayRollBL.Company.getCompanyName());
myEPFRep.SetParameterValue("Period", "January/2012" + " To " + "June/2012");
myReportViewer.crystalReportViewer1.ReportSource = myEPFRep;
myReportViewer.Show();
}
}
}
catch (Exception ex)
{ }
}
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
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (String.IsNullOrEmpty(cmbMonth.Text))
{
MessageBox.Show("Select A Time Period.");
}
else
{
Int32 intChkAll = 0;
Int32 intPeriod = 1;
String StrAllDiv = "%";
if (cmbMonth.Text.Equals("Jan-Jun"))
{
intPeriod = 1;
}
else
{
intPeriod = 2;
}
if (chkAll.Checked)
{
intChkAll = 1;
}
if (chkAllDiv.Checked)
{
StrAllDiv = "%";
}
else
{
StrAllDiv = cmbDivision.SelectedValue.ToString();
}
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getETF6Month(Convert.ToInt32(cmbYear.Text), intPeriod, intChkAll, StrAllDiv);
dataSetReport.WriteXml("ETF6MonthReport.xml");
if (intChkAll == 1)
{
ETF6MonthReportAll myEPFRep = new ETF6MonthReportAll();
myEPFRep.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myEPFRep.SetParameterValue("Estate", "Employer's Registration No : 269/S ");
myEPFRep.SetParameterValue("Period", "Return for the period January to June 2012");
myReportViewer.crystalReportViewer1.ReportSource = myEPFRep;
myReportViewer.Show();
}
else
{
ETF6MonthReport myEPFRep = new ETF6MonthReport();
myEPFRep.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myEPFRep.SetParameterValue("Estate", "Employer's Registration No : 269/S ");
myEPFRep.SetParameterValue("Period", "Return for the period January to June 2012");
myReportViewer.crystalReportViewer1.ReportSource = myEPFRep;
myReportViewer.Show();
}
}
}
catch (Exception ex)
{ }
}
private void btnDisplay_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
DataSet dataSetReportSub = new DataSet();
String strDivisionID = "%";
Int32 intworktyp = 1;
if (rbNormal.Checked)
{
intworktyp = 1;
}
else
{
intworktyp = 2;
}
if (chkAllDivisions.Checked)
{
strDivisionID = "%";
}
else
{
strDivisionID = cmbDivision.SelectedValue.ToString();
}
if (chkDateRange.Checked)
{
dataSetReport = myReports.DailyWorkDistributionByRange(dtpFrom.Value.Date, dtpTo.Value.Date, strDivisionID, intworktyp, true);
dataSetReport.WriteXml("DailyWorkDistribution.xml");
dataSetReportSub = myReports.DailyWorkDistributionNONWorkByRange(dtpFrom.Value.Date, dtpTo.Value.Date, strDivisionID, intworktyp);
dataSetReportSub.WriteXml("DailyWorkDistributionSub.xml");
}
else
{
dataSetReport = myReports.DailyWorkDistribution(Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(cmbYear.SelectedValue.ToString()), strDivisionID, intworktyp, true);
dataSetReport.WriteXml("DailyWorkDistribution.xml");
dataSetReportSub = myReports.DailyWorkDistributionNONWork(Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(cmbYear.SelectedValue.ToString()), strDivisionID, intworktyp);
dataSetReportSub.WriteXml("DailyWorkDistributionSub.xml");
}
if (dataSetReport.Tables[0].Rows.Count > 0)
{
DailyWorkDistribution1RPT myDailyWorkDistributionRPT = new DailyWorkDistribution1RPT();
myDailyWorkDistributionRPT.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myDailyWorkDistributionRPT.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myDailyWorkDistributionRPT.SetParameterValue("DivisionName", "ALL");
if (chkDateRange.Checked)
{
myDailyWorkDistributionRPT.SetParameterValue("Period", "From : " + dtpFrom.Value.Date.ToShortDateString() + " To : " + dtpTo.Value.Date.ToShortDateString());
}
else
{
myDailyWorkDistributionRPT.SetParameterValue("Period", "Month : " + cmbMonth.Text + " / " + cmbYear.Text);
}
if (intworktyp == 1)
{
myDailyWorkDistributionRPT.SetParameterValue("WorkType", "For Normal Work");
}
else
{
myDailyWorkDistributionRPT.SetParameterValue("WorkType", "For Cash Work");
}
myReportViewer.crystalReportViewer1.ReportSource = myDailyWorkDistributionRPT;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Preview");
}
}
private void cmdDisplay_Click(object sender, EventArgs e)
{
try
{
if (chkAllDivisions.Checked == true)
{
if (chkAllCategory.Checked == true)
{
dataSetReport = myReports.getGreenLeafRegister(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
dataSetReport.WriteXml("GreenLeafRegister.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
GreenLeafRegisterRPT myaclist = new GreenLeafRegisterRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Options", "For All Divisions for the Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No data to preview..!");
}
}
else
{
dataSetReport = myReports.getGreenLeafRegister(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbEmployeeCategory.SelectedValue.ToString());
dataSetReport.WriteXml("GreenLeafRegister.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
GreenLeafRegisterRPT myaclist = new GreenLeafRegisterRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Options", "For All Divisions and for the Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No data to preview..!");
}
}
}
else
{
if (chkAllCategory.Checked == true)
{
dataSetReport = myReports.getGreenLeafRegister(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
dataSetReport.WriteXml("GreenLeafRegister.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
GreenLeafRegisterRPT myaclist = new GreenLeafRegisterRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Options", "For Division : " + cmbDivision.Text + " for the Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No data to preview..!");
}
}
else
{
dataSetReport = myReports.getGreenLeafRegister(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbEmployeeCategory.SelectedValue.ToString());
dataSetReport.WriteXml("GreenLeafRegister.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
GreenLeafRegisterRPT myaclist = new GreenLeafRegisterRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Options", "For Division : " + cmbDivision.Text + " for the 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);
}
}
private void btnDisplay_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
Int32 wrkType = 1;
if (rbGeneral.Checked)
{
wrkType = 1;
}
else
{
wrkType = 2;
}
ds = myreport.getHarvestRegisterRubber(cmbDivision.SelectedValue.ToString(), Convert.ToDateTime(dtDate.Value.Date.ToShortDateString()), wrkType);
ds.WriteXml("DailyHarvestRegisterRubberRep.xml");
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[1].Rows.Count > 0)
{
DailyHarvestRegisterRubberRPT myDailyRep = new DailyHarvestRegisterRubberRPT();
myDailyRep.SetDataSource(ds);
ReportViewer myReportViewer = new ReportViewer();
myDailyRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myDailyRep.SetParameterValue("Date", dtDate.Value.Date.ToShortDateString());
myDailyRep.SetParameterValue("Division", "Division : " + cmbDivision.Text);
if (wrkType == 1)
{
myDailyRep.SetParameterValue("General", "For Normal Work");
}
else
{
myDailyRep.SetParameterValue("General", "For Cash Work");
}
myDailyRep.SetParameterValue("CashWork", "");
try
{
if (myEntries.IsDayExistsInCHKDateConfirmations(dtDate.Value.Date))
{
if (Convert.ToBoolean(myEntries.IsDailyEntryConfirmed(dtDate.Value.Date).Rows[0][0].ToString()) == true)
{
myDailyRep.SetParameterValue("ConfirmYesNo", "Entries Confirmed");
}
else
{
myDailyRep.SetParameterValue("ConfirmYesNo", "Confirmation Pending");
}
}
else
{
myDailyRep.SetParameterValue("ConfirmYesNo", "Confirmation Pending");
}
}
catch (Exception ex)
{
}
myReportViewer.crystalReportViewer1.ReportSource = myDailyRep;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
private void cmdDisplay_Click(object sender, EventArgs e)
{
try
{
String strDivision = "";
if (chkActiveDiv.Checked)
{
strDivision = cmbDivision.SelectedValue.ToString();
dataSetReport = myReports.getDivisionAmalgamation(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), strDivision.ToString());
dataSetReport.WriteXml("DivisionAmalgamation.xml");
}
else
{
strDivision = "";
dataSetReport = myReports.getDivisionAmalgamation(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
dataSetReport.WriteXml("DivisionAmalgamation.xml");
}
if (dataSetReport.Tables[0].Rows.Count > 0)
{
DivisionAmalgamationRPT myaclist = new DivisionAmalgamationRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
if (chkActiveDiv.Checked)
{
myaclist.SetParameterValue("Division", "Division : " + cmbDivision.Text);
}
else
{
myaclist.SetParameterValue("Division", strDivision.ToString());
}
myaclist.SetParameterValue("Options", "For the Month of : " + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
//}
//else
//{
// dataSetReport = myReports.getDivisionAmalgamation(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(cmbEmployeeCategory.SelectedValue.ToString()));
// dataSetReport.WriteXml("DivisionAmalgamation.xml");
// if (dataSetReport.Tables[0].Rows.Count > 0)
// {
// DivisionAmalgamationRPT myaclist = new DivisionAmalgamationRPT();
// myaclist.SetDataSource(dataSetReport);
// ReportViewer myReportViewer = new ReportViewer();
// myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
// myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
// myaclist.SetParameterValue("Options", "For All Divisions and Category of : " + cmbEmployeeCategory.Text + " for the 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);
}
//}
//else
//{
// if (chkAllCategory.Checked == true)
// {
// dataSetReport = myReports.getDivisionAmalgamation(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
// dataSetReport.WriteXml("DivisionAmalgamation.xml");
// DivisionAmalgamationRPT myaclist = new DivisionAmalgamationRPT();
// myaclist.SetDataSource(dataSetReport);
// ReportViewer myReportViewer = new ReportViewer();
// myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
// myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
// myaclist.SetParameterValue("Options", "For All Categories and Division : " + cmbDivision.Text + " for the Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
// myReportViewer.crystalReportViewer1.ReportSource = myaclist;
// myReportViewer.Show();
// }
// else
// {
// dataSetReport = myReports.getDivisionAmalgamation(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbEmployeeCategory.SelectedValue.ToString());
// dataSetReport.WriteXml("DivisionAmalgamation.xml");
// DivisionAmalgamationRPT myaclist = new DivisionAmalgamationRPT();
// myaclist.SetDataSource(dataSetReport);
// ReportViewer myReportViewer = new ReportViewer();
// myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
// myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
// myaclist.SetParameterValue("Options", "For Division : " + cmbDivision.Text + " and Category : " + cmbEmployeeCategory.Text + " for the Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
// myReportViewer.crystalReportViewer1.ReportSource = myaclist;
// myReportViewer.Show();
// }
//}
}
private void btnView_Click(object sender, EventArgs e)
{
//FTSPayRollBL.Reports myDeducSearch = new FTSPayRollBL.Reports();
ReportViewer myReportViewer = new ReportViewer();
if ((chkAllDeduction.Checked) && (chkAllEmp.Checked))
{
DataSet AllDeducnAllEmp = new DataSet();
AllDeducnAllEmp = myDeducSearch.AllDeductAllEmp((cmbDivision.SelectedValue.ToString()), (cmbYear.Text), (cmbMonth.SelectedValue.ToString()));
if (AllDeducnAllEmp.Tables[0].Rows.Count > 0)
{
AllDeducnAllEmp.WriteXml("AllDeductAllEmp.xml");
AllDeductAllEmp myAllDeducAllEmp = new AllDeductAllEmp();
myAllDeducAllEmp.SetDataSource(AllDeducnAllEmp);
myAllDeducAllEmp.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myAllDeducAllEmp.SetParameterValue("Estate", "Estate :" + myEstateDiv.ListEstates().Rows[0][0].ToString());
myAllDeducAllEmp.SetParameterValue("Division", "Division :" + cmbDivision.Text);
myAllDeducAllEmp.SetParameterValue("Period", "For the Month of :" + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myAllDeducAllEmp;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else if ((chkAllDeduction.Checked) && (chkSelfromRange.Checked))
{
DataSet myRangeAllDeduc = new DataSet();
myRangeAllDeduc = myDeducSearch.EmpRangeAllDeduc((cmbDivision.SelectedValue.ToString()), (cmbYear.Text), (cmbMonth.SelectedValue.ToString()), (cmbFromEmpNo.SelectedValue.ToString()), (cmbToEmpNo.SelectedValue.ToString()));
if (myRangeAllDeduc.Tables[0].Rows.Count > 0)
{
myRangeAllDeduc.WriteXml("AllDeducRangeEmp.xml");
AllDeducRangeEmp myAllDeducRangeEmp = new AllDeducRangeEmp();
myAllDeducRangeEmp.SetDataSource(myRangeAllDeduc);
myAllDeducRangeEmp.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myAllDeducRangeEmp.SetParameterValue("Estate", "Estate :" + myEstateDiv.ListEstates().Rows[0][0].ToString());
myAllDeducRangeEmp.SetParameterValue("Division", "Division :" + cmbDivision.Text);
myAllDeducRangeEmp.SetParameterValue("RPTTitle", "All Deductions For Employee From : " + cmbFromEmpNo.Text + " To : " + cmbToEmpNo.Text);
myAllDeducRangeEmp.SetParameterValue("Period", "For the Month of :" + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myAllDeducRangeEmp;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else if (chkAllEmp.Checked)
{
DataSet oneDeducAllEmp = new DataSet();
if (myDeducSearch.BoolAll == true)
{
oneDeducAllEmp = myDeducSearch.OneDeducAllEmpAllDivision((cmbDivision.SelectedValue.ToString()), (cmbYear.Text), (cmbMonth.SelectedValue.ToString()), (cmbDeductCode.SelectedValue.ToString()));
}
else
{
oneDeducAllEmp = myDeducSearch.OneDeducAllEmp((cmbDivision.SelectedValue.ToString()), (cmbYear.Text), (cmbMonth.SelectedValue.ToString()), (cmbDeductCode.SelectedValue.ToString()));
}
if (oneDeducAllEmp.Tables[0].Rows.Count > 0)
{
oneDeducAllEmp.WriteXml("oneDeducAllEmp.xml");
OneDeducAllEmp myOneDeducAllEmp = new OneDeducAllEmp();
myOneDeducAllEmp.SetDataSource(oneDeducAllEmp);
myOneDeducAllEmp.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myOneDeducAllEmp.SetParameterValue("Estate", "Estate :" + myEstateDiv.ListEstates().Rows[0][0].ToString());
myOneDeducAllEmp.SetParameterValue("Division", "Division :" + cmbDivision.Text);
myOneDeducAllEmp.SetParameterValue("RPTTitle", cmbDeductCode.Text + " For All Employees");
myOneDeducAllEmp.SetParameterValue("Period", "For the Month of :" + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myOneDeducAllEmp;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else if (chkAllDeduction.Checked)
{
DataSet myAllDeduc = new DataSet();
myAllDeduc = myDeducSearch.AllDeductEmp((cmbDivision.SelectedValue.ToString()), (cmbYear.Text), (cmbMonth.SelectedValue.ToString()), (cmbEmpNo.SelectedValue.ToString()));
if (myAllDeduc.Tables[0].Rows.Count > 0)
{
myAllDeduc.WriteXml("EmpAllDeductEmp.xml");
AllDeductEmp myAllDeductEmp = new AllDeductEmp();
myAllDeductEmp.SetDataSource(myAllDeduc);
myAllDeductEmp.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myAllDeductEmp.SetParameterValue("Estate", "Estate :" + myEstateDiv.ListEstates().Rows[0][0].ToString());
myAllDeductEmp.SetParameterValue("Division", "Division :" + cmbDivision.Text);
myAllDeductEmp.SetParameterValue("RPTTitle", "Deductions for Employee No :" + cmbEmpNo.Text);
myAllDeductEmp.SetParameterValue("Period", "For the Month of :" + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myAllDeductEmp;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else if (chkSelfromRange.Checked)
{
DataSet myRangeOneDeduc = new DataSet();
myRangeOneDeduc = myDeducSearch.EmpRangeOneDeduc((cmbDivision.SelectedValue.ToString()), (cmbYear.Text), (cmbMonth.SelectedValue.ToString()), (cmbDeductCode.SelectedValue.ToString()), (cmbFromEmpNo.SelectedValue.ToString()), (cmbToEmpNo.SelectedValue.ToString()));
if (myRangeOneDeduc.Tables[0].Rows.Count > 0)
{
myRangeOneDeduc.WriteXml("OneDeducRangeEmp.xml");
OneDeducRangeEmp myOneDeducRangeEmp = new OneDeducRangeEmp();
myOneDeducRangeEmp.SetDataSource(myRangeOneDeduc);
myOneDeducRangeEmp.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myOneDeducRangeEmp.SetParameterValue("Estate", "Estate :" + myEstateDiv.ListEstates().Rows[0][0].ToString());
myOneDeducRangeEmp.SetParameterValue("Division", "Division :" + cmbDivision.Text);
myOneDeducRangeEmp.SetParameterValue("RPTTitle", cmbDeductCode.Text + " For Employee No From :" + cmbFromEmpNo.Text + " To : " + cmbToEmpNo.Text);
myOneDeducRangeEmp.SetParameterValue("Period", "For the Month of :" + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myOneDeducRangeEmp;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else
{
DataSet dataSetReport = new DataSet();
dataSetReport = myDeducSearch.DeducSearch((cmbDivision.SelectedValue.ToString()), (cmbDeductCode.SelectedValue.ToString()), (cmbMonth.SelectedValue.ToString()), (cmbYear.Text), (cmbEmpNo.SelectedValue.ToString()));
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmpDeductionAmount.xml");
EmpDeductionAmount myEmpDeduc = new EmpDeductionAmount();
myEmpDeduc.SetDataSource(dataSetReport);
myEmpDeduc.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myEmpDeduc.SetParameterValue("Estate", "Estate :" + myEstateDiv.ListEstates().Rows[0][0].ToString());
myEmpDeduc.SetParameterValue("Division", "Division :" + cmbDivision.Text);
myEmpDeduc.SetParameterValue("RPTTitle", cmbDeductCode.Text + " For Employee No :" + cmbEmpNo.Text);
myEmpDeduc.SetParameterValue("Period", "For the Month of :" + cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myEmpDeduc;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
}
private void cmdDisplay_Click(object sender, EventArgs e)
{
try
{
Int32 intworktyp = 1;
String strAllDivision = "%";
DateTime dtFrom;
DateTime dtTo;
if (chkDateRange.Checked)
{
dtFrom = dtpFrom.Value.Date;
dtTo = dtpTo.Value.Date;
}
else
{
dtFrom = new DateTime(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), 1);
dtTo = new DateTime(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), 1).AddMonths(1).AddDays(-1);
}
if (chkAllDivisions.Checked)
{
strAllDivision = "%";
}
else
{
strAllDivision = cmbDivision.SelectedValue.ToString();
}
if (rbNormal.Checked)
{
intworktyp = 1;
}
else
{
intworktyp = 2;
}
if (chkAllDivisions.Checked == true)
{
//if (chkAllCategory.Checked == true)
//{
dataSetReport = myReports.getEmployeeAttendance(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), intworktyp);
dataSetReport.WriteXml("EmployeeAttendance.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
EmployeeAttendanceRPT myaclist = new EmployeeAttendanceRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Options", "Division : ALL / Month:" + cmbMonth.Text + "/" + cmbYear.Text);
if (intworktyp == 1)
{
myaclist.SetParameterValue("WorkType", "Work Type : Normal Work");
}
else
{
myaclist.SetParameterValue("WorkType", "Work Type : Cash Work");
}
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else
{
//if (chkAllCategory.Checked == true)
//{
dataSetReport = myReports.getEmployeeAttendance(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), intworktyp);
dataSetReport.WriteXml("EmployeeAttendance.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
EmployeeAttendanceRPT myaclist = new EmployeeAttendanceRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
myaclist.SetParameterValue("Options", "Division : " + cmbDivision.Text + " / Month : " + cmbMonth.Text + "/" + cmbYear.Text);
if (intworktyp == 1)
{
myaclist.SetParameterValue("WorkType", "Work Type : Normal Work");
}
else
{
myaclist.SetParameterValue("WorkType", "Work Type : Cash Work");
}
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void cmdDisplay1_Click(object sender, EventArgs e)
{
String strAllDiv = "%";
String strAllCrop = "%";
Int32 intworktype = 1;
DateTime dtFrom;
DateTime dtTo;
if (chkAllDivisions.Checked)
{
strAllDiv = "%";
}
else
{
strAllDiv = cmbDivision.SelectedValue.ToString();
}
if (!chkAllCrop.Checked)
{
strAllCrop = cmbCropType.SelectedValue.ToString();
//if (Convert.ToInt32(cmbCropType.SelectedValue.ToString()) == 1)
// strAllCrop = "1";
//else
// strAllCrop = "2";
}
if (rbNormal.Checked)
{
intworktype = 1;
}
else
{
intworktype = 2;
}
if (chkDateRange.Checked)
{
dtFrom = dtpFrom.Value.Date;
dtTo = dtpTo.Value.Date;
}
else
{
dtFrom = new DateTime(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), 1);
dtTo = new DateTime(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), 1).AddMonths(1).AddDays(-1);
}
dataSetReport = myReports.getEmployeeAttendanceByCrop(dtFrom, dtTo, intworktype, strAllDiv, strAllCrop);
dataSetReport.WriteXml("EmployeeAttendance.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
EmployeeAttendanceRPT myaclist = new EmployeeAttendanceRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", EstDivBlock.GetClusterName(myDivision.ListEstate().Rows[0][0].ToString(), cmbDivision.SelectedValue.ToString()));
if (chkAllDivisions.Checked)
{
myaclist.SetParameterValue("Options", "Division : ALL / Month:" + cmbMonth.Text + "/" + cmbYear.Text);
}
else
{
myaclist.SetParameterValue("Options", "Division : " + cmbDivision.SelectedValue.ToString() + " / Month:" + cmbMonth.Text + "/" + cmbYear.Text);
}
if (intworktype == 1)
{
myaclist.SetParameterValue("WorkType", "Work Type : Normal Work");
}
else
{
myaclist.SetParameterValue("WorkType", "Work Type : Cash Work");
}
if (chkAllCrop.Checked)
{
myaclist.SetParameterValue("CropType", "Crop Type : All Crop");
}
else
{
myaclist.SetParameterValue("CropType", "Crop Type : " + cmbCropType.Text);
}
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
