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

namespace BillionRec
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        public static string connectorString = "server = localhost;Database=billion;User ID=root;Password=";

        static string loremIpsum(int vlenght)
        {
            var rand = new Random();
            string result = null;
            var words = new[] { "lorem", "ipsum", "dolor", "sit", "amet", "consectetuer", "adipiscing", "elit", "sed", "diam", "nonummy", "nibh", "euismod", "tincidunt", "ut", "laoreet", "dolore", "magna", "aliquam", "erat" };
            for (int i = 0; i < vlenght; i++)
            {
                result = string.Concat(result, words[rand.Next(words.Length)]);
                if (i < vlenght)
                {
                    result = string.Concat(result, " ");
                }
            }
            return result;

        }

        private void button1_Click(object sender, EventArgs e)
        {
            textBox1.Text = loremIpsum(Convert.ToInt32(maskedTextBox1.Text));
        }

        private void maskedTextBox1_TextChanged(object sender, EventArgs e)
        {
            if (System.Text.RegularExpressions.Regex.IsMatch(maskedTextBox1.Text, "[^0-9]"))
            {
                MessageBox.Show("Please enter only numbers.");
                maskedTextBox1.Text = maskedTextBox1.Text.Remove(maskedTextBox1.Text.Length - 1);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            MySqlConnection myConn = new MySqlConnection(connectorString);
            myConn.Open();
            for (int i = 0; i<1000000; i++)
            {
                textBox1.Text = loremIpsum(Convert.ToInt32(maskedTextBox1.Text));
                string query = $"INSERT INTO record(name) VALUES('{textBox1.Text}')";
                MySqlCommand myCommand = new MySqlCommand(query, myConn);
                myCommand.ExecuteNonQuery();
            }
            MessageBox.Show("Finish");
            myConn.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            MySqlConnection myConn = new MySqlConnection(connectorString);
            myConn.Open();
            string query = "truncate record;";
            MySqlCommand myCommand = new MySqlCommand(query, myConn);
            myCommand.ExecuteNonQuery();
            myConn.Close();
            MessageBox.Show("Finish");
            string query2 = "SELECT * FROM record";
            MySqlConnection MyConn = new MySqlConnection(connectorString);
            MySqlCommand MyComm = new MySqlCommand(query2, MyConn);
            MySqlDataAdapter MyAdap = new MySqlDataAdapter();
            MyAdap.SelectCommand = MyComm;
            DataTable dTable = new DataTable();
            MyAdap.Fill(dTable);
            dataGridView1.DataSource = dTable;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            string query = "SELECT * FROM record";
            MySqlConnection MyConn = new MySqlConnection(connectorString);
            MySqlCommand MyComm = new MySqlCommand(query, MyConn);
            MySqlDataAdapter MyAdap = new MySqlDataAdapter();
            MyAdap.SelectCommand = MyComm;
            DataTable dTable = new DataTable();
            MyAdap.Fill(dTable);
            dataGridView1.DataSource = dTable;
            MessageBox.Show("Finish");
        }
    }
}