using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using MySql.Data.MySqlClient;
using MySql.Data;

namespace Internet_oglasi
{
    public partial class PretragaOglasa : System.Web.UI.Page
    {
        int id;
        ArrayList idovi = new ArrayList();
        MySqlConnection sqlKonekcija;
        public void pretragaOglasa() {
            //InitializeComponent();

       }
        protected void Page_Load(object sender, EventArgs e)
        {
            id = Convert.ToInt32(Request["id"]);
            string connStr = "server=etf.ba;user=ooadtim2;database=ooadtim2;port=3306;password=mema;";
            sqlKonekcija = new MySqlConnection(connStr);
            sqlKonekcija.Open();
        }
        protected void btnPretrazi_Click(object sender, EventArgs e)
        {
            if (txtPretraga.Text == " ")
            {
                Response.Redirect("Korisnicki_racun.aspx?id=" + Convert.ToString(id));
            }

            string qSviOglasi = "select id, naslov, tekst, istekao, oglasivacID from Oglas";
            MySqlCommand cmdSviOglasi = new MySqlCommand(qSviOglasi, sqlKonekcija);
            MySqlDataReader myReader = cmdSviOglasi.ExecuteReader();
            ArrayList oglasi = new ArrayList();
            ArrayList naslovi = new ArrayList();
            while (myReader.Read())
            {
                int oglasivacID = myReader.GetInt32("oglasivacID");
                bool istekao = myReader.GetBoolean("istekao");
                int oglasID = myReader.GetInt32("id");
                if (istekao == false && oglasivacID != id)
                {
                    idovi.Add(Convert.ToString(oglasID));
                    naslovi.Add(Convert.ToString(myReader.GetString("naslov")));
                    oglasi.Add(Convert.ToString(myReader.GetString("naslov")) + " " + Convert.ToString(myReader.GetString("tekst")));
                }

            }
            myReader.Close();
            int i;
            for (i = 0; i < oglasi.Count; i++)
            {
                string _oglas = Convert.ToString(oglasi[i]);
                _oglas = _oglas.ToLower();
                if (_oglas.Contains((txtPretraga.Text).ToLower()))
                {
                    string _naslov = Convert.ToString(naslovi[i]);
                    listPretraga.Items.Add(_naslov);
                }
            }
        }

        protected void btnPonisti_Click(object sender, EventArgs e)
        {
            Response.Redirect("Korisnicki_racun.aspx?id=" + Convert.ToString(id));
        }

        protected void btnPregledaj_Click(object sender, EventArgs e)
        {
            int oglasID = Convert.ToInt32(idovi[listPretraga.SelectedIndex]);
            Response.Redirect("detaljiOglasa.aspx?id=" + Convert.ToString(oglasID));
        }


    }




}