using System;
using System.Collections.Generic;
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.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Diagnostics;
using System.Collections;
using MySql.Data.MySqlClient;


namespace WpfApp1
{
    /// <summary>
    /// Logika interakcji dla klasy MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {


        static MySqlConnection polaczenie = new MySqlConnection("server=skydomesoftware.cba.pl; password=XXXXXX; user=FridgeCook; database=skydome_software;charset=utf8");
        static String ConnectionString = "server=skydomesoftware.cba.pl; password=XXXXXX; user=FridgeCook; database=skydome_software;charset=utf8";
        static MySqlCommand komenda;
        static MySqlDataReader czytnik;
        static string polecenie = "";




        public MainWindow()
        {
            InitializeComponent();


            CreateMenu();
            wypis();
        }

        public void CreateMenu()
        {
            string[] Categories = new string[13];
            Categories[0] = "Konwersacje";
            Categories[1] = "Słownictwo";
            Categories[2] = "Pisanie";
            Categories[3] = "Praca z tekstem";
            Categories[4] = "Słuchanie";
            Categories[5] = "Praca z filmem";
            Categories[6] = "Praca z ilustracją";
            Categories[7] = "Gramatyka";
            Categories[8] = "Gry";
            Categories[9] = "Technologie";
            Categories[10] = "Funkcje językowe";
            Categories[11] = "Gadżety";
            Categories[12] = "Lodołamacze";

            for (int i = 0; i < Categories.Length; i++)
            {
                System.Windows.Controls.Button CategoryButton = new Button();
                System.Windows.Controls.Image Image = new Image();

                CategoryButton.Content = Categories[i].ToString();
                CategoryButton.Background = Brushes.Black;
                CategoryButton.Foreground = Brushes.White;
                LeftMenuStackPanel.Children.Add(CategoryButton);
            }
        }




            public void wypis()
            {
            try
            {
                using (MySqlConnection polaczenie = new MySqlConnection(ConnectionString))
                {
                    polaczenie.Open();
                    polecenie = "select * from " + "CLPKonwersacje" + " where ID = 1 ";
                    komenda = new MySqlCommand(polecenie, polaczenie);
                    komenda.ExecuteNonQuery();
                    czytnik = komenda.ExecuteReader();

                    while (czytnik.Read())
                    {
                       // xyz.Text = czytnik["ContentPL1"].ToString();
                    }



                    czytnik.Close();
                    polaczenie.Close();
                }
            }
            catch (MySqlException ex)
            {
              //  xyz.Text = ex.ToString();

            }


            Debug.WriteLine("constructor fired");


        }



    }
}