public static List <AllUsersModel> GetAllUsers()
{
List <AllUsersModel> users = new List <AllUsersModel>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PracticeDemo"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_getAllUsers", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AllUsersModel user = new AllUsersModel();
user.UserId = Convert.ToInt32(reader["UserId"]);
user.UserName = reader["UserName"].ToString();
user.fullName = reader["FullName"].ToString();
user.Email = reader["Email"].ToString();
user.Gender = reader["Gender"].ToString();
users.Add(user);
}
}
}
return(users);
}
public async Task <IActionResult> AllUsers()
{
AllUsersModel model = new AllUsersModel();
var users = ctx.Users.ToArray();
model.Users = mapper.Map <UserDTO[]>(users);
return(View(model));
}
private AllUsersModel Convert(List <User> users)
{
var Users = new AllUsersModel {
Users = new List <UserModel> {
}
};
foreach (var user in users)
{
Users.Users.Add(Convert(user));
}
return(Users);
}
public async Task <IActionResult> Users()
{
var users = await this.db.Users.Where(x => x.IsDeleted == false && x.EmailConfirmed == true).ToListAsync();
var output = new AllUsersModel
{
Users = users.Select(x => new UserViewModel
{
FirstName = x.FirstName,
LastName = x.LastName,
Id = x.Id,
ImgPath = GlobalConstants.CloudinaryPathDimitur98 + x.UserImg,
NameOfCompany = x.NameOfCompany,
NameOfThePage = x.NameOfThePage,
CreatedOn = x.CreatedOn,
}).OrderByDescending(x => x.CreatedOn).ToList(),
};
return(this.View(output));
}
public ActionResult Index(int page = FIRST_PAGE, string sortby = NO_SORT_BY, string order = DEFAULT_ORDER)
{
if (!Authorized(RoleType.UsersManager))
{
return(Error(Loc.Dic.error_no_permission));
}
AllUsersModel model = new AllUsersModel();
IEnumerable <User> activeUsersQuery;
using (UsersRepository usersRep = new UsersRepository(CurrentUser.CompanyId))
using (PendingUsersRepository pendingUsersRep = new PendingUsersRepository())
using (CompaniesRepository companiesRep = new CompaniesRepository())
{
activeUsersQuery = usersRep.GetList().Where(x => x.CompanyId == CurrentUser.CompanyId && x.IsActive).ToList();
activeUsersQuery = Pagination(activeUsersQuery, page, sortby, order).ToList();
model.NonActiveUsers = usersRep.GetList().Where(x => x.CompanyId == CurrentUser.CompanyId && !x.IsActive).ToList();
Company company = companiesRep.GetEntity(CurrentUser.CompanyId);
if (model.NonActiveUsers == null)
{
return(Error(Loc.Dic.error_users_get_error));
}
if (activeUsersQuery == null)
{
return(Error(Loc.Dic.error_users_get_error));
}
if (company == null)
{
return(Error(Loc.Dic.error_database_error));
}
model.ActiveUsers = activeUsersQuery.ToList();
model.ActiveUsersCount = activeUsersQuery.Count();
model.CanceledUsersCount = model.NonActiveUsers.Count();
model.UsersLimit = companiesRep.GetEntity(CurrentUser.CompanyId).UsersLimit;
return(View(model));
}
}
