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;
}
