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