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