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));
}
