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