using MySql.Data.MySqlClient;
using System;
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;
        int[] idArray;

        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())
                    {
                        ListUser items = new ListUser();

                        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);

                        array einthält außerhalb der while methode nur noch den letzten zugewiesenen wert..    WARUM!!!!!!!!!!!!!!!
                        idArray = new int[] { 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 + ';;
                        conDataBase = new MySqlConnection(constring);
                        cmdDataBase = new MySqlCommand(Query, conDataBase);
                        MySqlDataReader myReader;
                        try
                        {
                            conDataBase.Open();
                            myReader = cmdDataBase.ExecuteReader();
                            ListUser items = new ListUser();
                            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);
                            }
                        }
                    }

                }
                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; }
    }
}