public async Task <AdminDemographicQuery> UpdateDemographicQueryAsync(AdminDemographicQuery query) { using (var cn = new SqlConnection(opts.ConnectionString)) { await cn.OpenAsync(); var updated = await cn.QueryFirstOrDefaultAsync <AdminDemographicQuery>( Sql.Update, new { sql = query.SqlStatement, user = user.UUID }, commandType : CommandType.StoredProcedure, commandTimeout : opts.DefaultTimeout); return(updated); } }
public async Task <ActionResult <AdminDemographicQuery> > Get() { try { var query = await manager.GetDemographicQueryAsync(); if (query == null) { query = new AdminDemographicQuery(); } return(Ok(query)); } catch (Exception ex) { log.LogError("Failed to get DemographicsQuery. Error:{Error}", ex.ToString()); return(StatusCode(StatusCodes.Status500InternalServerError)); } }
public async Task <ActionResult <AdminDemographicQuery> > Update([FromBody] AdminDemographicQuery model) { try { var updated = await manager.UpdateDemographicQueryAsync(model); return(Ok(updated)); } catch (ArgumentException ae) { log.LogError("Invalid update DemographicsQuery model. Model:{@Model} Error:{Error}", model, ae.Message); return(BadRequest()); } catch (LeafRPCException le) { return(StatusCode(le.StatusCode)); } catch (Exception ex) { log.LogError("Failed to update DemographicsQuery. Model:{@Model} Error:{Error}", model, ex.ToString()); return(StatusCode(StatusCodes.Status500InternalServerError)); } }