using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;


public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["Localhost"].ConnectionString;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ucitajNovosti();
        }
    }

    private void ucitajNovosti()
    {
        //string novostId = null;
        //string datum = null;
        //string slika = null;
        //string naslov = null;
        //string sazetak = null;
        //
        ArrayList news_arr = new ArrayList();
        //
        //OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//premfs16/sites/premium16/tstefan/database/news.mdb");
        OleDbConnection aConnection = new OleDbConnection(connStr);
        OleDbCommand aCommand = new OleDbCommand("SELECT TOP 3 * FROM HA_UcitajNovosti", aConnection);
        aConnection.Open();
        OleDbDataReader aReader = aCommand.ExecuteReader();

        while (aReader.Read())
        {
            news_arr.Add(new NewsData(
                aReader["NovostId"].ToString(),
                aReader["Datum"].ToString(),
                aReader["Slika"].ToString(),
                aReader["Naslov"].ToString(),
                aReader["Sazetak"].ToString()
                ));
            //
            //novostId += aReader["NovostId"].ToString() + "*";
            //datum += aReader["Datum"].ToString() + "*";
            //slika += aReader["Slika"].ToString() + "*";
            //naslov += aReader["Naslov"].ToString() + "*";
            //sazetak += aReader["Sazetak"].ToString() + "*";
            //tekst += aReader["Tekst"].ToString() + "*";
            //
        }
        //
        //Response.Write("&novostId=" + naslov);
        //Response.Write("&datum=" + datum);
        //Response.Write("&slika=" + sadrzaj);
        //Response.Write("&naslov=" + slike);
        //Response.Write("&sazetak=" + slike);
        //Response.Write("&tekst=" + slike);
        //
        aConnection.Close();
        Repeater1.DataSource = news_arr;
        Repeater1.DataBind();
        //
    }

    public class NewsData
    {
        private string novostId;
        private string datum;
        private string slika;
        private string naslov;
        private string sazetak;


        public NewsData(string novostId, string datum, string slika, string naslov, string sazetak)
        {
            this.novostId = novostId;
            this.datum = formatDatum(datum);
            this.slika = slika;
            this.naslov = naslov;
            this.sazetak = sazetak;
        }

        private string formatDatum(string datum)
        {
            string datumFormat = null;
            //
            datumFormat = datum.Remove(datum.Length - 8, 8);
            //
            return datumFormat;
        }

        public string NovostId
        {
            get
            {
                return novostId;
            }
        }

        public string Datum
        {
            get
            {
                return datum;
            }
        }

        public string Slika
        {
            get
            {
                return slika;
            }
        }

        public string Naslov
        {
            get
            {
                return naslov;
            }
        }

        public string Sazetak
        {
            get
            {
                return sazetak;
            }
        }
        
    }

    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {

    }

    protected void Repeater2_ItemCommand(object source, RepeaterCommandEventArgs e)
    {

    }
}