static User LogIn(UsersTableHandler handler)
        {
            string login;
            string password;

            while (true)
            {
                System.Console.Write("Enter your login: "******"Login can't be empty");
                    continue;
                }
                break;
            }

            while (true)
            {
                System.Console.Write("Enter your password: "******"Pasword can't be empty");
                    continue;
                }
                break;
            }


            User user = handler.SelectUserByLoginAndPassword(login, password);

            return(user);
        }
        public string CheckUserParameters()
        {
            if (RepeatedPassword != registratedUser.Password)
            {
                return(DifferentPasswordsMessage);
            }

            UsersTableHandler handler = new UsersTableHandler();
            var users = handler.SelectAllUsers();

            foreach (var user in users)
            {
                if (registratedUser.Password == user.Password && registratedUser.Login == user.Login)
                {
                    return(ThisUserAlreadyExistsMessage);
                }
            }

            if (registratedUser.Login == string.Empty || registratedUser.Password == string.Empty || registratedUser.Address == string.Empty || registratedUser.PhoneNumber == string.Empty)
            {
                return(EmptyFieldsMessage);
            }

            if (!registratedUser.PhoneNumber.Contains('+'))
            {
                return(IncorrectNumberMessage);
            }

            return(WellDoneMessage);
        }
        static void Main(string[] args)
        {
            UsersTableHandler handler = new UsersTableHandler();
            User currentUser          = new User();

            System.Console.WriteLine("Welcome to our app! To use it you must be logged in!");

            while (true)
            {
                System.Console.WriteLine("\n----------------------------------\n");
                System.Console.WriteLine("1 - Register\n2 - Log In\n3 - Exit");
                int answer = int.Parse(System.Console.ReadLine());

                switch (answer)
                {
                case 1: if (!Register())
                    {
                        continue;
                    }
                    break;

                case 2:
                    currentUser = LogIn(handler);
                    if (currentUser.Login == string.Empty || currentUser.Login == null)
                    {
                        System.Console.WriteLine("User with this data not found");
                        continue;
                    }
                    else
                    {
                        System.Console.WriteLine("You logged in");
                    }
                    break;

                case 3: Environment.Exit(1); break;

                default: System.Console.WriteLine("Incorrect answer"); continue;
                }
                break;
            }


            while (true)
            {
                System.Console.WriteLine("\n---------------------------------------\n");
                System.Console.WriteLine("What do we do?\n1 - Show menu\n2 - Make a purchase\n3 - Replenish a wallet\n4 - Exit");

                int answer = int.Parse(System.Console.ReadLine());

                switch (answer)
                {
                case 1:
                    SelectPizza(currentUser);
                    break;

                case 2:
                    if (currentUser.PurchaseProducts())
                    {
                        System.Console.WriteLine("You successfully purchased products! Wait a moment... We'll deliver them to " + currentUser.Address);
                        currentUser.Basket.Clear();
                    }
                    else
                    {
                        System.Console.WriteLine("You don't have enough money:( Try to replenish your wallet");
                    }
                    break;

                case 3:
                    System.Console.Write("Enter the sum: ");
                    double sum = double.Parse(System.Console.ReadLine());
                    if (sum > 0 && sum < 99999)
                    {
                        currentUser.Money += sum;
                        handler.UpdateMoney(currentUser, sum);
                        System.Console.WriteLine("Money were successfully added");
                    }
                    else
                    {
                        System.Console.WriteLine("You entered incorrect sum");
                    }
                    break;

                case 4: Environment.Exit(1); break;

                default:
                    System.Console.WriteLine("Incorrect answer"); break;
                }
            }
        }