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