public static IdValueViewModel ToVm(this ReviewRatingType entity) { return(new IdValueViewModel() { Id = entity.ReviewRatingTypeId, Value = entity.EnglishText, }); }
public IHttpActionResult GetReviewRatingType(int id) { ReviewRatingType reviewRatingType = db.ReviewRatingTypes.Find(id); if (reviewRatingType == null) { return(NotFound()); } return(Ok(reviewRatingType)); }
public async Task <bool> UpdateAsync(ReviewRatingType reviewRatingType) { try { string sqlQuery = $@" IF EXISTS (SELECT 1 FROM REVIEW_RATING_TYPE WHERE REVIEW_RATING_TYPE_CD = @ID) UPDATE REVIEW_RATING_TYPE SET REVIEW_RATING_TYPE_CD = @REVIEW_RATING_TYPE_CD, REVIEW_RATING_TYPE_ETXT = @REVIEW_RATING_TYPE_ETXT WHERE REVIEW_RATING_TYPE_CD = @ID "; return(await DbExecuteAsync <bool>(sqlQuery, reviewRatingType)); } catch (Exception ex) { _logger.LogError(ex, "something bad"); throw; } }
public async Task <long> CreateAsync(ReviewRatingType reviewRatingType) { try { string sqlQuery = $@" INSERT INTO REVIEW_RATING_TYPE ( REVIEW_RATING_TYPE_CD, REVIEW_RATING_TYPE_ETXT) VALUES ( @REVIEW_RATING_TYPE_CD, @REVIEW_RATING_TYPE_ETXT) SELECT CAST(SCOPE_IDENTITY() as bigint) "; return(await DbQuerySingleAsync <long>(sqlQuery, reviewRatingType)); } catch (Exception ex) { _logger.LogError(ex, "something bad"); throw; } }