public List <ApprovedPCLDTO_OS> GetApprovedPCLCntSL(string i_sConnectionString, int i_UserInfoId)
        {
            List <ApprovedPCLDTO_OS> lstApprovedPCLStatus_OS = new List <ApprovedPCLDTO_OS>();

            try
            {
                using (var objTradingTransactionDAL_OS = new TradingTransactionDAL_OS())
                {
                    lstApprovedPCLStatus_OS = objTradingTransactionDAL_OS.GetApprovedPCLCnt(i_sConnectionString, i_UserInfoId).ToList <ApprovedPCLDTO_OS>();
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }
            return(lstApprovedPCLStatus_OS);
        }
        /* Reference from GetCompanyFaceValueDetails Method in CompaniesSL.cs*/
        /// <summary>
        /// This method is used for the get pending PE disclosure count
        /// </summary>
        /// <param name="i_sConnectionString">DB Connection string</param>
        /// <param name="i_UserInfoId">User Info Id</param>
        /// <param name="dtEndDate">Period End Date</param>
        /// <returns>Object ContinuousDisclosureStatus DTO</returns>

        public List <ContinuousDisclosureStatusDTO> Get_PEDisclosureStatus(string i_sConnectionString, int i_UserInfoId, DateTime dtEndDate)
        {
            List <ContinuousDisclosureStatusDTO> lstPEDisclosureStatus_OS = new List <ContinuousDisclosureStatusDTO>();

            try
            {
                using (var objContDisStatusDAL_OS = new TradingTransactionDAL_OS())
                {
                    lstPEDisclosureStatus_OS = objContDisStatusDAL_OS.GetPEDisclosureStatus(i_sConnectionString, i_UserInfoId, dtEndDate).ToList <ContinuousDisclosureStatusDTO>();
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }
            return(lstPEDisclosureStatus_OS);
        }
        /// <summary>
        /// This method is used to save Initial Disclosure List
        /// </summary>
        /// <param name="i_sConnectionString"></param>
        /// <param name="i_objPreclearanceRequestNonImplCompanyDTO"></param>
        /// <returns></returns>
        public bool InsertUpdateIDTradingTransactionDetails(string i_sConnectionString, DataTable dt_InitialDiscList)
        {
            bool IsSave = false;

            try
            {
                using (TradingTransactionDAL_OS objTradingTransactionDAL_OS = new TradingTransactionDAL_OS())
                {
                    IsSave = objTradingTransactionDAL_OS.InsertUpdateIDTradingTransactionDetails(i_sConnectionString, dt_InitialDiscList);
                }
            }
            catch (Exception ex)
            {
                throw;
            }

            return(IsSave);
        }
        /// <summary>
        /// InsertTransactionFormDetails_ForPeriodEnd
        /// </summary>
        /// <param name="i_sConnectionString"></param>
        /// <param name="i_objTransactionLetterDTO_OS"></param>
        /// <returns></returns>
        public bool InsertTransactionFormDetails_ForPeriodEnd(string i_sConnectionString, TransactionLetterDTO_OS i_objTransactionLetterDTO_OS)
        {
            bool IsSave = false;

            try
            {
                using (TradingTransactionDAL_OS objTradingTransactionDAL_OS = new TradingTransactionDAL_OS())
                {
                    IsSave = objTradingTransactionDAL_OS.InsertTransactionFormDetails_ForPeriodEnd(i_sConnectionString, i_objTransactionLetterDTO_OS);
                }
            }
            catch (Exception ex)
            {
                throw;
            }

            return(IsSave);
        }