using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Payroll.BO;
using Ease.CoreV35.Model;
using Ease.CoreV35;
using Microsoft.Reporting.WinForms;
using Ease.CoreV35.DataAccess;
using Payroll.Service;

namespace Payroll.Report
{
    public partial class FSReport : Form
    {
        double nTotalTaka = 0.0;
        ObjectsTemplate<FSTran> oFSTrans = new ObjectsTemplate<FSTran>();
        private ReportItem _reportitem = null;
        private EnumReportType _reportType = EnumReportType.None;
        private EnumReportType _Type = EnumReportType.None;
        ObjectsTemplate<FSTranDetail> oItemDetails = new ObjectsTemplate<FSTranDetail>();
        ObjectsTemplate<Department> _oDepartments = new ObjectsTemplate<Department>();
        int _nEmpID = 0;
        double dues;
        double less;
        double amt1 = 0.0;
        double amt2 = 0.0;
        double amt3 = 0.0;
        string sDivision = "";
        string sDepartment = "";
        string sUnit = "";
        double nFracAmount = 0.0;
        double nGrossAmount = 0.0;
        double _nGrossPaid = 0;
        private double _Amount = 0;
        private EnumAllowOrDeduct _ADType = EnumAllowOrDeduct.Allowance;
        Employee _oEmp = null;
        public FSReport()
        {
            InitializeComponent();
        }
        public void ShowDlg(DateTime dt, int nEmpID)
        {
            dtpFrom.Value = dt;
            dtpTo.Value = dt;
            _nEmpID = nEmpID;
            this.ShowDialog();
        }

        public EnumReportType Type
        {
            set
            {
                _Type = value;
            }
        }
        private void btnRefresh_Click(object sender, EventArgs e)
        {
            lvwFss.Items.Clear();
            Employee oEmp = new Employee();
            ListViewItem li;
            if (rdoSettleDate.Checked)
                oFSTrans = FSTran.Get(dtpFrom.Value, dtpTo.Value, 1, "");
            else if (rdoDiscontinueDate.Checked)
                oFSTrans = FSTran.Get(dtpFrom.Value, dtpTo.Value, 2, "");
            else if (rdoBatchNumber.Checked)
                oFSTrans = FSTran.Get(dtpFrom.Value, dtpTo.Value, 3, txtBatchNumber.Text);
            foreach (FSTran oItem in oFSTrans)
            {
                li = new ListViewItem();
                oEmp = Employee.Get(oItem.EmployeeID);
                if (oEmp.PayrollTypeID == Payroll.BO.SystemInformation.CurrentSysInfo.PayrollTypeID)
                {
                    li.Text = oEmp.EmployeeNo;
                    li.SubItems.Add(oEmp.Name);
                    li.SubItems.Add(oItem.SettlementDate.ToString("dd MMM yyyy"));
                    li.SubItems.Add(oItem.DiscontinueDate.ToString("dd MMM yyyy"));
                    li.Tag = oItem;
                    lvwFss.Items.Add(li);
                }
            }
            //if (_nEmpID > 0)
            //{
            //    lvwFss.Items[0].Selected = true;
            //    btnPreview_Click(null, null);
            //    this.Close();
            //}
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void FindDivisionDeparmentUnit(Department department)
        {
            sDivision = "";
            sDepartment = "";
            sUnit = "";
            Department oItem = new Department();
            if (department.Tier == 4)
            {
                oItem = _oDepartments.Find(delegate(Department dept) { return dept.ID == department.ParentID; });
                sUnit = oItem.Name;
                oItem = _oDepartments.Find(delegate(Department dept) { return dept.ID == department.ParentID; });
                sDepartment = oItem.Name;
                oItem = _oDepartments.Find(delegate(Department dept) { return dept.ID == oItem.ParentID; });
                sDivision = oItem.Name;
            }
            else if (department.Tier == 3)
            {
                oItem = _oDepartments.Find(delegate(Department dept) { return dept.ID == department.ParentID; });
                sDepartment = oItem.Name;
                oItem = _oDepartments.Find(delegate(Department dept) { return dept.ID == department.ParentID; });
                sDivision = oItem.Name;
            }
            else if (department.Tier == 2)
            {
                sDepartment = oItem.Name;
                oItem = _oDepartments.Find(delegate(Department dept) { return dept.ID == department.ParentID; });
                sDivision = oItem.Name;
            }
            else if (department.Tier == 1)
            {
                sDivision = department.Name;
            }

        }

        private void btnPreview_Click(object sender, EventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;
            DataRow dRow = null;
            FSTran oItem = new FSTran();
            if (lvwFss.SelectedItems.Count > 0)
            {
                oItem = (FSTran)lvwFss.SelectedItems[0].Tag;
            }
            else
            {
                MessageBox.Show("Please select an item");
                return;
            }
            oItemDetails = FSTranDetail.GetDetail(oItem.ID);
            _oEmp = new Employee();
            _oEmp = Employee.Get(oItem.EmployeeID);
            ObjectsTemplate<ADParameter> adParams = ADParameter.Get(_oEmp.GradeID, EnumEntitleType.Grade, EnumAllowOrDeduct.Allowance);
            ObjectsTemplate<ADParameterEmployee> adParamEmps = ADParameterEmployee.GetByEmployee(_oEmp.ID, EnumAllowOrDeduct.Allowance, EnumADEmpType.AppliedToIndividual);

            EmployeeGradeSalary ogs = EmployeeGradeSalary.GetBasicOnDate(_oEmp.ID, oItem.DiscontinueDate);
            ObjectsTemplate<GrossDefination> grossDefinitions = GrossDefination.Get();
            _nGrossPaid = BonusCalculator.GetMonthlyGrossAmount(_oEmp, adParams, adParamEmps, grossDefinitions, oItem.DiscontinueDate, ogs);
            SalaryMonthly lastSalaryMonthly = SalaryMonthly.GetLastSalaryMonthDetails(_oEmp.ID);


            #region Old Code
            //dues = 0.0;
            //less = 0.0;
            //double nAddCount = 0;
            //double nDeductCount = 0;
            //double nAmount = 0.0;
            //double nDeductAmount = 0.0;
            //double nTaxAmount = 0.0;
            //double nNetAmount = 0.0;
            //double nReceivable = 0.0;
            //double nPayable = 0.0;
            //double nTotal = 0.0;
            //double nALBalance = 0.0;
            //double nEncashDays = 0.0;
            //List<ReportDataSource> dataSource;
            //Grade oGrade = new Grade();


            //EmployeeHistory oEmployeeHistory = new EmployeeHistory();
            //_oDepartments = Department.Get();
            //FindDivisionDeparmentUnit(oEmp.Department);
            //DataTable oBody = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSEmpDataTable();

            //DataTable oBody1 = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSSAddItemDataTable();

            //DataTable oBody2 = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSSDeductItemDataTable();

            //dataSource = new List<ReportDataSource>();
            //string sRequiredDays = oEmp.IsConfirmed ? oEmp.Grade.RequiredDays.ToString() + " Month(s)" : "15 Day(s)";
            //oBody.Rows.Add("(Employee ID :" + oEmp.EmployeeNo + ") " + oEmp.Name, oEmp.Designation.Name, sDivision, sDepartment, sUnit, oEmp.Location.Name, oEmp.JoiningDate.ToString("dd MMM yyyy"), oEmp.Status.ToString(), oItem.NoticeDate.ToString("dd MMM yyyy"), oItem.DiscontinueDate.ToString("dd MMM yyyy"), sRequiredDays, oItem.ShortNoticePeriod.ToString(), oEmp.ServiceLengthsInWords((DateTime)oEmp.EndOfContractDate), oEmp.EmployeeNo);
            //string embeddedResource = "Payroll.Report.RDLC.fsReport.rdlc";
            //string caption = "Final Settlement Report";

            //dataSource.Add(new ReportDataSource("dsEmpLeaveLedger_FSEmp", oBody));
            //amt1 = 0.0;
            //amt2 = 0.0;
            //amt3 = 0.0;

            ////Gross Salary
            //nGrossAmount = 0;
            //DataRow drG = GetGrossSalary(oEmp, oBody1.NewRow(), "Gross Salary", EnumFSItemCode.Gross, EnumSide.Add);

            //if (nGrossAmount == 0)
            //{
            //    nGrossAmount = 0;
            //    drG = GetGrossSalary(oEmp, oBody2.NewRow(), "Gross Salary", EnumFSItemCode.Gross, EnumSide.Deduct);
            //}
            //else
            //{
            //    nGrossAmount = 0;
            //    oBody1.Rows.Add(drG);
            //    nAddCount++;
            //}

            //if (nGrossAmount < 0)
            //{
            //    oBody2.Rows.Add(drG);
            //    nDeductCount++;
            //}

            ////Fractionate Salary
            //nFracAmount = 0;
            //DataRow dr = GetFracSalary(oEmp, oBody1.NewRow(), "Fractionate Salary", EnumFSItemCode.FractionateSalary, EnumSide.Add);

            //if (nFracAmount == 0)
            //{
            //    nFracAmount = 0;
            //    dr = GetFracSalary(oEmp, oBody2.NewRow(), "Fractionate Salary", EnumFSItemCode.FractionateSalary, EnumSide.Deduct);
            //}
            //else
            //{
            //    nFracAmount = 0;
            //    oBody1.Rows.Add(dr);
            //    nAddCount++;
            //}

            //if (nFracAmount < 0)
            //{
            //    oBody2.Rows.Add(dr);
            //    nDeductCount++;
            //}
            ////OPI
            //dr = GetFracSalary(oEmp, oBody1.NewRow(), "OPI", EnumFSItemCode.OPI, EnumSide.Add);
            //if (nFracAmount == 0)
            //{
            //    nFracAmount = 0;
            //    dr = GetFracSalary(oEmp, oBody2.NewRow(), "OPI", EnumFSItemCode.OPI, EnumSide.Deduct);
            //}
            //else
            //{
            //    oBody1.Rows.Add(dr);
            //    nAddCount++;
            //}

            //if (nFracAmount < 0)
            //{
            //    oBody2.Rows.Add(dr);
            //    nDeductCount++;
            //}

            ////nAddCount++;
            ////if (Convert.ToDouble(dr[1].ToString()) > 0)
            ////{
            ////    oBody1.Rows.Add(dr);
            ////    nAddCount++;
            ////}

            //oItemDetails.RemoveAll(delegate(FSTranDetail dta) { return dta.ItemCode == EnumFSItemCode.OPI; });
            ////Rest Items
            //foreach (FSTranDetail fd in oItemDetails)
            //{
            //    if (fd.AmountType == EnumValueType.Amount)
            //    {

            //        if (fd.ItemCode != EnumFSItemCode.FractionateSalary)
            //        {
            //            if (fd.ItemCode != EnumFSItemCode.Gross)
            //            {
            //                if (fd.FsTranType == EnumFSTranType.Fraction)
            //                {
            //                    oBody1.Rows.Add(fd.Description, Math.Abs(fd.ChangedValue));
            //                    amt1 += Math.Abs(fd.Amount);
            //                    nAddCount++;
            //                }
            //                else if (fd.FsTranType == EnumFSTranType.Fraction)
            //                {
            //                    oBody2.Rows.Add(fd.Description, Math.Abs(fd.ChangedValue));
            //                    amt2 += Math.Abs(fd.Amount);
            //                    nDeductCount++;
            //                }
            //            }
            //        }
            //    }
            //}

            //if (nAddCount > nDeductCount)
            //{
            //    for (int i = 0; i < nAddCount - nDeductCount; i++)
            //    {
            //        oBody2.Rows.Add("", 0.0);
            //    }
            //}
            //if (nDeductCount > nAddCount)
            //{
            //    for (int i = 0; i <= nDeductCount - nAddCount; i++)
            //    {
            //        oBody1.Rows.Add("", 0.0);
            //    }
            //}

            //dataSource.Add(new ReportDataSource("dsEmpLeaveLedger_FSSAddItem", oBody1));
            //dataSource.Add(new ReportDataSource("dsEmpLeaveLedger_FSSDeductItem", oBody2));

            //Cursor.Current = Cursors.WaitCursor;
            //try
            //{
            //    fReportViewer fViewer = new fReportViewer();
            //    fViewer.PreviewReport(_reportitem, dataSource, embeddedResource, caption);
            //}
            //catch (Exception exp)
            //{
            //    throw new Exception(exp.Message);
            //} 
            #endregion

            fReportViewer form = new fReportViewer();
            DataSet dSet = new DataSet();

            DataTable dTable = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSEmpNewDataTable();
            dRow = dTable.NewRow();
            dRow["EmpNo"] = _oEmp.EmployeeNo;
            dRow["EmpName"] = _oEmp.Name;
            dRow["BasicSalary"] = Math.Round(lastSalaryMonthly.ThisMonthBasic);
            dRow["Grade"] = _oEmp.Grade.Name;
            dRow["JoiningDate"] = (_oEmp.JoiningDate).ToString("dd MMM yyyy");
            dRow["LastWorkingDay"] = ((DateTime)_oEmp.EndOfContractDate).ToString("dd MMM yyyy");
            dRow["PaperReceivedDay"] = (oItem.NoticeDate).ToString("dd MMM yyyy");
            dRow["Designation"] = _oEmp.Designation == null ? "" : _oEmp.Designation.Name;
            dRow["Department"] = _oEmp.Department == null ? "" : _oEmp.Department.Name;
            dRow["Location"] = _oEmp.Location == null ? "" : _oEmp.Location.Name;
            //EmployeeCostCenter cc = (EmployeeCostCenter.GetByEmpID(_oEmp.ID)).Find(x => x.IsCurrentCC == true);

            dRow["CostCenter"] = _oEmp.Department == null ? "" : _oEmp.Department.RCCode;
            dRow["Status"] = _oEmp.Category == null ? "" : _oEmp.Category.Name;
            dRow["YearServed"] = _oEmp.ServiceLengthsInWords((DateTime)_oEmp.EndOfContractDate);
            dRow["LastPaidMonth"] = lastSalaryMonthly.SalaryMonth.ToString("dd MMM yyyy");
            dRow["BatchNumber"] = oItem.BatchNumber;
            dRow["GrossSalary"] = Math.Round(_nGrossPaid);
            dRow["Allowances"] = Math.Round(_nGrossPaid - _oEmp.BasicSalary);
            dRow["Bank"] = _oEmp.BranchID==null?"": _oEmp.Branch.BankID==null?"":_oEmp.Branch.Bank.Name;
            dRow["AccountNo"] = _oEmp.AccountNo;
            
            dTable.Rows.Add(dRow);
            dTable.TableName = "dsEmpLeaveLedger_FSEmpNew";
            dSet.Tables.Add(dTable);

            DataTable dTableAdd = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSAddItemNewDataTable();
            DataTable dTableDeduct = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSDeductItemNewDataTable();
            DataTable dTablePFDetails = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSPFDetailsDataTable();
            DataTable dTableWPPFDetails = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSWPPFDetailsDataTable();
            DataTable dTablePaymentItem = new Payroll.Report.PayrollDataSet.dsEmpLeaveLedger.FSPaymentItemDataTable();

            //Entitle Payment
            FSTranDetail Epd = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.EntitlePayment && x.AmountType==EnumValueType.Other);
            FSTranDetail Ep = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.EntitlePayment && x.AmountType == EnumValueType.Amount);
            if (Epd != null && Ep != null)
            {
                dRow = dTablePaymentItem.NewRow();
                dRow["Description"] = Ep.Description;
                dRow["Amount"] = Ep.ChangedValue;
                dRow["PaymentMode"] = Epd.Description;
                dTablePaymentItem.Rows.Add(dRow); 
            }

            //PF Payment
            FSTranDetail PFpd = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.PFPayment && x.AmountType == EnumValueType.Other);
            FSTranDetail PFp = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.PFPayment && x.AmountType == EnumValueType.Amount);
            if (PFpd != null && PFp != null)
            {
                dRow = dTablePaymentItem.NewRow();
                dRow["Description"] = PFp.Description;
                dRow["Amount"] = PFp.ChangedValue;
                dRow["PaymentMode"] = PFpd.Description;
                dTablePaymentItem.Rows.Add(dRow); 
            }

            //GF Payment
            //VRS
            FSTranDetail vrs = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.VRS && x.AmountType == EnumValueType.Amount);
            //FSTranDetail vrsDay = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.VRS && x.AmountType == EnumValueType.Other);
            double nVRSAmount = 0;
            if (vrs != null&& vrs.ChangedValue > 0)
            {
                nVRSAmount = vrs.ChangedValue;
            }

            FSTranDetail GFpd = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.GFPayment && x.AmountType == EnumValueType.Other);
            FSTranDetail GFp = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.GFPayment && x.AmountType == EnumValueType.Amount);
            if (GFpd != null && GFp != null)
            {
                dRow = dTablePaymentItem.NewRow();
                dRow["Description"] = GFp.Description;
                dRow["Amount"] = GFp.ChangedValue + nVRSAmount;
                dRow["PaymentMode"] = GFpd.Description;
                dTablePaymentItem.Rows.Add(dRow); 
            }

            //WPPF Payment
            FSTranDetail WPPFpd = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.WPPFPayment && x.AmountType == EnumValueType.Other);
            FSTranDetail WPPFp = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.WPPFPayment && x.AmountType == EnumValueType.Amount);
            if ( WPPFpd != null && WPPFp != null )
            {
                dRow = dTablePaymentItem.NewRow();
                dRow["Description"] = WPPFp.Description;
                dRow["Amount"] = WPPFp.ChangedValue;
                dRow["PaymentMode"] = WPPFpd.Description;
                dTablePaymentItem.Rows.Add(dRow); 
            }

            //Fractionate Salary
            FSTranDetail fractionateSalary = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.FractionateSalary && x.AmountType == EnumValueType.Amount);
            FSTranDetail fractionateSalaryDay = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.FractionateSalary && x.AmountType == EnumValueType.Other);
            if (fractionateSalary != null && fractionateSalaryDay != null && fractionateSalary.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = fractionateSalary.Description + " ( " + fractionateSalaryDay.ChangedValue.ToString() + " Day/s )";
                dRow["AddAmount"] = fractionateSalary.ChangedValue;
                dTableAdd.Rows.Add(dRow); 
            }

            //LeaveEncashment
            FSTranDetail leaveEncashment = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.LeaveEncashment && x.AmountType == EnumValueType.Amount);
            FSTranDetail leaveEncashmentDay = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.LeaveEncashment && x.AmountType == EnumValueType.Other);
            if (leaveEncashment != null && leaveEncashmentDay != null && leaveEncashment.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = leaveEncashment.Description + " ( " + leaveEncashmentDay.ChangedValue.ToString() + " Day/s )";
                dRow["AddAmount"] = leaveEncashment.ChangedValue;
                dTableAdd.Rows.Add(dRow); 
            }

            //Festive Bonus
            FSTranDetail festiveBonus = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.FestiveBonus && x.AmountType == EnumValueType.Amount);
            if (festiveBonus != null && festiveBonus.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = festiveBonus.Description;
                dRow["AddAmount"] = festiveBonus.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

            //Quarterly Bonus
            FSTranDetail quarterlyBonus = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.QuarterlyBonus && x.AmountType == EnumValueType.Amount);
            if (quarterlyBonus!=null && quarterlyBonus.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = quarterlyBonus.Description ;
                dRow["AddAmount"] = quarterlyBonus.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

            //OT
            FSTranDetail ot = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.OT && x.AmountType == EnumValueType.Amount);
            if (ot!=null && ot.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = ot.Description;
                dRow["AddAmount"] = ot.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

            //Other
            FSTranDetail other = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.Other && x.AmountType == EnumValueType.Amount);
            if (other!=null && other.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = other.Description;
                dRow["AddAmount"] = other.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

           

            //Car/Fuel
            FSTranDetail carFuel = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.CarFuel && x.AmountType == EnumValueType.Amount);
            if (carFuel!=null && carFuel.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = carFuel.Description;
                dRow["AddAmount"] = carFuel.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

            //PF
            FSTranDetail pf = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.PF && x.AmountType == EnumValueType.Amount);
            if (pf!=null && pf.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = pf.Description;
                dRow["AddAmount"] = pf.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

            //GF
            FSTranDetail gf = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.GF && x.AmountType == EnumValueType.Amount);
            if (gf != null && gf.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = gf.Description;
                dRow["AddAmount"] = gf.ChangedValue+nVRSAmount;
                dTableAdd.Rows.Add(dRow);
            }

            //WPPF
            FSTranDetail wppf = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.WPPF && x.AmountType == EnumValueType.Amount);
            if (wppf!=null && wppf.ChangedValue > 0)
            {
                dRow = dTableAdd.NewRow();
                dRow["AddDescription"] = wppf.Description;
                dRow["AddAmount"] = wppf.ChangedValue;
                dTableAdd.Rows.Add(dRow);
            }

            FSTranDetail pfOwn = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.PF && x.AmountType == EnumValueType.Other && x.Description == "PF - Own Contribution");
            if (pfOwn != null)
            {
                dRow = dTablePFDetails.NewRow();
                dRow["PFOwn"] = pfOwn.ChangedValue;
                dTablePFDetails.Rows.Add(dRow);
            }

            FSTranDetail pfCompany = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.PF && x.AmountType == EnumValueType.Other && x.Description == "PF - Company Contribution");
            if (pfCompany != null)
            {
                dRow = dTablePFDetails.NewRow();
                dRow["PFCompany"] = pfCompany.ChangedValue;
                dTablePFDetails.Rows.Add(dRow);
            }
            FSTranDetail pfLoan = oItemDetails.Find(x => x.ItemCode == EnumFSItemCode.PF && x.AmountType == EnumValueType.Other && x.Description == "PF - Loan Amount Deduction");
            if (pfLoan != null)
            {
                dRow = dTablePFDetails.NewRow();
                dRow["PFLoan"] = pfLoan.ChangedValue;
                dTablePFDetails.Rows.Add(dRow);
            }

            foreach (FSTranDetail item in oItemDetails)
            {
                if (item.ItemCode == EnumFSItemCode.Deduction && item.AmountType == EnumValueType.Other)
                {
                    dRow = dTableDeduct.NewRow();
                    dRow["DeductDescription"] = item.Description;
                    dRow["DeductAmount"] = item.ChangedValue;
                    dTableDeduct.Rows.Add(dRow);
                }
                //else if((item.ItemCode == EnumFSItemCode.FractionateSalary || 
                //        item.ItemCode == EnumFSItemCode.LeaveEncashment ||
                //        item.ItemCode == EnumFSItemCode.QuarterlyBonus ||
                //        item.ItemCode == EnumFSItemCode.FestiveBonus ||
                //        item.ItemCode == EnumFSItemCode.GF ||
                //        item.ItemCode == EnumFSItemCode.OT ||
                //        item.ItemCode == EnumFSItemCode.PF ||
                //        item.ItemCode == EnumFSItemCode.WPPF ||
                //        item.ItemCode == EnumFSItemCode.Other ||
                //        item.ItemCode == EnumFSItemCode.VRS ||
                //        item.ItemCode == EnumFSItemCode.CarFuel) && item.AmountType == EnumValueType.Amount)
                //{
                //    if (item.ChangedValue > 0)
                //    {
                //        dRow = dTableAdd.NewRow();
                //        dRow["AddDescription"] = item.Description;
                //        dRow["AddAmount"] = item.ChangedValue;
                //        dTableAdd.Rows.Add(dRow); 
                //    }
                //}
                //else if (item.ItemCode == EnumFSItemCode.PF && item.AmountType == EnumValueType.Other)
                //{
                //    //if (item.ChangedValue > 0)
                //    //{
                //        dRow = dTablePFDetails.NewRow();
                //        dRow["Description"] = item.Description;
                //        dRow["Amount"] = item.ChangedValue;
                //        dTablePFDetails.Rows.Add(dRow);
                //    //}
                //}
                else if (item.ItemCode == EnumFSItemCode.WPPF && item.AmountType == EnumValueType.Other)
                {
                    if (item.ChangedValue > 0)
                    {
                        dRow = dTableWPPFDetails.NewRow();
                        dRow["Description"] = item.Description;
                        dRow["Amount"] = item.ChangedValue;
                        dTableWPPFDetails.Rows.Add(dRow);
                    }
                }
            }

            //if (dTablePaymentItem.Rows.Count>dTableDeduct.Rows.Count)
            //{
            //    int nCount = dTablePaymentItem.Rows.Count - dTableDeduct.Rows.Count;
            //    for(int i=0;i<nCount;i++)
            //    {
            //        dTableDeduct.Rows.Add("", 0);
            //    }
            //}

            if (dTableAdd.Rows.Count > dTableDeduct.Rows.Count)
            {
                for (int i = 0; i < dTableAdd.Rows.Count - dTableDeduct.Rows.Count; i++)
                    dTableDeduct.Rows.Add("",0);
            }
            dTableAdd.TableName = "dsEmpLeaveLedger_FSAddItemNew";
            dSet.Tables.Add(dTableAdd);
            dTableDeduct.TableName = "dsEmpLeaveLedger_FSDeductItemNew";
            dSet.Tables.Add(dTableDeduct);
            dTablePFDetails.TableName = "dsEmpLeaveLedger_FSPFDetails";
            dSet.Tables.Add(dTablePFDetails);
            dTableWPPFDetails.TableName = "dsEmpLeaveLedger_FSWPPFDetails";
            dSet.Tables.Add(dTableWPPFDetails);
            dTablePaymentItem.TableName = "dsEmpLeaveLedger_FSPaymentItem";
            dSet.Tables.Add(dTablePaymentItem);

            //List<ReportParameter> parameters = new List<ReportParameter>();
            //parameters.Add(new ReportParameter("BankName", _selectedParameter.Banks[0].Name));


            form.CommonReportView(null, dSet, "Payroll.Report.RDLC.fsReportNew.rdlc", null);


        }

        private DataTable TakaInWords(DataTable dt2)
        {
            DataRow oRow = dt2.NewRow();
            string tk = Ease.CoreV35.Utility.Global.NumericFunctions.TakaWords(GlobalFunctions.Round(dues - less));
            oRow[0] = tk.Replace("Taka", " BDT");
            dt2.Rows.Add(oRow);
            return dt2;
        }

        private void FSReport_Load(object sender, EventArgs e)
        {
            this._reportType = _Type;
            _reportitem = ReportItem.Get(ID.FromInteger(Convert.ToInt32(_reportType)));
            rdoSettleDate.Checked = true;
            btnRefresh_Click(null, null);
        }

       

        private DataTable GetSalaryComponent(Employee oEmp, DataTable dt2)
        {
            //DataRow oRow = dt2.NewRow();
            //oRow[0] = GlobalFunctions.TakaFormat(oEmp.BasicSalary); 
            //oRow[9] = GlobalFunctions.TakaFormat(oEmp.BasicSalary*3);
            //ObjectsTemplate<ADParameter> _oADParameters = ADParameter.Get(EnumStatus.Active, ID.FromInteger(14));
            //List<ADParameter> _ADParameters = ADParameter.GetApplicableParameters(oEmp, oEmp.GradeID, _oADParameters);
            //oRow[10] = GlobalFunctions.TakaFormat(_ADParameters[0].FlatAmount);
            //ObjectsTemplate<ADParameter> adParams = ADParameter.Get(oEmp.GradeID, EnumEntitleType.Grade, EnumAllowOrDeduct.Allowance);
            //if (adParams != null)
            //{ 
            //    foreach (ADParameter adParam in adParams)
            //    {
            //        double nAmt = 0.0;

            //        nAmt = adParam.GetGradeDefinedAmount(oEmp, oEmp.BasicSalary, oEmp.GrossSalary);
            //        if (adParam.AllowDeductID.Integer == 3)
            //            oRow[1] =GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer == 9)
            //            oRow[2] = GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer == 5)
            //            oRow[3] = GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer == 41)
            //            oRow[4] = GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer == 4)
            //            oRow[5] = GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer == 6)
            //            oRow[6] = GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer ==7)
            //            oRow[7] = GlobalFunctions.TakaFormat(nAmt);
            //        else if (adParam.AllowDeductID.Integer == 8)
            //            oRow[8] = GlobalFunctions.TakaFormat(nAmt);
            //        nTotalTaka += GlobalFunctions.Round(nAmt); 
            //    }
            //}
            //dt2.Rows.Add(oRow);

            return dt2;
        }

        private DataTable GetPreviledgeLeave(Employee oEmp, DataTable dt2)
        {
            //DataRow oRow = dt2.NewRow();
            //foreach (FSTranDetail fd in oItemDetails)
            //{
            //    if (fd.ItemCode == EnumFSItemCode.Provision)
            //        continue;
            //    if (fd.ChangedValue > 0)
            //    {
            //        if (fd.ItemCode == EnumFSItemCode.Leave && fd.ItemID == -101 && fd.AmountType == EnumValueType.Amount)
            //        {
            //            oRow[0] = GlobalFunctions.TakaFormat(fd.ChangedValue);
            //            dues += GlobalFunctions.Round(fd.ChangedValue);
            //        }
            //        else if (fd.ItemCode == EnumFSItemCode.Leave && fd.ItemID == 3 && fd.AmountType == EnumValueType.Amount)
            //        {
            //            oRow[1] = GlobalFunctions.TakaFormat(fd.ChangedValue);
            //            dues += GlobalFunctions.Round(fd.ChangedValue);
            //        }
            //        else if (fd.ItemCode == EnumFSItemCode.Leave && fd.ItemID == 9 && fd.AmountType == EnumValueType.Amount)
            //        {
            //            oRow[2] = GlobalFunctions.TakaFormat(fd.ChangedValue);
            //            dues += GlobalFunctions.Round(fd.ChangedValue);
            //        }
            //        else if (fd.ItemCode == EnumFSItemCode.Leave && fd.ItemID == 5 && fd.AmountType == EnumValueType.Amount)
            //        {
            //            oRow[3] = GlobalFunctions.TakaFormat(fd.ChangedValue);
            //            dues += GlobalFunctions.Round(fd.ChangedValue);
            //        }
            //        else if (fd.ItemCode == EnumFSItemCode.Leave && fd.ItemID == 41 && fd.AmountType == EnumValueType.Amount)
            //        {
            //            oRow[4] = GlobalFunctions.TakaFormat(fd.ChangedValue);
            //            dues += GlobalFunctions.Round(fd.ChangedValue);
            //        }
            //        else if (fd.ItemCode == EnumFSItemCode.Leave && fd.ItemID == -101 && fd.AmountType == EnumValueType.Other)
            //        {
            //            oRow[5] = GlobalFunctions.TakaFormat(fd.ChangedValue);                        
            //        }
            //        nTotalTaka += GlobalFunctions.Round(fd.ChangedValue); 
            //    }
            //}  

            //dt2.Rows.Add(oRow);

            return dt2;

        }

        private DataRow GetFracSalary(Employee oEmp, DataRow dr, string sName, EnumFSItemCode eItemCode, EnumSide eSide)
        {
            double nAmount = 0.0;
            foreach (FSTranDetail fd in oItemDetails)
            {
                if (fd.ItemCode == EnumFSItemCode.Provision)
                    continue;
                if (fd.Side == eSide)
                {
                    if (fd.ItemCode == eItemCode && fd.AmountType == EnumValueType.Amount)
                    {
                        nAmount += Math.Abs(fd.ChangedValue);
                    }

                }
            }
            amt1 += Math.Abs(nAmount);
            dr[0] = sName;
            dr[1] = GlobalFunctions.TakaFormat(Math.Abs(nAmount));
            nFracAmount = Math.Abs(nAmount);
            return dr;

        }
        public double GetGross(Employee emp)
        {
            try
            {
                ObjectsTemplate<ADParameter> adParams = null;
                ObjectsTemplate<ADParameterEmployee> adParamEmps = null;
                _Amount = 0;

                _Amount += emp.BasicSalary;

                adParams = ADParameter.Get(emp.GradeID, EnumEntitleType.Grade, _ADType);
                if (adParams != null)
                {
                    foreach (ADParameter adParam in adParams)
                    {
                        _Amount += adParam.GetGradeDefinedAmount(emp, emp.BasicSalary, emp.GrossSalary);
                    }
                }

                adParamEmps = ADParameterEmployee.GetByEmployee(emp.ID, _ADType, EnumADEmpType.AppliedToIndividual);

                if (adParamEmps != null)
                {
                    foreach (ADParameterEmployee adEmp in adParamEmps)
                    {
                        _Amount += adEmp.MonthlyAmount;
                    }
                }
                return _Amount;
            }
            catch (Exception ex)
            {
                return _Amount;
            }
        }
        private DataRow GetGrossSalary(Employee oEmp, DataRow dr, string sName, EnumFSItemCode eItemCode, EnumSide eSide)
        {
            double nAmount = 0.0;
            foreach (FSTranDetail fd in oItemDetails)
            {
                if (fd.ItemCode == EnumFSItemCode.Provision)
                    continue;
                if (fd.Side == eSide)
                {
                    if (fd.ItemCode == eItemCode && fd.AmountType == EnumValueType.Amount)
                    {
                        nAmount += Math.Abs(fd.ChangedValue);
                    }

                }
            }
            amt1 += Math.Abs(nAmount);
            dr[0] = sName;
            dr[1] = GlobalFunctions.TakaFormat(Math.Abs(nAmount));
            nGrossAmount = Math.Abs(nAmount);
            return dr;

        }

        private DataTable GetItems(Employee oEmp, DataTable dt2, EnumSide eside)
        {
            ObjectsTemplate<FSTranDetail> details = new ObjectsTemplate<FSTranDetail>();
            details = oItemDetails;
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Gross; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.FractionateSalary; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Leave; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.PF; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.CPF; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Gratuity; });
            foreach (FSTranDetail fd in details)
            {
                if (fd.ItemCode == EnumFSItemCode.Provision)
                    continue;
                if (fd.ItemCode != EnumFSItemCode.Other)
                {
                    if (fd.ChangedValue > 0)
                    {
                        if (fd.Side == eside && fd.AmountType == EnumValueType.Amount)
                        {
                            DataRow oRow = dt2.NewRow();
                            oRow[0] = fd.Description;
                            oRow[1] = GlobalFunctions.TakaFormat(fd.ChangedValue);
                            nTotalTaka += GlobalFunctions.Round(fd.ChangedValue);
                            dues += GlobalFunctions.Round(fd.ChangedValue);
                            dt2.Rows.Add(oRow);
                        }
                    }
                }
            }

            return dt2;

        }
        private DataTable GetItemsWithOther(Employee oEmp, DataTable dt2, EnumSide eside)
        {
            ObjectsTemplate<FSTranDetail> details = new ObjectsTemplate<FSTranDetail>();
            details = oItemDetails;
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Gross; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.FractionateSalary; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Leave; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.PF; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.CPF; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Gratuity; });
            foreach (FSTranDetail fd in details)
            {
                if (fd.ItemCode == EnumFSItemCode.Provision)
                    continue;
                if (fd.ChangedValue > 0)
                {
                    if (fd.Side == eside && fd.AmountType == EnumValueType.Amount)
                    {
                        if (fd.ItemCode == EnumFSItemCode.Loan && fd.ItemID == 1)
                            continue;
                        else
                        {
                            FSTranDetail item = null;
                            if (fd.ItemCode == EnumFSItemCode.NoticePay)
                                item = details.Find(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.NoticePay && td.AmountType == EnumValueType.Other; });
                            DataRow oRow = dt2.NewRow();
                            oRow[0] = item == null ? fd.Description : fd.Description + "                  " + item.ChangedValue + " day(s)";
                            oRow[1] = GlobalFunctions.TakaFormat(fd.ChangedValue);
                            nTotalTaka -= GlobalFunctions.Round(fd.ChangedValue);
                            less += GlobalFunctions.Round(fd.ChangedValue);
                            dt2.Rows.Add(oRow);
                        }
                    }
                }
            }

            return dt2;

        }
        private void rdoSettleDate_CheckedChanged(object sender, EventArgs e)
        {
            if (rdoSettleDate.Checked)
                HideControls(true);
            else
                HideControls(false);
        }

        private void rdoDiscontinueDate_CheckedChanged(object sender, EventArgs e)
        {
            if (rdoDiscontinueDate.Checked)
                HideControls(true);
            else
                HideControls(false);
        }

        private void rdoBatchNumber_CheckedChanged(object sender, EventArgs e)
        {
            if (rdoBatchNumber.Checked)
                HideControls(false);
            else
                HideControls(true);
        }
        private void HideControls(bool sts)
        {
            dtpFrom.Enabled = sts;
            dtpTo.Enabled = sts;
            txtBatchNumber.Enabled = !sts;
        }
        private DataTable GetOtherItems(Employee oEmp, DataTable dt2, EnumSide eside)
        {
            ObjectsTemplate<FSTranDetail> details = new ObjectsTemplate<FSTranDetail>();
            details = oItemDetails;
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Gross; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.FractionateSalary; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Leave; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.PF; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.CPF; });
            details.RemoveAll(delegate(FSTranDetail td) { return td.ItemCode == EnumFSItemCode.Gratuity; });
            foreach (FSTranDetail fd in details)
            {
                if (fd.ItemCode == EnumFSItemCode.Provision)
                    continue;
                if (fd.ItemCode == EnumFSItemCode.Other)
                {
                    if (fd.ChangedValue > 0)
                    {
                        if (fd.Side == eside && fd.AmountType == EnumValueType.Amount)
                        {
                            DataRow oRow = dt2.NewRow();
                            oRow[0] = fd.Description;
                            oRow[1] = GlobalFunctions.TakaFormat(fd.ChangedValue);
                            dues += GlobalFunctions.Round(fd.ChangedValue);
                            dt2.Rows.Add(oRow);
                        }
                        else if (fd.Side == EnumSide.Deduct && fd.ItemCode == EnumFSItemCode.LFA)
                        {
                            DataRow oRow = dt2.NewRow();
                            oRow[0] = fd.Description;
                            oRow[1] = GlobalFunctions.TakaFormat(fd.ChangedValue);
                            dt2.Rows.Add(oRow);
                        }
                    }
                }
            }

            return dt2;

        }

       
    }
}