/// <summary>
/// This method is used for the delete Trading Policy
/// </summary>
/// <param name="i_sConnectionString">DB COnnection string</param>
/// <param name="i_nTradingPolicyId">Trading Policy ID</param>
/// <param name="inp_nUserId">Logged In User ID</param>
/// <returns></returns>
public bool Delete(string i_sConnectionString, int i_nTradingPolicyId, int inp_nUserId)
{
TradingPolicyDTO res = null;
bool bReturn = false;
#region Paramters
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
PetaPoco.Database db = null;
#endregion Paramters
try
{
var nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int);
nReturnValue.Direction = System.Data.ParameterDirection.Output;
// nReturnValue.Value = 0;
var nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int);
nSQLErrCode.Direction = System.Data.ParameterDirection.Output;
nSQLErrCode.Value = 0;
var sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.VarChar);
sSQLErrMessage.Direction = System.Data.ParameterDirection.Output;
sSQLErrMessage.Value = "";
sSQLErrMessage.Size = 500;
using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
res = db.Query <TradingPolicyDTO>("exec st_rul_TradingPolicyDelete @inp_iTradingPolicyId, @inp_nUserId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
inp_iTradingPolicyId = i_nTradingPolicyId,
inp_nUserId,
out_nReturnValue = nReturnValue,
out_nSQLErrCode = nSQLErrCode,
out_sSQLErrMessage = sSQLErrMessage
}).SingleOrDefault <TradingPolicyDTO>();
if (Convert.ToInt32(nReturnValue.Value) != 0)
{
Exception e = new Exception();
out_nReturnValue = Convert.ToInt32(nReturnValue.Value);
string sReturnValue = sLookUpPrefix + out_nReturnValue;
e.Data[0] = sReturnValue;
if (nSQLErrCode.Value != System.DBNull.Value)
{
out_nSQLErrCode = Convert.ToInt32(nSQLErrCode.Value);
e.Data[1] = out_nSQLErrCode;
}
if (sSQLErrMessage.Value != System.DBNull.Value)
{
out_sSQLErrMessage = Convert.ToString(sSQLErrMessage.Value);
e.Data[2] = out_sSQLErrMessage;
}
bReturn = false;
Exception ex = new Exception(db.LastSQL.ToString(), e);
throw ex;
}
else
{
scope.Complete();
bReturn = true;
}
}
}
}
catch (Exception exp)
{
bReturn = false;
throw exp;
}
return(bReturn);
}
/// <summary>
/// This method is used for the get details for trading policy details.
/// </summary>
/// <param name="i_sConnectionString">DB COnnection string</param>
/// <param name="i_nTradingPolicyId">Trading Policy ID</param>
/// <returns></returns>
public InsiderTradingDAL.TradingPolicyDTO GetUserwiseOverlapTradingPolicyCount(string i_sConnectionString, int i_nTradingPolicyId, out int out_nCountUserAndOverlapTradingPolicy)
{
TradingPolicyDTO res = null;
//bool bReturn = false;
string sErrCode = string.Empty;
#region Paramters
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
PetaPoco.Database db = null;
#endregion Paramters
try
{
var nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int);
nReturnValue.Direction = System.Data.ParameterDirection.Output;
var nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int);
nSQLErrCode.Direction = System.Data.ParameterDirection.Output;
nSQLErrCode.Value = 0;
var sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.VarChar);
sSQLErrMessage.Direction = System.Data.ParameterDirection.Output;
sSQLErrMessage.Value = "";
sSQLErrMessage.Size = 500;
var nCountUserAndOverlapTradingPolicy = new SqlParameter("@out_nCountUserAndOverlapTradingPolicy", System.Data.SqlDbType.Int);
nCountUserAndOverlapTradingPolicy.Direction = System.Data.ParameterDirection.Output;
using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
db.CommandTimeout = 5000;
using (var scope = db.GetTransaction())
{
res = db.Query <TradingPolicyDTO>("exec st_rul_UserwiseOverlapTradingPolicyCount @inp_iTradingPolicyId,@out_nCountUserAndOverlapTradingPolicy OUTPUT,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
inp_iTradingPolicyId = i_nTradingPolicyId,
out_nCountUserAndOverlapTradingPolicy = nCountUserAndOverlapTradingPolicy,
out_nReturnValue = nReturnValue,
out_nSQLErrCode = nSQLErrCode,
out_sSQLErrMessage = sSQLErrMessage
}).FirstOrDefault <TradingPolicyDTO>();
if (Convert.ToInt32(nReturnValue.Value) != 0)
{
Exception e = new Exception();
out_nReturnValue = Convert.ToInt32(nReturnValue.Value);
string sReturnValue = sLookUpPrefix + out_nReturnValue;
e.Data[0] = sReturnValue;
if (nSQLErrCode.Value != System.DBNull.Value)
{
out_nSQLErrCode = Convert.ToInt32(nSQLErrCode.Value);
e.Data[1] = out_nSQLErrCode;
}
if (sSQLErrMessage.Value != System.DBNull.Value)
{
out_sSQLErrMessage = Convert.ToString(sSQLErrMessage.Value);
e.Data[2] = out_sSQLErrMessage;
}
//bReturn = false;
Exception ex = new Exception(db.LastSQL.ToString(), e);
throw ex;
}
else
{
out_nCountUserAndOverlapTradingPolicy = Convert.ToInt32(nCountUserAndOverlapTradingPolicy.Value);
scope.Complete();
}
}
}
}
catch (Exception exp)
{
//bReturn = false;
throw exp;
}
return(res);
}
/// <summary>
/// This method is used for the save Trading policy details
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="m_objTradingPolicyDTO">object TradingPolicyDTO</param>
/// <returns></returns>
public TradingPolicyDTO Save(string i_sConnectionString, TradingPolicyDTO m_objTradingPolicyDTO, DataTable i_tblPreclearanceSecuritywise,
DataTable i_tblContinousSecuritywise, DataTable i_tblPreclearanceTransactionSecurityMap)
{
#region Paramters
//bool bReturn = false;
int out_nReturnValue;
int out_nSQLErrCode;
string out_sSQLErrMessage;
TradingPolicyDTO res = null;
PetaPoco.Database db = null;
#endregion Paramters
try
{
#region Output Param
var nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int);
nReturnValue.Direction = System.Data.ParameterDirection.Output;
nReturnValue.Value = 0;
var nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int);
nSQLErrCode.Direction = System.Data.ParameterDirection.Output;
nSQLErrCode.Value = 0;
var sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.VarChar);
sSQLErrMessage.Direction = System.Data.ParameterDirection.Output;
sSQLErrMessage.Value = "";
sSQLErrMessage.Size = 500;
var inp_tblPreclearanceSecuritywise = new SqlParameter();
inp_tblPreclearanceSecuritywise.DbType = DbType.Object;
inp_tblPreclearanceSecuritywise.ParameterName = "@inp_tblPreClearanceSecuritywise";
inp_tblPreclearanceSecuritywise.TypeName = "dbo.SecuritywiseLimitsType";
inp_tblPreclearanceSecuritywise.SqlValue = i_tblPreclearanceSecuritywise;
inp_tblPreclearanceSecuritywise.SqlDbType = SqlDbType.Structured;
var inp_tblContinousSecuritywise = new SqlParameter();
inp_tblContinousSecuritywise.DbType = DbType.Object;
inp_tblContinousSecuritywise.ParameterName = "@inp_tblContinousSecuritywise";
inp_tblContinousSecuritywise.TypeName = "dbo.SecuritywiseLimitsType";
inp_tblContinousSecuritywise.SqlValue = i_tblContinousSecuritywise;
inp_tblContinousSecuritywise.SqlDbType = SqlDbType.Structured;
var inp_tblPreclearanceTransactionSecurityMap = new SqlParameter();
inp_tblPreclearanceTransactionSecurityMap.DbType = DbType.Object;
inp_tblPreclearanceTransactionSecurityMap.ParameterName = "@inp_tblPreclearanceTransactionSecurityMap";
inp_tblPreclearanceTransactionSecurityMap.TypeName = "dbo.TradingPolicyForTransactionSecurityMap";
inp_tblPreclearanceTransactionSecurityMap.SqlValue = i_tblPreclearanceTransactionSecurityMap;
inp_tblPreclearanceTransactionSecurityMap.SqlDbType = SqlDbType.Structured;
#endregion Output Param
using (db = new PetaPoco.Database(i_sConnectionString, "System.Data.SqlClient")
{
EnableAutoSelect = false
})
{
using (var scope = db.GetTransaction())
{
res = db.Query <TradingPolicyDTO>("exec st_rul_TradingPolicySave @inp_iTradingPolicyId,@inp_iTradingPolicyParentId,"
+ "@inp_iCurrentHistoryCodeId,@inp_iTradingPolicyForCodeId,@inp_sTradingPolicyName,@inp_sTradingPolicyDescription,@inp_dtApplicableFromDate,"
+ "@inp_dtApplicableToDate,@inp_bPreClrTradesApprovalReqFlag,@inp_iPreClrSingleTransTradeNoShares,"
+ "@inp_iPreClrSingleTransTradePercPaidSubscribedCap,@inp_bPreClrProhibitNonTradePeriodFlag,@inp_iPreClrCOApprovalLimit,"
+ "@inp_iPreClrApprovalValidityLimit,@inp_bPreClrSeekDeclarationForUPSIFlag,@inp_sPreClrUPSIDeclaration,@inp_bPreClrReasonForNonTradeReqFlag,"
+ "@inp_bPreClrCompleteTradeNotDoneFlag,@inp_bPreClrPartialTradeNotDoneFlag,@inp_iPreClrTradeDiscloLimit,"
+ "@inp_iPreClrTradeDiscloShareholdLimit,@inp_bStExSubmitTradeDiscloAllTradeFlag,@inp_iStExSingMultiTransTradeFlagCodeId,"
+ "@inp_iStExMultiTradeFreq,@inp_iStExMultiTradeCalFinYear,@inp_iStExTransTradeNoShares,@inp_iStExTransTradePercPaidSubscribedCap,"
+ "@inp_iStExTransTradeShareValue,@inp_iStExTradeDiscloSubmitLimit,@inp_bDiscloInitReqFlag,@inp_iDiscloInitLimit,"
+ "@inp_dtDiscloInitDateLimit,@inp_bDiscloPeriodEndReqFlag,@inp_iDiscloPeriodEndFreq,@inp_sGenSecurityType,@inp_bGenTradingPlanTransFlag,"
+ "@inp_iGenMinHoldingLimit,@inp_iGenContraTradeNotAllowedLimit,@inp_sGenExceptionFor,@inp_iTradingPolicyStatusCodeId,"
+ "@inp_bDiscloInitSubmitToStExByCOFlag,@inp_bStExSubmitDiscloToStExByCOFlag,@inp_iDiscloPeriodEndToCOByInsdrLimit,@inp_bDiscloPeriodEndSubmitToStExByCOFlag,@inp_iDiscloPeriodEndSubmitToStExByCOLimit,"
+ "@inp_bDiscloInitReqSoftcopyFlag,@inp_bDiscloInitReqHardcopyFlag,@inp_bDiscloInitSubmitToStExByCOSoftcopyFlag,@inp_bDiscloInitSubmitToStExByCOHardcopyFlag,"
+ "@inp_iStExTradePerformDtlsSubmitToCOByInsdrLimit,@inp_bStExSubmitDiscloToStExByCOSoftcopyFlag,@inp_bStExSubmitDiscloToStExByCOHardcopyFlag,"
+ "@inp_bDiscloPeriodEndReqSoftcopyFlag,@inp_bDiscloPeriodEndReqHardcopyFlag,@inp_bDiscloPeriodEndSubmitToStExByCOSoftcopyFlag,@inp_bDiscloPeriodEndSubmitToStExByCOHardcopyFlag,"
+ "@inp_bStExSubmitDiscloToCOByInsdrFlag,@inp_bStExSubmitDiscloToCOByInsdrSoftcopyFlag,@inp_bStExSubmitDiscloToCOByInsdrHardcopyFlag,"
+ "@inp_bPreClrForAllSecuritiesFlag,@inp_bStExForAllSecuritiesFlag,"
+ "@inp_sSelectedPreClearancerequiredforTransactionValue,@inp_sSelectedPreClearanceProhibitforNonTradingforTransactionValue,"
+ "@inp_tblPreClearanceSecuritywise,@inp_tblContinousSecuritywise,"
+ "@inp_tblPreclearanceTransactionSecurityMap,@inp_bPreClrAllowNewForOpenPreclearFlag,@inp_iPreClrMultipleAboveInCodeId,"
+ "@inp_iPreClrApprovalPreclearORPreclearTradeFlag,"
+ "@inp_bPreClrTradesAutoApprovalReqFlag,@inp_iPreClrSingMultiPreClrFlagCodeId,"
+ "@inp_iGenCashAndCashlessPartialExciseOptionForContraTrade,@inp_bGenSecuritiesPriortoAcquisitionManualInputorAutoCalculate,"
+ "@inp_bTradingThresholdLimtResetFlag,@inp_nContraTradeBasedOn,@inp_sSelectedContraTradeSecuirtyType, "
+ "@inp_nUserId,@inp_SeekDeclarationFromEmpRegPossessionOfUPSIFlag,@inp_DeclarationFromInsiderAtTheTimeOfContinuousDisclosures,@inp_DeclarationToBeMandatoryFlag,@inp_DisplayDeclarationPostSubmissionOfContinuouseDisclosureFlag,"
+ "@inp_bIsPreclearanceFormForImplementingCompany,@inp_iPreclearanceWithoutPeriodEndDisclosure,@inp_PreClrApprovalReasonReqFlag,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT",
new
{
inp_iTradingPolicyId = m_objTradingPolicyDTO.TradingPolicyId,
inp_iTradingPolicyParentId = m_objTradingPolicyDTO.TradingPolicyParentId,
inp_iCurrentHistoryCodeId = m_objTradingPolicyDTO.CurrentHistoryCodeId,
inp_iTradingPolicyForCodeId = m_objTradingPolicyDTO.TradingPolicyForCodeId,
inp_sTradingPolicyName = m_objTradingPolicyDTO.TradingPolicyName,
inp_sTradingPolicyDescription = m_objTradingPolicyDTO.TradingPolicyDescription,
inp_dtApplicableFromDate = m_objTradingPolicyDTO.ApplicableFromDate,
inp_dtApplicableToDate = m_objTradingPolicyDTO.ApplicableToDate,
inp_bPreClrTradesApprovalReqFlag = m_objTradingPolicyDTO.PreClrTradesApprovalReqFlag,
inp_iPreClrSingleTransTradeNoShares = m_objTradingPolicyDTO.PreClrSingleTransTradeNoShares,
inp_iPreClrSingleTransTradePercPaidSubscribedCap = m_objTradingPolicyDTO.PreClrSingleTransTradePercPaidSubscribedCap,
inp_bPreClrProhibitNonTradePeriodFlag = m_objTradingPolicyDTO.PreClrProhibitNonTradePeriodFlag,
inp_iPreClrCOApprovalLimit = m_objTradingPolicyDTO.PreClrCOApprovalLimit,
inp_iPreClrApprovalValidityLimit = m_objTradingPolicyDTO.PreClrApprovalValidityLimit,
inp_bPreClrSeekDeclarationForUPSIFlag = m_objTradingPolicyDTO.PreClrSeekDeclarationForUPSIFlag,
inp_sPreClrUPSIDeclaration = m_objTradingPolicyDTO.PreClrUPSIDeclaration,
inp_bPreClrReasonForNonTradeReqFlag = m_objTradingPolicyDTO.PreClrReasonForNonTradeReqFlag,
inp_bPreClrCompleteTradeNotDoneFlag = m_objTradingPolicyDTO.PreClrCompleteTradeNotDoneFlag,
inp_bPreClrPartialTradeNotDoneFlag = m_objTradingPolicyDTO.PreClrPartialTradeNotDoneFlag,
inp_iPreClrTradeDiscloLimit = m_objTradingPolicyDTO.PreClrTradeDiscloLimit,
inp_iPreClrTradeDiscloShareholdLimit = m_objTradingPolicyDTO.PreClrTradeDiscloShareholdLimit,
inp_bStExSubmitTradeDiscloAllTradeFlag = m_objTradingPolicyDTO.StExSubmitTradeDiscloAllTradeFlag,
inp_iStExSingMultiTransTradeFlagCodeId = m_objTradingPolicyDTO.StExSingMultiTransTradeFlagCodeId,
inp_iStExMultiTradeFreq = m_objTradingPolicyDTO.StExMultiTradeFreq,
inp_iStExMultiTradeCalFinYear = m_objTradingPolicyDTO.StExMultiTradeCalFinYear,
inp_iStExTransTradeNoShares = m_objTradingPolicyDTO.StExTransTradeNoShares,
inp_iStExTransTradePercPaidSubscribedCap = m_objTradingPolicyDTO.StExTransTradePercPaidSubscribedCap,
inp_iStExTransTradeShareValue = m_objTradingPolicyDTO.StExTransTradeShareValue,
inp_iStExTradeDiscloSubmitLimit = m_objTradingPolicyDTO.StExTradeDiscloSubmitLimit,
inp_bDiscloInitReqFlag = m_objTradingPolicyDTO.DiscloInitReqFlag,
inp_iDiscloInitLimit = m_objTradingPolicyDTO.DiscloInitLimit,
inp_dtDiscloInitDateLimit = m_objTradingPolicyDTO.DiscloInitDateLimit,
inp_bDiscloPeriodEndReqFlag = m_objTradingPolicyDTO.DiscloPeriodEndReqFlag,
inp_iDiscloPeriodEndFreq = m_objTradingPolicyDTO.DiscloPeriodEndFreq,
inp_sGenSecurityType = m_objTradingPolicyDTO.GenSecurityType,
inp_bGenTradingPlanTransFlag = m_objTradingPolicyDTO.GenTradingPlanTransFlag,
inp_iGenMinHoldingLimit = m_objTradingPolicyDTO.GenMinHoldingLimit,
inp_iGenContraTradeNotAllowedLimit = m_objTradingPolicyDTO.GenContraTradeNotAllowedLimit,
inp_sGenExceptionFor = m_objTradingPolicyDTO.GenExceptionFor,
inp_iTradingPolicyStatusCodeId = m_objTradingPolicyDTO.TradingPolicyStatusCodeId,
inp_bDiscloInitSubmitToStExByCOFlag = m_objTradingPolicyDTO.DiscloInitSubmitToStExByCOFlag,
inp_bStExSubmitDiscloToStExByCOFlag = m_objTradingPolicyDTO.StExSubmitDiscloToStExByCOFlag,
inp_iDiscloPeriodEndToCOByInsdrLimit = m_objTradingPolicyDTO.DiscloPeriodEndToCOByInsdrLimit,
inp_bDiscloPeriodEndSubmitToStExByCOFlag = m_objTradingPolicyDTO.DiscloPeriodEndSubmitToStExByCOFlag,
inp_iDiscloPeriodEndSubmitToStExByCOLimit = m_objTradingPolicyDTO.DiscloPeriodEndSubmitToStExByCOLimit,
inp_bDiscloInitReqSoftcopyFlag = m_objTradingPolicyDTO.DiscloInitReqSoftcopyFlag,
inp_bDiscloInitReqHardcopyFlag = m_objTradingPolicyDTO.DiscloInitReqHardcopyFlag,
inp_bDiscloInitSubmitToStExByCOSoftcopyFlag = m_objTradingPolicyDTO.DiscloInitSubmitToStExByCOSoftcopyFlag,
inp_bDiscloInitSubmitToStExByCOHardcopyFlag = m_objTradingPolicyDTO.DiscloInitSubmitToStExByCOHardcopyFlag,
inp_iStExTradePerformDtlsSubmitToCOByInsdrLimit = m_objTradingPolicyDTO.StExTradePerformDtlsSubmitToCOByInsdrLimit,
inp_bStExSubmitDiscloToStExByCOSoftcopyFlag = m_objTradingPolicyDTO.StExSubmitDiscloToStExByCOSoftcopyFlag,
inp_bStExSubmitDiscloToStExByCOHardcopyFlag = m_objTradingPolicyDTO.StExSubmitDiscloToStExByCOHardcopyFlag,
inp_bDiscloPeriodEndReqSoftcopyFlag = m_objTradingPolicyDTO.DiscloPeriodEndReqSoftcopyFlag,
inp_bDiscloPeriodEndReqHardcopyFlag = m_objTradingPolicyDTO.DiscloPeriodEndReqHardcopyFlag,
inp_bDiscloPeriodEndSubmitToStExByCOSoftcopyFlag = m_objTradingPolicyDTO.DiscloPeriodEndSubmitToStExByCOSoftcopyFlag,
inp_bDiscloPeriodEndSubmitToStExByCOHardcopyFlag = m_objTradingPolicyDTO.DiscloPeriodEndSubmitToStExByCOHardcopyFlag,
inp_bStExSubmitDiscloToCOByInsdrFlag = m_objTradingPolicyDTO.StExSubmitDiscloToCOByInsdrFlag,
inp_bStExSubmitDiscloToCOByInsdrSoftcopyFlag = m_objTradingPolicyDTO.StExSubmitDiscloToCOByInsdrSoftcopyFlag,
inp_bStExSubmitDiscloToCOByInsdrHardcopyFlag = m_objTradingPolicyDTO.StExSubmitDiscloToCOByInsdrHardcopyFlag,
inp_bPreClrForAllSecuritiesFlag = m_objTradingPolicyDTO.PreClrForAllSecuritiesFlag,
inp_bStExForAllSecuritiesFlag = m_objTradingPolicyDTO.StExForAllSecuritiesFlag,
inp_sSelectedPreClearancerequiredforTransactionValue = m_objTradingPolicyDTO.SelectedPreClearancerequiredforTransactionValue,
inp_sSelectedPreClearanceProhibitforNonTradingforTransactionValue = m_objTradingPolicyDTO.SelectedPreClearanceProhibitforNonTradingforTransactionValue,
inp_tblPreClearanceSecuritywise = inp_tblPreclearanceSecuritywise,
inp_tblContinousSecuritywise = inp_tblContinousSecuritywise,
inp_tblPreclearanceTransactionSecurityMap = inp_tblPreclearanceTransactionSecurityMap,
inp_bPreClrAllowNewForOpenPreclearFlag = m_objTradingPolicyDTO.PreClrAllowNewForOpenPreclearFlag,
inp_iPreClrMultipleAboveInCodeId = m_objTradingPolicyDTO.PreClrMultipleAboveInCodeId,
inp_iPreClrApprovalPreclearORPreclearTradeFlag = m_objTradingPolicyDTO.PreClrApprovalPreclearORPreclearTradeFlag,
inp_bPreClrTradesAutoApprovalReqFlag = m_objTradingPolicyDTO.PreClrTradesAutoApprovalReqFlag,
inp_iPreClrSingMultiPreClrFlagCodeId = m_objTradingPolicyDTO.PreClrSingMultiPreClrFlagCodeId,
inp_iGenCashAndCashlessPartialExciseOptionForContraTrade = m_objTradingPolicyDTO.GenCashAndCashlessPartialExciseOptionForContraTrade,
inp_bGenSecuritiesPriortoAcquisitionManualInputorAutoCalculate = m_objTradingPolicyDTO.GenSecuritiesPriortoAcquisitionManualInputorAutoCalculate,
@inp_bTradingThresholdLimtResetFlag = m_objTradingPolicyDTO.TradingThresholdLimtResetFlag,
@inp_nContraTradeBasedOn = m_objTradingPolicyDTO.ContraTradeBasedOn,
inp_sSelectedContraTradeSecuirtyType = m_objTradingPolicyDTO.SelectedContraTradeSecuirtyType,
inp_nUserId = m_objTradingPolicyDTO.LoggedInUserId,
//New column added on 2-Jun-2016(YES BANK customization)
inp_SeekDeclarationFromEmpRegPossessionOfUPSIFlag = m_objTradingPolicyDTO.SeekDeclarationFromEmpRegPossessionOfUPSIFlag,
inp_DeclarationFromInsiderAtTheTimeOfContinuousDisclosures = m_objTradingPolicyDTO.DeclarationFromInsiderAtTheTimeOfContinuousDisclosures,
inp_DeclarationToBeMandatoryFlag = m_objTradingPolicyDTO.DeclarationToBeMandatoryFlag,
inp_DisplayDeclarationPostSubmissionOfContinuouseDisclosureFlag = m_objTradingPolicyDTO.DisplayDeclarationPostSubmissionOfContinuouseDisclosureFlag,
@inp_bIsPreclearanceFormForImplementingCompany = m_objTradingPolicyDTO.IsPreclearanceFormForImplementingCompany,
@inp_iPreclearanceWithoutPeriodEndDisclosure = m_objTradingPolicyDTO.PreclearanceWithoutPeriodEndDisclosure,
@inp_PreClrApprovalReasonReqFlag = m_objTradingPolicyDTO.PreClrApprovalReasonReqFlag,
out_nReturnValue = nReturnValue,
out_nSQLErrCode = nSQLErrCode,
out_sSQLErrMessage = sSQLErrMessage
}).SingleOrDefault <TradingPolicyDTO>();
#region Error Values
if (Convert.ToInt32(nReturnValue.Value) != 0)
{
Exception e = new Exception();
out_nReturnValue = Convert.ToInt32(nReturnValue.Value);
string sReturnValue = sLookUpPrefix + out_nReturnValue;
e.Data[0] = sReturnValue;
if (nSQLErrCode.Value != System.DBNull.Value)
{
out_nSQLErrCode = Convert.ToInt32(nSQLErrCode.Value);
e.Data[1] = out_nSQLErrCode;
}
if (sSQLErrMessage.Value != System.DBNull.Value)
{
out_sSQLErrMessage = Convert.ToString(sSQLErrMessage.Value);
e.Data[2] = out_sSQLErrMessage;
}
Exception ex = new Exception(db.LastSQL.ToString(), e);
//bReturn = false;
throw ex;
}
else
{
scope.Complete();
//bReturn = true;
}
#endregion Error Values
}
}
}
catch (Exception exp)
{
throw exp;
}
return(res);
}