public bool ModifyQuestion(string qText, int qSetID, int qID) { QuestionSet qSet = SqlManager.FindQuestionSet(qSetID); if (qSet != null) { foreach (Question q in qSet.Questions) { if (q.QuestionID == qID) { q.QuestionText = qText; bool passed = SqlManager.ModifyQuestion(q, qSetID); qSet.Status = "UPDATED"; SqlManager.ModifyQuestionSet(qSet); return(passed); } } return(false); } else { return(false); } }
public string previewStener(int qID) { QuestionSet resultsByID = SqlManager.FindQuestionSet(qID); string resultStr = ""; resultStr += "Assigned Department : "; resultStr += " " + resultsByID.AssignedDepartment + "\r\n"; resultStr += "Category : "; resultStr += " " + resultsByID.Category + "\r\n"; resultStr += "Due Date : "; resultStr += " " + resultsByID.DueDate + "\r\n"; resultStr += "Priority : "; resultStr += " " + resultsByID.Priority + "\r\n"; resultStr += "Question Count: "; resultStr += " " + resultsByID.QuestionCount + "\r\n"; resultStr += "Submitted Date : "; resultStr += " " + resultsByID.SubmittedDate + "\r\n"; resultStr += "Unique ID : "; resultStr += " " + resultsByID.UniqueID + "\r\n"; resultStr += "Violated : "; resultStr += " " + resultsByID.Violated + "\r\n"; resultStr += "Status : "; resultStr += " " + resultsByID.Status + "\r\n"; foreach (Question question in resultsByID.Questions) { resultStr += "Question ID: "; resultStr += question.QuestionID + "\r\n"; resultStr += "Question: "; resultStr += question.QuestionText + "\r\n"; resultStr += "Answer: "; resultStr += question.Answer + "\r\n"; resultStr += "Evidence Location: "; resultStr += question.EvidenceLocation + "\r\n"; resultStr += "Compliance: "; resultStr += question.Compliance + "\r\n"; resultStr += "Plan For Solution: "; resultStr += question.PlanForSolution + "\r\n"; } return(resultStr); }
public bool AddQuestion(string qText, int qSetID) { var qSet = SqlManager.FindQuestionSet(qSetID); if (qSet != null) { var question = new Question(); question.QuestionText = qText; question.QuestionId = GetNextQuestionId(qSet); qSet.Questions.Add(question); qSet.Status = "UPDATED"; var passed = SqlManager.AddQuestion(qSet, question); SqlManager.ModifyQuestionSet(qSet); return(passed); } return(false); }
public QuestionSet GetQuestionSet(int id) { QuestionSet qSet = SqlManager.FindQuestionSet(id); return(qSet); }