/*Fetch the question and display in gridview*/
public void methodQuestion()
{
dt.Clear();
da = new SqlDataAdapter("Select Question,OptionA,OptionB,OptionC,OptionD from QuizApp_Questions where QId=" + i, conn);
da.Fill(dt);
GridViewQuestion.DataSource = dt;
GridViewQuestion.DataBind();
}
protected void Insert_Click(object sender, EventArgs e)
{
string questionname = tbQuestionName.Text;
questionname = questionname.Replace("'", "''");
string answer = tbAnswer.Text;
answer = answer.Replace("'", "''");
Util.ExecuteQuery("Insert Into QuestionList values('" + questionname + "', '" + answer + "', 1)");
GridViewQuestion.DataBind();
tbQuestionName.Text = "";
tbAnswer.Text = "";
}
protected void ButtonRangMoinsUn_Click(object sender, EventArgs e)
{
int indexRow = 0;
DataKeyArray dka = GridViewQuestion.DataKeys;
foreach (GridViewRow r in GridViewQuestion.Rows)
{
CheckBox cb = ( CheckBox )GridViewQuestion.Rows[indexRow].FindControl("CheckBoxRangPlusMoinsUn");
Guid questionGuid = new Guid(dka[indexRow].Value.ToString());
if (cb.Checked)
{
PollQuestion question = PollQuestion.GetQuestion(questionGuid);
question.Rank -= 1;
PollQuestion.UpdateRank(question);
}
indexRow += 1;
}
//Response.Redirect( Request.RawUrl ); surtout pas ici !!
HiddenFieldQuestionnaireID.Value = SessionState.Questionnaire.QuestionnaireID.ToString();
GridViewQuestion.DataBind();
BuildDataList();
}
public void ShowQuestions()
{
GridViewQuestion.DataSource = Question.GetQuestionRecords("CompanyId=" + Recruiter_Company.GetRecruiter_CompanyRecords("PersonId=" + int.Parse(this.Page.User.Identity.Name)).Rows[0]["CompanyId"]);
GridViewQuestion.DataBind();
}
