public IHttpActionResult addone([FromBody] aspnetmodelView viewToAdd) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } aspnetmodel entityToAdd = new aspnetmodel(); entityToAdd.ModelPk = viewToAdd.ModelPk; entityToAdd.ModelName = viewToAdd.ModelName; entityToAdd.ModelDescription = viewToAdd.ModelDescription; db.aspnetmodellDbSet.Add(entityToAdd); db.SaveChanges(); aspnetmodelView result = db.aspnetmodellDbSet .Where(p => p.ModelPk == entityToAdd.ModelPk) .Select(itm => new aspnetmodelView() { ModelPk = itm.ModelPk, ModelName = itm.ModelName, ModelDescription = itm.ModelDescription }).FirstOrDefault(); if (result == null) { return(NotFound()); } return(Ok(result)); }
public IHttpActionResult deleteone([FromUri] System.Int32 modelPk ) { aspnetmodelView result = db.aspnetmodellDbSet .Where(p => p.ModelPk == modelPk) .Select(itm => new aspnetmodelView() { ModelPk = itm.ModelPk, ModelName = itm.ModelName, ModelDescription = itm.ModelDescription }).FirstOrDefault(); if (result == null) { return(NotFound()); } aspnetmodel entityToDelete = db.aspnetmodellDbSet .Where(p => p.ModelPk == result.ModelPk) .FirstOrDefault(); if (entityToDelete == null) { return(Ok(result)); } db.aspnetmodellDbSet.Remove(entityToDelete); db.SaveChanges(); return(Ok(result)); }
public IHttpActionResult updateone([FromBody] aspnetmodelView viewToUpdate) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } aspnetmodel resultEntity = db.aspnetmodellDbSet .Where(p => p.ModelPk == viewToUpdate.ModelPk) .FirstOrDefault(); if (resultEntity == null) { return(NotFound()); } resultEntity.ModelName = viewToUpdate.ModelName; resultEntity.ModelDescription = viewToUpdate.ModelDescription; db.Entry(resultEntity).State = EntityState.Modified; db.SaveChanges(); aspnetmodelView result = db.aspnetmodellDbSet .Where(p => p.ModelPk == viewToUpdate.ModelPk) .Select(itm => new aspnetmodelView() { ModelPk = itm.ModelPk, ModelName = itm.ModelName, ModelDescription = itm.ModelDescription }).FirstOrDefault(); if (result == null) { return(NotFound()); } return(Ok(result)); }