public CountsViewModel ShowUsersAndPicturesCount()
{
var usersCount = db.Users.Where(u => u.EmailConfirmed).Count();
var obituariesCount = db.Obituaries.Count();
var picturesCount = db.Pictures.Count();
var counts = new CountsViewModel
{
TotalUsersCount = usersCount,
TotalObituaryCount = obituariesCount,
TotalUserPicturesCount = picturesCount,
};
return(counts);
}