public void CreateOrder()
        {
            var order = new Order();
            order.CustomerID = "VINET";
            order.EmployeeID = 5;
            order.OrderDate = DateTime.Now;
            order.ShipVia = 1;
            order.Freight = 10.05m;
            order.ShipName = "Toms Spezialitäten";
            order.ShipAddress = "Luisenstr. 48";
            order.ShipCity = "Münster";
            order.ShipPostalCode = "44087";
            order.ShipCountry = "Germany";

            var dal = new OrdersDAL();
            dal.CreateNewOrder(order);
        }