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