using MySql.Data.MySqlClient;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Forms;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using MessageBox = System.Windows.MessageBox;

namespace ReadDisk
{
    /// <summary>
    /// Interaction logic for suchergebnisSeriennummer.xaml
    /// </summary>
    public partial class sea : Window
    {
        private int selectet = suchen.selectet;
        private string seriennummer = suchen.seriennummer;
        private string gehäusetyp = suchen.gehäusetyp;
        ArrayList idArray = new ArrayList();
        List<User> items = new List<User>();


        public sea()
        {
            InitializeComponent();
            loadData();
        }

        private void ListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {

        }

        private void loadData()
        {
            if (selectet == 0)
            {
                MessageBox.Show("Nothing");
                this.Close();
            } else if (selectet == 1)
            {
                string constring = "datasource=localhost;port=3306;username=readdisk;password=guju1guju1";
                string Query = "SELECT * FROM smartcontrol.harddisks WHERE serialnumber ='" + seriennummer + "';";
                MySqlConnection conDataBase = new MySqlConnection(constring);
                MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
                MySqlDataReader myReader;
                try
                {
                    conDataBase.Open();
                    myReader = cmdDataBase.ExecuteReader();
                    while (myReader.Read())
                    {
                        string item = myReader.GetString(0);
                        string item1 = myReader.GetString(1);
                        string item2 = myReader.GetString(2);
                        string item3 = myReader.GetString(3);
                        string item4 = myReader.GetString(4);
                        string item5 = myReader.GetString(5);
                        string item6 = myReader.GetString(6);
                        string item7 = myReader.GetString(7);
                        items.Add(new User() { harddisk = item, caseid = item1, model = item2, device = item3, serialnumber = item4, firmwareversion = item5, user = item6, date = item7 });
                    }
                    listView1.ItemsSource = items;
                }
                catch (Exception ex)
                {
                    if (ex.Message == "Unable to connect to any of the specified MySQL hosts.")
                    {
                        MessageBox.Show("Es konnte keine Verbindung zum Server aufgebaut werden.");
                    }
                    else
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
            else if (selectet == 2)
            {
                string constring = "datasource=localhost;port=3306;username=readdisk;password=guju1guju1";
                string Query = "SELECT PK_case FROM smartcontrol.cases WHERE casename ='" + gehäusetyp + "';";
                MySqlConnection conDataBase = new MySqlConnection(constring);
                MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
                MySqlDataReader myReader;
                try
                {
                    conDataBase.Open();
                    myReader = cmdDataBase.ExecuteReader();
                    

                    while (myReader.Read())
                    {
                        string intCaseId = myReader.GetString(0);

                        idArray.Add(Convert.ToInt32(intCaseId));
                    }
                    conDataBase.Close();

                    foreach (int ids in idArray)
                    {
                        MessageBox.Show(Convert.ToString(ids));
                    }

                    foreach (int ids in idArray)
                    {
                        constring = "datasource=localhost;port=3306;username=readdisk;password=guju1guju1";
                        Query = "SELECT * FROM smartcontrol.harddisks WHERE FK_case ='" + ids + "';";
                        MessageBox.Show(Convert.ToString(ids) + "6");
                        conDataBase = new MySqlConnection(constring);
                        cmdDataBase = new MySqlCommand(Query, conDataBase);
                        //MySqlDataReader myReader;
                        try
                        {
                            conDataBase.Open();
                            myReader = cmdDataBase.ExecuteReader();

                            while (myReader.Read())
                            {
                                string item = myReader.GetString(0);
                                string item1 = myReader.GetString(1);
                                string item2 = myReader.GetString(2);
                                string item3 = myReader.GetString(3);
                                string item4 = myReader.GetString(4);
                                string item5 = myReader.GetString(5);
                                string item6 = myReader.GetString(6);
                                string item7 = myReader.GetString(7);
                                //array enthält nur den ersten und letzten wert..?
                                items.Add(new User() { harddisk = item, caseid = item1, model = item2, device = item3, serialnumber = item4, firmwareversion = item5, user = item6, date = item7 });
                            }
                            listView1.ItemsSource = items;
                        }
                        catch (Exception ex)
                        {
                            if (ex.Message == "Unable to connect to any of the specified MySQL hosts.")
                            {
                                MessageBox.Show("Es konnte keine Verbindung zum Server aufgebaut werden.");
                            }
                            else
                            {
                                MessageBox.Show(ex.Message);
                            }
                        }
                    }

                }
                catch (Exception ex)
                {
                    if (ex.Message == "Unable to connect to any of the specified MySQL hosts.")
                    {
                        MessageBox.Show("Es konnte keine Verbindung zum Server aufgebaut werden.");
                    }
                    else
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
            //hier gehts weiter..
            else
            {
                MessageBox.Show("Error 987");
            }
        }
    }

    public class User
    {
        public string harddisk { get; set; }

        public string caseid { get; set; }

        public string model { get; set; }

        public string device { get; set; }

        public string serialnumber { get; set; }

        public string firmwareversion { get; set; }

        public string user { get; set; }

        public string date { get; set; }
    }
}