public async Task<tbSurveyQuestionItem> CreateNewItem(dtoSurveyQuestionItem item) { tbSurveyQuestionItem newItem = new tbSurveyQuestionItem(); try { var itemCount = _db.tbSurveyQuestionItems.Where(x => x.QuestionId == item.QuestionId && (x.IsActive ?? true) && !(x.IsDeleted ?? false)).Count(); newItem.QuestionId = item.QuestionId; newItem.ItemDescription = item.ItemDescription; newItem.ItemOrder = item.ItemOrder != 0 ? item.ItemOrder : itemCount + 1; newItem.Score = item.Score; newItem.CreatedDate = DateTime.UtcNow; newItem.UpdatedDate = DateTime.UtcNow; newItem.IsActive = true; newItem.IsDeleted = false; _db.tbSurveyQuestionItems.Add(newItem); await _db.SaveChangesAsync(); } catch (DataException dex) { throw new ApplicationException("Data error!", dex); } return newItem; }
public async Task<tbSurveyQuestionItem> GetQuestionItemByItemId(int itemId) { tbSurveyQuestionItem item = new tbSurveyQuestionItem(); try { item = await _db.tbSurveyQuestionItems.FirstOrDefaultAsync(x => x.QuestionItemId == itemId && (x.IsActive ?? true) && !(x.IsDeleted ?? false)); } catch (DataException dex) { throw new ApplicationException("Data error!", dex); } return item; }