public int CountAdvisorBranch() { AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo(); List <AdvisorBranchVo> advisorBranchList = null; int count; try { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, ""); count = advisorBranchList.Count; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "AdvisorDashBoard.ascx:CountAdvisorBranch()"); object[] objects = new object[2]; objects[0] = advisorBranchBo; objects[1] = advisorBranchList; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(count); }
public void setAdvisorBranch() { AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo(); List <AdvisorBranchVo> advisorBranchList = null; AdvisorBranchVo advisorBranchVo = null; try { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, ""); DataTable dtAdvisorBranch = new DataTable(); dtAdvisorBranch.Columns.Add("Sl.No."); dtAdvisorBranch.Columns.Add("Branch Name"); dtAdvisorBranch.Columns.Add("Email"); DataRow drAdvisorBranch; for (int i = 0; i < advisorBranchList.Count; i++) { drAdvisorBranch = dtAdvisorBranch.NewRow(); advisorBranchVo = new AdvisorBranchVo(); advisorBranchVo = advisorBranchList[i]; drAdvisorBranch[0] = (i + 1).ToString(); drAdvisorBranch[1] = advisorBranchVo.BranchName; drAdvisorBranch[2] = advisorBranchVo.Email; dtAdvisorBranch.Rows.Add(drAdvisorBranch); } gvAdvisorBranch.DataSource = dtAdvisorBranch; gvAdvisorBranch.DataBind(); gvAdvisorBranch.Visible = true; } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "AdvisorDashBoard.ascx:setAdvisorLOB()"); object[] objects = new object[4]; objects[0] = advisorBranchBo; objects[1] = advisorBranchList; objects[2] = advisorVo; objects[3] = advisorBranchVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
protected void BindGrid() { try { if (hdnCurrentPage.Value.ToString() != "") { mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString()); hdnCurrentPage.Value = ""; } advisorVo = (AdvisorVo)Session["advisorVo"]; int Count; if (Session["Branch"] != null) { lblMessage.Visible = false; string branch = Session["Branch"].ToString(); if (branch.ToLower().Trim() == "find branch" || branch.ToLower().Trim() == "") { branch = ""; } branchList = advisorBranchBo.FindBranch(branch, advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out Count); lblTotalRows.Text = hdnCount.Value = Count.ToString(); LoadBranches(branchList); Session.Remove("Branch"); } else { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, hdnSort.Value, mypager.CurrentPage, out Count); lblTotalRows.Text = hdnCount.Value = Count.ToString(); //if (Count > 0) //{ // tblPager.Visible = true; // lblTotalRows.Text = hdnCount.Value = Count.ToString(); //} if (advisorBranchList.Count == 0) { lblMessage.Visible = true; tblPager.Visible = false; lblCurrentPage.Visible = false; lblTotalRows.Visible = false; } else { lblMessage.Visible = false; DataTable dtAdvisorBranch2 = new DataTable(); dtAdvisorBranch2.Columns.Add("Sl.No."); dtAdvisorBranch2.Columns.Add("BranchId"); dtAdvisorBranch2.Columns.Add("BranchName"); dtAdvisorBranch2.Columns.Add("BranchCode"); dtAdvisorBranch2.Columns.Add("Email"); dtAdvisorBranch2.Columns.Add("Phone"); dtAdvisorBranch2.Columns.Add("BranchHead"); dtAdvisorBranch2.Columns.Add("BranchType"); DataRow drAdvisorBranch; for (int i = 0; i < advisorBranchList.Count; i++) { drAdvisorBranch = dtAdvisorBranch2.NewRow(); advisorBranchVo = new AdvisorBranchVo(); advisorBranchVo = advisorBranchList[i]; drAdvisorBranch[0] = (i + 1).ToString(); drAdvisorBranch[1] = advisorBranchVo.BranchId.ToString(); drAdvisorBranch[2] = advisorBranchVo.BranchName.ToString(); drAdvisorBranch[3] = advisorBranchVo.BranchCode.ToString(); drAdvisorBranch[4] = advisorBranchVo.Email; drAdvisorBranch[5] = advisorBranchVo.Phone1Isd.ToString() + "-" + advisorBranchVo.Phone1Std.ToString() + "-" + advisorBranchVo.Phone1Number.ToString(); drAdvisorBranch[6] = advisorBranchVo.BranchHead.ToString(); drAdvisorBranch[7] = advisorBranchVo.BranchType.ToString(); dtAdvisorBranch2.Rows.Add(drAdvisorBranch); } gvBranchList.DataSource = dtAdvisorBranch2; gvBranchList.DataBind(); gvBranchList.Visible = true; } } this.GetPageCount(); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewBranches.ascx:Page_Load()"); object[] objects = new object[4]; objects[0] = advisorVo; objects[1] = advisorBranchVo; objects[2] = advisorBranchBo; objects[3] = advisorBranchList; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public void setBranchList1(string IsExternal) { UserVo rmUserVo = null; DataRow drAdvisorBranch; DataTable dtAdvisorBranch = new DataTable(); try { rmUserVo = (UserVo)Session["rmUserVo"]; if (IsExternal == "Y") { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, "Y"); } else if (IsExternal == "N") { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, "N"); } if (advisorBranchList == null) { lblError.Visible = true; lblError.Text = "Add some Branches.."; gvBranchList.DataSource = null; gvBranchList.DataBind(); } else { gvBranchList.Visible = true; lblError.Visible = false; dtAdvisorBranch.Columns.Add("Sl.No."); dtAdvisorBranch.Columns.Add("BranchId"); dtAdvisorBranch.Columns.Add("Branch Name"); dtAdvisorBranch.Columns.Add("Branch Address"); dtAdvisorBranch.Columns.Add("Branch Phone"); for (int i = 0; i < advisorBranchList.Count; i++) { drAdvisorBranch = dtAdvisorBranch.NewRow(); advisorBranchVo = new AdvisorBranchVo(); advisorBranchVo = advisorBranchList[i]; drAdvisorBranch[0] = (i + 1).ToString(); drAdvisorBranch[1] = advisorBranchVo.BranchId.ToString(); drAdvisorBranch[2] = advisorBranchVo.BranchName.ToString(); if (advisorBranchVo.State != "" && advisorBranchVo.State != "Select a State") { drAdvisorBranch[3] = advisorBranchVo.AddressLine1.ToString() + "'" + advisorBranchVo.AddressLine2.ToString() + "'" + advisorBranchVo.AddressLine3.ToString() + "," + advisorBranchVo.City.ToString() + "'" + XMLBo.GetStateName(path, advisorBranchVo.State.ToString()); } else { drAdvisorBranch[3] = advisorBranchVo.AddressLine1.ToString() + "'" + advisorBranchVo.AddressLine2.ToString() + "'" + advisorBranchVo.AddressLine3.ToString() + "," + advisorBranchVo.City.ToString() + "'"; } drAdvisorBranch[4] = advisorBranchVo.Phone1Isd + "-" + advisorBranchVo.Phone1Std + "-" + advisorBranchVo.Phone1Number; dtAdvisorBranch.Rows.Add(drAdvisorBranch); } gvBranchList.DataSource = dtAdvisorBranch; gvBranchList.DataBind(); gvBranchList.Visible = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RMBranchAssocistion.ascx:setBranchList()"); object[] objects = new object[3]; objects[0] = rmUserVo; objects[1] = advisorBranchList; objects[2] = advisorBranchVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public void setBranchList(string IsExternal) { UserVo rmUserVo = null; DataRow drAdvisorBranch; DataTable dtAdvisorBranch = new DataTable(); bool tracker = false; try { rmUserVo = (UserVo)Session["rmUserVo"]; if (IsExternal == "Y") { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, "Y"); } else if (IsExternal == "N") { advisorBranchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, "N"); } dtAdvisorBranch.Columns.Add("Branch"); dtAdvisorBranch.Columns.Add("Branch Code"); if (advisorBranchList != null) { for (int i = 0; i < advisorBranchList.Count; i++) { drAdvisorBranch = dtAdvisorBranch.NewRow(); advisorBranchVo = new AdvisorBranchVo(); advisorBranchVo = advisorBranchList[i]; if (associatedBranch.Items.FindByValue(advisorBranchVo.BranchId.ToString()) == null) { //if (tracker) //{ if (drAdvisorBranch["Branch"] != null && drAdvisorBranch["Branch Code"] != null) { drAdvisorBranch["Branch"] = advisorBranchVo.BranchName.ToString() + "," + advisorBranchVo.BranchId.ToString(); drAdvisorBranch["Branch Code"] = advisorBranchVo.BranchId.ToString(); dtAdvisorBranch.Rows.Add(drAdvisorBranch); } } } } //_commondatasetSource.Tables.Add(dtAdvisorBranch); availableBranch.DataSource = dtAdvisorBranch; availableBranch.DataTextField = "Branch"; availableBranch.DataValueField = "Branch Code"; availableBranch.DataBind(); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RMBranchAssocistion.ascx:setBranchList()"); object[] objects = new object[3]; objects[0] = rmUserVo; objects[1] = advisorBranchList; objects[2] = advisorBranchVo; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public void SetBranches() { bool bResult = false; try { branchList = advisorBranchBo.GetAdvisorBranches(advisorVo.advisorId, ""); for (int i = 0; i < branchList.Count; i++) { advisorBranchVo = new AdvisorBranchVo(); advisorBranchVo = branchList[i]; bResult = advisorBranchBo.ChkBranchManagerAvail(advisorBranchVo.BranchId); if (bResult) { newBranchList.Add(advisorBranchVo); } } if (newBranchList.Count == 0) { lblIllegal.Visible = true; lnkAddBranch.Visible = true; btnAssociateBM.Visible = false; } else { lblIllegal.Visible = false; lnkAddBranch.Visible = false; btnAssociateBM.Visible = true; DataTable dtAdvisorBranch = new DataTable(); dtAdvisorBranch.Columns.Add("Sl.No."); dtAdvisorBranch.Columns.Add("BranchId"); dtAdvisorBranch.Columns.Add("Branch Name"); dtAdvisorBranch.Columns.Add("Branch Address"); dtAdvisorBranch.Columns.Add("Branch Phone"); DataRow drAdvisorBranch; for (int i = 0; i < newBranchList.Count; i++) { drAdvisorBranch = dtAdvisorBranch.NewRow(); advisorBranchVo = new AdvisorBranchVo(); advisorBranchVo = newBranchList[i]; drAdvisorBranch[0] = (i + 1).ToString(); drAdvisorBranch[1] = advisorBranchVo.BranchId.ToString(); drAdvisorBranch[2] = advisorBranchVo.BranchName.ToString(); drAdvisorBranch[3] = advisorBranchVo.AddressLine1.ToString() + "'" + advisorBranchVo.AddressLine2.ToString() + "'" + advisorBranchVo.AddressLine3.ToString() + "," + advisorBranchVo.City.ToString() + "'" + advisorBranchVo.State.ToString(); drAdvisorBranch[4] = advisorBranchVo.Phone1Isd + "-" + advisorBranchVo.Phone1Std + "-" + advisorBranchVo.Phone1Number; dtAdvisorBranch.Rows.Add(drAdvisorBranch); } gvBranchListBM.DataSource = dtAdvisorBranch; gvBranchListBM.DataBind(); gvBranchListBM.Visible = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "BMBranchAssociation.ascx.cs:SetBranches()"); object[] objects = new object[3]; objects[0] = advisorBranchVo; objects[1] = branchList; objects[2] = newBranchList; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }