public async Task <IActionResult> PutSQLquery([FromRoute] int id, [FromBody] SQLquery sQLquery) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != sQLquery.Query_ID) { return(BadRequest()); } _context.Entry(sQLquery).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SQLqueryExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostSQLquery([FromBody] SQLquery sQLquery) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.SQLquery.Add(sQLquery); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSQLquery", new { id = sQLquery.Query_ID }, sQLquery)); }