public async Task <IActionResult> ChildrenByBus() { var user = await userManager.GetUserAsync(User); if (user == null || !(await userManager.IsInRoleAsync(user, UserHelpers.UserRoles.Staff.ToString()))) { return(Utilities.ErrorJson("Not authorized.")); } try { AnalyticsRepository repo = new AnalyticsRepository(configModel.ConnectionString); return(new JsonResult(new { ChildrenByBus = repo.GetChildrenByBus() })); } catch (Exception exc) { return(new JsonResult(new { Error = exc.Message, })); } }