public static UserProfileQuestionsResults FetchUserProfileQuestions(Guid SessionId)
{
UserProfileQuestionsResults questionResults = new UserProfileQuestionsResults();
try
{
AgileMindEntities agileDB = new AgileMindEntities();
t_LoginSession session = (from loginSession in agileDB.t_LoginSession where loginSession.LoginSessionId == SessionId && loginSession.ValidTill > DateTime.Now select loginSession).First();
if (session != null)
{
questionResults.QuestionList = agileDB.FetchQuestionAnswer_ByLoginId(session.LoginId).ToList();
questionResults.Success = true;
}
else
{
questionResults.Error = "Could not find sessionId";
}
}
catch (Exception ex)
{
questionResults.Error = ex.Message;
}
return questionResults;
}
public static ProfileQuizQuestionRequest FetchRandomQuizQuestions(Guid SessionId, int QuestionCount)
{
ProfileQuizQuestionRequest request = new ProfileQuizQuestionRequest();
try
{
AgileMindEntities agileDB = new AgileMindEntities();
t_LoginSession session = (from loginSession in agileDB.t_LoginSession where loginSession.LoginSessionId == SessionId && loginSession.ValidTill > DateTime.Now select loginSession).First();
if (session != null)
{
List<vwQuestionAnswer> questionList = agileDB.FetchQuestionAnswer_ByLoginId(session.LoginId).ToList();
//Make sure we only get active and ones with an actual answer.
questionList = questionList.FindAll(delegate(vwQuestionAnswer findQA)
{
return findQA.Active && !string.IsNullOrEmpty(findQA.Answer);
});
Random rand = new Random();
for (int count = 0; count < QuestionCount; count++)
{
ProfileQuizQuestion newQA = new ProfileQuizQuestion();
int index = rand.Next(questionList.Count);
vwQuestionAnswer foundA = questionList[index];
newQA.Answer = foundA.Answer;
newQA.Question = foundA.Question;
request.QuestionList.Add(newQA);
}
request.Success = true;
}
else
{
request.Error = "Could not find sessionId";
}
}
catch (Exception ex)
{
request.Error = ex.Message;
}
return request;
}