static void AddAuthor(Author author)
{
using (LibraryDataEntities db = new LibraryDataEntities())
{
db.Author.Add(author);
db.SaveChanges();
Console.WriteLine("New author added: " + author.FirstName);
}
}
static Author GetAuthorByName(string firstName)
{
using (LibraryDataEntities db = new LibraryDataEntities())
{
var author = (from a in db.Author
where a.FirstName == firstName
select a).FirstOrDefault();
return(author);
}
}
static void GetAllBook()
{
using (LibraryDataEntities db = new LibraryDataEntities())
{
var books = db.Book.OrderBy(b => b.Title).ToList();
foreach (var book in books)
{
Console.WriteLine($"Book: {book.Title}, Price: {book.Price}, Author: {book.Author.LastName}, Publisher: {book.Publisher.PublisherName}");
}
}
}
static void AddBooks(Book book)
{
using (LibraryDataEntities db = new LibraryDataEntities())
{
Book bookCurr = db.Book.Where(b => b.Title == book.Title).FirstOrDefault();
if (bookCurr == null)
{
db.Book.Add(book);
db.SaveChanges();
Console.WriteLine("New book added: " + book.Title);
}
}
}
static void AddPublisher(Publisher publisher)
{
using (LibraryDataEntities db = new LibraryDataEntities())
{
Publisher publisherCurr = db.Publisher.Where(p => p.PublisherName == publisher.PublisherName).FirstOrDefault();
if (publisherCurr == null)
{
db.Publisher.Add(publisher);
db.SaveChanges();
Console.WriteLine("New publisher added: " + publisher.PublisherName);
}
}
}
static void GetAllAuthors()
{
using (LibraryDataEntities db = new LibraryDataEntities())
{
var authors = db.Author.Where(a => a.LastName.StartsWith("A")).ToList();
authors = (from author in db.Author
where author.LastName.StartsWith("A")
select author).ToList();
foreach (var author in authors)
{
Console.WriteLine(author.FirstName + " " + author.LastName);
}
}
}
