using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data;
using MySql.Data.Entity;
using MySql.Data.MySqlClient;
using System.Globalization;

namespace MYSQL {
    class Program {
        static void Main(string[] args) {
            string connectionString =
                "SERVER=LOCALHOST;DATABASE=secret_stash;USER=root;PASSWORD=secure";
            MySqlConnection conn = new MySqlConnection(connectionString);
            conn.Open();
            MySqlCommand test;
            MySqlDataReader reader;
            int id = 1;
            object gameName = "";
            object game = "";

            #region Hide
            List<string> FirstNames = new List<string>()
    {
        "Sergio",
        "Daniel",
        "Carolina",
        "David",
        "Reina",
        "Saul",
        "Bernard",
        "Danny",
        "Dimas",
        "Yuri",
        "Ivan",
        "Laura"
    };

            List<string> LastNamesA = new List<string>()
            {
        "Tapia",
        "Gutierrez",
        "Rueda",
        "Galviz",
        "Yuli",
        "Rivera",
        "Mamami",
        "Saucedo",
        "Dominguez",
        "Escobar",
        "Martin",
        "Crespo",
        "Johnson",
        "Williams",
        "Jones",
        "Brown",
        "David",
        "Miller",
        "Wilson",
        "Anderson",
        "Thomas",
        "Jackson",
        "White",
        "Robinson"
    };

            List<string> LastNamesB = new List<string>()
            {
        "Johnson",
        "Williams",
        "Jones",
        "Brown",
        "David",
        "Miller",
        "Wilson",
        "Anderson",
        "Thomas",
        "Jackson",
        "White",
        "Robinson"
    };

            var permutations = new List<Tuple<int, int, int>>();
            List<string> generatedNames = new List<string>();

            Random random = new Random();
            int a, b, c;

            //We want to generate 500 names.
            while (permutations.Count < 500) {
                a = random.Next(0, FirstNames.Count);
                b = random.Next(0, FirstNames.Count);
                c = random.Next(0, FirstNames.Count);

                Tuple<int, int, int> tuple = new Tuple<int, int, int>(a, b, c);

                if (!permutations.Contains(tuple)) {
                    permutations.Add(tuple);
                }
            }

            List<string> countries = new List<string>();
            countries.Add("Swedish");
            countries.Add("Danish");
            countries.Add("German");
            countries.Add("Bolivian");
            countries.Add("Armenian");
            countries.Add("Space");
            countries.Add("Finnish");
            countries.Add("Russian");
            countries.Add("USSR");
            countries.Add("African-American");

            List<string> jobs = new List<string>();
            jobs.Add("Sausage-Seller");
            jobs.Add("Programmer");
            jobs.Add("Filmmaker");
            jobs.Add("Bum");
            jobs.Add("Scientist");
            jobs.Add("Spaceman");
            jobs.Add("Failure");
            jobs.Add("Teacher");
            jobs.Add("Clown");
            jobs.Add("King");

            foreach (var tuple in permutations) {
                test = new MySqlCommand("INSERT INTO person (first_name, last_name, birthyear, occupation, nationality, salary) VALUES('" + FirstNames[tuple.Item1] + "', '" + LastNamesA[tuple.Item2] + "', " + random.Next(1,2016) + ", '" + jobs[random.Next(jobs.Count )] + "', '" + countries[random.Next(countries.Count)] + "', " + random.Next(500000) + ")",conn);
                reader = test.ExecuteReader();
                reader.Close();
                generatedNames.Add(string.Format("{0} {1} {2}", FirstNames[tuple.Item1],
                                                                LastNamesA[tuple.Item2],
                                                                LastNamesB[tuple.Item3])
                );
            }

            foreach (var n in generatedNames) {

            }
            #endregion



            //test = new MySqlCommand("create Table Games ( id int AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255));", conn);
            //test = new MySqlCommand("UPDATE `basketball_played` SET `team_2_score` = '1' WHERE `basketball_played`.`game_id` = 2;",conn);
            /*test = new MySqlCommand("select name from games where id = " + id, conn);
            reader = test.ExecuteReader();
            while (reader.Read()) { gameName = reader[0]; }
            reader.Close();

            test = new MySqlCommand("select corresponding_column from games where name = '" + gameName + "'",conn); ;
            reader = test.ExecuteReader();
            while (reader.Read()) { game = reader[0]; }
            reader.Close();

            test = new MySqlCommand("select team_1 from " + game + " where team_1_score = 2", conn);
            test = new MySqlCommand("ALTER TABLE Games ADD Played_Games int default '5'", conn);
            reader = test.ExecuteReader();
            while (reader.Read()) { game = reader[0]; }
            reader.Close();

            Console.WriteLine("The " + gameName + "team, " + game + ", played in a game and scored 2 points");*/

            conn.Close();
        }
    }
}