using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class admin_form : System.Web.UI.Page
{
    SqlConnection con;
    SqlCommand com;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["out"].ToString() == "false")
        {
            Response.Redirect("log_out.aspx");
        }
           
        else if (Session["u_type"].ToString() == "user")
        {
          Response.Redirect("log_out.aspx");
         
        }
        else
        {

            con = new SqlConnection(ConfigurationManager.ConnectionStrings["regis_dbConnectionString"].ConnectionString);
            if (Session["u_type"].ToString() == "admin")
            {
                btn_delete.Enabled = true;

            }
            else
                btn_delete.Enabled = false;
        }

    }
    protected void ddl_sem_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void link_btn_home_Click(object sender, EventArgs e)
    {
        if (Session["u_type"].ToString() == "admin")
        {
            Response.Redirect("admin_choice_form.aspx");
        }
        else
            Response.Redirect("admin_form.aspx");
            //Response.Redirect("log_in_form.aspx");

    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[2].Attributes.Add("onclick",
            ClientScript.GetPostBackEventReference(GridView1, "Select$" +
            e.Row.RowIndex.ToString()));
            //    e.Row.Attributes.Add("onclick",
            //ClientScript.GetPostBackEventReference(GridView1, "Select$" +
            //e.Row.RowIndex.ToString()));
            e.Row.Style.Add("cursor", "pointer");
        }
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string strSelectedID = GridView1.SelectedValue.ToString();
        Session["u_id"] = strSelectedID;
        Response.Redirect("registration_form.aspx");
    }
    protected void ddl_course_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddl_course.SelectedItem.Text == "B.TECH")
        {
            ddl_branch.Enabled =true;
            ddl_branch.Items.Clear();
            string str = "select branch from branch_master";
            con.Open();
            com = new SqlCommand(str, con);
            dr = com.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    ddl_branch.Items.Add(dr[0].ToString());

                }
            }
            com.Dispose();
            con.Close();
           // ddl_sem.Items.Clear();
           // for (int i = 1; i <= 6; i++)
           // {
           //     ddl_sem.Items.Add(i.ToString());
           // }
        }
        else if (ddl_course.SelectedItem.Text == "MBA")
        {
            ddl_branch.Enabled = false;
            //ddl_sem.Items.Clear();
            //for (int i = 1; i <= 4; i++)
            //{
            //    ddl_sem.Items.Add(i.ToString());
            //}

        }
        else 
        {
            ddl_branch.Items.Clear();
           // ddl_sem.Items.Clear();

        }
    }
    protected void btn_search_Click(object sender, EventArgs e)
    {
        string r_no="";
        string  str = "select * from registration_master where registration_no='" + txt_box_rollno.Text + "'";
        con.Open();
        com = new SqlCommand(str, con);
        dr = com.ExecuteReader();
        if (dr.HasRows)
        {
            while (dr.Read())
            {
                r_no = dr[0].ToString();
                



            }
            Session["u_id"] = r_no;
            Response.Redirect("registration_form.aspx");
        }
        com.Dispose();
        con.Close();
    }
    protected void btn_search_adv_Click(object sender, EventArgs e)
    {

    }
    protected void btn_delete_Click(object sender, EventArgs e)
    {
        //int usrid;
        string  usrid;
        foreach (GridViewRow gvrow in GridView1.Rows)
        {
            //Finiding checkbox control in gridview for particular row
            CheckBox chkdelete = (CheckBox)gvrow.FindControl("CheckBox1");
            //Condition to check checkbox selected or not
            if (chkdelete.Checked)
            {
                //Getting UserId of particular row using datakey value
                 //usrid = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Value);
                 usrid = GridView1.DataKeys[gvrow.RowIndex].Value.ToString();
                SqlDataSource1.DeleteParameters["registration_no"].DefaultValue = usrid.ToString();
                SqlDataSource1.Delete();
                DeleteRecordByID(usrid);

            }
           

        }

        

    }
    private void DeleteRecordByID(string  usrid)
    {

        con.Open();
        string str = "delete from contact_info where roll_number='" + usrid.ToString() + "'";
        com = new SqlCommand(str, con);
        com.ExecuteNonQuery();
        com.Dispose();
        con.Close();
        con.Open();
        str = "delete from image_master where image_name='" + usrid.ToString() + "'";
        com = new SqlCommand(str, con);
        com.ExecuteNonQuery();
        com.Dispose();
        con.Close();
        con.Open();
        str = "delete from log_master where log_id='" + usrid.ToString() + "'";
        com = new SqlCommand(str, con);
        com.ExecuteNonQuery();
        com.Dispose();
        con.Close();
        con.Open();
        str = "delete from course_master where roll_number='" + usrid.ToString() + "'";
        com = new SqlCommand(str, con);
        com.ExecuteNonQuery();
        com.Dispose();
        con.Close();
        con.Open();
        str = "delete from cop_master where roll_number='" + usrid.ToString() + "'";
        com = new SqlCommand(str, con);
        com.ExecuteNonQuery();
        com.Dispose();
        con.Close();
    }
    protected void link_btn_logout_Click(object sender, EventArgs e)
    {
        string session_check = "false";
        Session["out"] = session_check;
        Response.Redirect("log_out.aspx");
        //Response.Redirect("log_in_form.aspx");
    }
    protected void link_btn_change_password_Click(object sender, EventArgs e)
    {
        Response.Redirect("Change_pass_form.aspx");
    }
}