public void DeleteBook(Guid ID)
{
Models.DBObjects.Book bookToDelete = booksLibraryDataContext.Books.FirstOrDefault(x => x.IDBook == ID);
if (bookToDelete != null)
{
booksLibraryDataContext.Books.DeleteOnSubmit(bookToDelete);
booksLibraryDataContext.SubmitChanges();
}
}
public void UpdateBook(BookModel bookModel)
{
Models.DBObjects.Book existingBook = booksLibraryDataContext.Books.FirstOrDefault(x => x.IDBook == bookModel.IDBook);
if (existingBook != null)
{
existingBook.IDBook = bookModel.IDBook;
existingBook.Name = bookModel.Name;
existingBook.Author = bookModel.Author;
existingBook.Publisher = bookModel.Publisher;
existingBook.NumberOfCopies = bookModel.NumberOfCopies;
existingBook.IDBooksCategory = bookModel.IDBooksCategory;
existingBook.IDLocationInLibrary = bookModel.IDLocationInLibrary;
existingBook.imageUrl = bookModel.imageUrl;
booksLibraryDataContext.SubmitChanges();
}
}
private Models.DBObjects.Book MapModelToDbObject(BookModel bookModel)
{
Models.DBObjects.Book dbBookModel = new Models.DBObjects.Book();
if (bookModel != null)
{
dbBookModel.IDBook = bookModel.IDBook;
dbBookModel.Name = bookModel.Name;
dbBookModel.Author = bookModel.Author;
dbBookModel.Publisher = bookModel.Publisher;
dbBookModel.NumberOfCopies = bookModel.NumberOfCopies;
dbBookModel.IDBooksCategory = bookModel.IDBooksCategory;
dbBookModel.IDLocationInLibrary = bookModel.IDLocationInLibrary;
dbBookModel.imageUrl = bookModel.imageUrl;
return(dbBookModel);
}
return(null);
}
private BookModel MapDbObjectToModel(Models.DBObjects.Book dbBook)
{
BookModel bookModel = new BookModel();
if (dbBook != null)
{
bookModel.IDBook = dbBook.IDBook;
bookModel.Name = dbBook.Name;
bookModel.Author = dbBook.Author;
bookModel.Publisher = dbBook.Publisher;
bookModel.NumberOfCopies = dbBook.NumberOfCopies;
bookModel.IDBooksCategory = dbBook.IDBooksCategory;
bookModel.IDLocationInLibrary = dbBook.IDLocationInLibrary;
bookModel.imageUrl = dbBook.imageUrl;
return(bookModel);
}
return(null);
}
