protected void ddlHub_SelectedIndexChanged(object sender, EventArgs e)
{
if (IsPostBack)
{
try
{
if (ddlHub.Text == "All" && ddlQuiz.Text == "All")
{
gvResult.DataSource = qc.GetResults();
gvResult.DataBind();
}
else if (ddlHub.Text != "All" && ddlQuiz.Text == "All")
{
gvResult.DataSource = qc.GetResultsByHub(ddlHub.Text);
gvResult.DataBind();
}
else if (ddlHub.Text == "All" && ddlQuiz.Text != "All")
{
gvResult.DataSource = qc.GetResultsByQuiz(ddlQuiz.Text);
gvResult.DataBind();
}
else
{
gvResult.DataSource = qc.GetResultsByHubQuiz(ddlQuiz.Text, ddlHub.Text);
gvResult.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex);
lblNoResult.Visible = true;
lblNoResult.Text = "Error loading results. Please refresh the page.";
}
if (gvResult.Rows.Count <= 0)
{
lblNoResult.Visible = true;
lblNoResult.Text = "No results available.";
btnExcel.Enabled = false;
btnExcel.BackColor = System.Drawing.Color.Gray;
}
else
{
lblNoResult.Visible = false;
btnExcel.Enabled = true;
btnExcel.BackColor = System.Drawing.ColorTranslator.FromHtml("#5bc0de");
}
}
}
