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