public StackOverflowSearchVM GetRecentGuesses()
{
StackOverflowSearchVM result = new StackOverflowSearchVM();
try
{
using (CodingChallengeEntities data = new CodingChallengeEntities())
{
var guesses = data.GuessLogs.GroupBy(g => g.QuestionID).Select(grp => grp.FirstOrDefault()).ToList();
result.items = new List <StackOverflowResultVM>();
foreach (var guess in guesses)
{
result.items.Add(new StackOverflowResultVM()
{
question_id = guess.QuestionID,
title = guess.QuestionText,
creation_date = guess.QuestionDate
});
}
}
}catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(result);
}
public GuessResult SubmitGuess(int answerID, int questionID, string description, long questionDate)
{
GuessResult result = new GuessResult();
try
{
using (CodingChallengeEntities data = new CodingChallengeEntities())
{
var guessLog = data.GuessLogs.FirstOrDefault(g => g.AnswerID == answerID);
if (guessLog == null)
{
guessLog = new GuessLog()
{
QuestionID = questionID,
AnswerID = answerID,
QuestionText = description,
QuestionDate = questionDate,
GuessCount = 1
};
data.GuessLogs.Add(guessLog);
}
else
{
guessLog.GuessCount++;
data.Entry(guessLog).State = System.Data.Entity.EntityState.Modified;
}
data.SaveChanges();
var totalGuesses = data.GuessLogs.Where(g => g.QuestionID == questionID).Sum(g => g.GuessCount);
result.Answers = data.GuessLogs.Where(g => g.QuestionID == questionID)
.Select(g => new AnswerData()
{
AnswerID = g.AnswerID,
GuessCount = g.GuessCount,
GuessPercentage = ((decimal)g.GuessCount / totalGuesses)
}).ToList();
}
}catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(result);
}
