using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Configuration;

namespace WebApplication5
{
    public partial class _default : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["kutya"].ConnectionString);

        protected void Page_Load(object sender, EventArgs e)
        {

            kiiras();

        }

        public void kiiras()
        {
            SqlCommand select = new SqlCommand("SELECT * FROM Kutya", con);
            SqlDataReader dr;
            try
            {
                con.Open();
                dr = select.ExecuteReader();
                GridView1.DataSource = dr;
                GridView1.DataBind();
                dr.Close();
            }
            catch (Exception x)
            {

                Label1.Text = x.ToString();
            }
            finally {
                con.Close();
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            SqlCommand add = new SqlCommand("INSERT INTO Kutya values(@nev,@nem,@szin,@tulajemail)", con);
            add.Parameters.AddWithValue("@nev", TextBox2.Text);
            add.Parameters.AddWithValue("@nem", DropDownList1.SelectedItem.Text);
            add.Parameters.AddWithValue("@szin", TextBox3.Text);
            add.Parameters.AddWithValue("@tulajemail", TextBox4.Text);
            try
            {
                con.Open();
                if (add.ExecuteNonQuery() < 0)
                {
                    Label1.Text = "Nem mukszik";
                }
            }
            catch (Exception x)
            {

                Label1.Text = x.ToString();
            }
            finally
            {
                con.Close();
                kiiras();

            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            SqlCommand delete = new SqlCommand("DELETE FROM Kutya where @id = id", con);
            delete.Parameters.AddWithValue("@id", TextBox1.Text);
            delete.Parameters.AddWithValue("@nev", TextBox2.Text);
            delete.Parameters.AddWithValue("@nem", DropDownList1.SelectedItem.Text);
            delete.Parameters.AddWithValue("@szin", TextBox3.Text);
            delete.Parameters.AddWithValue("@tulajemail", TextBox4.Text);
            try
            {
                con.Open();
                if (delete.ExecuteNonQuery() < 0)
                {
                    Label1.Text = "Nem mukszik";
                }
            }
            catch (Exception x)
            {

                Label1.Text = x.ToString();
            }
            finally
            {
                con.Close();
                kiiras();

            }
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            SqlCommand insert = new SqlCommand("UPDATE Kutya set nev = @nev,nem = @nem,szin = @szin,tulajemajl = @tulajemail where id = @id", con);
            insert.Parameters.AddWithValue("@id", TextBox1.Text);
            insert.Parameters.AddWithValue("@nev", TextBox2.Text);
            insert.Parameters.AddWithValue("@nem", DropDownList1.SelectedItem.Text);
            insert.Parameters.AddWithValue("@szin", TextBox3.Text);
            insert.Parameters.AddWithValue("@tulajemail", TextBox4.Text);
            try
            {
                con.Open();
                if (insert.ExecuteNonQuery() < 0)
                {
                    Label1.Text = "Nem mukszik";
                }
            }
            catch (Exception x)
            {

                Label1.Text = x.ToString();
            }
            finally
            {
                con.Close();
                kiiras();

            }
        }
    }
}