using UnityEngine;
using System.Collections;
using MySql.Data.MySqlClient;
using System;
using UnityEngine.UI;
using TMPro;
using UnityEngine.Networking;
public class DownloadIdeas : MonoBehaviour
{

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



    //PrefabInCategory
    public GameObject PrefabIdeaInCategories;
    public Transform[] CategoryParrents;
    //PrefabInCategory

    //PrefabInSearcher
    public TMP_Text PlaceHolder;
    public TMP_InputField InputSearch;
    public GameObject PrefabInSearcher;
    public Transform SearcherParrent;
    //PrefabInSearcher

    public String[] TableName;
    public Sprite[] CategorySprite;

    //generally
    public GameObject IdeaContent;
    public GameObject InternetAlert;
    //generally

    public GameObject demoalert;

    private void Start()
    {
        MainFunction();

    }

    public void Update()
    {
        if (Application.internetReachability == NetworkReachability.NotReachable)
        {
            InternetAlert.SetActive(true);
        }
        else
        {
            InternetAlert.SetActive(false);
        }
    }
    public void searcher()
    {

        for (int i = 0; i < SearcherParrent.childCount; i++)
        {
            if (SearcherParrent.GetChild(i).gameObject.transform.GetChild(0).GetComponent<TMP_Text>().text.ToLower().Contains(InputSearch.text.ToLower()))
            {
                SearcherParrent.GetChild(i).gameObject.SetActive(true);
            }
            else
            {
                SearcherParrent.GetChild(i).gameObject.SetActive(false);
            }
        }

    }





    public void MainFunction()
    {
        for (int i = 0; i < TableName.Length; i++)
        {
            Download(CategoryParrents[i], TableName[i], i, CategorySprite[i]);
        }
    }

    public void AddLike(string sign, int id, int TableNR)
    {
        if (polaczenie.State == System.Data.ConnectionState.Closed)
        {
            polaczenie.Open();
            polecenie = "update "+TableName[TableNR] +" set Likes ="+ sign + " where ID = '" + id + "' ";
            komenda = new MySqlCommand(polecenie, polaczenie);
            komenda.ExecuteNonQuery();

        }
        czytnik.Close();
        polaczenie.Close();
        polaczenie.Dispose();
    }
    public void AddComment(string Comment, int id, int TableNR)
    {
        if (polaczenie.State == System.Data.ConnectionState.Closed)
        {
            polaczenie.Open();
            polecenie = "update " + TableName[TableNR] + " set Comments = '" + Comment  + "' where ID = '" + id + "' ";
            komenda = new MySqlCommand(polecenie, polaczenie);
            komenda.ExecuteNonQuery();

        }
        czytnik.Close();
        polaczenie.Close();
        polaczenie.Dispose();
    }



    public void AddView(string sign, int id, int TableNR)
    {
        if (polaczenie.State == System.Data.ConnectionState.Closed)
        {
            polaczenie.Open();
            polecenie = "update " + TableName[TableNR] + " set Views =" + sign + " where ID = '" + id + "' ";
            komenda = new MySqlCommand(polecenie, polaczenie);
            komenda.ExecuteNonQuery();

        }
        czytnik.Close();
        polaczenie.Close();
        polaczenie.Dispose();
    }




    public void Download(Transform CategoryParrent, string table, int CategoryNumber, Sprite CategorySprite)
    {
        if (polaczenie.State == System.Data.ConnectionState.Closed)
        {
            polaczenie.Open();
            polecenie = "select * from " + table + " order by ID";
            komenda = new MySqlCommand(polecenie, polaczenie);
            komenda.ExecuteNonQuery();
            czytnik = komenda.ExecuteReader();
            int IdeaNumber = 0;
            while (czytnik.Read())
            {
                IdeaNumber++;

                //PrefabIdeaInCategories
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().ID = int.Parse(czytnik["ID"].ToString());     //ID
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().CategoryNumber = CategoryNumber;              //Category Number
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().TextNumber.text = IdeaNumber.ToString() + ".";
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().Title = czytnik["Title"].ToString();          //Title
                Array.Resize(ref PrefabIdeaInCategories.GetComponent<IdeaButtonName>().ContentPL, 9);
                Array.Resize(ref PrefabIdeaInCategories.GetComponent<IdeaButtonName>().ContentENG, 9);
                for (int i = 0; i <= 8; i++)
                {
                    PrefabIdeaInCategories.GetComponent<IdeaButtonName>().ContentPL[i] = czytnik["ContentPL" + (i + 1)].ToString();       //ContentPL
                    PrefabIdeaInCategories.GetComponent<IdeaButtonName>().ContentENG[i] = czytnik["ContentENG" + (i + 1)].ToString();   //ContentENG
                }
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().PictureUrl = czytnik["Picture"].ToString();                     //Picture
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().Link = czytnik["Link"].ToString();
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().Likes = czytnik["Likes"].ToString();
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().Comments = czytnik["Comments"].ToString();
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().views = czytnik["Views"].ToString();
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().CategorySprite = CategorySprite;
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().IdeaContent = IdeaContent;
                PrefabIdeaInCategories.GetComponent<IdeaButtonName>().DownloadIdeasScript = this.gameObject;
                Instantiate(PrefabIdeaInCategories, CategoryParrent);
                //PrefabIdeaInCategories


                //PrefabInSearcher
                PrefabInSearcher.GetComponent<IdeaButtonName>().ID = int.Parse(czytnik["ID"].ToString());     //ID
                PrefabInSearcher.GetComponent<IdeaButtonName>().CategoryNumber = CategoryNumber;              //Category Number

                PrefabInSearcher.GetComponent<IdeaButtonName>().Title = czytnik["Title"].ToString();          //Title
                Array.Resize(ref PrefabInSearcher.GetComponent<IdeaButtonName>().ContentPL, 9);
                Array.Resize(ref PrefabInSearcher.GetComponent<IdeaButtonName>().ContentENG, 9);
                for (int i = 0; i <= 8; i++)
                {
                    PrefabInSearcher.GetComponent<IdeaButtonName>().ContentPL[i] = czytnik["ContentPL" + (i + 1)].ToString();       //ContentPL
                    PrefabInSearcher.GetComponent<IdeaButtonName>().ContentENG[i] = czytnik["ContentENG" + (i + 1)].ToString();   //ContentENG
                }
                PrefabInSearcher.GetComponent<IdeaButtonName>().PictureUrl = czytnik["Picture"].ToString();
                PrefabInSearcher.GetComponent<IdeaButtonName>().Link = czytnik["Link"].ToString();
                PrefabInSearcher.GetComponent<IdeaButtonName>().Likes = czytnik["Likes"].ToString();
                PrefabInSearcher.GetComponent<IdeaButtonName>().Comments = czytnik["Comments"].ToString();
                PrefabInSearcher.GetComponent<IdeaButtonName>().views = czytnik["Views"].ToString();
                PrefabInSearcher.GetComponent<IdeaButtonName>().CategorySprite = CategorySprite;
                PrefabInSearcher.GetComponent<IdeaButtonName>().IdeaContent = IdeaContent;
                PrefabInSearcher.GetComponent<IdeaButtonName>().DownloadIdeasScript = this.gameObject;
                Instantiate(PrefabInSearcher, SearcherParrent);
                // PrefabInSearcher
            }
            czytnik.Close();
            polaczenie.Close();
            polaczenie.Dispose();
        }
        PlaceHolder.text = "Wyszukaj wśród (" + SearcherParrent.childCount + ") pomysłów";
    }
}