/// <summary>
        ///
        /// </summary>
        /// <param name="i_sConnectionString"></param>
        /// <param name="i_nUserInfoId"></param>
        /// <param name="o_nReturnValue"></param>
        /// <param name="o_nErroCode"></param>
        /// <param name="o_sErrorMessage"></param>
        /// <returns></returns>
        public List <TradingTransactionMasterDTO_OS> Get_PanNumber_OS(TradingTransactionMasterDTO_OS objTradingTransactionMasterDTO, string i_sConnectionString)
        {
            List <TradingTransactionMasterDTO_OS> lstPanNo_OS = new List <TradingTransactionMasterDTO_OS>();

            try
            {
                using (var objTradingTransactionDAL_OS = new InsiderTradingDAL.TradingTransactionDAL_OS())
                {
                    lstPanNo_OS = objTradingTransactionDAL_OS.GetPanNumber_OS(objTradingTransactionMasterDTO, i_sConnectionString).ToList <TradingTransactionMasterDTO_OS>();
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(lstPanNo_OS);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="i_sConnectionString"></param>
        /// <param name="i_nUserInfoId"></param>
        /// <param name="o_nReturnValue"></param>
        /// <param name="o_nErroCode"></param>
        /// <param name="o_sErrorMessage"></param>
        /// <returns></returns>
        public InsiderTradingDAL.TradingTransactionMasterDTO_OS GetTradingTransactionMasterCreate(string i_sConnectionString,
                                                                                                  TradingTransactionMasterDTO_OS objTradingTransactionMasterDTO_OS, int i_nLoggedInUserId, out int o_iDisclosureCompletedFlag)
        {
            InsiderTradingDAL.TradingTransactionMasterDTO_OS res = null;

            try
            {
                //InsiderTradingDAL.TradingTransactionDAL objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL();
                using (var objTradingTransactionDAL_OS = new InsiderTradingDAL.TradingTransactionDAL_OS())
                {
                    res = objTradingTransactionDAL_OS.GetTransactionMasterCreate(i_sConnectionString, objTradingTransactionMasterDTO_OS, i_nLoggedInUserId, out o_iDisclosureCompletedFlag);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(res);
        }