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