private void DatabindRatingQuestion(GridViewRowEventArgs e, AssessmentQuestion question)
{
RadioButtonList rbRatings = (RadioButtonList)e.Row.Cells[ColumnRatings].FindControl("rbRatings");
if (rbRatings == null)
return;
List<Rating> ratings = new List<Rating>();
for (int i = 0; i <= MaxRating; i++)
{
Rating obj = new Rating();
obj.Value = i;
ratings.Add(obj);
}
rbRatings.DataSource = ratings;
rbRatings.DataBind();
// select the answer
int currentRating = 0;
int.TryParse(question.AnswerValue, out currentRating);
rbRatings.SelectedIndex = currentRating;
TextBox txtAnswer = (TextBox)e.Row.Cells[ColumnTextAnswer].FindControl("txtAnswer");
if (txtAnswer != null)
txtAnswer.Visible = false;
HideRatingColumn = false;
return;
}
private void DatabindTextQuestion(GridViewRowEventArgs e, AssessmentQuestion question)
{
TextBox txtAnswer = (TextBox)e.Row.Cells[ColumnTextAnswer].FindControl("txtAnswer");
if (txtAnswer == null)
return;
txtAnswer.Text = question.AnswerValue;
RadioButtonList rb = (RadioButtonList)e.Row.Cells[ColumnRatings].FindControl("rbRatings");
if (rb != null)
rb.Visible = false;
}
public void LoadQuestions()
{
Questions = new List<AssessmentQuestion>();
using (SqlConnection conn = UtilityDb.GetConnectionESS())
{
string sql = "SELECT * FROM ASM_Questions WHERE GroupID=" +
Id + " ORDER BY DisplayOrder";
SqlDataReader dr = UtilityDb.GetDataReader(sql, conn);
while (dr.Read())
{
AssessmentQuestion question = new AssessmentQuestion();
question.LoadFromReader(dr);
question.Group = this;
Questions.Add(question);
}
}
}
