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