public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            OneDeducRangeEmp rpt = new OneDeducRangeEmp();

            rpt.Site = this.Site;
            return(rpt);
        }
        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..!");
                }
            }
        }