public override ShowTime Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(showtimeId.ToString()); } return(new ShowTime(showtimeId, reader.GetInt32("MovieId"), reader.GetString("Time"), reader.GetString("Date"), reader.GetDecimal("Price"))); }
public override Movie Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(movieId.ToString()); } return(new Movie(movieId, reader.GetString("Name"), reader.GetString("Genre"), reader.GetDecimal("Rating"), reader.GetString("Director"))); }
public override IReadOnlyList <Report4Object> Translate(SqlCommand command, IDataRowReader reader) { var actors = new List <Report4Object>(); while (reader.Read()) { actors.Add(new Report4Object( reader.GetString("Name"), reader.GetDecimal("OverallRating"))); } return(actors); }
public override Review Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { throw new RecordNotFoundException(reviewId.ToString()); } return(new Review(reviewId, reader.GetInt32("MovieId"), reader.GetInt32("ViewerId"), reader.GetString("ReviewMessage"), reader.GetDecimal("Rating"))); }
public override IReadOnlyList <Report1Object> Translate(SqlCommand command, IDataRowReader reader) { var movies = new List <Report1Object>(); while (reader.Read()) { movies.Add(new Report1Object( reader.GetString("Name"), reader.GetDecimal("Rating"))); } return(movies); }
public override IReadOnlyList <ShowTime> Translate(SqlCommand command, IDataRowReader reader) { var showtimes = new List <ShowTime>(); while (reader.Read()) { showtimes.Add(new ShowTime( reader.GetInt32("ShowTimeId"), reader.GetInt32("MovieId"), time, reader.GetString("Date"), reader.GetDecimal("Price"))); } return(showtimes); }
public override IReadOnlyList <Movie> Translate(SqlCommand command, IDataRowReader reader) { var movies = new List <Movie>(); while (reader.Read()) { movies.Add(new Movie( reader.GetInt32("MovieId"), reader.GetString("Name"), reader.GetString("Genre"), reader.GetDecimal("Rating"), reader.GetString("Director"))); } return(movies); }
public override IReadOnlyList <Review> Translate(SqlCommand command, IDataRowReader reader) { var reviews = new List <Review>(); while (reader.Read()) { reviews.Add(new Review( reader.GetInt32("ReviewId"), reader.GetInt32("MovieId"), reader.GetInt32("ViewerId"), reader.GetString("ReviewMessage"), reader.GetDecimal("Rating"))); } return(reviews); }