private void ShowRM()
{
string rm = "";
DataTable dtAdvisorStaff = new DataTable();
DataRow drAdvisorStaff;
DataTable dt = new DataTable();
DataSet ds = new DataSet();
int count = 0;
try
{
rm = Session["RM"].ToString();
if (rm.ToLower().Trim() == "find rm" || rm.ToLower().Trim() == "")
{
rm = "";
}
ds = advisorStaffBo.FindRM(rm, advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value.ToString(), out count);
lblTotalRows.Text = hdnCount.Value = count.ToString();
if (ds.Tables[0].Rows.Count != 0)
{
trBMBranchs.Visible = false;
trMessage.Visible = false;
dt = ds.Tables[0];
trMessage.Visible = false;
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
//dtAdvisorStaff.Columns.Add("RM Main Branch");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("BranchList");
//dtAdvisorStaff.Columns.Add("Branch Name");
DataRow dr;
for (int i = 0; i < dt.Rows.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
dr = dt.Rows[i];
rmVo = new RMVo();
drAdvisorStaff[0] = dr["u_userId"].ToString();
drAdvisorStaff[1] = dr["ar_rmid"].ToString();
drAdvisorStaff[2] = dr["ar_firstname"].ToString() + " " + dr["ar_middlename"].ToString() + " " + dr["ar_lastname"].ToString();
if (dr["AR_IsExternalStaff"].ToString() == "1")
{
drAdvisorStaff[3] = "External";
}
else
{
drAdvisorStaff[3] = "Internal";
}
drAdvisorStaff[4] = dr["AR_JobFunction"].ToString();
drAdvisorStaff[5] = dr["AR_Email"].ToString();
drAdvisorStaff[6] = dr["AR_Mobile"].ToString();
drAdvisorStaff[7] = dr["BranchList"].ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
this.GetPageCount();
}
else
{
trBMBranchs.Visible = false;
gvRMList.DataSource = null;
gvRMList.DataBind();
DivPager.Visible = false;
lblCurrentPage.Visible = false;
lblTotalRows.Visible = false;
trMessage.Visible = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewRM.ascx.cs:ShowRM()");
object[] objects = new object[3];
objects[0] = advisorVo;
objects[1] = rm;
objects[2] = rmList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}