public override IReadOnlyList <Location> Translate(SqlCommand command, IDataRowReader reader)
{
var locations = new List <Location>();
while (reader.Read())
{
locations.Add(
new Location(
reader.GetInt32("LocationID"),
reader.GetString("StreetAddress"),
reader.GetString("City"),
reader.GetString("Region"),
reader.GetString("Zip")
)
);
/*
* LocationID = locationID;
* StreetAddress = streetAddress;
* City = city;
* Region = region;
* Zip = zip;
*/
}
return(locations);
}
public override Actor Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
throw new RecordNotFoundException(name.ToString());
return new Actor(reader.GetInt32("ActorId"), name);
}
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 IReadOnlyList <PartSearch> Translate(SqlCommand command, IDataRowReader reader)
{
//if (!reader.Read())
//throw new RecordNotFoundException(StreetAddress);
if (!reader.Read())
{
throw new RecordNotFoundException(PartName);
}
var temp = new List <PartSearch>();
while (reader.Read())
{
temp.Add(new PartSearch(
//StreetAddress,
//PartName,
reader.GetInt32("Quantity"),
reader.GetString("Price"),
reader.GetString("StreetAddress")
)
);
}
return(temp);
}
public override Subject Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(icNumber);
}
DOBSource source;
if (reader.GetNullableString("DOBSource") == null)
{
source = DOBSource.none;
}
else
{
source = (DOBSource)Enum.Parse(typeof(DOBSource), reader.GetString("DOBSource"));
}
return(new Subject(
reader.GetInt32("SubjectID"),
(EthnicGroup)Enum.Parse(typeof(EthnicGroup), reader.GetString("EthnicGroup")),
reader.GetString("OAHeLPID"),
reader.GetString("Sex")[0],
reader.GetNullableDateTime("DOB"),
source,
icNumber,
reader.GetNullableInt32("MotherID"),
reader.GetNullableInt32("FatherID"),
reader.GetNullableString("PhotoFileName")
));;
}
public override Subject Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(subjectId.ToString());
}
DOBSource source;
if (reader.GetNullableString("DOBSource") == null)
{
source = DOBSource.none;
}
else
{
source = (DOBSource)Enum.Parse(typeof(DOBSource), reader.GetString("DOBSource"));
}
return(new Subject(
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")
));
}
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);
}
}
/// <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 category of runtime as key and the earnings as the value</returns>
public override Dictionary <string, double> Translate(SqlCommand command, IDataRowReader reader)
{
var movies = new Dictionary <string, double>();
double less90 = 0;
double middle = 0;
double greater120 = 0;
while (reader.Read())
{
string s = reader.GetString("MovieLength");
if (s == "The Movie is Less Than 90 Minutes")
{
less90 += reader.GetDouble("TicketSales");
}
else if (s == "This Movie is Between 90 and 120 Minutes")
{
middle += reader.GetDouble("TicketSales");
}
else
{
greater120 += reader.GetDouble("TicketSales");
}
}
movies.Add("The Movie is Less Than 90 Minutes", less90);
movies.Add("This Movie is Between 90 and 120 Minutes", middle);
movies.Add("This Movie is Longer Than 120 minutes", greater120);
return(movies);
}
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 Agent Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Agent(reader.GetInt32("AgentID"), reader.GetString("Name"), reader.GetDouble("Salary")));
}
public override int Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(0);
}
return(reader.GetInt32("LocationId"));
}
public HeaderAliasDataRowReader(IDataRowReader underlyingReader, HeaderAlias[] aliases)
{
RaiseException.WhenTrue(underlyingReader == null, "underlyingReader must not be null!");
RaiseException.WhenTrue(aliases == null, "aliases must not be null!");
RaiseException.WhenTrue(aliases.Length == 0, "aliases must not be empty!");
this.underlyingReader = underlyingReader;
this.aliases = aliases;
}
public override City Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new City(reader.GetInt32("CityID"), cityName, region, country));
}
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 DataRowFilterReader(IDataRowReader underlyingReader, string[] headerFilter)
{
RaiseException.WhenTrue(underlyingReader == null, "underlyingReader must not be null!");
RaiseException.WhenTrue(headerFilter == null, "headerFilter must not be null!");
RaiseException.WhenTrue(headerFilter.Length == 0, "headerFilter must not be empty!");
this.underlyingReader = underlyingReader;
this.headerFilter = headerFilter;
}
public override BoardingPass Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new BoardingPass(reservationID, reader.GetInt32("FlightID"), reader.GetDouble("Price")));
}
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")));
}
/// <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")));
}
/// <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")));
}
public override Attraction Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Attraction(reader.GetInt32("AttractionID"), name, cityID));
}
public override Actor Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(actorId.ToString());
}
return(new Actor(actorId, reader.GetString("Name")));
}
public override Restaurant Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Restaurant(reader.GetInt32("RestaurantID"), restaurantName, cityID));
}
public override Attraction Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Attraction(attractionID, reader.GetString("Name"), reader.GetInt32("CityID")));
}
public override Librarian Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(librarianID.ToString());
}
return(new Librarian(librarianID,
reader.GetInt32("UserID")));
}
public override Creator Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(creatorID.ToString());
}
return(new Creator(creatorID,
reader.GetInt32("CreatorTypeID")));
}
public override ProductionHouse Translate(SqlCommand command, IDataRowReader reader)///may need to overide
{
//if (!reader.Read())
/// throw new RecordNotFoundException(pId);
return(new ProductionHouse(pId,
Name,
location,
"Deleted"));
}
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")
));
}
/// <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 all movies in the database</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 DataTable Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(subjectId.ToString());
}
DataTable result = new DataTable();
//still need implementation code here...
return(result);
}
public override CarRental Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new CarRental(reader.GetInt32("CarRentalID"),
agencyName, cityID
));
}
