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;

namespace WebApplication1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        SqlConnection con;
        SqlCommand cmd1,cmd2,cmd3,cmd4,cmd5;
        SqlDataReader dr;
        protected void Page_Load(object sender, EventArgs e)
        {
           con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=F:\SEM-4\WEB\LABWORKS\LABWORK15\WebApplication1\App_Data\Database1.mdf;Initial Catalog=Tables;Integrated Security=True;");
           con.Open();
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            cmd1 = new SqlCommand("SELECT * FROM [UserTable] WHERE UserName =@UserName",con);
            cmd1.Parameters.AddWithValue("@UserName", TextBox1.Text);

            cmd2 = new SqlCommand("INSERT INTO [UserTable] VALUES(@UserName,@Password,@DateOfBirth,@EMail,@Gender,@ContactNo)", con);
            dr = cmd1.ExecuteReader();
            if(dr.HasRows)
            {
                Response.Write("User Already Exist");
            }
            else
            {
                dr.Close();
                cmd1.Dispose();
                cmd2.Parameters.AddWithValue("@UserName",TextBox1.Text);
                cmd2.Parameters.AddWithValue("@Password", TextBox2.Text);
                cmd2.Parameters.AddWithValue("@DateOfBirth", TextBox3.Text);
                cmd2.Parameters.AddWithValue("@EMail", TextBox4.Text);
                cmd2.Parameters.AddWithValue("@ContactNo", TextBox5.Text);

                String gen;
                if (RadioButton1.Checked)
                {
                    gen = "Male";
                }
                else
                {
                    gen = "Female";
                }
                Label7.Text = gen;
                cmd2.Parameters.AddWithValue("@Gender", gen);
                cmd2.ExecuteNonQuery();
                Response.Write("User Registered Successfully");

                TextBox1.Text = " ";
                TextBox2.Text = " ";
                TextBox3.Text = " ";
                TextBox4.Text = " ";
                TextBox5.Text = " ";
                con.Close();
                cmd2.Dispose();
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            String gen;
            if (RadioButton1.Checked)
            {
                gen = "Male";
            }
            else
            {
                gen = "Female";
            }
            Label7.Text = gen;
            cmd3 = new SqlCommand("UPDATE [UserTable] SET Password=@Password,DateOfBirth=@DateOfBirth,EMail=@EMail,Gender=@Gender,ContactNo=@ContactNo WHERE UserName=@UserName",con);
            cmd3.Parameters.AddWithValue("@Password", TextBox2.Text);
            cmd3.Parameters.AddWithValue("@DateOfBirth", TextBox3.Text);
            cmd3.Parameters.AddWithValue("@EMail", TextBox4.Text);
            cmd3.Parameters.AddWithValue("@ContactNo", TextBox5.Text);
            cmd3.Parameters.AddWithValue("@UserName", TextBox1.Text);
            cmd3.Parameters.AddWithValue("@Gender", gen);
            cmd3.ExecuteNonQuery();
            Response.Write("Record Updated");
            TextBox1.Text = " ";
            TextBox2.Text = " ";
            TextBox3.Text = " ";
            TextBox4.Text = " ";
            TextBox5.Text = " ";
            con.Close();
            cmd3.Dispose();
        }
        protected void Button3_Click(object sender, EventArgs e)
        {
            cmd4 = new SqlCommand("SELECT * FROM [UserTable] WHERE UserName =@UserName", con);
            cmd4.Parameters.AddWithValue("@UserName", TextBox1.Text);
            cmd5 = new SqlCommand("DELETE FROM [UserTable] WHERE UserName =@UserName", con);
            cmd5.Parameters.AddWithValue("@UserName", TextBox1.Text);
            dr = cmd4.ExecuteReader();
            if(dr.HasRows)
            {
                dr.Close();
                cmd4.Dispose();
                cmd5.ExecuteNonQuery();
                Response.Write("User Deleted Successfully");
            }
            else
            {
                Response.Write("User does not exist");
            }
            TextBox1.Text = " ";
            TextBox2.Text = " ";
            TextBox3.Text = " ";
            TextBox4.Text = " ";
            TextBox5.Text = " ";
            con.Close();
            cmd5.Dispose();
        }

    }
}