public async Task <PredictionHouseDB.Questions> AddQuestion(PredictionHouseDB.Questions newQuestion)
{
PredictionHouseDB.Questions addedQ = null;
try
{
addedQ = await _dbContext
.Questions
.SingleOrDefaultAsync(x => x.Question == newQuestion.Question && x.Year == newQuestion.Year);
if (addedQ == null)
{
var newQ = new PredictionHouseDB.Questions(newQuestion.Question, newQuestion.Year, newQuestion.Answer);
var addedResponse = await _dbContext.AddAsync(newQ);
await _dbContext.SaveChangesAsync();
addedQ = addedResponse.Entity;
}
}
catch (Exception ex)
{
Console.WriteLine("Error saving new question to DB: {0}", ex.Message);
addedQ = null;
}
return(addedQ);
}
public async Task <PredictionHouseDB.Responses> AddResponseAsync(PredictionHouseDB.Responses newResponse)
{
PredictionHouseDB.Responses addedResponse = null;
try
{
addedResponse = await _dbContext
.Responses
.SingleOrDefaultAsync(x => x.RespondentId == newResponse.RespondentId &&
x.QuestionId == newResponse.QuestionId);
if (addedResponse == null)
{
var newR = new PredictionHouseDB.Responses(newResponse.ResponseId, newResponse.QuestionId,
newResponse.RespondentId, newResponse.Response, newResponse.Correct);
var addedR = await _dbContext.AddAsync(newR);
await _dbContext.SaveChangesAsync();
addedResponse = addedR.Entity;
}
else
{
addedResponse = null;
}
}
catch (Exception ex)
{
Console.WriteLine("Error saving new response to DB: {0}", ex.Message);
addedResponse = null;
}
return(addedResponse);
}
