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 System.Data.SqlClient;
using MySql.Data.MySqlClient;

namespace Rust_Nights
{
    public partial class Form1 : Form
    {
        private MySqlConnection conn;
        private string server;
        private string database;
        private string uid;
        private string password;

        public Form1()
        {
            server = "sql174.main-hosting.eu";
            database = "u476341154_tehut";
            uid = "HIDDEN";
            password = "HIDDDEN";

            string connString;
            connString = string.Format("SERVER={0};DATABASE={1};UID={2};PASSWORD={3};", server, database, uid, password);


            conn = new MySqlConnection(connString);
            InitializeComponent();
        }

        private bool OpenConnection()
        {
            try
            {
                conn.Open();
                return true;
            }
            catch (MySqlException ex)
            {
                switch (ex.Number)
                {
                    case 0:
                        MessageBox.Show("Connection to server failed!");
                        break;
                    case 1045:
                        MessageBox.Show("Server username or password is incorrect!");
                        break;
                }
                return false;
            }

        }

        public bool IsLogin(string user, string pass)
        {
          //string query = "SELECT * FROM wp_users WHERE user_login='user' and user_pass= 'pass';";
          //string query = "SELECT * from wp_users WHERE user_login= '" + user + "' and user_pass = '" + pass + "'";
          string query = "SELECT * from wp_users WHERE user_login = @user and user_pass = @pass";


            try
            {
                if (OpenConnection())
                {
                    MySqlCommand cmd = new MySqlCommand(sql, conn);
                    MySqlDataReader reader = cmd.ExecuteReader();

                    if (reader.Read())
                    {
                        reader.Close();
                        conn.Close();
                        return true;
                    }
                    else
                    {
                        reader.Close();
                        conn.Close();
                        return false;
                    }
                }
                else
                {
                    conn.Close();
                    return false;
                }
            }
            catch (Exception ex)
            {
                conn.Close();
                return false;
            }
        }




        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void Login_Button_Click(object sender, EventArgs e)
        {
            string user = Username_Textbox.Text;
            string pass = Password_Textbox.Text;

            if (IsLogin(@user, @pass))
            {
                MessageBox.Show("Welcome @user!");
            }
            else
            {
                MessageBox.Show("{user} does not exist or password is incorrect!");

            }
        }
    }
}