/// <summary>
/// Update Advisor Dynamic RiskQuestions Options
/// Added by Vinayak Patil...
/// </summary>
/// <param name="adviserDynamicRiskQuestionsVo"></param>
/// <param name="AdviserMaintainableOrNot"></param>
/// <param name="InsertAdviserQuestionOROptions"></param>
/// <returns></returns>
public bool UpdateAdvisorDynamicRiskQuestionsOptions(AdviserDynamicRiskQuestionsVo adviserDynamicRiskQuestionsVo)
{
bool bResult = false;
AdviserFPConfigurationDao adviserFPConfigurationDao = new AdviserFPConfigurationDao();
try
{
bResult = adviserFPConfigurationDao.UpdateAdvisorDynamicRiskQuestionsOptions(adviserDynamicRiskQuestionsVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorBo.cs:UpdateAdvisorDynamicRiskQuestions(AdviserDynamicRiskQuestionsVo adviserDynamicRiskQuestionsVo)");
object[] objects = new object[3];
objects[0] = adviserDynamicRiskQuestionsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
/// <summary>
/// Create Advisor Dynamic RiskQuestions Options
/// Added by Vinayak Patil...
/// </summary>
/// <param name="adviserDynamicRiskQuestionsVo"></param>
/// <param name="AdviserMaintainableOrNot"></param>
/// <param name="InsertAdviserQuestionOROptions"></param>
/// <returns></returns>
public int CreateAdvisorDynamicRiskQuestionsOptions(AdviserDynamicRiskQuestionsVo adviserDynamicRiskQuestionsVo)
{
int qustionID = 0;
AdviserFPConfigurationDao adviserFPConfigurationDao = new AdviserFPConfigurationDao();
try
{
qustionID = adviserFPConfigurationDao.CreateAdvisorDynamicRiskQuestionsOptions(adviserDynamicRiskQuestionsVo);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffDao.cs:CreateAdvisorDynamicRiskQuestionsOptions()");
object[] objects = new object[3];
objects[0] = adviserDynamicRiskQuestionsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(qustionID);
}
//******************RiskScore END********************************************************
/// <summary>
/// Create Advisor Dynamic RiskQuestions
/// Added by Vinayak Patil...
/// </summary>
/// <param name="adviserDynamicRiskQuestionsVo"></param>
/// <param name="AdviserMaintainableOrNot"></param>
/// <param name="InsertAdviserQuestionOROptions"></param>
/// <returns></returns>
public int CreateAdvisorDynamicRiskQuestions(AdviserDynamicRiskQuestionsVo adviserDynamicRiskQuestionsVo)
{
int qustionID = 0;
Database db;
DbCommand createAdvisorStaffCmd;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
createAdvisorStaffCmd = db.GetStoredProcCommand("SP_CreateAdvisorDynamicRiskProfileQuestions");
db.AddInParameter(createAdvisorStaffCmd, "@AdvisorId", DbType.Int32, adviserDynamicRiskQuestionsVo.AdviserId);
db.AddInParameter(createAdvisorStaffCmd, "@QM_Question", DbType.String, adviserDynamicRiskQuestionsVo.Question);
db.AddInParameter(createAdvisorStaffCmd, "@QM_Purpose", DbType.String, adviserDynamicRiskQuestionsVo.Purpose);
db.AddInParameter(createAdvisorStaffCmd, "@QM_IsImageAttached", DbType.Int32, 0);
db.AddInParameter(createAdvisorStaffCmd, "@QM_ImageLocation", DbType.String, "");
db.AddInParameter(createAdvisorStaffCmd, "@QM_IsActive", DbType.Int32, 0);
db.AddOutParameter(createAdvisorStaffCmd, "@QM_QustionID", DbType.Int32, 0);
if (db.ExecuteNonQuery(createAdvisorStaffCmd) != 0)
{
qustionID = int.Parse(db.GetParameterValue(createAdvisorStaffCmd, "@QM_QustionID").ToString());
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffDao.cs:CreateAdvisorStaff()");
object[] objects = new object[3];
objects[0] = adviserDynamicRiskQuestionsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(qustionID);
}
public bool UpdateAdvisorDynamicRiskQuestionsOptions(AdviserDynamicRiskQuestionsVo adviserDynamicRiskQuestionsVo)
{
bool bResult = false;
Database db;
DbCommand updateAdvisorStaffCmd;
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
updateAdvisorStaffCmd = db.GetStoredProcCommand("SP_UpdateAdvisorDynamicRiskProfileQuestionsOptions");
db.AddInParameter(updateAdvisorStaffCmd, "@AdvisorId", DbType.Int32, adviserDynamicRiskQuestionsVo.AdviserId);
db.AddInParameter(updateAdvisorStaffCmd, "@QM_QustionID", DbType.Int32, adviserDynamicRiskQuestionsVo.QuestionId);
db.AddInParameter(updateAdvisorStaffCmd, "@QOM_OptionId", DbType.Int32, adviserDynamicRiskQuestionsVo.OptionId);
db.AddInParameter(updateAdvisorStaffCmd, "@QOM_Option", DbType.String, adviserDynamicRiskQuestionsVo.Option);
db.AddInParameter(updateAdvisorStaffCmd, "@QOM_Weightage", DbType.Int32, adviserDynamicRiskQuestionsVo.Weightage);
if (db.ExecuteNonQuery(updateAdvisorStaffCmd) != 0)
{
bResult = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorStaffDao.cs:UpdateAdvisorDynamicRiskQuestionsOptions()");
object[] objects = new object[3];
objects[0] = adviserDynamicRiskQuestionsVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
