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 PhoneBook
{
    public partial class PhoneBook : Form
    {
        SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename='C:\Users\Studentas\Documents\Martynas IST\PhoneBook\PhoneBook\PhoneBook.mdf';Integrated Security=True");

        public PhoneBook()
        {
            InitializeComponent();
        }

        private void button5_Click_1(object sender, EventArgs e)
        {
            for (int i = 0; i < 10; i++)
                MessageBox.Show("AHAHAHAHHAHA");
        }

        private void PhoneBook_Load(object sender, EventArgs e)
        {
            this.ActiveControl = textBox1;
            textBox1.Focus();
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void panel1_Paint(object sender, PaintEventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            textBox1.Clear();
            textBox2.Clear();
            textBox3.Clear();
            textBox4.Clear();
            comboBox1.SelectedIndex=-1;

        }

        private void button2_Click(object sender, EventArgs e)
        {

            con.Open();
            SqlCommand cmd = new SqlCommand(@"
                INSERT INTO PhoneBook
                (Vardas, Pavarde, Telefonas, Email, Kategorija)
                VALUES ('" + textBox1.Text + "','" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "', '" + comboBox1.Text + "')", con);
            cmd.ExecuteNonQuery();
            con.Close();

            MessageBox.Show("Įterpta");
            Display();
        }
           void Display()
        {
                SqlDataAdapter sda = new SqlDataAdapter ("Select * from PhoneBook", con);
                DataTable dt = new DataTable ();
                sda.Fill(dt);
    dataGridView1.Rows.Clear();
foreach (DataRow item in dt.Rows)
	{
		   int n = dataGridView1.Rows.Add();
            dataGridView1.Rows[n].Cells[0].Value = item[0].ToString();
            dataGridView1.Rows[n].Cells[1].Value = item[1].ToString();
            dataGridView1.Rows[n].Cells[2].Value = item[2].ToString();
            dataGridView1.Rows[n].Cells[3].Value = item[3].ToString();
            dataGridView1.Rows[n].Cells[4].Value = item[4].ToString();

	}
        }
           private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
           {
               textBox1.Text = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
               textBox2.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
               textBox3.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
               textBox4.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
               comboBox1.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();

           }

           private void button3_Click(object sender, EventArgs e)
           {
               con.Open();
               SqlCommand cmd = new SqlCommand(@"DELETE FROM PhoneBook
               WHERE (Telefonas = '" + textBox3.Text + "')", con);
               cmd.ExecuteNonQuery();
               con.Close();

               MessageBox.Show("Ištrinta");
               Display();

           }

           private void button4_Click(object sender, EventArgs e)
           {
               con.Open();
               SqlCommand cmd = new SqlCommand(@"UPDATE PhoneBook
                SET Vardas='" + textBox1.Text + "',Pavarde='" + textBox2.Text + "',Telefonas= '" + textBox3.Text + "',Email= '" + textBox4.Text + "', Kategorija='" + comboBox1.Text + "'WHERE (Telefonas='" + textBox3.Text + "')", con);
               cmd.ExecuteNonQuery();
               con.Close();

               MessageBox.Show("Atnaujinta");
               Display();

           }



           private void textBox1_TextChanged(object sender, EventArgs e)
           {

           }

           private void panel2_Paint(object sender, PaintEventArgs e)
           {

           }


    }
}