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