Acceptonestop.aspx.cs

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;


public partial class Acceptonestop : System.Web.UI.Page
{
    static int roll;
    protected void Page_Load(object sender, EventArgs e)
    {
        Button7.Visible = false;
        TextBox1.Visible = false;
        Label1.Visible = false;
    }

    protected void Button6_Click(object sender, EventArgs e)
    {
        Response.Redirect("OnestopUI.aspx");
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source=DESKTOP-A1B8R5V\\SQLEXPRESS;Initial Catalog=project;Integrated Security=True");

        SqlCommand SqlCommand;
        SqlDataReader reader;

        SqlDataAdapter adapter = new SqlDataAdapter();
        con.Open();

        string query = "SELECT TOP(1) fname,lname,rollno,cnic,cgpa,processed FROM (DEGREE_ISSUANCE INNER JOIN STUDENT ON rollno=Roll_no) INNER JOIN PERMISSION ON Roll_no=roll WHERE Fypaccept LIKE 1 AND Financeaccept LIKE 1 AND processed LIKE 0";

        SqlCommand = new SqlCommand(query, con);
        adapter.SelectCommand = new SqlCommand(query, con);
        reader = SqlCommand.ExecuteReader();
        GridView1.DataSource = reader;
        GridView1.DataBind();
        
    }

    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }

    protected void Button7_Click(object sender, EventArgs e)
    {
        Button7.Visible = true;
        TextBox1.Visible = true;
        SqlConnection conn = new SqlConnection("Data Source=DESKTOP-A1B8R5V\\SQLEXPRESS;Initial Catalog=project;Integrated Security=True");
        string query = "update PERMISSION set processed=@accept, accept=@tim, status = 'Accepted! Degree to be Issued' where roll=@id";
        conn.Open();
        SqlCommand cm;
        cm = new SqlCommand(query, conn);
        DateTime timee = DateTime.Now;
        cm.Parameters.AddWithValue("@accept", TextBox1.Text);
        cm.Parameters.AddWithValue("@id", roll);
        cm.Parameters.AddWithValue("@tim", timee);
        cm.ExecuteNonQuery();


        conn.Close();
    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        roll = Convert.ToInt32(GridView1.SelectedRow.Cells[3].Text);
        TextBox1.Text = GridView1.SelectedRow.Cells[6].Text;
        Button7.Visible = true;
        TextBox1.Visible = true;
        Label1.Visible = true;
    }
}