internal List<CommunityUsersByRole> GetCommunityUsersByRole(CommunityUsersByRole communityUsersByRole)
{
AddParameter("@communityid", communityUsersByRole.CommunityID);
Dt_CommunityUsersByRole = this.GetDataTable("[usp_GetCommunityUsersByRole]");
if (Dt_CommunityUsersByRole.Rows.Count > 0)
{
communityUsersByRoleList = new List<CommunityUsersByRole>();
foreach (DataRow dr in Dt_CommunityUsersByRole.Rows)
{
communityUsersByRole = new CommunityUsersByRole();
communityUsersByRole.RoleID = Convert.ToByte(dr["RoleID"].ToString());
communityUsersByRole.UsersCount = Convert.ToInt64(dr["UsersCount"].ToString());
communityUsersByRoleList.Add(communityUsersByRole);
}
}
return communityUsersByRoleList;
}
public ActionResult Users()
{
community = new CommunitiesModel();
community.CommunityID = myCommunityID;
communityUsersByRole = new CommunityUsersByRole();
communityUsersByRole.CommunityID = myCommunityID;
communityUsersByRoleList = new List<CommunityUsersByRole>();
communityUsersByRoleList = accountDAL.GetCommunityUsersByRole(communityUsersByRole);
if (communityUsersByRoleList != null)
{
foreach (CommunityUsersByRole cubr in communityUsersByRoleList)
{
switch (cubr.RoleID)
{
case 2: ViewBag.AdministratorsCount = cubr.UsersCount;
break;
case 3: ViewBag.SecurityManagersCount = cubr.UsersCount;
break;
case 4: ViewBag.SercurityPersonsCount = cubr.UsersCount;
break;
case 5: ViewBag.HomeOwnersCount = cubr.UsersCount;
break;
case 6: ViewBag.ServiceProvidersCount = cubr.UsersCount;
break;
}
}
}
return View("Users");
}
public ActionResult RolesList(String communityid)
{
if (CommunityIDSanctityCheck(communityid))
{
community = new CommunitiesModel();
community.CommunityID = outCommunityID;;
communityUsersByRole = new CommunityUsersByRole();
communityUsersByRole.CommunityID = outCommunityID;;
communityUsersByRoleList = new List<CommunityUsersByRole>();
communityUsersByRoleList = accountDAL.GetCommunityUsersByRole(communityUsersByRole);
if (communityUsersByRoleList != null)
{
foreach (CommunityUsersByRole cubr in communityUsersByRoleList)
{
switch (cubr.RoleID)
{
case 2: ViewBag.AdministratorsCount = cubr.UsersCount;
break;
case 3: ViewBag.SecurityManagersCount = cubr.UsersCount;
break;
case 4: ViewBag.SercurityPersonsCount = cubr.UsersCount;
break;
case 5: ViewBag.HomeOwnersCount = cubr.UsersCount;
break;
case 6: ViewBag.ServiceProvidersCount = cubr.UsersCount;
break;
}
}
}
return PartialView("Partials/Users/RolesList");
}
return Json("Community");
}