public ActionResult Search(AdminUserSearch user) { var model = _lmsUserManager.Search(user); var roleRepo = new SqlLmsRoleRepository(); model.CreateRole(roleRepo.RoleGetAll()); return(View(model)); }
public ActionResult Search() { var roleRepo = new SqlLmsRoleRepository(); AdminUserSearch model = new AdminUserSearch(); model.CreateRole(roleRepo.RoleGetAll()); return(View(model)); }
public AdminUserSearch Search(AdminUserSearch user) { var response = new AdminUserSearch(); try { response.AdminUserList = _lmsUserRepository.UserSearch(user); } catch (Exception ex) { } return(response); }
public List <LmsUser> UserSearch(AdminUserSearch searchName) { List <LmsUser> users = new List <LmsUser>(); using (var cn = new SqlConnection(Settings.GetConnectionString())) { var cmd = new SqlCommand("UserSearch", cn); cmd.CommandType = CommandType.StoredProcedure; if (!string.IsNullOrEmpty(searchName.FirstName)) { cmd.Parameters.Add(new SqlParameter("@FirstNamePartial", searchName.FirstName)); } if (!string.IsNullOrEmpty(searchName.LastName)) { cmd.Parameters.Add(new SqlParameter("@LastNamePartial", searchName.LastName)); } if (!string.IsNullOrEmpty(searchName.Email)) { cmd.Parameters.Add(new SqlParameter("@EmailPartial", searchName.Email)); } if (!string.IsNullOrEmpty(searchName.SelectedRoleID)) { cmd.Parameters.Add(new SqlParameter("@RoleID", searchName.SelectedRoleID)); } cn.Open(); using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { var user = new LmsUser(); user.UserID = (int)dr["UserID"]; user.FirstName = dr["FirstName"].ToString(); user.LastName = dr["LastName"].ToString(); user.Email = dr["Email"].ToString(); users.Add(user); } } } return(users); }
public async Task <Pagination <AdminUser> > Search(AdminUserSearch search, Pager pager) { Expression <Func <AdminUser, bool> > predicate = x => x.IsValid && x.IsDeleted == false; if (!string.IsNullOrWhiteSpace(search.UserName)) { predicate = predicate.And(x => x.UserName.Contains(search.UserName.Trim())); } int total = await _adminUserRepository.CountAsync(predicate); var data = await _adminUserRepository.Query(predicate) .OrderByDescending(x => x.Id) .Offset(pager.Offset) .Take(pager.Limit) .ToListAsync(); var ret = new Pagination <AdminUser>(total, data, pager); return(ret); }
public List <LmsUser> UserSearch(AdminUserSearch searchName) { List <LmsUser> user2 = new List <LmsUser>(); return(user2); }