public static List <Entities.Editorial> GetEditorials()
{
using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext())
{
return(_context.Editorials.ToList());
}
}
public static List <Entities.AuthorsView> GetAuthors()
{
using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext())
{
return(_context.AuthorsView.ToList());
}
}
public static List <Entities.AuthorsByEditorialView> GetAuthorsByEditorial(int editorialId)
{
using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext())
{
return(_context.AuthorsByEditorialView
.Where(x => x.EditorialId == editorialId).ToList());
}
}
public static Entities.Editorial PostEditorial(Entities.Editorial editorial)
{
using (Data.LibraryEntitiesContext _context = new Data.LibraryEntitiesContext())
{
Entities.Editorial result = _context.Editorials.Add(editorial);
_context.SaveChanges();
return(result);
}
}
