/// <summary> /// Creating activityreview table row as review is created /// </summary> /// <param name="ID">activity id</param> public async Task CreateActivityReviews(int ID) { int LastReviews = await _context.Reviews.OrderByDescending(x => x.Id).Select(x => x.Id).FirstAsync(); ActivitiesReviews activitiesReviews = new ActivitiesReviews() { ActivitiesID = ID, ReviewsID = LastReviews }; _context.ActivitiesReviews.Add(activitiesReviews); await _context.SaveChangesAsync(); }
public async Task <ActionResult <ActivitiesReviews> > PostActivitiesReviews(ActivitiesReviews activitiesReviews) { _context.ActivitiesReviews.Add(activitiesReviews); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (ActivitiesReviewsExists(activitiesReviews.ReviewsID)) { return(Conflict()); } else { throw; } } return(CreatedAtAction("GetActivitiesReviews", new { id = activitiesReviews.ReviewsID }, activitiesReviews)); }