public static List<Order> GetByInventoryItemId(Guid inventoryItemId) { List<Order> orderList = new List<Order>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetOrderByInventoryItemId objectCommand = new GetOrderByInventoryItemId(objectConnection)) { objectCommand.InventoryItemId = inventoryItemId; objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return orderList; } using (OrderSqlDataReader objectSqlDataReader = new OrderSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { Order order = objectSqlDataReader.Order; orderList.Add(order); } } } } } return orderList; }
public static List<Order> GetOrderByLastName(string lastName) { List<Order> orderList = new List<Order>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetOrderByLastName objectCommand = new GetOrderByLastName(objectConnection)) { objectCommand.LastName = lastName; objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return orderList; } using (OrderSqlDataReader objectSqlDataReader = new OrderSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { Order order = objectSqlDataReader.Order; orderList.Add(order); } } } } } return orderList; }