public bool PreclearanceRequestApproveRejectSave_OS(string sConnectionString, DataTable dt_PreClearanceList, DataTable dt_PreclearanceRequestId, bool?preclearanceNotTakenFlag, int?reasonForNotTradingCodeId,
string reasonForNotTradingText, int?userID, int preclearanceStatusCodeId, string reasonForRejection, string reasonForApproval, int?ReasonForApprovalCodeId)
{
bool returnVal = false;
using (PreclearanceRequestNonImplCompanyDAL objPreclearanceRequestNonImplCompanyDAL = new PreclearanceRequestNonImplCompanyDAL())
{
returnVal = objPreclearanceRequestNonImplCompanyDAL.PreclearanceRequestApproveRejectSave_OS(sConnectionString, dt_PreClearanceList, dt_PreclearanceRequestId, preclearanceNotTakenFlag, reasonForNotTradingCodeId,
reasonForNotTradingText, userID, preclearanceStatusCodeId, reasonForRejection, reasonForApproval, ReasonForApprovalCodeId);
}
return(returnVal);
}
public InsiderTradingDAL.PreclearanceRequestNonImplCompanyDTO GetLastPeriodEndSubmissonFlag_OS(string i_sConnectionString, int i_nUserInfoID, out int out_nIsPreviousPeriodEndSubmission, out string out_sSubsequentPeriodEndOrPreciousPeriodEndResource, out string out_sSubsequentPeriodEndResourceOtherSecurity)
{
try
{
using (var objPreclearanceRequestDAL = new PreclearanceRequestNonImplCompanyDAL())
{
return(objPreclearanceRequestDAL.GetLastPeriodEndSubmissonFlag_OS(i_sConnectionString, i_nUserInfoID, out out_nIsPreviousPeriodEndSubmission, out out_sSubsequentPeriodEndOrPreciousPeriodEndResource, out out_sSubsequentPeriodEndResourceOtherSecurity));
}
}
catch (Exception exp)
{
throw exp;
}
}
/// <summary>
/// This method is used to get pre-clearance request details
/// </summary>
/// <param name="sConnectionString"></param>
/// <param name="nPreclearanceRequestId"></param>
/// <returns></returns>
public PreclearanceRequestNonImplCompanyDTO GetPreclearanceRequestDetail(string sConnectionString, long nPreclearanceRequestId)
{
PreclearanceRequestNonImplCompanyDTO objPreclearanceRequestNonImplCompanyDTO = null;
try
{
using (PreclearanceRequestNonImplCompanyDAL objPreclearanceRequestNonImplCompanyDAL = new PreclearanceRequestNonImplCompanyDAL())
{
objPreclearanceRequestNonImplCompanyDTO = objPreclearanceRequestNonImplCompanyDAL.GetPreclearanceRequestDetail(sConnectionString, nPreclearanceRequestId);
}
}
catch (Exception ex)
{
throw;
}
return(objPreclearanceRequestNonImplCompanyDTO);
}
/// <summary>
/// This method is used to save pre-clearance request
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_objPreclearanceRequestNonImplCompanyDTO"></param>
/// <returns></returns>
public bool SavePreclearanceRequest(string i_sConnectionString, DataTable dt_PreClearanceList)
{
bool IsSave = false;
try
{
using (PreclearanceRequestNonImplCompanyDAL objPreclearanceRequestNonImplCompanyDAL = new PreclearanceRequestNonImplCompanyDAL())
{
IsSave = objPreclearanceRequestNonImplCompanyDAL.SavePreclearanceRequest(i_sConnectionString, dt_PreClearanceList);
}
}
catch (Exception ex)
{
throw;
}
return(IsSave);
}
/// <summary>
/// This method is used to get security balance details for user
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_nUserInfoId"></param>
/// <param name="i_nSecurityTypeCodeId"></param>
/// <returns></returns>
public BalancePoolOSDTO GetSecurityBalanceDetailsFromPool(string i_sConnectionString, int?i_nUserInfoId, int i_nSecurityTypeCodeId, int i_nDMATDetailsID, int i_nCompanyID)
{
BalancePoolOSDTO objExerciseBalancePoolDTO = null;
try
{
//PreclearanceRequestDAL objPreclearanceRequestDAL = new PreclearanceRequestDAL();
using (var objPreclearanceRequestNonImplCompanyDAL = new PreclearanceRequestNonImplCompanyDAL())
{
objExerciseBalancePoolDTO = objPreclearanceRequestNonImplCompanyDAL.GetSecurityBalanceDetailsFromPool(i_sConnectionString, i_nUserInfoId, i_nSecurityTypeCodeId, i_nDMATDetailsID, i_nCompanyID);
}
}
catch (Exception exp)
{
throw exp;
}
return(objExerciseBalancePoolDTO);
}
public int ValidatePreclearanceRequest(string i_sConnectionString, int preclearanceRequestId, int tradingPolicyID, int userInfoId, int?userInfoIdRelative,
int transactionTypeCodeId, int securityTypeCodeId, decimal?securitiesToBeTradedQty, decimal?securitiesToBeTradedValue, int companyId,
int modeOfAcquisitionCodeId, int DMATDetailsID, int DisplaySequenceNo, out bool out_bIsContraTrade, out string sContraTradeDate, out bool iIsAutoApproved)
{
int returnVal = 0;
try
{
using (PreclearanceRequestNonImplCompanyDAL objPreclearanceRequestNonImplCompanyDAL = new PreclearanceRequestNonImplCompanyDAL())
{
returnVal = objPreclearanceRequestNonImplCompanyDAL.ValidatePreclearanceRequest(i_sConnectionString, preclearanceRequestId, tradingPolicyID, userInfoId, userInfoIdRelative,
transactionTypeCodeId, securityTypeCodeId, securitiesToBeTradedQty, securitiesToBeTradedValue, companyId, modeOfAcquisitionCodeId, DMATDetailsID, DisplaySequenceNo, out out_bIsContraTrade, out sContraTradeDate, out iIsAutoApproved);
}
}
catch (Exception ex)
{
throw;
}
return(returnVal);
}
/// <summary>
/// This method is used to save pre-clearance request
/// </summary>
/// <param name="i_sConnectionString"></param>
/// <param name="i_objPreclearanceRequestNonImplCompanyDTO"></param>
/// <returns></returns>
public bool SavePreclearanceRequest_OS(string i_sConnectionString, DataTable dt_PreClearanceList, int?preclearanceRequestId, bool?preclearanceNotTakenFlag, int?reasonForNotTradingCodeId,
string reasonForNotTradingText, int?userID, string preclearanceStatusCodeId, string reasonForRejection, string reasonForApproval, int?ReasonForApprovalCodeId, int?displaySequenceNo)
{
bool returnVal = false;
try
{
using (PreclearanceRequestNonImplCompanyDAL objPreclearanceRequestNonImplCompanyDAL = new PreclearanceRequestNonImplCompanyDAL())
{
returnVal = objPreclearanceRequestNonImplCompanyDAL.SavePreclearanceRequest_OS(i_sConnectionString, dt_PreClearanceList, preclearanceRequestId, preclearanceNotTakenFlag, reasonForNotTradingCodeId,
reasonForNotTradingText, userID, preclearanceStatusCodeId, reasonForRejection, reasonForApproval, ReasonForApprovalCodeId, displaySequenceNo);
}
}
catch (Exception ex)
{
throw;
}
return(returnVal);
}
