public override IReadOnlyList <Team> Translate(SqlCommand command, IDataRowReader reader)
{
var teams = new List <Team>();
if (!reader.Read())
{
return(null);
}
do
{
int EndYear = 0;
if (!reader.IsDbNull("EndYear"))
{
EndYear = reader.GetInt32("EndYear");
}
teams.Add(new Team(
reader.GetInt32("TeamId"),
coachId,
reader.GetString("Name"),
reader.GetInt32("StartYear"),
EndYear,
reader.GetValue <DateTimeOffset>("CreatedOn"),
reader.GetValue <DateTimeOffset>("UpdatedOn")
));
} while (reader.Read());
return(teams);
}
public override Team Translate(SqlCommand command, IDataRowReader reader)
{
int EndYear = 0;
if (reader.Read())
{
if (!reader.IsDbNull("EndYear"))
{
EndYear = reader.GetInt32("EndYear");
}
return(new Team(
reader.GetInt32("TeamId"),
reader.GetInt32("CoachId"),
name,
reader.GetInt32("StartYear"),
EndYear,
reader.GetValue <DateTimeOffset>("CreatedOn"),
reader.GetValue <DateTimeOffset>("UpdatedOn")
));
}
else
{
return(null);
}
}
public override IReadOnlyList <TrainingRun> Translate(SqlCommand command, IDataRowReader reader)
{
var trainingRuns = new List <TrainingRun>();
if (!reader.Read())
{
return(null);
}
do
{
int averageHR = 0;
if (!reader.IsDbNull("AvgHeartRate"))
{
averageHR = reader.GetValue <int>("AvgHeartRate");
}
int isArchived = 0;
if (!reader.IsDbNull("isArchived"))
{
isArchived = reader.GetValue <int>("isArchived");
}
trainingRuns.Add(new TrainingRun(
reader.GetInt32("TrainingRunId"),
runnerId,
reader.GetValue <DateTime>("Date"),
reader.GetInt32("Distance"),
reader.GetInt32("Time"),
averageHR,
isArchived
));
} while (reader.Read());
return(trainingRuns);
}
public override Race Translate(SqlCommand command, IDataRowReader reader)
{
return(new Race(
raceId,
reader.GetInt32("CreatorId"),
reader.GetInt32("LocationId"),
reader.GetValue <DateTime>("DateTime"),
reader.GetInt32("Distance")));
}
public override Ticket Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(ticketId.ToString());
}
return(new Ticket(ticketId, reader.GetInt32("ViewerId"), reader.GetInt32("ShowTimeId")));
}
public override Trip Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Trip(tripID,
reader.GetInt32("CustomerID"),
reader.GetDateTimeOffset("DateCreated"),
reader.GetInt32("AgentID")));
}
public override IndividualAwardsWon Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new IndividualAwardsWon(reader.GetInt32("IndividualAwardsWonId"),
reader.GetInt32("MoviePersonId"), reader.GetString("IsDeleated")
));
}
public override AttractionTicket Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(reservationID.ToString());
}
return(new AttractionTicket(reader.GetInt32("ReservationID"),
reader.GetInt32("AttractionID"),
reader.GetDateTime("TicketDate"),
reader.GetFloat("Price")));
}
public override Team Translate(SqlCommand command, IDataRowReader reader)
{
return(new Team(
teamId,
reader.GetInt32("CoachId"),
reader.GetString("Name"),
reader.GetInt32("StartYear"),
reader.GetInt32("EndYear"),
reader.GetValue <DateTime>("CreatedOn"),
reader.GetValue <DateTime>("UpdatedOn")
));
}
/// <summary>
/// Method to create the objects with the information
/// returned from the sql procedure.
/// </summary>
/// <param name="command">The Sql command</param>
/// <param name="reader">The data row reader</param>
/// <returns>A dictionary with the Movie as the key and the theater sales as the value</returns>
public override Dictionary <Movie, double> Translate(SqlCommand command, IDataRowReader reader)
{
var movies = new Dictionary <Movie, double>();
while (reader.Read())
{
movies.Add(new Movie(reader.GetInt32("MovieId"), reader.GetString("MovieTitle"), reader.GetString("Rating"),
reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate")), reader.GetDouble("TheaterSales"));
}
return(movies);
}
public override IReadOnlyList <string> Translate(SqlCommand command, IDataRowReader reader)
{
List <string> rows = new List <string>();
while (reader.Read())
{
rows.Add($"{reader.GetInt32("AttractionID")}-{reader.GetString("Name")}-" +
$"{reader.GetInt32("NumberOfCustomers")}-{reader.GetString("CityName")}, " +
$"{reader.GetString("Country")}-${string.Format("{0:0.00}", reader.GetDouble("Price"))}");
}
return(rows);
}
public override CarRental Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(reservationID.ToString());
}
return(new CarRental(
reader.GetInt32("CarRentalID"),
reader.GetString("AgencyName"),
reader.GetInt32("CityID")));
}
public override RestaurantReservation Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
;
return(new RestaurantReservation(reader.GetInt32("ReservationID"),
reader.GetDateTime("ReservationDate"),
reader.GetInt32("RestaurantID")));
}
public override MoviePerson Translate(SqlCommand command, IDataRowReader reader)///may need to overide
{
if (!reader.Read())
{
throw new RecordNotFoundException(moviepersonId.ToString());
}
return(new MoviePerson(moviepersonId,
reader.GetInt32("PersonId"),
reader.GetInt32("MovieId"),
reader.GetString("Role")));
}
public override IReadOnlyList <Creator> Translate(SqlCommand command, IDataRowReader reader)
{
var users = new List <Creator>();
while (reader.Read())
{
users.Add(new Creator(
reader.GetInt32("CategoryID"),
reader.GetInt32("CreatorTypeID")));
}
return(users);
}
public override IReadOnlyList <Trip> Translate(SqlCommand command, IDataRowReader reader)
{
List <Trip> trips = new List <Trip>();
while (reader.Read())
{
trips.Add(new Trip(reader.GetInt32("TripID"),
reader.GetInt32("CustomerID"),
reader.GetDateTimeOffset("DateCreated"),
reader.GetInt32("AgentID")));
}
return(trips);
}
public override Sales Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(movieId.ToString());
}
return(new Sales(movieId,
reader.GetInt32("Domesticsales"),
reader.GetInt32("Foreignsales"),
"NULL"
));
}
public override RunnerSummary Translate(SqlCommand command, IDataRowReader reader)
{
if (reader.Read())
{
return(new RunnerSummary(
reader.GetInt32("AverageDistance"),
reader.GetInt32("AverageTime")));
}
else
{
return(null);
}
}
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 <string> Translate(SqlCommand command, IDataRowReader reader)
{
List <string> rows = new List <string>();
while (reader.Read())
{
rows.Add($"{reader.GetInt32("Year")},{reader.GetInt32("Month").ToString()}," +
$" {reader.GetInt32("NumberOfTrips")}," +
$"{string.Format("{0:0.00}", reader.GetDouble("AverageTripsPerAgent"))}," +
$"${string.Format("{0:0.00}", reader.GetDouble("TotalSale"))}");
}
return(rows);
}
public override Oscars Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Oscars(reader.GetInt32("OscarsId"),
reader.GetInt32("InidiualAwardsWonId"),
reader.GetInt32("MovieAwardsWonId"),
Name, reader.GetString("IsDeleated")
));
}
public override Oscars Translate(SqlCommand command, IDataRowReader reader)///may need to overide
{
if (!reader.Read())
{
throw new RecordNotFoundException(OscarsId.ToString());
}
return(new Oscars(OscarsId,
reader.GetInt32("IndiviualAwardsWonId"),
reader.GetInt32("MovieAwardsWon"),
reader.GetInt32("Year"), reader.GetString("IsDeleated")
));
}
public override MoviePerson Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(Name.ToString());
}
return(new MoviePerson(reader.GetInt32("MoviePersonId"),
Name,
reader.GetInt32("MovieId"),
reader.GetString("Role")
));
}
public override IReadOnlyList <Ticket> Translate(SqlCommand command, IDataRowReader reader)
{
var tickets = new List <Ticket>();
while (reader.Read())
{
tickets.Add(new Ticket(
reader.GetInt32("TicketId"),
reader.GetInt32("ViewerId"),
reader.GetInt32("ShowTimeId")));
}
return(tickets);
}
public override Department Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Department(
reader.GetInt32("DepartmentID"),
reader.GetValue <DepartmentType>("DepartmentType"),
reader.GetInt32("StoreID"),
departmentName)); //reader.GetString("DepartmentName"));
}
/// <summary>
/// Method to create the objects with the information
/// returned from the sql procedure.
/// </summary>
/// <param name="command">The Sql command</param>
/// <param name="reader">The data row reader</param>
/// <returns>The list of movies in the specified genre</returns>
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("MovieTitle"),
reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"),
reader.GetDateTime("ReleaseDate")));
}
return(movies);
}
public override IReadOnlyList <Librarian> Translate(SqlCommand command, IDataRowReader reader)
{
var users = new List <Librarian>();
while (reader.Read())
{
users.Add(new Librarian(
reader.GetInt32("LibrarianID"),
reader.GetInt32("UserID")));
}
return(users);
}
public override IReadOnlyList <MoviePerson> Translate(SqlCommand command, IDataRowReader reader)
{
var person = new List <MoviePerson>();
while (reader.Read())
{
person.Add(new MoviePerson(reader.GetInt32("MoviePersonId"),
reader.GetInt32("PersonId"),
reader.GetInt32("MovieId"),
reader.GetString("Role")));
}
return(person);
}
public override Flight Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Flight(reader.GetInt32("FlightID"),
reader.GetString("AirlineName"),
reader.GetDateTime("DepartureTime"),
reader.GetDateTime("ArrivalTime"),
reader.GetInt32("CityDepartureID"),
reader.GetInt32("CityArrivalID")));
}
public override IReadOnlyList <Sales> Translate(SqlCommand command, IDataRowReader reader)
{
var person = new List <Sales>();
while (reader.Read())
{
person.Add(new Sales(reader.GetInt32("MovieId"),
reader.GetInt32("Domesticsales"),
reader.GetInt32("Foreignsales"),
"NULL"));
}
return(person);
}
