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

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

        private void Form1_Load(object sender, EventArgs e)
        {
            txtPW.Text = Properties.Settings.Default.password;
            txtUser.Text = Properties.Settings.Default.username;
            txtServerDB.Text = Properties.Settings.Default.database;
            txtServerIP.Text = Properties.Settings.Default.serverip;
        }


        private void lBSpielerliste_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void btnConnect_Click(object sender, EventArgs e)
        {
            lBSpielerliste.Items.Clear();
            string ConnectionString = "SERVER=" + Properties.Settings.Default.serverip + ";" +
                                      "DATABASE=" + Properties.Settings.Default.database + ";" +
                                      "UID=" + Properties.Settings.Default.username + ";" +
                                      "PASSWORD=" + Properties.Settings.Default.password + ";";
            try
            {
                MySqlConnection connection = new MySqlConnection(ConnectionString);
                // Alles auslesen
                MySqlCommand selectname = connection.CreateCommand();
                selectname.CommandText = "SELECT name FROM chars;";
                /* // ID auslesen
                 MySqlCommand selectid = connection.CreateCommand();
                 selectid.CommandText = "SELECT id FROM chars;";
                 // SteamID auslesen
                 MySqlCommand selectsteamid = connection.CreateCommand();
                 selectsteamid.CommandText = "SELECT steam FROM chars;";
                 // Charnamen auslesen
                 MySqlCommand selectname = connection.CreateCommand();
                 selectname.CommandText = "SELECT name FROM chars;";
                 // Model auslesen
                 MySqlCommand selectmodel = connection.CreateCommand();
                 selectmodel.CommandText = "SELECT model FROM chars;";
                 // Skin auslesen
                 MySqlCommand selectskin = connection.CreateCommand();
                 selectskin.CommandText = "SELECT skin FROM chars;";
                 // Job auslesen
                 MySqlCommand selectjob = connection.CreateCommand();
                 selectjob.CommandText = "SELECT job FROM chars;";
                 // Points auslesen
                 MySqlCommand selectpoints = connection.CreateCommand();
                 selectpoints.CommandText = "SELECT points FROM chars;";
                 // Pskill auslesen
                 MySqlCommand selectpskill = connection.CreateCommand();
                 selectpskill.CommandText = "SELECT pskill FROM chars;";*/


                MySqlDataReader Readername;
                connection.Open();
                Readername = selectname.ExecuteReader();

                while (Readername.Read())
                {
                    string name = "";
                    for (int i = 0; i < Readername.FieldCount; i++)
                        name += Readername.GetValue(i).ToString() + " ";
                    lBSpielerliste.Items.Add(name);
                    lBSpielerliste.Sorted = true;
                }
                lblStatusco.Text = "Verbindung erfolgreich hergestellt!";
                lblStatusco.ForeColor = Color.Green;
                lblStatusco.Visible = true;
            }
            catch
            {
                lblStatusco.Text = "Verbindung konnte nicht hergestellt werden!";
                lblStatusco.ForeColor = Color.Red;
                lblStatusco.Visible = true;
            }
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            Properties.Settings.Default.username = txtUser.Text;
            Properties.Settings.Default.serverip = txtServerIP.Text;
            Properties.Settings.Default.database = txtServerDB.Text;
            Properties.Settings.Default.password = txtPW.Text;
            try
            {
                Properties.Settings.Default.Save();
                lblSpeichernstatus.Text = "Speichern erfolgreich!";
                lblSpeichernstatus.ForeColor = Color.Green;
                lblSpeichernstatus.Visible = true;
            }
            catch
            {
                lblSpeichernstatus.Text = "Speichern fehlgeschlagen!";
                lblSpeichernstatus.ForeColor = Color.Red;
                lblSpeichernstatus.Visible = true;
            }
        }
    }
}