public IHttpActionResult UpdateItem(int id, MyDBModel details) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (todoDBEntities1 db = new todoDBEntities1()) { db.Entry(details).State = System.Data.EntityState.Modified; try { db.SaveChanges(); } catch (Exception ec) { Console.WriteLine(ec.Message); } } return(Ok(details)); }
public IHttpActionResult DeleteItem(int id) { if (!ModelState.IsValid || id == null) { return(BadRequest(ModelState)); } using (todoDBEntities1 db = new todoDBEntities1()) { MyDBModel tmp = db.MyDBModels.Find(id); db.MyDBModels.Remove(tmp); try { db.SaveChanges(); } catch (Exception ec) { Console.WriteLine(ec.Message); } } return(Ok()); }
public IEnumerable <MyDBModel> GetAll() { List <MyDBModel> mytodoitems = new List <MyDBModel>(); using (todoDBEntities1 db = new todoDBEntities1()) { mytodoitems = db.MyDBModels.OrderBy(a => a.Key).ToList(); } return(mytodoitems); }
public IHttpActionResult Create([FromBody] MyDBModel item) { if (item == null) { return(BadRequest()); } using (todoDBEntities1 db = new todoDBEntities1()) { db.MyDBModels.Add(item); try { db.SaveChanges(); } catch (Exception ec) { Console.WriteLine(ec.Message); } } return(Ok(item)); }