[LV7] Baze podataka

USING System;
USING System.Collections.Generic;
USING System.ComponentModel;
USING System.DATA;
USING System.Drawing;
USING System.Linq;
USING System.Text;
USING System.Threading.Tasks;
USING System.Windows.Forms;
USING System.DATA.SqlClient;

namespace Baze_LV7_predlozak
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnSve_Click(object sender, EventArgs e)
        {
            // OVDJE SLIJEDI ZADATAK IZ LV7 a):
            SqlConnection conn = NEW SqlConnection("Data Source=192.168.23.35;Initial Catalog=student;User ID=student;Password=student");
            conn.OPEN();
            string statement = "SELECT * FROM osobe ORDER BY prezime ASC";
            SqlDataAdapter dataAdapter = NEW SqlDataAdapter(statement, conn);
            DataTable dt = NEW DataTable();
            dataAdapter.Fill(dt);
            dgvPodaci.DataSource = dt;
            conn.Close();
        }

        private void btnSpremi_Click(object sender, EventArgs e)
        {
            // OVDJE SLIJEDI ZADATAK IZ LV7 b) (i BONUS zadatak):
            string ime = txtIme.Text, prezime = txtPrezime.Text, oib = txtOIB.Text, datum = txtDatum.VALUE.ToString("yyyy/MM/dd"), spol = "M";
            SqlConnection conn = NEW SqlConnection("Data Source=192.168.23.35;Initial Catalog=student;User ID=student;Password=student");
            conn.OPEN();
            string statement = "";
            IF (rbM.Checked) spol = "M";
            ELSE IF (rbZ.Checked) spol = "Z";
            IF (txtOIB.ReadOnly == FALSE)
            {
                IF (ime != "" && prezime != "" && oib != "" && datum != "")
                {
                    statement = "INSERT INTO osobe VALUES('" + oib + "', '" + ime + "', '" + prezime + "', '" + spol + "', '" + datum + "')";
                }
            }
            ELSE
            {
                statement = "UPDATE osobe SET ime='" + ime + "', prezime ='" + prezime + "', spol ='" + spol + "', datum_rodjenja='" + datum + "' WHERE OIB='" + oib + "'";
            }
            SqlCommand cmd = NEW SqlCommand(statement, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }

        public void obrisiSve()
        {
            txtOIB.Text = "";
            txtIme.Text = "";
            txtPrezime.Text = "";
            txtDatum.Text = "";
            dgvPodaci.ClearSelection();
            txtOIB.ReadOnly = FALSE;
        }

        private void btnObrisi_Click(object sender, EventArgs e)
        {
            obrisiSve();
        }

        private void dgvPodaci_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            //OVDJE JE DODATAK POTREBAN ZA BONUS ZADATAK
            txtOIB.Text = dgvPodaci.SelectedRows[0].Cells[0].VALUE.ToString();
            txtIme.Text = dgvPodaci.SelectedRows[0].Cells[1].VALUE.ToString();
            txtPrezime.Text = dgvPodaci.SelectedRows[0].Cells[2].VALUE.ToString();
            IF (dgvPodaci.SelectedRows[0].Cells[3].VALUE.ToString() == "M") rbM.Checked = TRUE;
            ELSE rbZ.Checked = TRUE;
            txtOIB.ReadOnly = TRUE;
            txtDatum.Text = dgvPodaci.SelectedRows[0].Cells[4].VALUE.ToString();
        }





    }
}