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