CEL_Payroll/Payroll.Service/Budget/Service/MiscellaneousDatasetService.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Ease.CoreV35.Model;
using Payroll.BO;
using Ease.CoreV35.DataAccess;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

namespace Payroll.Service
{
    public class MiscellaneousDatasetService : ServiceTemplate, IMiscellaneousDatasetService
    {
        #region Service implementation

        public int? GetByGlobalID(string globalID)
        {
            TransactionContext tc = null;
            int? glbID = null;
            try
            {
                tc = TransactionContext.Begin(true);
                DataReader dr = new DataReader(MiscellaneousDatasetDA.GetByGlobalID(tc,globalID));
                if(dr.Read())
                {
                    glbID = dr.GetInt32("EmployeeID") == null ? null : dr.GetInt32("EmployeeID");
                }
            }
            catch (Exception e)
            {
                #region Handle Exception

                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);

                throw new ServiceException(e.Message, e);

                #endregion
            }

            return glbID;
        }

        public DataSet GetEmpGrossPay(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmpGrossPay(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetTotalOPI(string oPIItem, DateTime _SalaryMonth, string sEmpID)
        {
            DataSet oTotalOPI = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oTotalOPI = MiscellaneousDatasetDA.GetTotalOPI(tc, oPIItem, _SalaryMonth, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oTotalOPI;
        }

        public DataSet GetTotalOPIForBranch(string oPIItem, DateTime _SalaryMonth, string sEmpID)
        {
            DataSet oTotalOPI = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oTotalOPI = MiscellaneousDatasetDA.GetTotalOPIForBranch(tc, oPIItem, _SalaryMonth, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oTotalOPI;
        }

        public DataSet GetLineManager(string empId)
        {
            DataSet oLineManager = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oLineManager = MiscellaneousDatasetDA.GetLineManager(tc, empId);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oLineManager;
        }

        public DataSet GetEmpDeduction(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmpDeduction(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetCashChequePaymentReport(DateTime Month, string paymentType)
        {
            DataSet oCashChequePayment = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oCashChequePayment = MiscellaneousDatasetDA.GetCashChequePaymentReport(tc, Month, paymentType);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oCashChequePayment;
        }
        public DataSet GetCashChequePaymentReportBonus(DateTime Month, string paymentType)
        {
            DataSet oCashChequePayment = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oCashChequePayment = MiscellaneousDatasetDA.GetCashChequePaymentReportBonus(tc, Month, paymentType);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oCashChequePayment;
        }

        public DataSet GetBranchWiseSalary(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetBranchWiseSalary(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetBranchWiseSalaryDetails(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetBranchWiseSalaryDetails(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetBEFTNform(DateTime dSMonthDate, string ids)
        {
            DataSet oBEFTNform = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oBEFTNform = MiscellaneousDatasetDA.GetBEFTNform(tc, dSMonthDate, ids);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oBEFTNform;
        }


        public DataSet GetTotalBranchWiseOPI(string str, DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetTotalBranchWiseOPI(tc, str, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetBranchWiseEmpDeduction(DateTime _SalaryMonth, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetBranchWiseEmpDeduction(tc, _SalaryMonth, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetCCWiseSalaryDetails(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetCCWiseSalaryDetails(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetDividionWiseReport(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetDividionWiseReport(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetCTCDetail(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetCTCDetail(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetIncrement(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetIncrement(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetADHeadReport(DateTime dSMonthDate, string checkItem,string itemCode)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetADHeadReport(tc, dSMonthDate, checkItem, itemCode);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetOPIHeadReport(DateTime dSMonthDate, string checkItem)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetOPIHeadReport(tc, dSMonthDate, checkItem);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetCCWiseFinance(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetCCWiseFinance(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetNewCCWiseSalaryDetails(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetNewCCWiseSalaryDetails(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetCCWiseOPIDetails(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetCCWiseOPIDetails(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetCCWiseSummary(DateTime dSMonthDate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetCCWiseSummary(tc, dSMonthDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetItemWiseSalary(string sEmpID, DateTime _SalaryMonth, DateTime toDate, string sSQL)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetItemWiseSalary(tc, sEmpID, _SalaryMonth, toDate, sSQL);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmpIndSalarySheet(string sEmpID, string _months)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmpIndSalarySheet(tc, sEmpID, _months);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetPFLedger(string sEmpID, DateTime FromDate, DateTime toDate)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetPFLedger(tc, sEmpID, FromDate, toDate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet PrintEnvelop(string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.PrintEnvelop(tc, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetSalarySheet(string sEmpID, DateTime _SalaryMonth, DateTime toDate)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetSalarySheet(tc, sEmpID, _SalaryMonth, toDate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetSalaryData(string sEmpID, DateTime _SalaryMonth, DateTime toDate)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetSalaryData(tc, sEmpID, _SalaryMonth, toDate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmpsFiscalYeartax(string sEmpIDs, DateTime fromdate, DateTime toDate,int taxParamID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmpsFiscalYeartax(tc, sEmpIDs, fromdate, toDate, taxParamID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmpstaxInvestment(string sEmpIDs, int taxParamID)
        {
            DataSet oTaxInvestment = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oTaxInvestment = MiscellaneousDatasetDA.GetEmpstaxInvestment(tc, sEmpIDs, taxParamID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oTaxInvestment;
        }

        public DataSet GetEmpstaxChallan(string sEmpIDs, int taxParamId)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmpstaxChallan(tc, sEmpIDs, taxParamId);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmployeesMasterData(DateTime Fromdate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmployeesMasterData(tc, Fromdate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmployeesPF(DateTime dateTime, string sUnitID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmployeesPF(tc, dateTime, sUnitID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmployeesPFNew(DateTime fromDate, DateTime toDate)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetEmployeesPFNew(tc, fromDate, toDate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetMonthlySalaryRevision(DateTime fromDate, DateTime toDate)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetMonthlySalaryRevision(tc, fromDate, toDate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetStuffListWithoutSalary(DateTime fromdate, string sEmpID)
        {
            DataSet oGrossPay = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oGrossPay = MiscellaneousDatasetDA.GetStuffListWithoutSalary(tc, fromdate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oGrossPay;
        }

        public DataSet GetEmployeesPF(DateTime dateTime)
        {
            DataSet oEmployeesPF = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oEmployeesPF = MiscellaneousDatasetDA.GetEmployeesPF(tc, dateTime);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oEmployeesPF;
        }

        public DataSet GetEmployeesPF(DateTime Fromdate, DateTime Todate)
        {
            DataSet oEmployeesPF = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oEmployeesPF = MiscellaneousDatasetDA.GetEmployeesPF(tc, Fromdate, Todate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oEmployeesPF;
        }

        public DataSet GetSalarySummaryData(DateTime dateTime, int deptId)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetSalarySummaryData(tc, dateTime, deptId);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        

        public DataSet GetSalaryComparisonData(DateTime _SalaryMonth, string sEmpID)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetSalaryComparisonData(tc, _SalaryMonth, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }


        public DataSet GetSalaryPaySlipData(DateTime _SalaryMonth, string sEmpID)
        {
            DataSet oSalaryPaySlipData = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalaryPaySlipData = MiscellaneousDatasetDA.GetSalaryPaySlipData(tc, _SalaryMonth, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalaryPaySlipData;
        }


        public DataSet GetExpensesPaySlipData(DateTime fromdate, DateTime toDate, string sEmpID)
        {
            DataSet oExpensesPaySlipData = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oExpensesPaySlipData = MiscellaneousDatasetDA.GetExpensesPaySlipData(tc, fromdate, toDate, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oExpensesPaySlipData;
        }

        public DataSet GetEmpExperience(int empid)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetEmpExperience(tc, empid);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        public DataSet GetEmpsAuditReport(DateTime _SalaryMonth, string sEmpID)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetEmpsAuditReport(tc, _SalaryMonth, sEmpID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        public DataSet GetSalaryCertificateData(int EmpID, int bankID)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetSalaryCertificateData(tc, EmpID, bankID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        public DataSet GetSalaryCertificateDataforOtherBank(int EmpID, int bankID)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetSalaryCertificateDataforOtherBank(tc, EmpID, bankID);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        public DataSet GetExceptionEmployeesPF(DateTime fromdate, DateTime todate)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetExceptionEmployeesPF(tc, fromdate, todate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        public DataSet GetBankPaymentSummaryData(DateTime fromdate)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetBankPaymentSummaryData(tc, fromdate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        public DataSet GetCashPaymentSummaryData(DateTime fromdate)
        {
            DataSet oSalarySummary = new DataSet();

            TransactionContext tc = null;
            try
            {
                tc = TransactionContext.Begin();
                oSalarySummary = MiscellaneousDatasetDA.GetCashPaymentSummaryData(tc, fromdate);
                tc.End();
            }
            catch (Exception e)
            {
                #region Handle Exception
                if (tc != null)
                    tc.HandleError();
                ExceptionLog.Write(e);
                throw new ServiceException(e.Message, e);
                #endregion
            }
            return oSalarySummary;
        }

        #endregion

        protected override T CreateObject<T>(DataReader dr)
        {
            throw new NotImplementedException();
        }
    }
}