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