public ActionResult <Sync> Post([FromBody] Sync sync) { sync.SourceServer = null; sync.TargetServer = null; sync.Query = null; if (sync.Id == 0) { dataContext.Syncs.Add(sync); } else { dataContext.Syncs.Update(sync); } try { dataContext.SaveChanges(); return(Ok()); } catch (DbUpdateConcurrencyException) { return(Conflict(UserMessages.Conflict(nameof(sync)))); } catch (SqlException) { // TODO: handle errors in generic error handlers: // example code // https://www.devtrends.co.uk/blog/handling-errors-in-asp.net-core-web-api throw; } }
public ActionResult Delete([FromBody] Server server) { if (server.Id == 0) { return(NotFound()); } try { //Op deze manier wordt ook de rowversion meegecheck dataContext.Servers.Attach(server); dataContext.Servers.Remove(server); dataContext.SaveChanges(); return(Ok()); } catch (DbUpdateConcurrencyException) { return(Conflict(UserMessages.Conflict(nameof(server)))); } }
public ActionResult <Server> Post([FromBody] Server server) { if (server.Id == 0) { dataContext.Servers.Add(server); } else { dataContext.Servers.Update(server); } try { dataContext.SaveChanges(); return(Ok()); } catch (DbUpdateConcurrencyException) { return(Conflict(UserMessages.Conflict(nameof(server)))); } }
public ActionResult <Query> Post([FromBody] Query query) { if (query.Id == 0) { dataContext.Queries.Add(query); } else { dataContext.Queries.Update(query); } try { dataContext.SaveChanges(); return(Ok()); } catch (DbUpdateConcurrencyException) { return(Conflict(UserMessages.Conflict(nameof(query)))); } }