public override MemberStatus Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new MemberStatus(
MemberID,
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetInt32("Points"),
reader.GetString("Status")
));
}
public override RaceParticipant Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new RaceParticipant(
raceParticipantId,
reader.GetInt32("RaceId"),
reader.GetInt32("RunnerId"),
reader.GetInt32("Time"),
reader.GetValue <int>("AverageHeartRate")
));
}
public override IReadOnlyList <RepairHistory> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <RepairHistory>();
while (reader.Read())
{
temp.Add(new RepairHistory(
reader.GetString("RepairName"),
reader.GetString("EmployeeName"),
reader.GetString("CustomerName")
)
);
}
return(temp);
}
public override IReadOnlyList <WorkPosition> Translate(SqlCommand command, IDataRowReader reader)
{
var workPositions = new List <WorkPosition>();
while (reader.Read())
{
//product just product id and name (match with select in query)
workPositions.Add(new WorkPosition(
reader.GetString("PositionName"),
reader.GetValue <double>("AverageHourlyPay")
));
}
return(workPositions);
}
public override IReadOnlyList <Food> Translate(SqlCommand command, IDataRowReader reader)
{
List <Food> foods = new List <Food>();
while (reader.Read())
{
foods.Add(new Food(
reader.GetInt32("FoodID"),
reader.GetString("Name"),
reader.GetInt32("Quantity"),
reader.GetValue <decimal>("Price")));
}
return(foods);
}
public override Customer Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Customer(customerID,
reader.GetString("Name"),
reader.GetDouble("Budget"),
reader.GetInt32("Age"),
reader.GetString("Sex"),
reader.GetInt32("ContactID")
));
}
public override IReadOnlyList <Person> Translate(SqlCommand command, IDataRowReader reader)
{
var persons = new List <Person>();
while (reader.Read())
{
persons.Add(new Person(
reader.GetInt32("PersonId"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetString("Email")));
}
return(persons);
}
public override IReadOnlyList <SalesObj> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <SalesObj>();
while (reader.Read())
{
temp.Add(new SalesObj(
reader.GetString("StreetAddress"),
reader.GetInt32("Year"),
reader.GetDouble("Sales")
)
);
}
return(temp);
}
public override Product Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(ProductID.ToString());
}
return(new Product(
ProductID,
reader.GetInt32("StoreID"),
reader.GetValue <DepartmentType>("DepartmentType"),
reader.GetValue <Double>("UnitPrice"),
reader.GetInt32("StockQuantity"),
reader.GetString("ProductName")));
}
public override Orders Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Orders(
orderID,
reader.GetInt32("MemberID"),
reader.GetInt32("EmployeeID"),
reader.GetInt32("ShipmentID"),
reader.GetDateTimeOffset("OrderDate"),
reader.GetString("ShipmentAddress")));
}
public override IReadOnlyList <Department> Translate(SqlCommand command, IDataRowReader reader)
{
var Departments = new List <Department>();
while (reader.Read())
{
Departments.Add(new Department(
reader.GetInt32("DepartmentID"),
reader.GetValue <DepartmentType>("DepartmentType"),
reader.GetInt32("StoreID"),
reader.GetString("DepartmentName")));
}
return(Departments);
}
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 <Person> Translate(SqlCommand command, IDataRowReader reader)
{
var Person = new List <Person>();
while (reader.Read())
{
Person.Add(new Person(Convert.ToInt32(reader.GetInt32("PersonId")),
reader.GetString("Name"),
reader.GetString("DOB"),
reader.GetString("DeathDate"),
reader.GetString("IsDeleted")));
}
return(Person);
}
public override IReadOnlyList <ProductionHouse> Translate(SqlCommand command, IDataRowReader reader)
{
var production = new List <ProductionHouse>();
while (reader.Read())
{
production.Add(new ProductionHouse(
reader.GetInt32("ProductionId"),
reader.GetString("ProductionName"),
reader.GetString("Location"),
"NULL"));
}
return(production);
}
public override IReadOnlyList <ItemSale> Translate(SqlCommand command, IDataRowReader reader)
{
List <ItemSale> itemSales = new List <ItemSale>();
while (reader.Read())
{
itemSales.Add(new ItemSale(
reader.GetString("ProductName"),
reader.GetValue <decimal>("TotalSalesOnItem"),
reader.GetInt32("OrderedTimes"),
date));
}
return(itemSales);
}
public override IReadOnlyList <Repair> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <Repair>();
while (reader.Read())
{
temp.Add(new Repair(
reader.GetInt32("RepairID"),
reader.GetString("RepairName"),
reader.GetString("LaborCost"),
reader.GetString("Status")
));
}
return(temp);
}
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.GetInt32("Quantity"),
reader.GetString("QuantityStatus")
)
);
}
return(temp);
}
public override IReadOnlyList <Product> Translate(SqlCommand command, IDataRowReader reader)
{
var Products = new List <Product>();
while (reader.Read())
{
//product just product id and name (match with select in query)
Products.Add(new Product(
reader.GetInt32("QuantitySold"),
reader.GetString("ProductName")
));
}
return(Products);
}
public override IReadOnlyList <TimeEntry> Translate(SqlCommand command, IDataRowReader reader)
{
var Employees = new List <TimeEntry>();
while (reader.Read())
{
//product just product id and name (match with select in query)
Employees.Add(new TimeEntry(
reader.GetString("EmployeeName"),
reader.GetInt32("HoursWorked")
));
}
return(Employees);
}
public override IReadOnlyList <Workout> Translate(SqlCommand command, IDataRowReader reader)
{
var workout = new List <Workout>();
while (reader.Read())
{
workout.Add(new Workout(
reader.GetInt32("WorkoutID"),
reader.GetInt32("SessionID"), //dont know how to get fk
(double)reader.GetInt32("Duration"),
(double)reader.GetInt32("AvgHeartRate")));
}
return(workout);
}
public override IReadOnlyList <Movie> Translate(SqlCommand command, IDataRowReader reader)
{
var Movie = new List <Movie>();
while (reader.Read())
{
Movie.Add(new Movie(Convert.ToInt32(reader.GetInt32("MovieId")),
reader.GetInt32("ProductionId"),
reader.GetString("MovieName"),
"NULL",
"NULL"));
}
return(Movie);
}
public override IReadOnlyList <Racer> Translate(SqlCommand command, IDataRowReader reader)
{
var raceParticipants = new List <Racer>();
while (reader.Read())
{
raceParticipants.Add(new Racer(
reader.GetInt32("RaceParticipantId"),
reader.GetString("Name"),
reader.GetInt32("Time"),
reader.GetValue <int>("AvgHeartRate")));
}
return(raceParticipants);
}
public override IReadOnlyList <RatingByWeather> Translate(SqlCommand command, IDataRowReader reader)
{
var ratingsByWeather = new List <RatingByWeather>();
while (reader.Read())
{
ratingsByWeather.Add(new RatingByWeather(
reader.GetDouble("Rating"),
reader.GetString("WeatherType"),
reader.GetString("Date")
));
}
return(ratingsByWeather);
}
public override IReadOnlyList <IngredientInformation> Translate(SqlCommand command, IDataRowReader reader)
{
List <IngredientInformation> ingredientInformation = new List <IngredientInformation>();
while (reader.Read())
{
ingredientInformation.Add(new IngredientInformation(
reader.GetString("Name"),
reader.GetValue <decimal>("Amount"),
reader.GetString("Units"),
reader.GetValue <decimal>("CostPerUnit")));
}
return(ingredientInformation);
}
public override IReadOnlyList <RunnerNameAndTeam> Translate(SqlCommand command, IDataRowReader reader)
{
var runners = new List <RunnerNameAndTeam>();
if (!reader.Read())
{
return(null);
}
do
{
int EndYear = 0;
if (!reader.IsDbNull("EndYear"))
{
EndYear = reader.GetInt32("EndYear");
}
runners.Add(new RunnerNameAndTeam(
reader.GetString("RunnerName"),
reader.GetString("TeamName"),
reader.GetInt32("StartYear"),
EndYear));
} while (reader.Read());
return(runners);
}
public override IReadOnlyList <Environment> Translate(SqlCommand command, IDataRowReader reader)
{
var environment = new List <Environment>();
while (reader.Read())
{
environment.Add(new Environment(
reader.GetInt32("EnvironmentID"),
reader.GetInt32("WeatherID"), //dont know how to get fk
reader.GetInt32("LocationID"),
reader.GetInt32("IsIndoor")));
}
return(environment);
}
public override IReadOnlyList <ShowTime> Translate(SqlCommand command, IDataRowReader reader)
{
var showtimes = new List <ShowTime>();
while (reader.Read())
{
showtimes.Add(new ShowTime(
reader.GetInt32("ShowTimeId"),
reader.GetInt32("MovieId"),
time,
reader.GetString("Date"),
reader.GetDecimal("Price")));
}
return(showtimes);
}
public override IReadOnlyList <Runner> Translate(SqlCommand command, IDataRowReader reader)
{
var runners = new List <Runner>();
while (reader.Read())
{
runners.Add(new Runner(
reader.GetInt32("RunnerId"),
reader.GetInt32("TeamId"),
reader.GetInt32("StartYear"),
reader.GetInt32("EndYear")));
}
return(runners);
}
/*
* @EmployeeName NVARCHAR(255)
* AS
* SELECT COUNT(DISTINCT IIF(R.[Status] = 'Complete', R.[Status], NULL)) AS RepairsCompleted,
* COUNT(DISTINCT IIF(R.[Status] = 'In Progress', R.[Status], NULL)) AS RepairsInProgress
*/
public override IReadOnlyList <EmployeeRepair> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <EmployeeRepair>();
while (reader.Read())
{
temp.Add(
new EmployeeRepair(
reader.GetInt32("RepairsCompleted"),
reader.GetInt32("RepairsInProgress")
)
);
}
return(temp);
}
public override IReadOnlyList <LocationQuantity> Translate(SqlCommand command, IDataRowReader reader)
{
var temp = new List <LocationQuantity>();
while (reader.Read())
{
temp.Add(new LocationQuantity(
reader.GetInt32("LocationID"),
reader.GetString("StreetAddress"),
reader.GetInt32("Quantity")
)
);
}
return(temp);
}
