// Adkjfadsgafdhglkajfgnafkmngakgnakjgndakjgndkajgngkdjangsdkjgnadskjnglkadsjng internal void PopulateOrderList() { Database.getDatabase().getOrderList().Clear(); SqlConnection conn = new SqlConnection("Server=EALDB1.EAL.LOCAL;Database=EJL41_DB; User ID = EJL41_USR; Password = Baz1nga41"); conn.Open(); SqlCommand command = new SqlCommand("SelectOrders", conn); command.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sqlR = command.ExecuteReader(); while (sqlR.Read()) { int orderid = Convert.ToInt32(sqlR["ordreID"]); DateTime orderDate = Convert.ToDateTime(sqlR["orderDate"]); DateTime startDate = Convert.ToDateTime(sqlR["startDate"]); DateTime deliveryDate = Convert.ToDateTime(sqlR["deliveryDate"]); string addresse = Convert.ToString(sqlR["addresse"]); domain.Order o = new domain.Order(orderid, orderDate, startDate, deliveryDate, addresse); Database.getDatabase().orderList.Add(o); } conn.Close(); conn.Dispose(); foreach (domain.Order item in orderList) { Console.WriteLine(item.ToString()); } }
public OrderViewModel(domain.Order order, domain.Recipient recipient, OrderService orderService) { this.order = order; this.order.PropertyChanged += new System.ComponentModel.PropertyChangedEventHandler(OnOrder_PropertyChanged); this.orderService = orderService; this.recipient = recipient; }