public bool InsertLending(LendingModel lending) { try { var dbLending = new Lending() { LendingDate = lending.LendingDate, ReturnDate = lending.ReturnDate, BookId = lending.BookId, ClientId = lending.ClientId, LibraryId = lending.LibraryId }; db.Lendings.Add(dbLending); var bookCopy = db.BookCopies.FirstOrDefault( x => x.BookId == lending.BookId && x.LibraryId == lending.LibraryId); bookCopy.NumberOfCopies = bookCopy.NumberOfCopies - 1; db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertLibrary(LibraryModel library) { try { var dbLibrary = new Library() { Name = library.Name, City = library.City, Address = library.Address }; db.Libraries.Add(dbLibrary); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertPublisher(PublisherModel publisher) { try { var dbpublisher = new Publisher() { Id = publisher.Id, Name = publisher.Name, Country = publisher.Country }; db.Publishers.Add(dbpublisher); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertBookCopy(BookCopyModel bookCopy) { try { var dbBookCopy = new BookCopy() { Id = bookCopy.Id, NumberOfCopies = bookCopy.NumberOfCopies, BookId = bookCopy.BookId, LibraryId = bookCopy.LibraryId }; db.BookCopies.Add(dbBookCopy); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertBook(BookModel book) { try { var dbBook = new Book() { Title = book.Title, YearOfIssue = book.YearOfIssue, NumberOfPages = book.NumberOfPages, PublisherId = book.PublisherId }; db.Books.Add(dbBook); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool InsertClient(ClientModel client) { try { var dbClient = new Client() { Id = client.Id, Name = client.Name, Phone = client.Phone, City = client.City, Address = client.Address }; db.Clients.Add(dbClient); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }