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