public static void CreateUser()
        {
            try
            {
                DatabaseAccess.DBConnectionOpen();

                Console.WriteLine("Enter a Name and LastName");
                string name     = Console.ReadLine();
                string lastname = Console.ReadLine();

                Console.WriteLine("Enter Age and Telephone");
                int    age       = int.Parse(Console.ReadLine());
                string telephone = Console.ReadLine();

                Console.WriteLine("Enter an Email");
                string email = Console.ReadLine();

                Console.WriteLine("Enter a UserName and Password");
                string username = Console.ReadLine();
                string password = Console.ReadLine();

                Console.WriteLine("Enter the Users Role");
                int role = int.Parse(Console.ReadLine());

                DatabaseAccess.DBInsertUser(name, lastname, age, telephone, email, username, password, role);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                DatabaseAccess.DBConnectionClose();
                DatabaseAccess.DBConnectionDispose();
            }
        }