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