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