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