public async Task<tbSurveyResult> CreateNewSurveyResult(dtoSurveyResult result)
{
tbSurveyResult newResult = new tbSurveyResult();
try
{
newResult.MinScore = result.MinScore;
newResult.MaxScore = result.MaxScore;
newResult.SurveyId = result.SurveyId;
newResult.Title = result.Title;
newResult.Description = result.Description;
newResult.CreatedDate = DateTime.UtcNow;
newResult.UpdatedDate = DateTime.UtcNow;
newResult.IsActive = true;
newResult.IsDeleted = false;
_db.tbSurveyResults.Add(newResult);
await _db.SaveChangesAsync();
}
catch (DataException dex)
{
throw new ApplicationException("Data error!", dex);
}
return newResult;
}
public async Task<tbSurveyResult> GetSurveyResultByResultId(int resultId)
{
tbSurveyResult result = new tbSurveyResult();
try
{
result = await _db.tbSurveyResults.FirstOrDefaultAsync(x => x.SurveyResultId == resultId
&& (x.IsActive ?? true) && !(x.IsDeleted ?? false));
}
catch (DataException dex)
{
throw new ApplicationException("Data error!", dex);
}
return result;
}
