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