private void submitOrder_Click(object sender, EventArgs e)
        {
            Database.Orders newOrder = new Database.Orders();
            newOrder.client_id        = clientID;
            newOrder.route_id         = route;
            newOrder.width            = width;
            newOrder.height           = height;
            newOrder.start_date       = dateChoice.Value.Date;
            newOrder.load_description = description.Text;


            Database.Database_DAO.OrdersTable.new_order(newOrder);
        }
        static void orders()
        {
            //Database.Database_DAO.OrdersTable.Select(1);
            //Database.Database_DAO.OrdersTable.Select();

            Database.Orders order1 = new Database.Orders();
            order1.route_id         = 1;
            order1.client_id        = 1;
            order1.start_date       = Convert.ToDateTime("2016-05-25");
            order1.width            = 2;
            order1.height           = 2;
            order1.load_description = "Nice things";

            //Database.Database_DAO.OrdersTable.new_order(order1);

            order1.Truck_plate = "aaa1114";
            //order1.order_status = "executed";

            //Database.Database_DAO.OrdersTable.Update(order1, 17);
            //Database.Database_DAO.OrdersTable.Delete(1);
            //Database.Database_DAO.OrdersTable.Order_details(2);
        }