public void showRMList()
{
rmVo = new RMVo();
int Count = 0;
List <RMVo> rmList = new List <RMVo>();
List <string> roleList = new List <string>();
//roleList = userBo.GetUserRoles(userVo.UserId);
string role = "BM";
rmVo = advisorStaffBo.GetAdvisorStaff(userVo.UserId);
try
{
//if (roleList.Contains("BM") && Session["CurrentUserRole"] == "BM")
if (role == Session[SessionContents.CurrentUserRole].ToString())
{
trBMBranchs.Visible = true;
if (!Page.IsPostBack)
{
branchId = 0;
all = 1;
bmIdOrHeadID = rmVo.RMId;
BindBMDropDown(bmIdOrHeadID);
}
rmList = advisorStaffBo.GetBMRMList(branchId, bmIdOrHeadID, all, mypager.CurrentPage, out Count);
if (rmList.Count != 0)
{
lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("BranchList");
dtAdvisorStaff.Columns.Add("Mobile Number");
DataRow drAdvisorStaff;
for (int i = 0; i < rmList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = rmList[i];
drAdvisorStaff[0] = rmVo.UserId.ToString();
drAdvisorStaff[1] = rmVo.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[3] = "External";
}
else
{
drAdvisorStaff[3] = "Internal";
}
drAdvisorStaff[4] = string.Empty;
drAdvisorStaff[5] = rmVo.Email.ToString();
drAdvisorStaff[6] = string.Empty;
drAdvisorStaff[7] = rmVo.Mobile.ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
//gvRMList.Style.Add("Width", "580px");
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.Columns[3].Visible = false;
gvRMList.Columns[4].Visible = false;
//dtAdvisorStaff.Columns.Remove("StaffRole");
//dtAdvisorStaff.Columns.Remove("BranchList");
gvRMList.DataBind();
this.GetPageCount();
}
else
{
gvRMList.DataSource = null;
gvRMList.DataBind();
DivPager.Visible = false;
lblCurrentPage.Visible = false;
lblTotalRows.Visible = false;
trMessage.Visible = true;
}
//branchId = advisorBranchBo.GetBranchId(rmVo.RMId);
//if (branchId != 0)
//{
// //lblMsg.Visible = true;
// //lblMsg.Text = "You dont have RM.. !";
// rmList = advisorStaffBo.GetBMRMList(branchId, mypager.CurrentPage, out Count);
// if (rmList.Count != 0)
// {
// lblTotalRows.Text = hdnCount.Value = Count.ToString();
// DataTable dtAdvisorStaff = new DataTable();
// dtAdvisorStaff.Columns.Add("UserId");
// dtAdvisorStaff.Columns.Add("WealthERP Id");
// dtAdvisorStaff.Columns.Add("RMName");
// dtAdvisorStaff.Columns.Add("StaffType");
// dtAdvisorStaff.Columns.Add("StaffRole");
// dtAdvisorStaff.Columns.Add("Email");
// dtAdvisorStaff.Columns.Add("Mobile Number");
// dtAdvisorStaff.Columns.Add("BranchList");
// DataRow drAdvisorStaff;
// for (int i = 0; i < rmList.Count; i++)
// {
// drAdvisorStaff = dtAdvisorStaff.NewRow();
// rmVo = new RMVo();
// rmVo = rmList[i];
// drAdvisorStaff[0] = rmVo.UserId.ToString();
// drAdvisorStaff[1] = rmVo.RMId.ToString();
// drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
// //drAdvisorStaff[3] = rmVo.MainBranch.ToString();
// if (rmVo.IsExternal == 1)
// drAdvisorStaff[3] = "External";
// else
// drAdvisorStaff[3] = "Internal";
// drAdvisorStaff[4] = rmVo.RMRole.ToString();
// drAdvisorStaff[5] = rmVo.Email.ToString();
// drAdvisorStaff[6] = rmVo.Mobile.ToString();
// drAdvisorStaff[7] = rmVo.BranchList.ToString();
// dtAdvisorStaff.Rows.Add(drAdvisorStaff);
// }
// gvRMList.DataSource = dtAdvisorStaff;
// gvRMList.DataBind();
// this.GetPageCount();
// }
// else
// {
// gvRMList.DataSource = null;
// gvRMList.DataBind();
// DivPager.Visible = false;
// lblCurrentPage.Visible = false;
// lblTotalRows.Visible = false;
// trMessage.Visible = true;
// }
//}
//else
//{
// trMessage.Visible = true;
//}
//Session[SessionContents.CurrentUserRole] = null;
}
else
{
trBMBranchs.Visible = false;
trMessage.Visible = false;
advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out Count, string.Empty);
if (advisorStaffList != null)
{
lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("BranchList");
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.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
//drAdvisorStaff[3] = rmVo.MainBranch.ToString();
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[3] = "External";
}
else
{
drAdvisorStaff[3] = "Internal";
}
drAdvisorStaff[4] = rmVo.RMRole.ToString();
drAdvisorStaff[5] = rmVo.Email.ToString();
drAdvisorStaff[6] = rmVo.Mobile.ToString();
drAdvisorStaff[7] = rmVo.BranchList.ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
this.GetPageCount();
}
else
{
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: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;
}
}
public void showRMList()
{
rmVo = new RMVo();
int Count = 0;
List <RMVo> rmList = new List <RMVo>();
List <string> roleList = new List <string>();
//roleList = userBo.GetUserRoles(userVo.UserId);
string role = "BM";
rmVo = advisorStaffBo.GetAdvisorStaff(userVo.UserId);
try
{
//if (roleList.Contains("BM") && Session["CurrentUserRole"] == "BM")
if (role == Session[SessionContents.CurrentUserRole].ToString())
{
trBMBranchs.Visible = true;
if (!Page.IsPostBack)
{
branchId = 0;
all = 1;
bmIdOrHeadID = rmVo.RMId;
BindBMDropDown(bmIdOrHeadID);
}
rmList = advisorStaffBo.GetBMRMList(branchId, bmIdOrHeadID, all);
if (rmList != null && rmList.Count != 0)
{
//lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffCode");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("BranchList");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("AR_StaffCode");
DataRow drAdvisorStaff;
for (int i = 0; i < rmList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = rmList[i];
drAdvisorStaff[0] = rmVo.UserId.ToString();
drAdvisorStaff[1] = rmVo.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[4] = "External";
}
else
{
drAdvisorStaff[4] = "Internal";
}
if (!string.IsNullOrEmpty(rmVo.StaffCode))
{
drAdvisorStaff[3] = rmVo.StaffCode;
}
else
{
drAdvisorStaff[3] = "";
}
drAdvisorStaff[5] = rmVo.RMRole;
drAdvisorStaff[6] = rmVo.Email.ToString();
drAdvisorStaff[8] = rmVo.Mobile.ToString();
drAdvisorStaff[7] = rmVo.BranchList;
drAdvisorStaff[9] = rmVo.StaffCode;
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
if (Cache["RMList" + advisorVo.advisorId.ToString()] == null)
{
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
else
{
Cache.Remove("RMList" + advisorVo.advisorId.ToString());
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
//this.GetPageCount();
}
else
{
gvRMList.DataSource = null;
gvRMList.DataBind();
//DivPager.Visible = false;
//lblCurrentPage.Visible = false;
//lblTotalRows.Visible = false;
trMessage.Visible = true;
}
}
else
{
trBMBranchs.Visible = false;
trMessage.Visible = false;
advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
//advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out Count, string.Empty);
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, hdnSort.Value, string.Empty);
if (advisorStaffList != null)
{
//lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffCode");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("BranchList");
dtAdvisorStaff.Columns.Add("AR_StaffCode");
dtAdvisorStaff.Columns.Add("RoleList");
dtAdvisorStaff.Columns.Add("ReportingTo");
dtAdvisorStaff.Columns.Add("ReportingTitle");
dtAdvisorStaff.Columns.Add("Title");
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.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
//drAdvisorStaff[3] = rmVo.MainBranch.ToString();
if (!string.IsNullOrEmpty(rmVo.StaffCode))
{
drAdvisorStaff[3] = rmVo.StaffCode;
}
else
{
drAdvisorStaff[3] = "";
}
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[4] = "External";
}
else
{
drAdvisorStaff[4] = "Internal";
}
drAdvisorStaff[5] = rmVo.RMRole.ToString();
drAdvisorStaff[6] = rmVo.Email.ToString();
drAdvisorStaff[7] = rmVo.Mobile.ToString();
drAdvisorStaff[8] = rmVo.BranchList.ToString();
drAdvisorStaff[9] = rmVo.StaffCode;
drAdvisorStaff[10] = rmVo.userRole;
drAdvisorStaff[11] = rmVo.ReportingTo;
drAdvisorStaff[12] = rmVo.ReportingTitle;
drAdvisorStaff[13] = rmVo.Title;
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
dtAdvisorStaff.DefaultView.Sort = "RMName ASC";
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
if (Cache["RMList" + advisorVo.advisorId.ToString()] == null)
{
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
else
{
Cache.Remove("RMList" + advisorVo.advisorId.ToString());
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
//this.GetPageCount();
}
else
{
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: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;
}
}