public async Task <IActionResult> PutResult([FromRoute] int id, [FromBody] Result result)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != result.ResultId)
{
return(BadRequest());
}
using (var context = new testmsdaContext(_dbOptions))
{
context.Entry(result).State = EntityState.Modified;
try
{
await context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ResultExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(NoContent());
}
public IEnumerable <Result> GetResult()
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.Result.ToList());
}
}
private bool UserExists(int id)
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.User.Any(e => e.UserId == id));
}
}
private bool ResultExists(int id)
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.Result.Any(e => e.ResultId == id));
}
}
public IEnumerable <User> GetUser()
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.User.ToList());
}
}
public IEnumerable <App> GetApp()
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.App.ToList());
}
}
public IEnumerable <Device> GetDevice()
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.Device.ToList());
}
}
private bool DeviceExists(int id)
{
using (var context = new testmsdaContext(_dbOptions))
{
return(context.Device.Any(e => e.DeviceId == id));
}
}
public async Task <IActionResult> PostResult([FromBody] Result result)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var context = new testmsdaContext(_dbOptions))
{
context.Result.Add(result);
await context.SaveChangesAsync();
return(CreatedAtAction("GetResult", new { id = result.ResultId }, result));
}
}
public async Task <IActionResult> PostUser([FromBody] User user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var context = new testmsdaContext(_dbOptions))
{
context.User.Add(user);
await context.SaveChangesAsync();
return(CreatedAtAction("GetUser", new { id = user.UserId }, user));
}
}
public async Task <IActionResult> PostApp([FromBody] App app)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var context = new testmsdaContext(_dbOptions))
{
context.App.Add(app);
await context.SaveChangesAsync();
return(CreatedAtAction("GetApp", new { id = app.AppId }, app));
}
}
public async Task <IActionResult> PostDevice([FromBody] Device device)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var context = new testmsdaContext(_dbOptions))
{
context.Device.Add(device);
await context.SaveChangesAsync();
return(CreatedAtAction("GetDevice", new { id = device.DeviceId }, device));
}
}
public async Task <IActionResult> GetResult([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var context = new testmsdaContext(_dbOptions))
{
var result = await context.Result.FindAsync(id);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
}
public async Task <IActionResult> DeleteUser([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var context = new testmsdaContext(_dbOptions))
{
var user = await context.User.FindAsync(id);
if (user == null)
{
return(NotFound());
}
context.User.Remove(user);
await context.SaveChangesAsync();
return(Ok(user));
}
}
private bool AppExists(int id, testmsdaContext context)
{
return(context.App.Any(e => e.AppId == id));
}
