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