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