asp.net mvc 5 count registered users and return the number

Thabo Happy

8y7.4k.NET

Hello am trying to count registered users from my database

so i came up with something like this:

public class HomeController : Controller
{
private ApplicationDbContext db = new ApplicationDbContext();
public ActionResult Index()
{
if(User.IsInRole("Tutor"))
{
ViewData["TutorCount"] = db.Users.Count();
}
else
{
ViewData["StudentCount"] = db.Users.Count();
}
return View();
}
}

but doesn't seem to be working

any help or improvement please

i ll apriciate any help.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Thabo Happy8y ago
when i use this code

if(User.IsInRole("Tutor"))
        {
             ViewData["TutorCount"] = db.Users.Count();
         }
         else
         {
               ViewData["StudentCount"] = db.Users.Count();

results are    }
the results are: the above picture.

i think it counts all users so i used it like this
ViewData["UsersCount"] = db.Users.Count();
the results are

So in my database i have users(AspNetUsers) they are assigned to different role which are Student and Tutor. I want to count number of students and tutors
Ruchi Sharavat8y ago
So according to your logic count will be same for both if and else here because you are assigning "db.Users.Count() in both conditions.

If there is problem in case of display only than please show your UI code where you are displaying the count.
Thabo Happy8y ago
it works but only for students ViewData["StudentCount"] = db.Users.Count();
i thin this code ViewData["StudentCount"] = db.Users.Count(); all users not students becouse i dont think this if(User.IsInRole("Tutor")) works like this.
for tutor it doesn't display any number
if(User.IsInRole("Tutor"))
{
ViewData["TutorCount"] = db.Users.Count();
}
Also if there is another approach i will be happy to try it.
Ruchi Sharavat8y ago
Hello Thabo,

Are you getting any error or you want the logical code to get the count of users from database?
Farhan Ahmed8y ago
https://stackoverflow.com/questions/45184834/how-i-can-get-count-of-user-from-db-and-show-on-a-button-in-net-core