public void ShowStaffList() { int Count; DataSet dsRMList = new DataSet(); try { if (userVo.UserType == "Branch Man") { if (hdnCurrentPage.Value.ToString() != "") { mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString()); hdnCurrentPage.Value = ""; } dsRMList = advisorStaffBo.GetBMStaff(rmVo.RMId, mypager.CurrentPage, hdnSort.Value, out Count); lblTotalRows.Text = hdnCount.Value = Count.ToString(); if (dsRMList != null) { DataTable dtBMStaff = new DataTable(); dtBMStaff.Columns.Add("UserId"); dtBMStaff.Columns.Add("StaffName"); dtBMStaff.Columns.Add("Email"); dtBMStaff.Columns.Add("MobileNo"); dtBMStaff.Columns.Add("BranchName"); DataRow drBMStaff; for (int i = 0; i < dsRMList.Tables[0].Rows.Count; i++) { drBMStaff = dtBMStaff.NewRow(); drBMStaff[0] = dsRMList.Tables[0].Rows[i]["U_UserId"].ToString(); drBMStaff[1] = dsRMList.Tables[0].Rows[i]["AR_FirstName"].ToString() + " " + dsRMList.Tables[0].Rows[i]["AR_MiddleName"].ToString() + " " + dsRMList.Tables[0].Rows[i]["AR_LastName"].ToString(); drBMStaff[2] = dsRMList.Tables[0].Rows[i]["AR_Email"].ToString(); drBMStaff[3] = dsRMList.Tables[0].Rows[i]["AR_Mobile"].ToString(); drBMStaff[4] = dsRMList.Tables[0].Rows[i]["AB_BranchCode"].ToString(); dtBMStaff.Rows.Add(drBMStaff); } gvBMStaffList.DataSource = dtBMStaff; gvBMStaffList.DataBind(); this.GetPageCount(); } else { lblMessage.Visible = false; } } //else //{ // lblMessage.Visible = false; // advisorStaffBo = new AdvisorStaffBo(); // List<RMVo> advisorStaffList = null; // advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out Count); // if (advisorStaffList != null) // { // lblTotalRows.Text = hdnCount.Value = Count.ToString(); // DataTable dtAdvisorStaff = new DataTable(); // dtAdvisorStaff.Columns.Add("UserId"); // dtAdvisorStaff.Columns.Add("StaffName"); // dtAdvisorStaff.Columns.Add("Email"); // dtAdvisorStaff.Columns.Add("MobileNo"); // DataRow drAdvisorStaff; // for (int i = 0; i < advisorStaffList.Count; i++) // { // drAdvisorStaff = dtAdvisorStaff.NewRow(); // rmVo = new RMVo(); // rmVo = advisorStaffList[i]; // drAdvisorStaff[0] = rmVo.UserId.ToString(); // drAdvisorStaff[1] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString(); // drAdvisorStaff[2] = rmVo.Email.ToString(); // drAdvisorStaff[3] = rmVo.OfficePhoneDirectIsd.ToString() + "-" + rmVo.OfficePhoneDirectStd.ToString() + "-" + rmVo.OfficePhoneDirectNumber.ToString(); // dtAdvisorStaff.Rows.Add(drAdvisorStaff); // } // gvBMStaffList.DataSource = dtAdvisorStaff; // gvBMStaffList.DataBind(); // this.GetPageCount(); // } //} } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "BMStaffView.ascx:showRMList()"); object[] objects = new object[4]; objects[0] = advisorVo; objects[1] = rmVo; objects[2] = rmId; objects[3] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }