private void FillOrderProperties(Order order, IDataReader reader) { order.CustomerId = (string)GetItem("CustomerID", reader); order.EmployeeId = (int?)GetItem("EmployeeID", reader); order.RequiredDate = (DateTime?)GetItem("RequiredDate", reader); order.ShipVia = (int?)GetItem("ShipVia", reader); order.Freight = (decimal?)GetItem("Freight", reader); order.ShipName = (string)GetItem("ShipName", reader); order.ShipAddress = (string)GetItem("ShipAddress", reader); order.ShipCity = (string)GetItem("ShipCity", reader); order.ShipRegion = (string)GetItem("ShipRegion", reader); order.ShipPostalCode = (string)GetItem("ShipPostalCode", reader); order.ShipCountry = (string)GetItem("ShipCountry", reader); if (reader["OrderDate"] is DBNull) { return; } order.StartProcessing((DateTime)reader["OrderDate"]); if (!(reader["ShippedDate"] is DBNull)) { order.Deliver((DateTime)reader["ShippedDate"]); } }