public async Task <IActionResult> CreateProductReview([FromBody] Production.ProductReview value)
        {
            _db.Production_ProductReview.Add(value);
            await _db.SaveChangesAsync();

            return(Ok(value));
        }
        public async Task <IActionResult> EditProductReview(int productReviewID, [FromBody] Production.ProductReview value)
        {
            var existing = await _db.Production_ProductReview.FirstOrDefaultAsync(x => x.ProductReviewID == productReviewID);

            if (existing == null)
            {
                return(NotFound());
            }

            existing.ProductReviewID = value.ProductReviewID;
            existing.ProductID       = value.ProductID;
            existing.ReviewerName    = value.ReviewerName;
            existing.ReviewDate      = value.ReviewDate;
            existing.EmailAddress    = value.EmailAddress;
            existing.Rating          = value.Rating;
            existing.Comments        = value.Comments;
            existing.ModifiedDate    = value.ModifiedDate;

            _db.Production_ProductReview.Update(existing);
            await _db.SaveChangesAsync();

            return(NoContent());
        }