public ICommandResult Handle(TeacherCommand command)
{
try
{
return(CreateUser(_dbContext.Teachers, command).Result);
}
catch
{
return(CommandResult.Failed());
}
}
public ICommandResult Handle(TeacherCommand command)
{
try
{
return(EditUser(_dbContext.Teachers.Include(x => x.AppUser), command).Result);
}
catch
{
return(CommandResult.Failed());
}
}
public static List<Subject> SubjectsByTeacher(Guid teacherID)
{
List<Subject> subjects = new List<Subject>();
TeacherCommand.Parameters.Clear();
TeacherCommand.Parameters.AddWithValue("@TeacherID", teacherID);
try
{
Connection.Open();
SqlDataReader reader = TeacherCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (reader.HasRows)
while (reader.Read())
subjects.Add(new Subject(new Guid(reader["ID"].ToString()),
reader["Name"].ToString(), new Guid(reader["TeacherID"].ToString())));
}
catch { }
Connection.Close();
return subjects;
}
