public List <StandartComboBox> GetAllRoles() { List <StandartComboBox> Result = new List <StandartComboBox>(); string Query = "GetComboRole"; DataTable dt = new DataTable(); dbAccess.strConn = conn; dt = dbAccess.GetDataTable_not_async(Query); foreach (DataRow dr in dt.Rows) { Result.Add( new StandartComboBox { Value = Convert.ToString(dr["Value"]), Text = Convert.ToString(dr["Text"]) }); } return(Result); }
// Controllers // GET: /Admin/ // [Authorize(Roles = "Administrator")] #region public ActionResult Index(string searchStringUserNameOrEmail) public ActionResult Index(string searchStringUserNameOrEmail, string currentFilter, int?page) { dbAccess dbAccess = new dbAccess(); string conn = ConfigurationManager.ConnectionStrings["GetConn"].ConnectionString; try { List <ExpandedUserDTO> Result = new List <ExpandedUserDTO>(); string Query = "GetUserAll"; DataTable dt = new DataTable(); dbAccess.strConn = conn; dt = dbAccess.GetDataTable_not_async(Query); foreach (DataRow dr in dt.Rows) { Result.Add( new ExpandedUserDTO { Photo = Convert.ToString(dr["Photo"]), NameIdentifier = Convert.ToString(dr["NameIdentifier"]), UserName = Convert.ToString(dr["UserName"]), Email = Convert.ToString(dr["Email"]), PhoneNumber = Convert.ToString(dr["PhoneNumber"]), RoleName = Convert.ToString(dr["Name"]) }); } return(View(Result)); } catch (Exception ex) { ModelState.AddModelError(string.Empty, "Error: " + ex); List <ExpandedUserDTO> Result = new List <ExpandedUserDTO>(); return(View(Result)); } //try //{ // searchStringUserNameOrEmail = ""; // ViewBag.CurrentFilter = searchStringUserNameOrEmail; // List<ExpandedUserDTO> col_UserDTO = new List<ExpandedUserDTO>(); // var result = UserManager.Users // .Where(x => x.UserName.Contains(searchStringUserNameOrEmail)) // .OrderBy(x => x.UserName) // //.Skip(intSkip) // //.Take(intPageSize) // .ToList(); // foreach (var item in result) // { // ExpandedUserDTO objUserDTO = new ExpandedUserDTO(); // objUserDTO.UserName = item.UserName; // objUserDTO.NameIdentifier = item.NameIdentifier; // objUserDTO.Email = item.Email; // objUserDTO.PhoneNumber = item.PhoneNumber; // objUserDTO.LockoutEndDateUtc = item.LockoutEndDateUtc; // col_UserDTO.Add(objUserDTO); // } ); // return View(col_UserDTO); //} //catch (Exception ex) //{ // ModelState.AddModelError(string.Empty, "Error: " + ex); // List<ExpandedUserDTO> col_UserDTO = new List<ExpandedUserDTO>(); // return View(col_UserDTO.ToPagedList(1, 25)); //} }