static void Main(string[] args)
{
UserController userController = new UserController(DBWorker.getMysqlConnection());
//get by ID
Console.WriteLine("Get by ID");
Console.WriteLine(userController.getUserById(2));
Console.WriteLine("============================");
////add users in List and show all
Console.WriteLine("Show All Users");
printListInfo(userController.GetAllUsers());
Console.WriteLine("============================");
//adding new user
Console.WriteLine("Adding New User");
userController.addUser(new User("Sveta", "babydoll", "sveta94", "Obolon", 26));
printListInfo(userController.GetAllUsers());
Console.WriteLine("============================");
//updating user
Console.WriteLine("Updating User");
userController.updateUser(new User(6, "Vika", "vikusya", "victory000", "Nyvky", 40));
printListInfo(userController.GetAllUsers());
Console.WriteLine("============================");
//deleting by id
Console.WriteLine("Deleting by ID");
userController.dellUserById(7);
printListInfo(userController.GetAllUsers());
Console.WriteLine("============================");
///////////////////////////////////////////////////////////////////////////////////
OrderController orderController = new OrderController(DBWorker.getMysqlConnection());
//get by ID
Console.WriteLine("Get by ID");
Console.WriteLine(orderController.getOrderById(2));
Console.WriteLine("============================");
//add orders in List and show all
Console.WriteLine("Show All Orders");
printListInfo(orderController.GetAllOrders());
Console.WriteLine("============================");
//adding new order
Console.WriteLine("Adding New Order");
orderController.addOrder(new Order(2, userController.getUserById(4)));
printListInfo(orderController.GetAllOrders());
Console.WriteLine("============================");
//updating order
Console.WriteLine("Updating Order");
orderController.updateOrder(new Order(3, 3, userController.getUserById(3)));
printListInfo(orderController.GetAllOrders());
Console.WriteLine("============================");
//deleting by id
Console.WriteLine("Deleting by ID");
orderController.dellOrderById(5);
printListInfo(orderController.GetAllOrders());
Console.WriteLine("============================");
//чтобы консоль не закрывалась
Console.ReadKey();
}