using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        List<string> keys = new List<string>();

        public Form1()
        {
            InitializeComponent();
        }

        string connectionString = "server=gfa1311.com; database=gfa1311_seriales_beta; user=gfa1311_totiimon; password=g3p56ootopbol1";
        MySqlCommand msc;

        private void btnGenerate_Click(object sender, EventArgs e)
        {
            lblGenerateStatus.Text = "Generating keys, please wait...";
            var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
            var stringChars = new char[16];
            var random = new Random();

            for (int x = keys.Count; x < 10;)
            {
                for (int i = 0; i < stringChars.Length; i++)
                {
                    stringChars[i] = chars[random.Next(chars.Length)];
                }

                var finalString = new String(stringChars);
                if (!keys.Contains(finalString))
                {
                    keys.Add(finalString);
                    x++;
                }
            }
            lblGenerateStatus.Text = "Generated successfully";
            btnGenerate.Enabled = false;
            btnInsert.Enabled = true;
        }

        private void btnInsert_Click(object sender, EventArgs e)
        {
            bool work = true;
            foreach (string key in keys)
            {
                try {
                    string query = "INSERT INTO  `gfa1311_seriales_beta`.`Seriales` (`Serial` ,`Estado` ,`Nombre` ,`Apellido` ,`Mail` ,`Pregunta_secreta` ,`Respuesta_secreta`)VALUES('"
                        + key + "', NULL, NULL, NULL, NULL, NULL, NULL); ";
                    MySqlConnection connection = new MySqlConnection(connectionString);
                    MySqlDataReader reader;
                    msc = new MySqlCommand(query, connection);
                    connection.Open();
                    reader = msc.ExecuteReader();
                    while (reader.Read())
                    {
                    }
                    connection.Close();
                }
                catch(Exception ex)
                {
                    work = false;
                }
            }
            if(work) lblInsertStatus.Text = "All keys inserted";
            else lblInsertStatus.Text = "ERROR INSERTING KEYS INTO THE DATABASE";

            btnInsert.Enabled = false;
        }
    }
}