public static int getFirstQuestion(int surveyID) { int linkID = 0, returnValue = 0; try { linkID = DBL.Tables.linkSurveysQuestions.SelectKeysWhere("surveyID=" + surveyID, "displayOrder", 1)[0]; } catch { linkID = 0; } DBL.Tables.linkSurveysQuestions Link = new DBL.Tables.linkSurveysQuestions(linkID); returnValue = Link.questionID; return(returnValue); }
public static int getPreviousQuestion(int surveyID, int currentQuestionID) { int returnValue = 0; int linkID = getLinkID(surveyID, currentQuestionID); DBL.Tables.linkSurveysQuestions Link = new DBL.Tables.linkSurveysQuestions(linkID); int DisplayOrder = Link.displayOrder; List <DBL.Tables.linkSurveysQuestions> sqs = DBL.Tables.linkSurveysQuestions.SelectWhere("surveyID = " + surveyID + " AND displayOrder < " + DisplayOrder, "DisplayOrder DESC", 1); try { returnValue = sqs[0].questionID; } catch { returnValue = 0; } return(returnValue); }