public IHttpActionResult deleteone([FromUri] System.Int32 editionId
)
{
LitEditionView result = db.LitEditionDbSet
.Where(p => p.EditionId == editionId)
.Select(itm => new LitEditionView()
{
editionId = itm.EditionId,
editionName = itm.EditionName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
LitEdition entityToDelete = db.LitEditionDbSet
.Where(p => p.EditionId == result.editionId)
.FirstOrDefault();
if (entityToDelete == null)
{
return(Ok(result));
}
db.LitEditionDbSet.Remove(entityToDelete);
db.SaveChanges();
return(Ok(result));
}
public IHttpActionResult updateone([FromBody] LitEditionView viewToUpdate)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
LitEdition resultEntity = db.LitEditionDbSet
.Where(p => p.EditionId == viewToUpdate.editionId)
.FirstOrDefault();
if (resultEntity == null)
{
return(NotFound());
}
resultEntity.EditionName = viewToUpdate.editionName;
db.Entry(resultEntity).State = EntityState.Modified;
db.SaveChanges();
LitEditionView result = db.LitEditionDbSet
.Where(p => p.EditionId == viewToUpdate.editionId)
.Select(itm => new LitEditionView()
{
editionId = itm.EditionId,
editionName = itm.EditionName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public IHttpActionResult addone([FromBody] LitEditionView viewToAdd)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
LitEdition entityToAdd = new LitEdition();
entityToAdd.EditionId = viewToAdd.editionId;
entityToAdd.EditionName = viewToAdd.editionName;
db.LitEditionDbSet.Add(entityToAdd);
db.SaveChanges();
LitEditionView result = db.LitEditionDbSet
.Where(p => p.EditionId == entityToAdd.EditionId)
.Select(itm => new LitEditionView()
{
editionId = itm.EditionId,
editionName = itm.EditionName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public IHttpActionResult getone([FromUri] System.Int32 editionId
)
{
LitEditionView result = db.LitEditionDbSet
.Where(p => p.EditionId == editionId)
.Select(itm => new LitEditionView()
{
editionId = itm.EditionId,
editionName = itm.EditionName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
} // the end of public GetOne()-method
