public List <TeacherClassRoster> Get([FromUri] TeacherClassRoster request) { var repo = new RosterRepository(); var students = repo.Search(request); return(students); }
//------------------------------------------------------------------------------------------------------------------------------------ //Redo in Dapper //determines which search method to use public List <TeacherClassRoster> Search(TeacherClassRoster request) { if (string.IsNullOrEmpty(request.LastName)) { return(SearchStudentByGradeLevel(request)); } if (request.GradeLevel == null) { return(SearchStudentByLastNameOnly(request)); } return(SearchStudentByLastNameAndGradeLevel(request)); }
private List <TeacherClassRoster> SearchStudentByGradeLevel(TeacherClassRoster request) { using (var cn = new SqlConnection(Config.GetConnectionString())) { var p = new DynamicParameters(); p.Add("@GradeLevel", request.GradeLevel); p.Add("@ClassID", request.ClassID); return (cn.Query <TeacherClassRoster>("SearchStudentByGradeLevelOnly", p, commandType: CommandType.StoredProcedure).ToList()); } }