public int TradingTransactionConfirmHoldingsFor(Int64 nTransactionMasterId, int nConfirmCompanyHoldingsFor, int nConfirmNonCompanyHoldingsFor, int nLoggedInUserId, string sConnectionString, string sLookupPrefix = "usr_com_")
 {
     try
     {
         using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
         {
             return(objTradingTransactionDAL.TradingTransactionConfirmHoldingsFor(nTransactionMasterId, nConfirmCompanyHoldingsFor, nConfirmNonCompanyHoldingsFor, nLoggedInUserId, sConnectionString, sLookupPrefix));
         }
     }
     catch (Exception exp)
     {
         throw exp;
     }
 }
Example #2
0
 public TradingTransactionSummaryDTO GetTransactionSummary(string sConnectionString, Int64 m_iTransactionMasterId, Int64 m_iPreclearanceId)
 {
     try
     {
         using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
         {
             return(objTradingTransactionDAL.GetTransactionSummary(sConnectionString, m_iTransactionMasterId, m_iPreclearanceId));
         }
     }
     catch (Exception exp)
     {
         throw exp;
     }
 }
 public bool IsAllowNegativeBalanceForSecurity(int nSecuirtyTypeCodeID, string sConnectionString)
 {
     try
     {
         using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
         {
             return(objTradingTransactionDAL.IsAllowNegativeBalanceForSecurity(nSecuirtyTypeCodeID, sConnectionString));
         }
     }
     catch (Exception exp)
     {
         throw exp;
     }
 }
        /// <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> Get_CDTransIdduringPE(TradingTransactionMasterDTO objTradingTransactionMasterDTO, string i_sConnectionString, bool cdDuringPE)
        {
            List <TradingTransactionMasterDTO> lstTransId = new List <TradingTransactionMasterDTO>();

            try
            {
                using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
                {
                    lstTransId = objTradingTransactionDAL.GetCDTransIdduringPE(objTradingTransactionMasterDTO, i_sConnectionString, cdDuringPE).ToList <TradingTransactionMasterDTO>();
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(lstTransId);
        }
Example #5
0
        /// <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> Get_PanNumber(TradingTransactionMasterDTO objTradingTransactionMasterDTO, string i_sConnectionString)
        {
            List <TradingTransactionMasterDTO> lstPanNo = new List <TradingTransactionMasterDTO>();

            try
            {
                using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
                {
                    lstPanNo = objTradingTransactionDAL.GetPanNumber(objTradingTransactionMasterDTO, i_sConnectionString).ToList <TradingTransactionMasterDTO>();
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(lstPanNo);
        }
Example #6
0
        /// <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 <DuplicateTransactionDetailsDTO> CheckDuplicateTransaction(string i_sConnectionString, int nLoggedInUserId, int nSecurityType, int nTransactionType, DateTime?dtTransactionDate, long nTransactionId)
        {
            List <DuplicateTransactionDetailsDTO> objDuplicateTransactionsDTO = new List <DuplicateTransactionDetailsDTO>();

            try
            {
                using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
                {
                    objDuplicateTransactionsDTO = objTradingTransactionDAL.CheckDuplicateTransaction(i_sConnectionString, nLoggedInUserId, nSecurityType, nTransactionType, dtTransactionDate, nTransactionId);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(objDuplicateTransactionsDTO);
        }
        /// <summary>
        /// This method is used for the insert/Update trading transaction letter details.
        /// </summary>
        /// <param name="i_sConnectionString">Connection string</param>
        /// <param name="i_objTransactionLetterDTO">Trading Transaction letter Object</param>
        /// <param name="i_nLoggedInUserID">Logged In User ID</param>
        /// <returns></returns>
        public TemplateMasterDTO InsertUpdateTradingTransactionLetterDetails(string i_sConnectionString, TemplateMasterDTO i_objTemplateMasterDTO, int i_nLoggedInUserID)
        {
            TemplateMasterDTO objTemplateMasterDTO = new TemplateMasterDTO();

            try
            {
                //TradingTransactionDAL objTradingTransactionDAL = new TradingTransactionDAL();
                using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
                {
                    objTemplateMasterDTO = objTradingTransactionDAL.InsertUpdateTradingTransactionLetterDetails(i_sConnectionString, i_objTemplateMasterDTO, i_nLoggedInUserID);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(objTemplateMasterDTO);
        }
        /// <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 TemplateMasterDTO GetTransactionLetterDetails(string i_sConnectionString, Int64 i_nTransactionLetterId, Int64 i_nTransactionMasterId, int i_nDisclosureTypeCodeId, int i_nLetterForCodeId, int i_nCommunicationModeCodeId)
        {
            TemplateMasterDTO objTemplateMasterDTO = new TemplateMasterDTO();

            try
            {
                //TradingTransactionDAL objTradingTransactionDAL = new TradingTransactionDAL();
                using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
                {
                    objTemplateMasterDTO = objTradingTransactionDAL.GetTransactionLetterDetails(i_sConnectionString, i_nTransactionLetterId, i_nTransactionMasterId, i_nDisclosureTypeCodeId, i_nLetterForCodeId, i_nCommunicationModeCodeId);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }

            return(objTemplateMasterDTO);
        }
Example #9
0
        /// <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 GetTradingTransactionMasterDetails(string i_sConnectionString, Int64 m_iTransactionMasterId)
        {
            InsiderTradingDAL.TradingTransactionMasterDTO res = null;

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

            return(res);
        }
Example #10
0
        /// <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 GetTradingTransactionMasterCreate(string i_sConnectionString,
                                                                                               TradingTransactionMasterDTO objTradingTransactionMasterDTO, int i_nLoggedInUserId, out int o_iDisclosureCompletedFlag)
        {
            InsiderTradingDAL.TradingTransactionMasterDTO res = null;

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

            return(res);
        }
Example #11
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="i_sConnectionString"></param>
        /// <param name="i_objUserInfoDTO"></param>
        /// <returns></returns>
        public bool DeleteTradingTransactionMaster(string i_sConnectionString, int m_iTransactionMasterId, int i_nLoggedInUserID)
        {
            bool bReturn = false;

            try
            {
                //InsiderTradingDAL.TradingTransactionDAL objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL();
                using (var objTradingTransactionDAL = new InsiderTradingDAL.TradingTransactionDAL())
                {
                    bReturn = objTradingTransactionDAL.DeleteTradingTransactionMaster(i_sConnectionString, m_iTransactionMasterId, i_nLoggedInUserID);
                }
            }
            catch (Exception exp)
            {
                bReturn = false;
                throw exp;
            }

            return(bReturn);
        }