public async Task <IEnumerable <StudentExam> > SearchStudentExam(StudentExamSearchRequest request)
{
var schoolYearIdParameter = new SqlParameter
{
ParameterName = "schoolYearId",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.BigInt,
Value = request.SchoolYearId
};
var classroomIdParameter = new SqlParameter
{
ParameterName = "classroomId",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.BigInt,
Value = request.ClassroomId
};
var examIdParameter = new SqlParameter
{
ParameterName = "examId",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.BigInt,
Value = request.ExamId
};
return(await _repository.ExecWithStoreProcedure("dbo.sp_SearchStudentExam @schoolYearId, @classroomId, @examId", schoolYearIdParameter, classroomIdParameter, examIdParameter));
}
public async Task <IHttpActionResult> StudentExamList([FromBody] StudentExamSearchRequest request)
{
try
{
var list = await _service.SearchStudentExam(request);
await _service.CommitAsync();
return(Ok(new { List = list }));
}
catch (Exception ex)
{
await _service.RollbackAsync();
return(BadRequest(GetError(ex)));
}
}
