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 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 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 WorkPosition Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
return null;
return new WorkPosition(
reader.GetInt32("WorkPositionID"),
reader.GetValue<double>("HourlyPay"),
WorkPositionName,
reader.GetValue<WorkPositionType>("WorkPositionType"));
}
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")
));
}
public override WorkPosition Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(WorkPositionID.ToString());
}
return(new WorkPosition(
WorkPositionID,
reader.GetValue <double>("HourlyPay"),
reader.GetString("PositionName"),
reader.GetValue <WorkPositionType>("WorkPositionType")));
}
public override Product Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new Product(
reader.GetInt32("ProductID"),
reader.GetInt32("StoreID"),
reader.GetValue <DepartmentType>("DepartmentType"),
reader.GetValue <double>("UnitPrice"),
reader.GetInt32("StockQuantity"),
productName));
}
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 <WorkPosition> Translate(SqlCommand command, IDataRowReader reader)
{
var WorkPositions = new List <WorkPosition>();
while (reader.Read())
{
WorkPositions.Add(new WorkPosition(
reader.GetInt32("WorkPositionID"),
reader.GetValue <double>("HourlyPay"),
reader.GetString("WorkPositionName"),
reader.GetValue <WorkPositionType>("WorkPositionType")));
}
return(WorkPositions);
}
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 TrainingRun Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new TrainingRun(
trainingRunId,
reader.GetInt32("RunnerId"),
reader.GetValue <DateTime>("Date"),
reader.GetInt32("Distance"),
reader.GetInt32("Time"),
reader.GetValue <int>("AverageHeartRate"),
reader.GetValue <int>("isArchived")));
}
public override IReadOnlyList <MonthProfitReport> Translate(SqlCommand command, IDataRowReader reader)
{
List <MonthProfitReport> monthProfitReports = new List <MonthProfitReport>();
while (reader.Read())
{
monthProfitReports.Add(new MonthProfitReport(
reader.GetInt32("Year"), reader.GetInt32("Month"),
reader.GetValue <decimal>("TotalEarnings"),
reader.GetValue <decimal>("WorkersWagesLoss"),
reader.GetValue <decimal>("IngredientsLoss"),
reader.GetValue <decimal>("MonthProfit"),
reader.GetValue <decimal>("TotalProfit")));
}
return(monthProfitReports);
}
public override User Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
return(null);
}
return(new User(
reader.GetInt32("UserId"),
email,
reader.GetString("PassHash"),
reader.GetInt32("UserType"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetValue <DateTimeOffset>("CreatedOn"),
reader.GetValue <DateTimeOffset>("UpdatedOn")));
}
public override IReadOnlyList <Sales> Translate(SqlCommand command, IDataRowReader reader)
{
var Sales = new List <Sales>();
while (reader.Read())
{
//product just product id and name (match with select in query)
Sales.Add(new Sales(
reader.GetString("ProductName"),
reader.GetInt32("AmountOfProductsSold"),
reader.GetValue <double>("UnitPrice"),
reader.GetValue <double>("TotalSales")
));
}
return(Sales);
}
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 IReadOnlyList <Team> Translate(SqlCommand command, IDataRowReader reader)
{
var teams = new List <Team>();
while (reader.Read())
{
teams.Add(new Team(
reader.GetInt32("TeamId"),
reader.GetInt32("CoachId"),
reader.GetString("Name"),
reader.GetInt32("StartYear"),
reader.GetInt32("EndYear"),
reader.GetValue <DateTime>("CreatedOn"),
reader.GetValue <DateTime>("UpdatedOn")
));
}
return(teams);
}
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("Email"),
reader.GetString("PassHash"),
reader.GetInt32("UserType"),
reader.GetString("FirstName"),
reader.GetString("LastName"),
reader.GetValue <DateTime>("CreatedOn"),
reader.GetValue <DateTime>("UpdatedOn")));
}
return(users);
}
public override IReadOnlyList <Ingredient> Translate(SqlCommand command, IDataRowReader reader)
{
List <Ingredient> ingredients = new List <Ingredient>();
while (reader.Read())
{
ingredients.Add(new Ingredient(
reader.GetString("Name"), reader.GetValue <decimal>("AmountUsed")));
}
return(ingredients);
}
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"));
}
public override Department Translate(SqlCommand command, IDataRowReader reader)
{
if (!reader.Read())
{
throw new RecordNotFoundException(DepartmentID.ToString());
}
return(new Department(
DepartmentID,
reader.GetValue <DepartmentType>("DepartmentType"),
reader.GetInt32("StoreID"),
reader.GetString("DepartmentName")));
}
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 <FoodYearInfo> Translate(SqlCommand command, IDataRowReader reader)
{
List <FoodYearInfo> foodYearInfos = new List <FoodYearInfo>();
while (reader.Read())
{
foodYearInfos.Add(new FoodYearInfo(
reader.GetString("ProductName"),
reader.GetInt32("AmountSoldInYear"),
reader.GetValue <decimal>("TotalEarnings")));
}
return(foodYearInfos);
}
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"),
reader.GetValue <decimal>("Salary")));
}
return(waiters);
}
public override IReadOnlyList <EmployeePerformanceReport> Translate(SqlCommand command, IDataRowReader reader)
{
List <EmployeePerformanceReport> employeePerformanceReports = new List <EmployeePerformanceReport>();
while (reader.Read())
{
employeePerformanceReports.Add(new EmployeePerformanceReport(
reader.GetString("FirstName"), reader.GetString("LastName"),
reader.GetInt32("HoursWorked"), reader.GetInt32("OrdersServed"),
reader.GetValue <decimal>("TotalTipEarnings"), reader.GetValue <decimal>("AverageTipOrder")));
}
return(employeePerformanceReports);
}
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 <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 <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 <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 <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 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")
));
}
