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 BindingList <Subject> Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(subjectIds.ToString());
}
BindingList <Subject> result = new BindingList <Subject>();
do
{
DOBSource source;
if (reader.GetNullableString("DOBSource") == null)
{
source = DOBSource.none;
}
else
{
source = (DOBSource)Enum.Parse(typeof(DOBSource), reader.GetString("DOBSource"));
}
Subject next = new Subject(
reader.GetInt32("SubjectID"),
(EthnicGroup)Enum.Parse(typeof(EthnicGroup), reader.GetString("EthnicGroup")),
reader.GetString("OAHeLPID"),
reader.GetString("Sex")[0], //there is a GetChar function to use instead of this
reader.GetNullableDateTime("DOB"),
source,
reader.GetNullableString("ICNumber"),
reader.GetNullableInt32("MotherID"),
reader.GetNullableInt32("FatherID"),
reader.GetNullableString("PhotoFileName")
);
Name name = new Name(
reader.GetString("FirstName"),
reader.GetString("MiddleNames"),
reader.GetString("LastName"));
Residence residence = null;
if (!reader.IsNull("ResidenceDate") || !reader.IsNull("Villagename"))
{
residence = new Residence(reader.GetDateTime("ResidenceDate"), reader.GetString("VillageName"));
}
if (result.Contains(next))
{
result[result.IndexOf(next)].AddName(name);
result[result.IndexOf(next)].AddResidence(residence);
}
else
{
next.AddName(name);
next.AddResidence(residence);
result.Add(next);
}
}while (reader.Read());
return(result);
}
public override HotelReservation Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(reservationId.ToString());
}
return(new HotelReservation(reservationId,
reader.GetInt32("HotelID"),
reader.GetDateTime("CheckInDate"),
reader.GetDouble("Price")));
}
/// <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 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 RestaurantReservation Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
;
return(new RestaurantReservation(reader.GetInt32("ReservationID"),
reader.GetDateTime("ReservationDate"),
reservationID));
}
/// <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 User Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(userID.ToString());
}
return(new User(userID,
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetString("PhoneNumber"),
reader.GetDateTime("LastCheckOutDate")));
}
public override CarRentalReservation Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(reservationID.ToString());
}
return(new CarRentalReservation(reader.GetInt32("ReservationID"),
reader.GetInt32("CarRentalID"),
reader.GetDateTime("RentalDate"),
reader.GetString("Model"),
reader.GetDouble("Price")
));
}
public override User Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new User(
reader.GetInt32("PersonId"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
phonenumber,
reader.GetDateTime("LastCheckOutDate")));
}
public override Asset Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(assetID.ToString());
}
return(new Asset(assetID,
reader.GetString("Name"),
reader.GetInt32("AssetTypeID"),
reader.GetInt32("CreatorID"),
reader.GetDateTime("ReleaseDate"),
reader.GetInt32("Stock")));
}
public override IReadOnlyList <HourReport> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <HourReport>();
while (reader.Read())
{
temp.Add(new HourReport(
reader.GetString("EmployeeName"),
reader.GetDateTime("Hours"),
reader.GetString("StreetAddress")
)
);
}
return(temp);
}
public override IReadOnlyList <User> Translate(SqlCommand command, IDataRowReader reader)
{
var users = new List <User>();
while (reader.Read())
{
users.Add(new User(
reader.GetInt32("UserID"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetString("PhoneNumber"),
reader.GetDateTime("LastCheckOutDate")));
}
return(users);
}
public override IReadOnlyList <Asset> Translate(SqlCommand command, IDataRowReader reader)
{
var users = new List <Asset>();
while (reader.Read())
{
users.Add(new Asset(
reader.GetInt32("AssetID"),
reader.GetString("Name"),
reader.GetInt32("AssetTypeID"),
reader.GetInt32("CreatorID"),
reader.GetDateTime("ReleaseDate"),
reader.GetInt32("Stock")));
}
return(users);
}
public override IReadOnlyList <Appointment> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <Appointment>();
while (reader.Read())
{
temp.Add(
new Appointment(
reader.GetInt32("AppointmentID"),
reader.GetInt32("LocationID"),
reader.GetInt32("RepairID"),
reader.GetInt32("CustomerID"),
reader.GetDateTime("AppointmentTime")
)
);
}
return(temp);
}
/// <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 movie being searched for</returns>
public override Movie Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Movie(reader.GetInt32("MovieId"), MovieName, reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate")));
}
/// <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 movie being searched for</returns>
public override Movie Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(MovieId.ToString());
}
return(new Movie(MovieId, reader.GetString("MovieTitle"), reader.GetString("Rating"), reader.GetInt32("RuntimeMinutes"), reader.GetDateTime("ReleaseDate")));
}
