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

// "SELECT * FROM userdata WHERE username=" + username + "password = " + password"

namespace ConsoleApplication4
{
    class Program
    {
        private static void retdb()
        {
            MySqlConnection getdb;
            string mysqlogin = "server=localhost;user=root;database=firstapp;port=3306;password=";
            try
            {
                getdb = new MySqlConnection(mysqlogin);
                getdb.Open();
            }
            catch (MySqlException)
            {
                MessageBox.Show("Unable to Connect! retrying...");
                retdb();
            }
        }
        private static void login()
        {
            Console.WriteLine("Username: ");
            string usernamefield = Console.ReadLine();
            MySqlConnection getdb;
            string mysqlogin = @"Data Source=USER;Initial Catalog=admin;Integrated Security=True";
            try
            {
                getdb = new MySqlConnection(mysqlogin);
                getdb.Open();
            }
            catch (MySqlException)
            {
                MessageBox.Show("Unable to Connect! retrying...");
                retdb();
            }
            SqlDataAdapter quser = new SqlDataAdapter("SELECT COUNT(*) FROM userdata WHERE username='" + usernamefield + "'" , mysqlogin);
            DataTable queryuser = new DataTable();
            quser.Fill(queryuser);
            if (queryuser.Rows[0][0].ToString() == "1")
            {
                Console.WriteLine("fuck it works!");
            }
            else
            {
                Console.WriteLine("fuck it works too!");
            }
        }
        static void Main(string[] args)
        {
            retdb();
            login();
        }
    }
}