public async Task <IHttpActionResult> Puttbl_Alerts(int id, tbl_Alerts tbl_Alerts) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_Alerts.col_AlertID) { return(BadRequest()); } db.Entry(tbl_Alerts).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tbl_AlertsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> Gettbl_Alerts(int id) { tbl_Alerts tbl_Alerts = await db.tbl_Alerts.FindAsync(id); if (tbl_Alerts == null) { return(NotFound()); } return(Ok(tbl_Alerts)); }
public async Task <IHttpActionResult> Posttbl_Alerts(tbl_Alerts tbl_Alerts) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_Alerts.Add(tbl_Alerts); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = tbl_Alerts.col_AlertID }, tbl_Alerts)); }
public async Task <IHttpActionResult> Deletetbl_Alerts(int id) { tbl_Alerts tbl_Alerts = await db.tbl_Alerts.FindAsync(id); if (tbl_Alerts == null) { return(NotFound()); } db.tbl_Alerts.Remove(tbl_Alerts); await db.SaveChangesAsync(); return(Ok(tbl_Alerts)); }