protected void Page_Load(object sender, EventArgs e)
{
role = (string)Session["role"];
if (!this.IsPostBack)
{
role = "";
DropDownListID.DataSource = SqlDataSource1;
DropDownListID.DataBind();
DropDownListID.Items.Add(new ListItem("Select ID"));
DropDownListID.ClearSelection();
DropDownListID.Items.FindByValue("Select ID").Selected = true;
DropDownListClass.DataSource = SqlDataSource2;
DropDownListClass.DataBind();
DropDownListClass.Items.Add(new ListItem("Select Class"));
DropDownListClass.ClearSelection();
DropDownListClass.Items.FindByValue("Select Class").Selected = true;
DropDownListCourse.DataSource = SqlDataSource3;
DropDownListCourse.DataBind();
DropDownListCourse.Items.Add(new ListItem("Select Course"));
DropDownListCourse.ClearSelection();
DropDownListCourse.Items.FindByValue("Select Course").Selected = true;
}
if ((string)Session["user"] == "")
{
ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('Please log in first');window.location='LoginPage.aspx';", true);
}
user = "******" + (string)(Session["user"]);
}
protected void DropDownListID_SelectedIndexChanged(object sender, EventArgs e)
{
string id = DropDownListID.SelectedValue;
string role2;
if (id == "Select ID")
{
role = "";
DropDownListCourse.Visible = false;
course.Visible = false;
DropDownListClass.ClearSelection();
DropDownListClass.Items.FindByValue("Select Class").Selected = true;
DropDownListCourse.ClearSelection();
DropDownListCourse.Items.FindByValue("Select Course").Selected = true;
}
else
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
conn.Open();
string uname = "SELECT role FROM UserData WHERE id = '" + id + "'";
SqlCommand com = new SqlCommand(uname, conn);
role2 = com.ExecuteScalar().ToString().Trim();
role = role2;
Session["role"] = role2;
conn.Close();
if (role2 == "Teacher")
{
DropDownListCourse.Visible = true;
RequiredFieldValidator4.Enabled = true;
course.Visible = true;
}
else
{
DropDownListCourse.Visible = false;
RequiredFieldValidator4.Enabled = false;
course.Visible = false;
}
}
}