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..!"); } }