protected void Button2_Click(object sender, EventArgs e)
{
db.CheckStatus();
SqlCommand cmd = new SqlCommand("select name from student where enrollid=@Name", db.sqcon);
cmd.Parameters.AddWithValue("@Name", TextBox2.Text);
dr = cmd.ExecuteReader();
if (dr.Read())
{
Label2.Text = "Issue report of " + dr[0].ToString();
}
else
{
Label2.Text = "Invalid ID";
}
repStuname();
res_stu.Style.Add("display", "block");
}
protected void Button1_Click(object sender, EventArgs e)
{
db.CheckStatus();
SqlCommand cmd = new SqlCommand("select name,dept,email,contact from student where enrollid=@Name", db.sqcon);
cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
dr = cmd.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr[0].ToString();
Label2.Text = dr[1].ToString();
Label3.Text = dr[2].ToString();
Label4.Text = dr[3].ToString();
}
else
{
Label1.Text = "Invalid ID/No such data existing in database";
}
string issue = "select bname from book where stuid='" + TextBox1.Text + "'";
dr = db.RetriveData(issue);
int i = 0;
while (dr.Read())
{
i++;
Label5.Text = dr[0].ToString();
}
Label5.Text = i + "";
//else
//{
// Label2.Text = "No book issued by this student";
//}
rmvstu.Style.Add("display", "block");
}
protected void unameTxt_TextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(unameTxt.Text))
{
db.CheckStatus();
SqlCommand cmd = new SqlCommand("select * from faculty where username=@Name", db.sqcon);
cmd.Parameters.AddWithValue("@Name", unameTxt.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
imgcheck.Visible = true;
lblcheck.Visible = true;
imgcheck.ImageUrl = "~/Images/taken.gif";
lblcheck.Text = "UserName Taken!!";
}
else
{
imgcheck.Visible = true;
lblcheck.Visible = true;
imgcheck.ImageUrl = "~/Images/available.gif";
lblcheck.Text = "Available";
}
}
}