public override OrderCount Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new OrderCount( reader.GetDateTimeOffset("StartDate"), reader.GetDateTimeOffset("EndDate"), reader.GetInt32("TotalOrders") )); }
public override Member Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new Member( reader.GetInt32("MemberID"), email, reader.GetString("FirstName"), reader.GetString("LastName"), reader.GetString("Phone"), reader.GetString("BillingAddress"), reader.GetInt32("Points"), reader.GetDateTimeOffset("JoinedOn"), reader.GetDateTimeOffset("BirthDate"), reader.GetString("Status"))); }
public override Trip Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new Trip(tripID, reader.GetInt32("CustomerID"), reader.GetDateTimeOffset("DateCreated"), reader.GetInt32("AgentID"))); }
public override IReadOnlyList <Trip> Translate(SqlCommand command, IDataRowReader reader) { List <Trip> trips = new List <Trip>(); //Get all trips associated with agent and customer while (reader.Read()) { trips.Add(new Trip(reader.GetInt32("TripID"), customerID, reader.GetDateTimeOffset("DateCreated"), agentID)); } return(trips); }
public override Shipment Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } return(new Shipment( reader.GetInt32("ShipmentID"), reader.GetDateTimeOffset("ShipmentDate"), reader.GetString("ShipmentAddress"))); }
public override IReadOnlyList <Trip> Translate(SqlCommand command, IDataRowReader reader) { List <Trip> trips = new List <Trip>(); while (reader.Read()) { trips.Add(new Trip(reader.GetInt32("TripID"), reader.GetInt32("CustomerID"), reader.GetDateTimeOffset("DateCreated"), reader.GetInt32("AgentID"))); } return(trips); }
public override IReadOnlyList <Member> Translate(SqlCommand command, IDataRowReader reader) { var members = new List <Member>(); while (reader.Read()) { members.Add(new Member( reader.GetInt32("MemberID"), reader.GetString("Email"), reader.GetString("FirstName"), reader.GetString("LastName"), reader.GetString("Phone"), reader.GetString("BillingAddress"), reader.GetInt32("Points"), reader.GetDateTimeOffset("JoinedOn"), reader.GetDateTimeOffset("BirthDate"), reader.GetString("Status") )); } return(members); }
public override IReadOnlyList <Order> Translate(SqlCommand command, IDataRowReader reader) { List <Order> listOfOrders = new List <Order>(); while (reader.Read()) { listOfOrders.Add(new Order( reader.GetInt32("OrderID"), new Waiter( reader.GetString("FirstName"), reader.GetString("LastName")), tableNumber, reader.GetDateTimeOffset("OrderedOn"))); } return(listOfOrders); }
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 <Shipment> Translate(SqlCommand command, IDataRowReader reader) { var shipments = new List <Shipment>(); while (reader.Read()) { shipments.Add(new Shipment( reader.GetInt32("ShipmentID"), reader.GetDateTimeOffset("ShipmentDate"), reader.GetString("ShipmentAddress") )); } return(shipments); }
public override IReadOnlyList <Reservation> Translate(SqlCommand command, IDataRowReader reader) { List <Reservation> reservations = new List <Reservation>(); while (reader.Read()) { reservations.Add(new Reservation(reader.GetInt32("ReservationID"), reader.GetDateTimeOffset("DateCreated"), reader.GetBitToBool("CarRentalReservation"), reader.GetBitToBool("HotelReservation"), reader.GetBitToBool("BoardingPass"), reader.GetBitToBool("AttractionTicket"), reader.GetBitToBool("RestaurantReservation"), tripID)); } return(reservations); }
public override IReadOnlyList <Orders> Translate(SqlCommand command, IDataRowReader reader) { var orders = new List <Orders>(); while (reader.Read()) { orders.Add(new Orders( reader.GetInt32("OrderID"), reader.GetInt32("MemberID"), reader.GetInt32("EmployeeID"), reader.GetInt32("ShipmentID"), reader.GetDateTimeOffset("OrderDate"), reader.GetString("ShipmentAddress"))); } return(orders); }