/// <summary>
        /// simulate live data by creating a new order
        /// </summary>
        private void CreateNewOrder()
        {
            using (var db = new DataContext())
            {
                Random r = new Random();

                Order o = new Order();
                o.OrderDate = DateTime.Now;
                o.Product = db.Products.OrderBy(x => x.Id).Skip(r.Next(0, 3)).FirstOrDefault();
                o.Customer = db.Customers.FirstOrDefault();

                db.Orders.Add(o);
                db.SaveChanges();
            }
        }