public static Collection <QuestionOption> GetAll(Guid questionGuid)
{
Collection <QuestionOption> questionOptionList
= new Collection <QuestionOption>();
using (IDataReader reader = DBQuestionOption.GetAll(questionGuid))
{
while (reader.Read())
{
QuestionOption questionOption = new QuestionOption();
questionOption.questionOptionGuid = new Guid(reader["QuestionOptionGuid"].ToString());
questionOption.questionGuid = new Guid(reader["QuestionGuid"].ToString());
questionOption.answer = reader["Answer"].ToString();
questionOption.order = Convert.ToInt32(reader["Order"]);
questionOptionList.Add(questionOption);
}
}
return(questionOptionList);
}
private void SaveQuestionOptions(Question question)
{
QuestionOption option;
int order = 0;
// Save options
foreach (ListItem item in lbOptions.Items)
{
Guid optionGuid = Guid.Empty;
if (item.Value.Length == 36)
{
try
{
optionGuid = new Guid(item.Value);
}
catch (FormatException) { }
catch (OverflowException) { }
}
if (optionGuid == Guid.Empty)
{
option = new QuestionOption();
}
else
{
option = new QuestionOption(optionGuid);
}
//if (item.Text == item.Value)
//{
// option = new QuestionOption();
//}
//else
//{
// option = new QuestionOption(new Guid(item.Value));
//}
option.Answer = item.Text;
option.QuestionGuid = question.QuestionGuid;
option.Order = order++;
option.Save();
}
}
private void DeleteOldQuestionOptions()
{
//delete the options that have been saved in viewstate for full deletion on save
QuestionOption option;
List<Guid> deletedOptions;
deletedOptions = (List<Guid>)ViewState[Deleted_Options_Key] ?? new List<Guid>();
foreach (Guid deletedOptionGuid in deletedOptions)
{
option = new QuestionOption(deletedOptionGuid);
option.Delete();
}
}
public static Collection<QuestionOption> GetAll(Guid questionGuid)
{
Collection<QuestionOption> questionOptionList
= new Collection<QuestionOption>();
using (IDataReader reader = DBQuestionOption.GetAll(questionGuid))
{
while (reader.Read())
{
QuestionOption questionOption = new QuestionOption();
questionOption.questionOptionGuid = new Guid(reader["QuestionOptionGuid"].ToString());
questionOption.questionGuid = new Guid(reader["QuestionGuid"].ToString());
questionOption.answer = reader["Answer"].ToString();
questionOption.order = Convert.ToInt32(reader["Order"]);
questionOptionList.Add(questionOption);
}
}
return questionOptionList;
}
