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