public async Task <IActionResult> CreateDatabaseLog([FromBody] dbo.DatabaseLog value)
{
_db.dbo_DatabaseLog.Add(value);
await _db.SaveChangesAsync();
return(Ok(value));
}
public async Task <IActionResult> EditDatabaseLog(int databaseLogID, [FromBody] dbo.DatabaseLog value)
{
var existing = await _db.dbo_DatabaseLog.FirstOrDefaultAsync(x => x.DatabaseLogID == databaseLogID);
if (existing == null)
{
return(NotFound());
}
existing.DatabaseLogID = value.DatabaseLogID;
existing.PostTime = value.PostTime;
existing.DatabaseUser = value.DatabaseUser;
existing.Event = value.Event;
existing.Schema = value.Schema;
existing.Object = value.Object;
existing.TSQL = value.TSQL;
existing.XmlEvent = value.XmlEvent;
_db.dbo_DatabaseLog.Update(existing);
await _db.SaveChangesAsync();
return(NoContent());
}
