/// <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 GetTradingTransactionMasterDetails(string i_sConnectionString, Int64 m_iTransactionMasterId)
        {
            InsiderTradingDAL.TradingTransactionMasterDTO_OS res = null;

            try
            {
                //InsiderTradingDAL.TradingTransactionDAL objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL();
                using (var objTradingTransactionDAL_OS = new InsiderTradingDAL.TradingTransactionDAL_OS())
                {
                    res = objTradingTransactionDAL_OS.GetTransactionMasterDetails(i_sConnectionString, m_iTransactionMasterId);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(res);
        }
        public InsiderTradingDAL.TradingTransactionMasterDTO_OS GetQuantity(string sConnectionString, int m_iDisclosureTypeCodeId, int m_iUserInfoId)
        {
            InsiderTradingDAL.TradingTransactionMasterDTO_OS res = null;

            try
            {
                //InsiderTradingDAL.TradingTransactionDAL objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL();
                using (var objTradingTransactionDAL_OS = new InsiderTradingDAL.TradingTransactionDAL_OS())
                {
                    res = objTradingTransactionDAL_OS.GetQunatityValue(sConnectionString, m_iDisclosureTypeCodeId, m_iUserInfoId);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(res);
        }
        /// <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);
        }