using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Turisticka_agencija_2
{
    public partial class Klijenti : Form
    {
        public Klijenti()
        {
            InitializeComponent();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if ((textBox1.Text == "") || (textBox1.Text == "1"))
            {
                OleDbConnection konekcija = new OleDbConnection();
                konekcija.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\Users\korisnik\Desktop\Turisticka agencija.accdb'";
                string komupit = "SELECT * FROM Klijent ORDER BY KlijentID";
                try
                {
                    konekcija.Open();
                    //MessageBox.Show("Uspesno kreirana konekcija");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Desila se greska");
                }
                DataSet ds = new DataSet();
                OleDbDataAdapter da = new OleDbDataAdapter(komupit, konekcija);
                da.Fill(ds);
                konekcija.Close();

                int br = ds.Tables[0].Rows.Count - 1;
                textBox1.Text = Convert.ToString(ds.Tables[0].Rows[br].ItemArray[0]);
                textBox2.Text = (string)ds.Tables[0].Rows[br].ItemArray[1];
                textBox3.Text = (string)ds.Tables[0].Rows[br].ItemArray[2];
                textBox4.Text = (string)ds.Tables[0].Rows[br].ItemArray[3];
                textBox5.Text = (string)ds.Tables[0].Rows[br].ItemArray[4];
            }
            else
            {
                OleDbConnection konekcija = new OleDbConnection();
                konekcija.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\Users\korisnik\Desktop\Turisticka agencija.accdb'";
                string komupit = "SELECT * FROM Klijent ORDER BY KlijentID";
                try
                {
                    konekcija.Open();
                    //MessageBox.Show("Uspesno kreirana konekcija");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Desila se greska");
                }
                DataSet ds = new DataSet();
                OleDbDataAdapter da = new OleDbDataAdapter(komupit, konekcija);
                da.Fill(ds);
                konekcija.Close();
                int br = Convert.ToInt32(textBox1.Text);
                textBox1.Text = Convert.ToString(ds.Tables[0].Rows[br - 2].ItemArray[0]);
                textBox2.Text = (string)ds.Tables[0].Rows[br - 2].ItemArray[1];
                textBox3.Text = (string)ds.Tables[0].Rows[br - 2].ItemArray[2];
                textBox4.Text = (string)ds.Tables[0].Rows[br - 2].ItemArray[3];
                textBox5.Text = (string)ds.Tables[0].Rows[br - 2].ItemArray[4];
            }
        }


        private void button1_Click(object sender, EventArgs e)
        {
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            textBox1.Focus();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            OleDbConnection konekcija = new OleDbConnection();
            konekcija.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='C:\Users\korisnik\Desktop\Turisticka agencija.accdb'";
            string komupit = "SELECT * FROM Klijent ORDER BY KlijentID";
            try
            {
                konekcija.Open();
                MessageBox.Show("Uspesno kreirana konekcija");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Desila se greska");
            }
            DataSet ds = new DataSet();
            OleDbDataAdapter da = new OleDbDataAdapter(komupit, konekcija);
            da.Fill(ds);
            konekcija.Close();
            if ((textBox1.Text == "") || (Convert.ToInt32(textBox1.Text) == ds.Tables[0].Rows.Count))
            {
                int br = ds.Tables[0].Rows.Count - 1;
                textBox1.Text = Convert.ToString(ds.Tables[0].Rows[br].ItemArray[0]);
                textBox2.Text = (string)ds.Tables[0].Rows[br].ItemArray[1];
                textBox3.Text = (string)ds.Tables[0].Rows[br].ItemArray[2];
                textBox4.Text = (string)ds.Tables[0].Rows[br].ItemArray[3];
                textBox5.Text = (string)ds.Tables[0].Rows[br].ItemArray[4];
            }
            else
            {
                int br = Convert.ToInt32(textBox1.Text);
                textBox1.Text = Convert.ToString(ds.Tables[0].Rows[br].ItemArray[0]);
                textBox2.Text = (string)ds.Tables[0].Rows[br].ItemArray[1];
                textBox3.Text = (string)ds.Tables[0].Rows[br].ItemArray[2];
                textBox4.Text = (string)ds.Tables[0].Rows[br].ItemArray[3];
                textBox5.Text = (string)ds.Tables[0].Rows[br].ItemArray[4];
            }
        }
    }
}