public ActionResult UpdateChildren(int id) { var vm = new ParentChildChecklistVM(); vm.ParentId = id; var searchRequest = new SearchRequest { RoleName = "Student" }; var searchResponse = _lmsUserManager.UserSearch(searchRequest); if (!searchResponse.Success) { ViewBag.ErrorMsg = searchResponse.Message; return View("Error"); } var studentResponse = _lmsUserManager.GetStudentsByParentId(id); if (studentResponse.Success) { vm.PopulateList(searchResponse.Data, studentResponse.Data); return View("SelectUserChildren", vm); } else { ViewBag.ErrorMsg = studentResponse.Message; return View("Error"); } }
public List<LmsUser> SearchUsers(SearchRequest request) { using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString())) { var p = new DynamicParameters(); if (!String.IsNullOrEmpty(request.FirstName)) { p.Add("@FirstName", request.FirstName); } if (!String.IsNullOrEmpty(request.LastName)) { p.Add("@LastName", request.LastName); } if (!String.IsNullOrEmpty(request.Email)) { p.Add("@Email", request.Email); } if (!String.IsNullOrEmpty(request.RoleName)) { p.Add("@RoleName", request.RoleName); } var users = cn.Query<LmsUser>("spUserSearch", p, commandType: CommandType.StoredProcedure).OrderBy(u=>u.LastName).ThenBy(u=>u.FirstName).ThenBy(u=>u.Email).ToList(); return users; } }
public List<LmsUser> SearchUsers(SearchRequest request) { return new List<LmsUser>() { new LmsUser() { Email = "*****@*****.**", FirstName = "Joe", LastName = "Schmoe", SuggestedRole = "Student", GradeLevelId = 10, AspId = "3", UserId = 3 }, new LmsUser() { Email = "*****@*****.**", FirstName = "Janet", LastName = "Schmoe", SuggestedRole = "Student", GradeLevelId = 11, AspId = "4", UserId = 4 } }; }
public DataResponse<List<LmsUser>> UserSearch(SearchRequest request) { var response = new DataResponse<List<LmsUser>>(); try { response.Data = _lmsUserRepository.SearchUsers(request); response.Success = true; } catch (Exception ex) { response.Message = ex.Message; response.Success = false; } return response; }