public async Task AddRequestedPartyMember(string username, int partyMemberId)
{
PartyUpRequest requestedPartyMember = new PartyUpRequest
{
Username = username,
PartyMemberId = partyMemberId
};
await ApiBotRequest.PostExecuteAsync(_twitchBotApiLink + $"partyuprequests/create", requestedPartyMember);
}
public async Task <IActionResult> GetUserRequest([FromRoute] int partyMemberId, [FromQuery] string username)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
PartyUpRequest partyUpRequests = await _context.PartyUpRequest.SingleOrDefaultAsync(m => m.PartyMemberId == partyMemberId && m.Username == username);
if (partyUpRequests == null)
{
return(NotFound());
}
return(Ok(partyUpRequests));
}
public async Task <IActionResult> Create([FromBody] PartyUpRequest partyUpRequest)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (PartyUpRequestExists(partyUpRequest.Username, partyUpRequest.PartyMemberId))
{
return(BadRequest());
}
_context.PartyUpRequest.Add(partyUpRequest);
await _context.SaveChangesAsync();
return(NoContent());
}
public async Task <IActionResult> DeleteFirst([FromRoute] int broadcasterId, [FromQuery] int gameId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
PartyUpRequestResult result = new PartyUpRequestResult();
await _context.LoadStoredProc("dbo.GetPartyUpRequestList")
.WithSqlParam("GameId", gameId)
.WithSqlParam("BroadcasterId", broadcasterId)
.ExecuteStoredProcAsync((handler) =>
{
result = handler.ReadToList <PartyUpRequestResult>().FirstOrDefault();
});
if (result == null)
{
return(NotFound());
}
PartyUpRequest requestToBeDeleted = new PartyUpRequest
{
Id = result.PartyRequestId,
PartyMemberId = result.PartyMemberId,
Username = result.Username,
TimeRequested = result.TimeRequested
};
if (requestToBeDeleted == null)
{
return(NotFound());
}
_context.PartyUpRequest.Remove(requestToBeDeleted);
await _context.SaveChangesAsync();
return(Ok(result));
}
