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(oaId);
}
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")),
oaId,
reader.GetString("Sex")[0],
reader.GetNullableDateTime("DOB"),
source,
reader.GetNullableString("ICNumber"),
reader.GetNullableInt32("MotherID"),
reader.GetNullableInt32("FatherID"),
reader.GetNullableString("PhotoFileName")
));
}
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);
}
/// <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")));
}
public override City Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new City(cityID,
reader.GetString("CityName"),
reader.GetString("Region"),
reader.GetString("Country")));
}
public override Person Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(personId.ToString());
}
return(new Person(personId,
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetString("Email")));
}
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 Person Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(Name);
}
return(new Person(reader.GetInt32("PersonId"),
Name,
reader.GetString("DOB"),
reader.GetString("DeathDate"), "NULL"));
}
public override ProductionHouse Translate(SqlCommand command, IDataRowReader reader)///may need to overide
{
if (!reader.Read())
{
throw new RecordNotFoundException(productionId.ToString());
}
return(new ProductionHouse(productionId,
reader.GetString("ProductionName"),
reader.GetString("Location"),
"NULL"));
}
public override Hotel Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Hotel(hotelID,
reader.GetInt32("CityID"),
reader.GetString("Name"),
reader.GetString("FullAddress")));
}
public override Person Translate(SqlCommand command, IDataRowReader reader)///may need to overide
{
if (!reader.Read())
{
throw new RecordNotFoundException(personId.ToString());
}
return(new Person(personId,
reader.GetString("Name"),
reader.GetString("DOB"),
"NULL", "NULL"));
}
public override Employee Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(EmployeeID.ToString());
}
return(new Employee(
EmployeeID,
reader.GetString("EmployeeName"),
reader.GetString("PositionName")));
}
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 <string> Translate(SqlCommand command, IDataRowReader reader)
{
List <string> rows = new List <string>();
while (reader.Read())
{
rows.Add($"{reader.GetString("CityName")}, " +
$"{reader.GetString("Country")}-{reader.GetString("Hotel")} " +
$"${string.Format("{0:0.00}", reader.GetDouble("CheapestHotelPrices"))}-{reader.GetString("Attraction")} " +
$"${string.Format("{0:0.00}", reader.GetDouble("CheapestAttractionPrices"))}");
}
return(rows);
}
public override Producer Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(creatorID.ToString());
}
return(new Producer(creatorID,
reader.GetInt32("CreatorTypeID"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetString("Company")));
}
public override IReadOnlyList <MenuItem> Translate(SqlCommand command, IDataRowReader reader)
{
List <MenuItem> menuItems = new List <MenuItem>();
while (reader.Read())
{
menuItems.Add(new MenuItem(
reader.GetString("Name"), reader.GetString("Description"),
reader.GetValue <decimal>("Price")));
}
return(menuItems);
}
public override IReadOnlyList <Waiter> Translate(SqlCommand command, IDataRowReader reader)
{
List <Waiter> waiters = new List <Waiter>();
while (reader.Read())
{
waiters.Add(new Waiter(
reader.GetString("FirstName"),
reader.GetString("LastName")));
}
return(waiters);
}
/// <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 key and the review score 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("UserScore"));
}
return(movies);
}
public override Person Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Person(
reader.GetInt32("PersonId"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
email));
}
/// <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 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 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 Location Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Location(
locationId,
reader.GetString("Name"),
reader.GetString("City"),
reader.GetString("StateProv")
));
}
public override IReadOnlyList <Report3Object> Translate(SqlCommand command, IDataRowReader reader)
{
var times = new List <Report3Object>();
while (reader.Read())
{
times.Add(new Report3Object(
reader.GetString("Time"),
reader.GetString("DayOfTheWeek"), //Potentially need something else, not sure how this lookup works
reader.GetInt32("NumberOfViewers")));
}
return(times);
}
public override ContactInfo Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new ContactInfo(reader.GetInt32("ContactID"),
reader.GetString("BillingAddress"),
reader.GetString("Phone"),
reader.GetString("Email"),
reader.GetInt32("CityID")
));
}
public override IReadOnlyList <ProductQuantity> Translate(SqlCommand command, IDataRowReader reader)
{
var products = new List <ProductQuantity>();
while (reader.Read())
{
products.Add(new ProductQuantity(
reader.GetString("ProductName"),
reader.GetInt32("Quantity"),
reader.GetString("Description")));
}
return(products);
}
public override Employees Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Employees(
employeeid,
reader.GetString("Email"),
reader.GetString("Name"),
reader.GetString("EmployeeRole"),
reader.GetInt32("Salary")));
}
public override IReadOnlyList <PartSearch> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <PartSearch>();
while (reader.Read())
{
temp.Add(new PartSearch(
reader.GetString("PartName"),
reader.GetString("Price")
)
);
}
return(temp);
}
public override Viewer Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(viewerId.ToString());
}
return(new Viewer(viewerId,
reader.GetString("Gender"),
reader.GetString("Name"),
reader.GetString("Email"),
reader.GetString("BirthDate"),
reader.GetString("Username")));
}
