private void btnBNormList_Click(object sender, EventArgs e)
{
try
{
DataSet dataSetReport = new DataSet();
if (chkAll.Checked)
{
dataSetReport = myReports.getBelowNormList(dtpFrom.Value.Date, dtpTo.Value.Date, "%");
}
else
{
dataSetReport = myReports.getBelowNormList(dtpFrom.Value.Date, dtpTo.Value.Date, cmbDivision.SelectedValue.ToString());
}
dataSetReport.WriteXml("BelowNormList.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
BelowNormListRPT myaclist = new BelowNormListRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Period", "From : " + dtpFrom.Value.Date + " To : " + dtpTo.Value.Date);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
String AllDiv = "%";
String AllCat = "%";
String AllGender = "%";
if (!chkAllDiv.Checked)
{
AllDiv = cmbDivision.SelectedValue.ToString();
}
if (!chkAllCat.Checked)
{
AllCat = cmbAllCat.SelectedValue.ToString();
}
if (!chkAllGender.Checked)
{
AllGender = cmbAllGender.SelectedValue.ToString();
}
ds = objListing.getEmployeeDetails(AllDiv, AllCat, AllGender);
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("EmployeeDetails.xml");
EmployeeDetailsRep myReport = new EmployeeDetailsRep();
myReport.SetDataSource(ds);
ReportViewer myReportViewer = new ReportViewer();
myReport.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReport.SetParameterValue("Estate", "ESTATE :" + myUser.GetEstates().Tables[0].Rows[0][1].ToString());
myReportViewer.crystalReportViewer1.ReportSource = myReport;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
//dt = myRep.GetAmalgamation(cmbYear.Text, month);
dt = DFieldSummary.ListDailyFieldSummary(cmbDivision.SelectedValue.ToString(), Convert.ToDateTime(dateTimePicker1.Value.Date.ToShortDateString()));
if (dt.Rows.Count > 0)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml("DailyFieldSummaryRep.xml");
DailyFieldSummaryRPT myReport = new DailyFieldSummaryRPT();
myReport.SetDataSource(ds);
ReportViewer myViewer = new ReportViewer();
//myReport.SetParameterValue("Estate", "Estate :" + myDivi.ListEstates().Rows[0][0].ToString()+" Division:"+cmbDivision.SelectedValue.ToString());
//myReport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
//myReport.SetParameterValue("Date:", dateTimePicker1.Value.Date.ToShortDateString());
myReport.SetParameterValue("Estate", "Estate :" + myDivi.ListEstates().Rows[0][0].ToString() + "/ Division:" + cmbDivision.SelectedValue.ToString());
myReport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myReport.SetParameterValue("EntryDate", "Date :" + dateTimePicker1.Value.Date.ToShortDateString());
myViewer.crystalReportViewer1.ReportSource = myReport;
myViewer.Show();
}
else
{
MessageBox.Show("No Data Preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Occurred..!" + ex.Message);
}
}
private void cmdDisplay1_Click(object sender, EventArgs e)
{
try
{
DataSet dataSetReport = new DataSet();
if (chkAll.Checked)
{
dataSetReport = myReports.getMenWomenMandays(dtpFrom.Value.Date.Year);
}
else
{
dataSetReport = myReports.getMenWomenMandays(dtpFrom.Value.Date.Year);
}
dataSetReport.WriteXml("MenWomenManDaysSum.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
MenWomenManDaysRPT myaclist = new MenWomenManDaysRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Period", "Year : " + dtpFrom.Value.Date.Year.ToString());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = objListing.getEPFEmployeeDetails(cmbDivision.SelectedValue.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("EmployeeEPFDetails.xml");
EmployeeEPFDetailsRPT myReport = new EmployeeEPFDetailsRPT();
myReport.SetDataSource(ds);
ReportViewer myReportViewer = new ReportViewer();
myReport.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReport.SetParameterValue("Estate", "ESTATE :" + myUser.GetEstates().Tables[0].Rows[0][1].ToString());
myReportViewer.crystalReportViewer1.ReportSource = myReport;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
private void btnNortifications_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
dataSetReport = myEmployee.ListEmployeesAboveToRetire();
dataSetReport.WriteXml("EmployeesAboveToRetire.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
EmployesAboveToRetireRPT myaclist = new EmployesAboveToRetireRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Estate", myDivision.ListEstates().Rows[0][0].ToString() + " Estate");
myaclist.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
private void btnActiveEmpRegister_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.DataSetName = "ActiveEmployeeEPFRegister";
ds = clsReports.GetEmployeeWiseEPFDetails(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("ActiveEmployeeEPFRegister.xml");
ActiveEmployeeEPFRegisterRPT myReportViewe = new ActiveEmployeeEPFRegisterRPT();
myReportViewe.SetDataSource(ds);
myReportViewe.SetParameterValue("Estate", "Estate:" + myEstate.ListEstates().Rows[0][0].ToString());
myReportViewe.SetParameterValue("Date", "Year: " + cmbYear.SelectedValue.ToString() + "/ Month: " + cmbMonth.SelectedValue.ToString());
myReportViewe.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myReportViewe;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Print", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnDisplay_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
try
{
if (strDivision == "All")
{
dataSetReport.Tables.Add(HoliPay.GetGratuityPayDataReportData("%", Convert.ToInt32(cmbYear.SelectedValue.ToString())));
}
else
{
dataSetReport.Tables.Add(HoliPay.GetGratuityPayDataReportData(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.SelectedValue.ToString())));
}
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("GratuityPayDataPreview.xml");
GratuitypayDataPreview myGPData = new GratuitypayDataPreview();
myGPData.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myGPData.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myGPData.SetParameterValue("Date", cmbYear.SelectedValue.ToString());
myGPData.SetParameterValue("Division", EstDivBlock.ListEstates().Rows[0][0].ToString() + " / " + strDivision);
myReportViewer.crystalReportViewer1.ReportSource = myGPData;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Preview Gratuitypay, \r\n May be Confirmed");
}
}
catch (Exception ex)
{
MessageBox.Show("Error, " + ex.Message);
}
}
private void btnDisplay_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
try
{
if (chkEmpRange.Checked)
{
ds = myReports.getHarvestNamePlkRegister(cmbDivision.SelectedValue.ToString(), Convert.ToDateTime(dtpFrom.Value.Date.ToShortDateString()), Convert.ToDateTime(dtpTo.Value.Date.ToShortDateString()), txtEmpNoFrom.Text, txtEmpNoTo.Text);
}
else
{
ds = myReports.getHarvestNamePlkRegister(cmbDivision.SelectedValue.ToString(), Convert.ToDateTime(dtpFrom.Value.Date.ToShortDateString()), Convert.ToDateTime(dtpTo.Value.Date.ToShortDateString()));
}
ds.WriteXml("CashNamePlkRegister.xml");
if (ds.Tables[0].Rows.Count > 0)
{
CashNamePluckingRegisterRPT myDailyRep = new CashNamePluckingRegisterRPT();
myDailyRep.SetDataSource(ds);
ReportViewer myReportViewer = new ReportViewer();
myDailyRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myDailyRep.SetParameterValue("Date", "From:" + dtpFrom.Value.Date.ToShortDateString() + " To:" + dtpTo.Value.Date.ToShortDateString());
myDailyRep.SetParameterValue("Division", "Division : " + cmbDivision.Text);
myReportViewer.crystalReportViewer1.ReportSource = myDailyRep;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Preview", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDisplay_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
String EmpType = "All";
if (chkAll.Checked)
{
cmbType.Enabled = false;
EmpType = "All";
}
else
{
cmbType.Enabled = true;
EmpType = cmbType.Text;
}
ds = myreport.getContractCWRegister((cmbDivision.SelectedValue.ToString()), (dtDate.Value.Date), 2, EmpType);
ds.WriteXml("ContractCWRegister.xml");
if (ds.Tables[0].Rows.Count > 0)
{
ContractCWRegister myDailyRep = new ContractCWRegister();
myDailyRep.SetDataSource(ds);
ReportViewer myReportViewer = new ReportViewer();
myDailyRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myDailyRep.SetParameterValue("Date", "Date : " + dtDate.Value.Date.ToShortDateString());
myDailyRep.SetParameterValue("Division", "Division : " + cmbDivision.SelectedValue.ToString());
myDailyRep.SetParameterValue("CashWork", "Contract Cash Work - " + cmbType.Text);
myReportViewer.crystalReportViewer1.ReportSource = myDailyRep;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
private void btnBlkPlk_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DateTime Fromdate;
DateTime Todate;
String strDivision = cmbDivision.SelectedValue.ToString();
if (chkDivision.Checked)
{
MessageBox.Show("Please Select a One Division");
cmbDivision.Focus();
}
else
{
strDivision = cmbDivision.SelectedValue.ToString();
Fromdate = Convert.ToDateTime(dtpFromDate.Value.Date.ToShortDateString());
Todate = Convert.ToDateTime(dtpToDate.Value.Date.ToShortDateString());
ds = clsReports.ListBlockPluckingDetails(Fromdate, Todate, strDivision);
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("BlockPlkDetails.xml");
DivisionWiseBlockPlkSummary myReportViewe = new DivisionWiseBlockPlkSummary();
myReportViewe.SetDataSource(ds);
myReportViewe.SetParameterValue("Estate", "Estate:" + myEstate.ListEstates().Rows[0][0].ToString() + " / DivisionID:" + cmbDivision.SelectedValue.ToString());
myReportViewe.SetParameterValue("Date", "From: " + Fromdate.ToShortDateString() + " To: " + Todate.ToShortDateString());
myReportViewe.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myReportViewe;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Print", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
DateTime dtStartDate, dtEndDate;
String strAllEmp = "%";
dtStartDate = myEmpwork.GetStartDate(int.Parse(cmbYear.Text.ToString()), int.Parse(cmbMonth.SelectedValue.ToString()));
dtEndDate = myEmpwork.GetEndDateOfMonth(dtStartDate);
if (chkAll.Checked)
{
strAllEmp = "%";
}
else
{
strAllEmp = cmbEmpNo.SelectedValue.ToString();
}
dataSetReport = myEmpwork.GetEmpWorkHis(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivisionID.SelectedValue.ToString(), strAllEmp);
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmpWorkHistory.xml");
EmpWorkHistory EmpWrkHis = new EmpWorkHistory();
EmpWrkHis.SetDataSource(dataSetReport);
EmpWrkHis.SetParameterValue("Estate", "Estate :" + mydiv.ListEstates().Rows[0][0].ToString());
EmpWrkHis.SetParameterValue("Period", "For the month :" + cmbMonth.Text + " / " + cmbYear.Text);
ReportViewer myRepView = new ReportViewer();
myRepView.crystalReportViewer1.ReportSource = EmpWrkHis;
myRepView.Show();
}
else
{
MessageBox.Show("No Data to Preview");
}
}
private void btnCashSundry_Click(object sender, EventArgs e)
{
String strAllDivision = "%";
if (chkDivision.Checked)
{
strAllDivision = "%";
}
else
{
strAllDivision = cmbDivision.SelectedValue.ToString();
}
dataSetReport = myReports.getEmployeeSundryManDaysDetails(Convert.ToDateTime(dtpFromDate.Value.ToShortDateString()), Convert.ToDateTime(dtpToDate.Value.ToShortDateString()), 2, strAllDivision);
dataSetReport.WriteXml("EmployeeCashSundryManDaysDetail.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
CashSundryManDays rptObj = new CashSundryManDays();
rptObj.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
rptObj.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
rptObj.SetParameterValue("Estate", myEstate.ListEstates().Rows[0][0].ToString());
rptObj.SetParameterValue("Options", "Division : " + cmbDivision.Text.ToString() + " / From:" + dtpFromDate.Value.ToShortDateString() + " To:" + dtpToDate.Value.ToShortDateString());
rptObj.SetParameterValue("WorkType", "Work Type : Cash Work");
myReportViewer.crystalReportViewer1.ReportSource = rptObj;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
private void cmdDisplay2_Click(object sender, EventArgs e)
{
DataSet ds = myGuarantee.GetGuaranteeRecoveryList(cmbDivision.Text, cmbYear.Text, cmbMonth.SelectedValue.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("GuaranteeRecovery.xml");
GuaranteeRecoveryRPT myRPT = new GuaranteeRecoveryRPT();
myRPT.SetDataSource(ds);
myRPT.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myRPT.SetParameterValue("Division", "DivisionID : " + cmbDivision.Text);
myRPT.SetParameterValue("Period", "Period : " + cmbYear.Text + " - " + cmbMonth.Text);
ReportViewer myViewer = new ReportViewer();
myViewer.crystalReportViewer1.ReportSource = myRPT;
myViewer.crystalReportViewer1.ShowRefreshButton = false;
myViewer.Show();
}
else
{
MessageBox.Show("No data to preview..!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getCoinAnalysis(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(cmbDeduct.SelectedValue.ToString()), cmbDivision.SelectedValue.ToString());
//dataSetReport = myReports.GetMonthlyAdvanceReport(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.Text, Convert.ToInt32(cmbDeduct.SelectedValue.ToString()));
dataSetReport.WriteXml("MACoinAnalysis.xml");
MonthlyAdvanceCoinAnalysisRPT myaclist = new MonthlyAdvanceCoinAnalysisRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", EstDivBlock.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Period", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
myaclist.SetParameterValue("Deduction", "Advance Code : " + cmbDeduct.Text);
//myaclist.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
//myaclist.SetParameterValue("Month", cmbMonth.Text + " / " + cmbYear.Text);
//myaclist.SetParameterValue("Division", cmbDivision.Text);
//myaclist.SetParameterValue("Deduction", "Monthly Advance Code : " + cmbDeduct.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
private void cmdDisplay2_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
dataSetReport = myReports.getDebtorList(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.SelectedValue.ToString());
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("DebtorList.xml");
DebtorListRPT myaclist = new DebtorListRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Period", cmbMonth.Text + " of " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
private void cmdDisplay_Click(object sender, EventArgs e)
{
String AllCat = "%";
if (chkAllCat.Checked)
{
AllCat = "%";
}
else
{
AllCat = cmbEmpCat.SelectedValue.ToString();
}
try
{
if (chkAllDivisions.Checked == true)
{
dataSetReport = myReports.getPaymentCheckRoll(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), AllCat);
dataSetReport.WriteXml("PaymentCheckRoll.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
PaymentCheckRollRPT myaclist = new PaymentCheckRollRPT();
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("paramDivision", "ALL");
myaclist.SetParameterValue("paramYearMonth", cmbMonth.Text + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
else
{
dataSetReport = myReports.getPaymentCheckRoll(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), AllCat);
dataSetReport.WriteXml("PaymentCheckRoll.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
PaymentCheckRollRPT myaclist = new PaymentCheckRollRPT();
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("paramDivision", cmbDivision.Text);
myaclist.SetParameterValue("paramYearMonth", 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 IntWorkType;
if (ChkAll.Checked)
{
if (rbtNormal.Checked)
{
IntWorkType = 1;
ds = myReports.GetEmpWorkAttandance(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(IntWorkType));
}
else
{
IntWorkType = 2;
ds = myReports.GetEmpWorkAttandance(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(IntWorkType));
}
}
else
{
if (rbtNormal.Checked)
{
IntWorkType = 1;
ds = myReports.GetEmpWorkAttandance(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(IntWorkType));
}
else
{
IntWorkType = 2;
ds = myReports.GetEmpWorkAttandance(cmbDivision.SelectedValue.ToString(), Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(IntWorkType));
}
}
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("EmployeeWorkAttendance.xml");
EmployeeWorkAttendanceRPT myWorkAtt = new EmployeeWorkAttendanceRPT();
myWorkAtt.SetDataSource(ds);
myWorkAtt.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myWorkAtt.SetParameterValue("Estate", myEstate.ListEstates().Rows[0][0].ToString());
if (ChkAll.Checked)
{
myWorkAtt.SetParameterValue("Options", "Division : ALL / Month:" + cmbMonth.Text + "/" + cmbYear.Text);
}
else
{
myWorkAtt.SetParameterValue("Options", "Division : " + cmbDivision.Text + " Month: " + cmbMonth.Text + "/" + cmbYear.Text);
}
if (IntWorkType == 1)
{
myWorkAtt.SetParameterValue("WorkType", "Work Type : Normal Work");
}
else
{
myWorkAtt.SetParameterValue("WorkType", "Work Type : Cash Work");
}
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myWorkAtt;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
private void button1_Click(object sender, EventArgs e)
{
String strDiv = "%";
String strWorkType = "%";
DataSet ds = new DataSet();
if (ChkAll.Checked)
{
strDiv = "%";
}
else
{
strDiv = cmbDivision.SelectedValue.ToString();
}
if (rbtNormal.Checked)
{
strWorkType = "1";
ds = myReports.GetEmpWorkDetailManDaysWorkCode(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), strWorkType, strDiv);
}
else
{
strWorkType = "2";
ds = myReports.GetEmpWorkDetailManDaysWorkCode(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), strWorkType, strDiv);
}
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("EmployeeWorkDetailMandaysWorkCode.xml");
if (chkWithManDays.Checked)
{
EmpWorkDetailsMandaysWorkCodeRPT myWorkAtt = new EmpWorkDetailsMandaysWorkCodeRPT();
myWorkAtt.SetDataSource(ds);
myWorkAtt.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myWorkAtt.SetParameterValue("Estate", myEstate.ListEstates().Rows[0][0].ToString());
if (ChkAll.Checked)
{
myWorkAtt.SetParameterValue("Options", "Division : ALL / Month:" + cmbMonth.Text + "/" + cmbYear.Text);
}
else
{
myWorkAtt.SetParameterValue("Options", "Division : " + cmbDivision.Text + " Month: " + cmbMonth.Text + "/" + cmbYear.Text);
}
if (strWorkType == "1")
{
myWorkAtt.SetParameterValue("WorkType", "Work Type : Normal Work");
}
else
{
myWorkAtt.SetParameterValue("WorkType", "Work Type : Cash Work");
}
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myWorkAtt;
myReportViewer.Show();
}
else
{
EmpWorkDetailsWorkcodeRPT myWorkAtt = new EmpWorkDetailsWorkcodeRPT();
myWorkAtt.SetDataSource(ds);
myWorkAtt.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myWorkAtt.SetParameterValue("Estate", myEstate.ListEstates().Rows[0][0].ToString());
if (ChkAll.Checked)
{
myWorkAtt.SetParameterValue("Options", "Division : ALL / Month:" + cmbMonth.Text + "/" + cmbYear.Text);
}
else
{
myWorkAtt.SetParameterValue("Options", "Division : " + cmbDivision.Text + " Month: " + cmbMonth.Text + "/" + cmbYear.Text);
}
if (strWorkType == "1")
{
myWorkAtt.SetParameterValue("WorkType", "Work Type : Normal Work");
}
else
{
myWorkAtt.SetParameterValue("WorkType", "Work Type : Cash Work");
}
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myWorkAtt;
myReportViewer.Show();
}
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
private void btnView_Click(object sender, EventArgs e)
{
String strAllDiv = "%";
String strAllEmp = "%";
String strAllDeductCode = "%";
String ReportName = "";
ReportViewer myReportViewer = new ReportViewer();
if (!chkAll.Checked)
{
strAllDiv = cmbDivision.SelectedValue.ToString();
ReportName = cmbDivision.SelectedValue.ToString() + " Division -";
}
else
{
ReportName = "All Division - ";
}
//if (!chkAllEmp.Checked)
//{
// strAllEmp = cmbEmpNo.SelectedValue.ToString();
//}
//else
//{
// ReportName += " All Employees - ";
//}
if (!chkAllDeduction.Checked)
{
strAllDeductCode = cmbDeductCode.SelectedValue.ToString();
ReportName += cmbDeductCode.SelectedValue.ToString() + " Deduction ";
}
else
{
ReportName += " All Deductions ";
}
DataSet DsDeductSearch = new DataSet();
if (chkAllEmp.Checked == true)
{
ReportName += " - All Employee ";
DsDeductSearch = myDeducSearch.GetDeductionSearchData(strAllDiv, strAllDeductCode, strAllEmp, cmbYear.SelectedValue.ToString(), cmbMonth.SelectedValue.ToString());
}
else
{
String empNoFrom = txtEmpFrom.Text.Trim().ToString();
String empNoTo = txtEmpTo.Text.Trim().ToString();
ReportName += "EmpNo- From" + txtEmpFrom.Text.ToString() + " to " + txtEmpTo.Text.ToString();
DsDeductSearch = myDeducSearch.GetDeductionSearchDataByEmpNoRange(strAllDiv, strAllDeductCode, strAllEmp, cmbYear.SelectedValue.ToString(), cmbMonth.SelectedValue.ToString(), empNoFrom, empNoTo);
}
if (DsDeductSearch.Tables[0].Rows.Count > 0)
{
DsDeductSearch.WriteXml("DeductionSearchData.xml");
DeductionSearchReportRPT myAllDeducAllEmp = new DeductionSearchReportRPT();
myAllDeducAllEmp.SetDataSource(DsDeductSearch);
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);
myAllDeducAllEmp.SetParameterValue("RepName", ReportName);
myReportViewer.crystalReportViewer1.ReportSource = myAllDeducAllEmp;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview..!");
}
}
private void button2_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, false);
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, false);
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)
{
String strDivision;
String strWorkType;
try
{
if (rbNormal.Checked)
{
strWorkType = "Normal Work";
}
else
{
strWorkType = "Cash Work";
}
if (chkAll.Checked)
{
strDivision = "%";
}
else
{
strDivision = cmbDivision.SelectedValue.ToString();
}
DataSet dataSetReport = new DataSet();
if (rbNormal.Checked)
{
dataSetReport = myReports.getPluckingKilos(dtpFrom.Value.Date, dtpTo.Value.Date, strDivision, 1);
}
else
{
dataSetReport = myReports.getPluckingKilosCashWork(dtpFrom.Value.Date, dtpTo.Value.Date, strDivision, 2);
}
dataSetReport.WriteXml("PlkKilosReg.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
PluckingKiloRegisterRPT RepObj = new PluckingKiloRegisterRPT();
RepObj.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
RepObj.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
if (chkAll.Checked)
{
RepObj.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString() + " - All Divisions");
}
else
{
RepObj.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString() + " - " + cmbDivision.SelectedValue.ToString());
}
RepObj.SetParameterValue("Period", "From : " + dtpFrom.Value.Date + " To : " + dtpTo.Value.Date);
RepObj.SetParameterValue("WorkType", "Work Type : " + strWorkType);
myReportViewer.crystalReportViewer1.ReportSource = RepObj;
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;
Boolean boolBlockPlk = false;
if (rbGeneral.Checked)
{
wrkType = 1;
boolBlockPlk = false;
}
else if (rbCashwork.Checked)
{
wrkType = 2;
boolBlockPlk = false;
}
else
{
wrkType = 2;
boolBlockPlk = true;
}
if (settings.IsCashOverKgsAvailable() && wrkType == 2)
{
ds = myreport.getHarvestRegisterCashOkg((cmbDivision.SelectedValue.ToString()), (dtDate.Value.Date), wrkType);
ds.WriteXml("DailyHarvestRegisterCashOkgRep.xml");
}
else
{
if (chkEmpRange.Checked)
{
ds = myreport.getHarvestRegister((cmbDivision.SelectedValue.ToString()), (dtDate.Value.Date), wrkType, txtEmpNoFrom.Text, txtEmpNoTo.Text, boolBlockPlk);
ds.WriteXml("DailyHarvestRegisterRep.xml");
}
else
{
ds = myreport.getHarvestRegister((cmbDivision.SelectedValue.ToString()), (dtDate.Value.Date), wrkType, boolBlockPlk);
ds.WriteXml("DailyHarvestRegisterRep.xml");
}
}
if (ds.Tables[0].Rows.Count > 0)
{
if (settings.IsCashOverKgsAvailable() && wrkType == 2)
{
DailyHarvestRegisterCashOKgRPT myDailyRep = new DailyHarvestRegisterCashOKgRPT();
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
{
DailyHarvestRegisterRep myDailyRep = new DailyHarvestRegisterRep();
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
{
if (boolBlockPlk == false)
{
myDailyRep.SetParameterValue("General", "For Cash Work");
}
else
{
myDailyRep.SetParameterValue("General", "For Cash Work-Block Plucking");
}
}
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 btnDisplay_Click(object sender, EventArgs e)
{
if (txtEmpNo.Text.Trim() == "")
{
DataSet ds = new DataSet();
if (chkAll.Checked)
{
ds = myMaster.GetChildrenDetails("%");
}
else
{
ds = myMaster.GetChildrenDetails(DivisionID.SelectedValue.ToString());
}
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("EmployeeChildrendetails.xml");
EmployeeChildrenRegisterRPT myreport = new EmployeeChildrenRegisterRPT();
myreport.SetDataSource(ds);
myreport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName().Trim());
if (chkAll.Checked)
{
myreport.SetParameterValue("Division", "For All Divisions");
}
else
{
myreport.SetParameterValue("Division", "Division : " + DivisionID.Text.Trim());
}
ReportViewer myviewer = new ReportViewer();
myviewer.crystalReportViewer1.ReportSource = myreport;
myviewer.Show();
}
else
{
MessageBox.Show("No data to preview..!");
}
}
else if (txtEmpNo.Text.Trim() != "")
{
DataSet ds = new DataSet();
ds = myMaster.GetChildrenDetails(DivisionID.SelectedValue.ToString(), txtEmpNo.Text.Trim());
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml("EmployeeChildrendetails.xml");
EmployeeChildrenRegisterRPT myreport = new EmployeeChildrenRegisterRPT();
myreport.SetDataSource(ds);
myreport.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName().Trim());
myreport.SetParameterValue("Division", "Division : " + DivisionID.Text.Trim());
ReportViewer myviewer = new ReportViewer();
myviewer.crystalReportViewer1.ReportSource = myreport;
myviewer.Show();
}
else
{
MessageBox.Show("No data to preview..!");
}
}
}
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 btnDisplay_Click(object sender, EventArgs e)
{
DataSet dataSetReport = new DataSet();
DataSet dataSetReportSub = new DataSet();
String strDivisionID = "%";
String strDivisionName = "ALL";
Int32 intworktyp = 1;
DateTime dtFrom;
DateTime dtTo;
if (rbNormal.Checked)
{
intworktyp = 1;
}
else
{
intworktyp = 2;
}
if (chkAllDivisions.Checked)
{
strDivisionID = "%";
}
else
{
strDivisionID = cmbDivision.SelectedValue.ToString();
strDivisionName = cmbDivision.Text;
}
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.DailyWorkDistributionByRange(dtFrom, dtTo, strDivisionID, intworktyp, true);
dataSetReport.WriteXml("DailyWorkDistribution.xml");
dataSetReportSub = myReports.DailyWorkDistributionNONWorkByRange(dtFrom, dtTo, 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", strDivisionName);
myDailyWorkDistributionRPT.SetParameterValue("Period", "From : " + dtFrom.ToShortDateString() + " To : " + dtTo.ToShortDateString());
if (intworktyp == 1)
{
myDailyWorkDistributionRPT.SetParameterValue("WorkType", "For Normal Work");
}
else
{
myDailyWorkDistributionRPT.SetParameterValue("WorkType", "For Cash Work");
}
myDailyWorkDistributionRPT.SetParameterValue("HalfNames", "(Including Half Names)");
myReportViewer.crystalReportViewer1.ReportSource = myDailyWorkDistributionRPT;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data To Preview");
}
}
private void cmdDisplay1_Click(object sender, EventArgs e)
{
if (chkAll.Checked == true)
{
DataSet dataSetReport = new DataSet();
DateTime dtStartDate, dtEndDate;
dtStartDate = MyMovRep.GetStartDate(int.Parse(cmbYear.Text.ToString()), int.Parse(cmbMonth.SelectedValue.ToString()));
dtEndDate = MyMovRep.GetEndDateOfMonth(dtStartDate);
dataSetReport = MyMovRep.GetEmployeeMovements1(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmployeeMovementsRep.xml");
EmployeeMovementReport myMovementRep = new EmployeeMovementReport();
myMovementRep.SetDataSource(dataSetReport);
myMovementRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myMovementRep.SetParameterValue("Estate", "Estate :" + mydiv.ListEstates().Rows[0][0].ToString());
myMovementRep.SetParameterValue("Period", "For the Month of " + cmbMonth.SelectedValue.ToString() + " / " + cmbYear.Text);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myMovementRep;
myReportViewer.Show();
}
else
{
MessageBox.Show(" No Data to Preview ");
}
}
else
{
DataSet dataSetReport = new DataSet();
DateTime dtStartDate, dtEndDate;
dtStartDate = MyMovRep.GetStartDate(int.Parse(cmbYear.Text.ToString()), int.Parse(cmbMonth.SelectedValue.ToString()));
dtEndDate = MyMovRep.GetEndDateOfMonth(dtStartDate);
dataSetReport = MyMovRep.GetEmployeeMovements(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.SelectedValue.ToString());
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmployeeMovementsRep.xml");
EmployeeMovementReport myMovementRep = new EmployeeMovementReport();
myMovementRep.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myMovementRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myMovementRep.SetParameterValue("Estate", "Estate :" + mydiv.ListEstates().Rows[0][0].ToString());
myMovementRep.SetParameterValue("Period", "For the Month of " + cmbMonth.SelectedValue.ToString() + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myMovementRep;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview");
}
}
//dataSetReport = myReports.getEmployeeMovements(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
//dataSetReport.WriteXml("EmployeeMovements.xml");
//EmployeeMovementRPT myaclist = new EmployeeMovementRPT();
//myaclist.SetDataSource(dataSetReport);
//ReportViewer myReportViewer = new ReportViewer();
//myaclist.SetParameterValue("Estate", FTSPayRollBL.Company.getCompanyName());
//myaclist.SetParameterValue("Period", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
//myReportViewer.crystalReportViewer1.ReportSource = myaclist;
//myReportViewer.Show();
}
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 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)
{ }
}
