public DTOGroupMovie Delete(string userId, int id) { DTOGroupMovie exists = GetById(id); _repo.Delete(id, userId); return(exists); }
public DTOGroupMovie GetById(int id) { DTOGroupMovie exists = _repo.GetById(id); if (exists == null) { throw new Exception("Invalid Group Movie"); } return(exists); }
public bool voteMovieGroup(DTOGroupMovie moviegroupToVote) { string sql = @" UPDATE moviegroup SET votes = @Votes WHERE id = @Id"; int affectedRows = _db.Execute(sql, moviegroupToVote); return(affectedRows == 1); }
internal DTOGroupMovie Create(DTOGroupMovie newGroupMovie) { string sql = @" INSERT INTO groupmovies (groupId, movieId, userId, votes) VALUES (@GroupId, @MovieId, @UserId, @Votes); SELECT LAST_INSERT_ID();"; newGroupMovie.Id = _db.ExecuteScalar <int>(sql, newGroupMovie); return(newGroupMovie); }
public ActionResult <DTOGroupMovie> Post([FromBody] DTOGroupMovie newDTOGroupMovie) { try { newDTOGroupMovie.UserId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; return(Ok(_gms.Create(newDTOGroupMovie))); } catch (Exception e) { return(BadRequest(e.Message)); } }
public ActionResult <DTOGroupMovie> Edit(int id, [FromBody] DTOGroupMovie editDTOGroupMovie) { try { string userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; editDTOGroupMovie.Id = id; return(Ok(_gms.Edit(editDTOGroupMovie))); } catch (Exception e) { return(BadRequest(e.Message)); } }
public DTOGroupMovie Edit(DTOGroupMovie editDTOGroupMovie) { DTOGroupMovie foundGroupMovie = GetById(editDTOGroupMovie.Id); if (foundGroupMovie.Votes < editDTOGroupMovie.Votes) { if (_repo.voteMovieGroup(editDTOGroupMovie)) { foundGroupMovie.Votes = editDTOGroupMovie.Votes; } throw new Exception("You can't view that GroupMovie"); } return(foundGroupMovie); }
internal bool Edit(DTOGroupMovie editGroupMovie, string userId) { string sql = @" UPDATE groupmovie SET groupId = @GroupId, movieId = @MovieId, userId = @UserId, votes = @Votes, WHERE id = @Id "; int affectedRows = _db.Execute(sql, editGroupMovie); return(affectedRows == 1); }
public DTOGroupMovie Create(DTOGroupMovie newDTOGroupMovie) { return(_repo.Create(newDTOGroupMovie)); }