public async Task <IActionResult> GetList([FromRoute] int broadcasterId, [FromQuery] int gameId)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
List <PartyUpRequestResult> results = new List <PartyUpRequestResult>();
await _context.LoadStoredProc("dbo.GetPartyUpRequestList")
.WithSqlParam("GameId", gameId)
.WithSqlParam("BroadcasterId", broadcasterId)
.ExecuteStoredProcAsync((handler) =>
{
results = handler.ReadToList <PartyUpRequestResult>().ToList();
});
return(Ok(results));
}
public async Task <IActionResult> CreateDefault([FromBody] List <Rank> rank)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
List <Rank> results = new List <Rank>();
await _context.LoadStoredProc("dbo.CreateDefaultRanks")
.WithSqlParam("BroadcasterId", rank.First().BroadcasterId)
.ExecuteStoredProcAsync((handler) =>
{
results = handler.ReadToList <Rank>().ToList();
});
return(Ok(results));
}
public async Task <IActionResult> UpdateCreateAccount([FromRoute] int broadcasterId, [FromQuery] int deposit, [FromQuery] bool showOutput, [FromBody] List <string> usernames)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
List <BalanceResult> results = new List <BalanceResult>();
await _context.LoadStoredProc("dbo.UpdateCreateBalance")
.WithSqlParam("tvpUsernames", usernames.ToDataTable())
.WithSqlParam("intDeposit", deposit)
.WithSqlParam("intBroadcasterID", broadcasterId)
.WithSqlParam("bitShowOutput", showOutput)
.ExecuteStoredProcAsync((handler) =>
{
results = handler.ReadToList <BalanceResult>().ToList();
});
return(Ok(results));
}