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 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 List<LmsUser> UserSearch(AdminUserSearch searchName) { List<LmsUser> user2 = new List<LmsUser>(); return user2; }
public AdminUserSearch Search(AdminUserSearch user) { var response = new AdminUserSearch(); try { response.AdminUserList = _lmsUserRepository.UserSearch(user); } catch (Exception ex) { } return response; }