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; }