public async Task <Result <TeacherData> > FindById(int teacherId) { using (SqlConnection con = new SqlConnection(_connectionString)) { TeacherData teacher = await con.QueryFirstOrDefaultAsync <TeacherData>( @"select t.TeacherId, t.FirstName, t.LastName, t.isPresent from iti.vTeacher t where t.TeacherId = @TeacherId;", new { TeacherId = teacherId }); if (teacher == null) { return(Result.Failure <TeacherData>(Status.NotFound, "Teacher not found.")); } return(Result.Success(teacher)); } }
public async Task <Result <TeacherData> > GetAssignedTeacher(int classId) { using (SqlConnection con = new SqlConnection(_connectionString)) { TeacherData assignedTeacherData = await con.QueryFirstOrDefaultAsync <TeacherData>( @"select c.TeacherId, c.TeacherFirstName as FirstName, c.TeacherLastName as LastName, c.TeacherPresence as Presence from iti.vClass c where c.ClassId = @ClassId;", new { ClassId = classId }); if (assignedTeacherData == null) { return(Result.Failure <TeacherData>(Status.BadRequest, "Teacher not found.")); } return(Result.Success(assignedTeacherData)); } }