public async Task <ActionResult> Delete([FromBody] RfidTagViewModel model) { if (string.IsNullOrWhiteSpace(model.Tag)) { return(BadRequest("Tag cannot be empty.")); } var rfid = await _context.Rfids.FirstOrDefaultAsync(r => r.Tag == model.Tag); if (rfid == null) { return(Ok()); } const string sql = "delete from RfidEvents where Rfid = @p0; delete from Rfids where id = @p0;"; var result = await _context.Database.ExecuteSqlCommandAsync(sql, rfid.Id); if (result > 0) { return(Ok()); } return(BadRequest("Again, something went wrong and I think you did it.")); }
public async Task <ActionResult> Post([FromBody] RfidTagViewModel model) { if (string.IsNullOrWhiteSpace(model.Tag)) { return(BadRequest("Tag cannot be empty.")); } var rfid = await _context.Rfids.FirstOrDefaultAsync(r => r.Tag == model.Tag); if (rfid != null) { return(Ok()); } _context.Rfids.Add(new Rfid { Tag = model.Tag }); if (0 < await _context.SaveChangesAsync()) { return(Ok()); } return(BadRequest("Couldn't create tag and I think it's something you did.")); }