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") )); }