protected void Page_Load(object sender, EventArgs e) { lblUserName.Text = " " + userVo.UserName; if (!IsPostBack) { userVo = (FPUserVo)Session["FPUserVo"]; DataSet dsQuestionNOptions = fpUserBo.GetQuestionAndOptions(userVo.UserId); int adviserId = Convert.ToInt32(ConfigurationManager.AppSettings["ONLINE_ADVISER"]); DataSet dsGetquestionList = new DataSet(); dsGetquestionList = fpUserBo.GetRiskProfileQuestion(adviserId); if (dsGetquestionList.Tables[0].Rows.Count <= dsQuestionNOptions.Tables[0].Rows.Count) { if (!string.IsNullOrEmpty(userVo.RiskClassCode)) { Response.Redirect("Result.aspx"); } MultiView1.ActiveViewIndex = dsGetquestionList.Tables[0].Rows.Count - 1; } else { MultiView1.ActiveViewIndex = dsQuestionNOptions.Tables[0].Rows.Count; } //else if (dsGetquestionList.Tables[0].Rows.Count >= dsQuestionNOptions.Tables[0].Rows.Count) //{ // MultiView1.ActiveViewIndex = dsQuestionNOptions.Tables[0].Rows.Count - 1; //} //string prevPage = Request.UrlReferrer.ToString(); } }
public FPUserVo GetFPUser(int fpUserId) { FPUserVo fpUserVo = new FPUserVo(); DataSet ds; Database db; DbCommand dbCommand; try { db = DatabaseFactory.CreateDatabase("wealtherp"); dbCommand = db.GetStoredProcCommand("SPROC_FPUtility_GETFPUtilityUser"); db.AddInParameter(dbCommand, "@UserId", DbType.Int32, fpUserId); ds = db.ExecuteDataSet(dbCommand); if (ds.Tables[0].Rows.Count > 0) { fpUserVo.EMail = ds.Tables[0].Rows[0]["FPUUD_EMail"].ToString(); fpUserVo.UserName = ds.Tables[0].Rows[0]["FPUUD_Name"].ToString(); fpUserVo.Pan = ds.Tables[0].Rows[0]["FPUUD_PAN"].ToString(); fpUserVo.MobileNo = Convert.ToInt64(ds.Tables[0].Rows[0]["FPUUD_MobileNo"].ToString()); fpUserVo.C_CustomerId = !string.IsNullOrEmpty(ds.Tables[0].Rows[0]["C_CustomerId"].ToString()) ? Convert.ToInt32(ds.Tables[0].Rows[0]["C_CustomerId"].ToString()) : 0; fpUserVo.UserId = Convert.ToInt32(ds.Tables[0].Rows[0]["FPUUD_UserId"].ToString()); fpUserVo.CreatedOn = Convert.ToDateTime(ds.Tables[0].Rows[0]["FPUUD_CreatedOn"].ToString()); fpUserVo.ModifiedOn = Convert.ToDateTime(ds.Tables[0].Rows[0]["FPUUD_ModifiedOn"].ToString()); fpUserVo.RiskClassCode = ds.Tables[0].Rows[0]["XRC_RiskClassCode"].ToString(); fpUserVo.IsProspectmarked = !string.IsNullOrEmpty(ds.Tables[0].Rows[0]["FPUUD_IsProspectmarked"].ToString()) ? Convert.ToBoolean(ds.Tables[0].Rows[0]["FPUUD_IsProspectmarked"]) : false; bool i; fpUserVo.IsClientExists = bool.TryParse(ds.Tables[0].Rows[0]["FPUUD_IsClientExists"].ToString(), out i) ? (bool?)i : null; } } catch (Exception Ex) { } return(fpUserVo); }
private bool UpdateCustomerIdInFPUserTable(int fpUserId, int customerId) { bool result = false; result = fpUserBo.UpdateCustomerProspect(customerId, fpUserId); fpuserVo = fpUserBo.GetFPUser(fpUserId); Session["FPUserVo"] = fpuserVo; return(result); }
public FPUserVo CreateAndGetFPUtilityUserDetails(FPUserVo userVo, string clientCode, bool userType) { FPUserVo fpUserVo = new FPUserVo(); DataSet ds; Database db; DbCommand dbCommand; try { db = DatabaseFactory.CreateDatabase("wealtherp"); dbCommand = db.GetStoredProcCommand("CreateFPUtilityUser"); db.AddInParameter(dbCommand, "@Name", DbType.String, userVo.UserName); db.AddInParameter(dbCommand, "@EMail", DbType.String, userVo.EMail); db.AddInParameter(dbCommand, "@PAN", DbType.String, userVo.Pan); db.AddInParameter(dbCommand, "@MobileNo", DbType.Int64, userVo.MobileNo); db.AddInParameter(dbCommand, "@ClientCode", DbType.String, clientCode); db.AddInParameter(dbCommand, "@UserType", DbType.Boolean, userType); if (userVo.DOB == DateTime.MinValue) { db.AddInParameter(dbCommand, "@DOB", DbType.DateTime, DBNull.Value); } else { db.AddInParameter(dbCommand, "@DOB", DbType.DateTime, userVo.DOB); } ds = db.ExecuteDataSet(dbCommand); if (ds.Tables[0].Rows.Count > 0) { fpUserVo.EMail = ds.Tables[0].Rows[0]["FPUUD_EMail"].ToString(); fpUserVo.UserName = ds.Tables[0].Rows[0]["FPUUD_Name"].ToString(); fpUserVo.Pan = ds.Tables[0].Rows[0]["FPUUD_PAN"].ToString(); fpUserVo.MobileNo = Convert.ToInt64(ds.Tables[0].Rows[0]["FPUUD_MobileNo"].ToString()); fpUserVo.C_CustomerId = !string.IsNullOrEmpty(ds.Tables[0].Rows[0]["C_CustomerId"].ToString()) ? Convert.ToInt32(ds.Tables[0].Rows[0]["C_CustomerId"].ToString()) : 0; fpUserVo.UserId = Convert.ToInt32(ds.Tables[0].Rows[0]["FPUUD_UserId"].ToString()); fpUserVo.CreatedOn = Convert.ToDateTime(ds.Tables[0].Rows[0]["FPUUD_CreatedOn"].ToString()); fpUserVo.ModifiedOn = Convert.ToDateTime(ds.Tables[0].Rows[0]["FPUUD_ModifiedOn"].ToString()); fpUserVo.RiskClassCode = ds.Tables[0].Rows[0]["XRC_RiskClassCode"].ToString(); fpUserVo.IsProspectmarked = !string.IsNullOrEmpty(ds.Tables[0].Rows[0]["FPUUD_IsProspectmarked"].ToString()) ? Convert.ToBoolean(ds.Tables[0].Rows[0]["FPUUD_IsProspectmarked"]) : false; fpUserVo.DOB = Convert.ToDateTime(ds.Tables[0].Rows[0]["FPUUD_DOB"].ToString()); bool i; fpUserVo.IsClientExists = bool.TryParse(ds.Tables[0].Rows[0]["FPUUD_IsClientExists"].ToString(), out i) ? (bool?)i : null; } } catch (Exception Ex) { } return(fpUserVo); }
protected void btnsignUpsubmit_Click(object sender, EventArgs e) { if (Session["FPUserVo"] != null) { Response.Redirect("Questionnaire.aspx"); } else { bool isValidUser = false; FPUserVo fpUserVo = new FPUserVo(); fpUserVo.MobileNo = Convert.ToInt64(txtMobNo.Text); fpUserVo.UserName = txtName.Text; fpUserVo.Pan = txtPan1.Text; fpUserVo.EMail = txtEmail.Text; fpUserVo.DOB = DateTime.ParseExact(txtDob.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); FPUserVo UserVo = new FPUserVo(); UserVo = fpUserBo.CreateAndGetFPUtilityUserDetails(fpUserVo, "", false); isValidUser = ValidateSingleSessionPerUser(UserVo.UserId.ToString()); int adviserId = Convert.ToInt32(ConfigurationManager.AppSettings["ONLINE_ADVISER"]); if (!fpUserBo.CheckInvestorExists(adviserId, txtPan1.Text, txtclientCode.Text)) { Label1.Visible = false; if (isValidUser && UserVo.UserId != 0 && string.IsNullOrEmpty(UserVo.RiskClassCode)) { Session["FPUserVo"] = UserVo; Response.Redirect("Questionnaire.aspx"); } else if (isValidUser && UserVo.UserId != 0 && !string.IsNullOrEmpty(UserVo.RiskClassCode)) { Session["FPUserVo"] = UserVo; Response.Redirect("Result.aspx"); } else { lbllogedIn1.Visible = true; } } else { Label1.Visible = true; } } }
protected void btnsignInsubmit_Click(object sender, EventArgs e) { if (Session["FPUserVo"] != null) { Response.Redirect("Questionnaire.aspx"); } else { bool isValidUser = false; FPUserVo fpUserVo = new FPUserVo(); fpUserVo.MobileNo = 0; fpUserVo.UserName = ""; fpUserVo.Pan = txtpan2.Text; fpUserVo.EMail = ""; fpUserVo.DOB = DateTime.MinValue; FPUserVo UserVo = new FPUserVo(); int adviserId = Convert.ToInt32(ConfigurationManager.AppSettings["ONLINE_ADVISER"]); if (fpUserBo.CheckInvestorExists(adviserId, txtpan2.Text, txtclientCode.Text)) { lblClient.Visible = false; UserVo = fpUserBo.CreateAndGetFPUtilityUserDetails(fpUserVo, txtclientCode.Text, true); isValidUser = ValidateSingleSessionPerUser(UserVo.UserId.ToString()); if (isValidUser && UserVo.UserId != 0 && string.IsNullOrEmpty(UserVo.RiskClassCode)) { Session["FPUserVo"] = UserVo; Response.Redirect("Questionnaire.aspx"); } else if (isValidUser && UserVo.UserId != 0 && !string.IsNullOrEmpty(UserVo.RiskClassCode)) { Session["FPUserVo"] = UserVo; Response.Redirect("Result.aspx"); } else { lbllogedIn2.Visible = true; } } else { lblClient.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { FPUserBO.CheckSession(); fpuserVo = (FPUserVo)Session["FPUserVo"]; int adviserId = Convert.ToInt32(ConfigurationManager.AppSettings["ONLINE_ADVISER"]); lblUserName.Text = " " + fpuserVo.UserName; if (!IsPostBack) { //Save(); divTncSuccess.Visible = false; divtnc2.Visible = true; //if (Request.UrlReferrer == null) // Response.Redirect("Questionnaire.aspx"); //else //{ DataSet dsRiskClass = fpUserBo.GetRiskClass(fpuserVo.UserId, adviserId); if (dsRiskClass.Tables[0].Rows.Count > 0) { lblRiskClass.Text = dsRiskClass.Tables[0].Rows[0]["XRC_RiskClass"].ToString(); lblRiskText.Text = dsRiskClass.Tables[0].Rows[0]["ARC_RiskText"].ToString(); } if (dsRiskClass.Tables[1].Rows.Count > 0) { BindAssetsPiaChart(dsRiskClass.Tables[1]); } if (!string.IsNullOrEmpty(fpuserVo.RiskClassCode) && fpuserVo.IsProspectmarked) { divtnc1.Visible = false; divtnc2.Visible = false; } //} } }
public static List <object> GetChartData() { FPUserBO fpUserBo = new FPUserBO(); FPUserVo userVo = new FPUserVo(); userVo = (FPUserVo)HttpContext.Current.Session["FPUserVo"]; int adviserId = Convert.ToInt32(ConfigurationManager.AppSettings["ONLINE_ADVISER"]); List <object> chartData = new List <object>(); chartData.Add(new object[] { "WAC_AssetClassification", "AllocationPercentage" }); DataSet dsRiskClass = fpUserBo.GetRiskClass(userVo.UserId, adviserId); foreach (DataRow dr in dsRiskClass.Tables[1].Rows) { chartData.Add(new object[] { dr["WAC_AssetClassification"], dr["AllocationPercentage"] }); } return(chartData); }
protected void Page_Init(object sender, EventArgs e) { FPUserBO.CheckSession(); userVo = (FPUserVo)Session["FPUserVo"]; DataSet dsQuestionNOptions = fpUserBo.GetQuestionAndOptions(userVo.UserId); int adviserId = Convert.ToInt32(ConfigurationManager.AppSettings["ONLINE_ADVISER"]); DataSet dsGetquestionList = new DataSet(); dsGetquestionList = fpUserBo.GetRiskProfileQuestion(adviserId); int questionNo = 0; int questioncount = 1; foreach (DataRow dr in dsGetquestionList.Tables[0].Rows) { questionNo = Convert.ToInt32(dr["QM_QuestionId"].ToString()); PlaceHolder placeholder = new PlaceHolder(); placeholder.Controls.Add(new LiteralControl("<div class=\"well\"><div class=\"row\"><div class=\"col-sm-2 form-group\"></div><div class=\"col-sm-8 form-group\"><p>" + dr["QM_Question"].ToString() + "</p></div><div class=\"col-sm-2\"></div></div><div class=\"row\"><div class=\"col-sm-3\"></div><div class=\"col-sm-3\"></div><div class=\"col-sm-6\">")); CustomValidator customeValidator = new CustomValidator(); customeValidator.ID = "CustomValidator" + questionNo.ToString(); customeValidator.ErrorMessage = "Please select an option."; customeValidator.ValidationGroup = questionNo.ToString(); customeValidator.ServerValidate += new ServerValidateEventHandler(cvRadioButtonGroup_ServerValidate); placeholder.Controls.Add(customeValidator); placeholder.Controls.Add(new LiteralControl("</div></div>")); DataSet ds = new DataSet(); ds = fpUserBo.GetQuestionOption(Convert.ToInt32(dr["QM_QuestionId"].ToString()), adviserId); int optionNo = 1; foreach (DataRow droption in ds.Tables[0].Rows) { optionNo = Convert.ToInt32(droption["QOM_OptionId"].ToString()); placeholder.Controls.Add(new LiteralControl("<div class=\"row\"><div class=\"col-sm-3 form-group\"></div><div class=\"col-sm-6 form-group\"><div class=\"radio radio-info radio-inline\">")); RadioButton rbtn = new RadioButton(); rbtn.ID = "rbtn" + questionNo.ToString() + optionNo.ToString(); rbtn.GroupName = questionNo.ToString(); //rbtn.AccessKey = optionNo.ToString(); rbtn.ValidationGroup = optionNo.ToString(); if (dsQuestionNOptions.Tables[0].Rows.Count > 0) { string expression; expression = "AQM_QuestionId=" + questionNo.ToString(); DataRow[] foundRows; foundRows = dsQuestionNOptions.Tables[0].Select(expression); if (foundRows.Length > 0) { if (foundRows[0]["AQOM_OptionId"].ToString() == optionNo.ToString()) { rbtn.Checked = true; } } } placeholder.Controls.Add(rbtn); placeholder.Controls.Add(new LiteralControl("<label for=\"" + rbtn.ID + "\">" + droption["QOM_Option"].ToString() + "</label></div></div><div class=\"col-sm-3\"></div></div>")); } placeholder.Controls.Add(new LiteralControl("<div class=\"row\"><div class=\"col-sm-3 form-group pull-left\">")); Button prevbtn = new Button(); prevbtn.ID = "btnprev" + questionNo.ToString(); prevbtn.CommandName = "PrevView"; prevbtn.Text = "« Prev"; prevbtn.CssClass = "btn btn-info"; if (questioncount != 1) { placeholder.Controls.Add(prevbtn); } placeholder.Controls.Add(new LiteralControl(" </div><div class=\"col-sm-3 form-group pull-right\">")); Button btnNext = new Button(); btnNext.ID = "btnNext" + questionNo.ToString(); btnNext.Text = "Next »"; btnNext.CssClass = "btn btn-info"; btnNext.ValidationGroup = questionNo.ToString(); btnNext.Click += new EventHandler(btnNext_click); Button btnSubmit = new Button(); btnSubmit.ID = "btnNext" + questionNo.ToString(); btnSubmit.Text = "Submit"; btnSubmit.CssClass = "btn btn-info"; btnSubmit.ValidationGroup = questionNo.ToString(); btnSubmit.Click += new EventHandler(btnSubmit_click); if (questioncount != dsGetquestionList.Tables[0].Rows.Count) { placeholder.Controls.Add(btnNext); } if (questioncount == dsGetquestionList.Tables[0].Rows.Count) { placeholder.Controls.Add(btnSubmit); } placeholder.Controls.Add(new LiteralControl("</div></div><div class=\"row\"><div class=\"col-sm-4 text-primary\">Displaying Question " + questioncount.ToString() + " of " + dsGetquestionList.Tables[0].Rows.Count.ToString() + "</div><div class=\"col-sm-4\"></div><div class=\"col-sm-4\"></div></div></div>")); View myView = new View(); myView.ID = "View" + questionNo.ToString(); myView.Controls.Add(placeholder); MultiView1.Views.Add(myView); MultiView1.ActiveViewIndex = 0; questioncount += 1; } }
public FPUserVo CreateAndGetFPUtilityUserDetails(FPUserVo userVo, string clientCode, bool userType) { return(fpUserDao.CreateAndGetFPUtilityUserDetails(userVo, clientCode, userType)); }