protected void Page_Load(object sender, EventArgs e)
{
if (Session["Role"].ToString() != "Admin")
{
Response.Redirect("../Anonymous/ErrorPage.aspx");
}
if (!Page.IsPostBack)
{
QuestionSource.SelectParameters["Crs_Id"].DefaultValue = ((Label)GridView5.Rows[0].Cells[0].FindControl("cou_idlbl")).Text;
QuestionSource.Select();
}
}
protected void InsertBtn_Click(object sender, EventArgs e)
{
QuestionSource.InsertParameters["Q_Body"].DefaultValue = QuestionTxt.Text;
QuestionSource.InsertParameters["Q_Type"].DefaultValue = TypeList.Text;
QuestionSource.InsertParameters["Q_Grade"].DefaultValue = GradeTxt.Text;
QuestionSource.InsertParameters["Q_Answer"].DefaultValue = CorrectTxt.Text;
QuestionSource.InsertParameters["Crs_Id"].DefaultValue = CourseList.SelectedValue;
QuestionSource.InsertParameters["Q_Choice1"].DefaultValue = ChoiceATxt.Text;
QuestionSource.InsertParameters["Q_Choice2"].DefaultValue = ChoiceBTxt.Text;
QuestionSource.InsertParameters["Q_Choice3"].DefaultValue = ChoiceCTxt.Text;
QuestionSource.InsertParameters["Q_Choice4"].DefaultValue = ChoiceDTxt.Text;
QuestionSource.Insert();
}
protected void GridView5_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
QuestionSource.SelectParameters["Crs_Id"].DefaultValue = ((Label)GridView5.Rows[e.NewSelectedIndex].Cells[0].FindControl("cou_idlbl")).Text;
QuestionSource.Select();
}
protected void QButton_Click(object sender, EventArgs e)
{
bool skipSearchUserByQuestion = true;
bool skipSearchUserByCategory = true;
bool skipSearchUserByLanguage = true;
SimilarQuestionsSource.SelectParameters.Clear();
SimilarQuestionsSource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv = (DataView)SimilarQuestionsSource.Select(new DataSourceSelectArguments());
if (dv.Table.Rows.Count != 0)
{
int userCount = dv.Table.Rows.Count;
for (int i = 0; i < userCount; i++)
{
QuestionSource.SelectParameters.Clear();
QuestionSource.SelectParameters.Add("SimilarUser", dv.Table.Rows[i]["Username"].ToString());
QuestionSource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv2 = (DataView)QuestionSource.Select(new DataSourceSelectArguments());
if (dv2.Table.Rows.Count != 0)
{
skipSearchUserByQuestion = false;
Response.Redirect("Challange.aspx?p=" + dv2.Table.Rows[0]["Question"].ToString());
break;
}
}
}
if (skipSearchUserByQuestion)
{
SimilarCategorySource.SelectParameters.Clear();
SimilarCategorySource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv3 = (DataView)SimilarCategorySource.Select(new DataSourceSelectArguments());
if (dv3.Table.Rows.Count != 0)
{
int userCount = dv3.Table.Rows.Count;
for (int i = 0; i < userCount; i++)
{
QuestionSource.SelectParameters.Clear();
QuestionSource.SelectParameters.Add("SimilarUser", dv3.Table.Rows[i]["Username"].ToString());
QuestionSource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv4 = (DataView)QuestionSource.Select(new DataSourceSelectArguments());
if (dv4.Table.Rows.Count != 0)
{
skipSearchUserByCategory = false;
Response.Redirect("Challange.aspx?p=" + dv4.Table.Rows[0]["Question"].ToString());
break;
}
}
}
if (skipSearchUserByCategory)
{
SimilarLanguageSource.SelectParameters.Clear();
SimilarLanguageSource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv5 = (DataView)SimilarLanguageSource.Select(new DataSourceSelectArguments());
if (dv5.Table.Rows.Count != 0)
{
int userCount = dv5.Table.Rows.Count;
for (int i = 0; i < userCount; i++)
{
QuestionSource.SelectParameters.Clear();
QuestionSource.SelectParameters.Add("SimilarUser", dv5.Table.Rows[i]["Username"].ToString());
QuestionSource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv6 = (DataView)QuestionSource.Select(new DataSourceSelectArguments());
if (dv6.Table.Rows.Count != 0)
{
skipSearchUserByLanguage = false;
Response.Redirect("Challange.aspx?p=" + dv6.Table.Rows[0]["Question"].ToString());
break;
}
}
}
if (skipSearchUserByLanguage)
{
UnsolvedQuestionSource.SelectParameters.Clear();
UnsolvedQuestionSource.SelectParameters.Add("Username", Membership.GetUser().UserName);
DataView dv7 = (DataView)UnsolvedQuestionSource.Select(new DataSourceSelectArguments());
if (dv7.Table.Rows.Count != 0)
{
Response.Redirect("Challange.aspx?p=" + dv7.Table.Rows[0]["Question"].ToString());
}
else
{
warn.InnerText = "Congratulations! Already you have solved all question.";
}
}
}
}
}
