// this method creates & returns a collection of question entries for a special form entry internal bool loadFormEntryQuestionEntries(cFormEntry formEntry) { SqlCommand cmd = new SqlCommand("SELECT ID, QuestionID, FormEntryID, AnswerText FROM questionEntries WHERE FormEntryID = @feid ORDER BY ID", cMain.getConnection()); cmd.Parameters.Add(new SqlParameter("feid", formEntry.ID)); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { cQuestionEntry qe = new cQuestionEntry(); qe.ID = reader.GetString(0); qe.QuestionID = reader.GetString(1); qe.FormEntryID = reader.GetString(2); qe.Text = reader.GetString(3); this.Add(qe); } return(true); } else { return(false); } }
// this method get's the question answers and creates the full form entry public bool addFormEntry(List <string> list) { System.Diagnostics.Debug.WriteLine(list[0]); if (fID.Length == 0) { return(false); } else { // create the form entry and assign form id (FK) then persist cFormEntry fe = new cFormEntry(); fe.FormID = fID; if (!fe.persist()) { return(false); } var j = 0; // now iterate the question answers foreach (var i in list) { // create the question entry and assign form entry id and question id cQuestionEntry qe = new cQuestionEntry(); qe.QuestionID = Questions[j].ID; qe.FormEntryID = fe.ID; qe.Text = i; if (!qe.persist()) { return(false); } j++; } return(true); } }
// this method get's the question answers and creates the full form entry public bool addFormEntry(List<string> list) { System.Diagnostics.Debug.WriteLine(list[0]); if (fID.Length == 0) return false; else { // create the form entry and assign form id (FK) then persist cFormEntry fe = new cFormEntry(); fe.FormID = fID; if (!fe.persist()) return false; var j = 0; // now iterate the question answers foreach (var i in list) { // create the question entry and assign form entry id and question id cQuestionEntry qe = new cQuestionEntry(); qe.QuestionID = Questions[j].ID; qe.FormEntryID = fe.ID; qe.Text = i; if (!qe.persist()) return false; j++; } return true; } }