public void GetBookByTitle_TitleOfBookExists_ReturnsBook(string title)
{
var expectedResult = AllBooks.Single(book => book.Title.Equals(title));
var result = BookRepository.GetBookByTitle(title);
result.Should().BeEquivalentTo(expectedResult);
}
public ActionResult AddAllBooks(All_Books b)
{
try
{
using (LMSEntities db = new LMSEntities())
{
AllBooks bk = new AllBooks();
bk.Name = b.Name;
bk.Number = b.Number;
bk.Price = b.Price;
bk.Author = b.Author;
bk.Edition = b.Edition;
bk.Status = b.Status;
db.All_Books.Add(b);
db.SaveChanges();
}
return(RedirectToAction("AllBooks"));
}
catch
{
return(View());
}
}
void AddBook()
{
AddEditBookViewModel newBook = new AddEditBookViewModel("Add", BookType.None);
AddEditBook newWin = new AddEditBook();
newWin.DataContext = newBook;
newWin.ShowDialog();
if (newWin.DialogResult == true)
{
BookProduct bookToAdd = new BookProduct();
bookToAdd.BookID = AllBooks.Count + 1;
bookToAdd.BookType = newBook.AddEditItem.BookType;
bookToAdd.BookName = newBook.AddEditItem.BookName;
bookToAdd.BookWriter = newBook.AddEditItem.BookWriter;
bookToAdd.PublishYear = newBook.AddEditItem.PublishYear;
switch (newBook.AddEditItem.BookType)
{
case BookType.EBook:
(bookToAdd as EbookItem).NumOfDownloads = (newBook.AddEditItem as EbookItem).NumOfDownloads;
foreach (var item in (newBook.AddEditItem as EbookItem).LanguagesTranslations)
{
(bookToAdd as EbookItem).LanguagesTranslations.Add(item);
}
break;
case BookType.Printed:
(bookToAdd as PrintedItem).NumOfCopied = (newBook.AddEditItem as PrintedItem).NumOfCopied;
(bookToAdd as PrintedItem).BookWeight = (newBook.AddEditItem as PrintedItem).BookWeight;
(bookToAdd as PrintedItem).IsAvilable = (newBook.AddEditItem as PrintedItem).IsAvilable;
break;
}
AllBooks.Add(bookToAdd);
}
}
public void AddBook()
{
bool result = _navigationService.GetWindow <BookDetailsViewModel>().ShowWindowModal();
if (result)
{
//Adding a new books to list
Book newBook = null;
using (var dbService = _dbServiceManager.GetService())
{
var books = dbService.Books.GetAll();
foreach (var b in books.OrderByDescending(cli => cli.Id))
{
if (AllBooks.Any(book => book.Id == b.Id))
{
break;
}
else
{
if (newBook == null)
{
newBook = b;
}
AllBooks.Add(b);
}
}
}
Books = new BindableCollection <Book>(AllBooks);
SelectedBook = newBook;
}
}
void MoveUp()
{
int itemIndex = AllBooks.IndexOf(SelectedBook);
AllBooks.Move(itemIndex - 1, itemIndex);
SelectedBook.BookID--;
AllBooks[itemIndex].BookID++;
}
void MoveDown()
{
int itemIndex = AllBooks.IndexOf(SelectedBook);
AllBooks.Move(itemIndex + 1, itemIndex);
SelectedBook.BookID++;
AllBooks[itemIndex].BookID--;
}
public BookLibrary()
{
AllBooks.Add(new Book(1, "Hamlet", "Bill Shakespeare", 1602));
AllBooks.Add(new Book(2, "Moby Dick", "Hermit Melville", 1851));
AllBooks.Add(new Book(3, "Frankenstein", "Merry Shelly", 1818));
AllBooks.Add(new Book(4, "Lord of the Rings", "J.R.R. Token", 1954));
AllBooks.Add(new Book(5, "Harry Potter", "J.K. Bowling", 1998));
}
public void ShowAllBooksMethod()
{
using (Model1 context = new Model1())
{
foreach (Book a in context.Books)
{
AllBooks.Add(a.BookName);
}
}
}
void bRemove_Click(object sender, EventArgs e)
{
var request = gvResult.GetSelectedRow <Request>();
request.Do(r => {
AllBooks.Add(r.Book);
AllBooks = AllBooks.OrderBy(b => b.Name).ToList();
gcBooks.Bind(AllBooks);
RemoveRequest(r);
});
}
void bAdd_Click(object sender, EventArgs e)
{
var book = GetSelectedBook();
book.Do(b => {
AllBooks.Remove(b);
AddRequest(b);
});
AllBooks = AllBooks.OrderBy(b => b.Name).ToList();
gcBooks.Bind(AllBooks);
}
public Book AddBook(string name, string catagory, string readingStatus, List <string> tags)
{
Book book = new Book(name, catagory, readingStatus, tags);
AllBooks.Add(book);
if (addBookEvent != null)
{
addBookEvent(book);
}
return(book);
}
public bool MoveDownCanExecute()
{
if (SelectedBook == null)
{
return(false);
}
if (AllBooks.IndexOf(SelectedBook) == AllBooks.Count - 1)
{
return(false);
}
return(true);
}
public bool MoveUpCanExecute()
{
if (SelectedBook == null)
{
return(false);
}
if (AllBooks.IndexOf(SelectedBook) == 0)
{
return(false);
}
return(true);
}
public void AddBookMethod()
{
AllBooks.Add(BookName);
Book NewBook = new Book();
NewBook.BookName = BookName;
using (Model1 context = new Model1())
{
context.Books.Add(NewBook);
context.SaveChanges();
}
}
public Book AddBook(Book book)
{
if (GetBook(book.Name) != null)
{
return(null);
}
AllBooks.Add(book);
if (addBookEvent != null)
{
addBookEvent(book);
}
return(book);
}
public void DeleteBook()
{
if (MessageBox.Show(String.Format(App.GetString("AreYouSureRemoveBook"), SelectedBook.Title), App.GetString("Removing"),
MessageBoxButton.YesNoCancel, MessageBoxImage.Warning, MessageBoxResult.Cancel) != MessageBoxResult.Yes)
{
return;
}
using (var dbService = _dbServiceManager.GetService())
{
dbService.Books.Delete(SelectedBook.Id);
AllBooks.Remove(SelectedBook);
Books.Remove(SelectedBook);
}
}
public void removeBookIfExists(Book book2)
{
if (AllBooks.Count == 0)
{
return;
}
Book bookToRemove = null;
foreach (var book in AllBooks)
{
if (book.Uniqe_ID.Equals(book2.Uniqe_ID))
{
bookToRemove = book;
}
}
AllBooks.Remove(bookToRemove);
}
//For creting a new book
public static int CreateBook(string Title, string Author, string Genre, int Year, string Des, string Photo)
{
AllBooks data = new AllBooks
{
Title = Title,
Author = Author,
Genre = Genre,
Year = Year,
Des = Des,
Photo = Photo
};
//sql query for adding inputed varialbles into the table
string sql = @"insert into dbo.Books (Title, Author, Genre, Year, Des, Photo)
values (@Title, @Author, @Genre, @Year, @Des, @Photo)";
//Using function for saving into the database
return(SqlDataAccess.SaveData(sql, data));
}
public void DeleteBookMethod()
{
if (CheckBook())
{
using (Model1 context = new Model1())
{
Book OneBook = context.Books.Where(c => c.BookName == BookName)
.Include(c => c.Authors).FirstOrDefault();
context.Books.Remove(OneBook);
context.SaveChanges();
}
AllBooks.Remove(BookName);
}
else
{
MessageBox.Show("Книга не найдена");
}
}
public void SearchBook(ActionExecutionContext context, string phrase)
{
SearchPhrase = phrase;
var keyArgs = context.EventArgs as KeyEventArgs;
if (keyArgs != null && keyArgs.Key == Key.Enter)
{
if (String.IsNullOrEmpty(phrase))
{
Books = new BindableCollection <Book>(AllBooks);
}
else
{
Books = new BindableCollection <Book>(AllBooks.Where(c => c.Title.ContainsAny(phrase) || (!String.IsNullOrEmpty(c.AuthorsString) && c.AuthorsString.ContainsAny(phrase))));
}
}
}
public override void SwitchEditableStateExecute()
{
base.SwitchEditableStateExecute();
InitializeBookCollection();
void InitializeBookCollection()
{
if (!Books.Any())
{
var tempBookCollection = AllBooks.Where(item => !SelectedItem.Model.BooksSeries
.Any(x => x.SeriesId == SelectedItem.Id && x.BookId == item.Id))
.OrderBy(b => b.DisplayMember);
PopulateBooksCollection(tempBookCollection);
}
}
}
// wypisz zarezerwowane ksiązki
private static void Query1()
{
var listOfReservationBook = new List <Book>();
AllReservation.ForEach(p =>
{
var reservedBooks = AllBooks.Where(a => a.Id == p.BookNumber).Select(b => b);
foreach (var book in reservedBooks)
{
listOfReservationBook.Add(book);
}
});
foreach (var book in listOfReservationBook)
{
Console.WriteLine($"Nazwa: {book.Name}");
}
}
public async override Task LoadAsync(Guid id)
{
SelectedItem = await Repository.GetSelectedAsync(id) ?? new Series();
Id = id;
if (Id != default)
{
TabTitle = SelectedItem.Name;
Name = SelectedItem.Name;
}
else
{
this.SwitchEditableStateExecute();
}
await PopulateAllBooksCollection();
SetDefaultSeriesPictureIfNoneSet();
SelectedItem.PropertyChanged += (s, e) =>
{
SetChangeTracker();
};
void SetDefaultSeriesPictureIfNoneSet()
{
if (SelectedItem.PicturePath is null)
{
SelectedItem.PicturePath = FileExplorerService.GetImagePath();
}
}
async Task PopulateAllBooksCollection()
{
AllBooks.Clear();
foreach (var item in await GetBookList())
{
AllBooks.Add(item);
}
}
}
public Page()
{
InitializeComponent();
//<snippet4>
//You can add items to your collection
AllBooks.Add(new Book("4458907683", "Training Your Dog",
new DateTime(2000, 2, 8), 44.25));
AllBooks.Add(new Book("0446675385", "Good Owners, Great Dogs",
new DateTime(1999, 9, 1), 15.99));
//Set the data context for the list of books
MyBooks.DataContext = AllBooks;
//</snippet4>
//<snippet6>
this.MyBooks.SelectionChanged +=
new SelectionChangedEventHandler(MyBooks_SelectionChanged);
MyBooks.SelectedIndex = 0;
//</snippet6>
}
public void CreateBook_ValidBookSuppliedAsParameter_CreatesAndReturnsNewBook
(string title, int authorId, decimal price)
{
var validInput = new Book
{
Title = title,
AuthorId = authorId,
Price = price
};
var highestCurrentBookId = AllBooks.Max(book => book.Id);
var expectedResult = new Book
{
Title = title,
AuthorId = authorId,
Price = price,
Id = highestCurrentBookId + 1
};
var result = BookRepository.CreateBook(validInput);
result.Should().BeEquivalentTo(expectedResult);
}
public override int GetHashCode()
{
return(AllBooks.GetHashCode() ^ AvailableBooks.GetHashCode());
}
IEnumerable <Book> GetFilteredBooks(string filter)
{
return(string.IsNullOrEmpty(filter) ? AllBooks : AllBooks.Where(b => b.Name.ToLower().Contains(filter)));
}
void DeleteBook()
{
AllBooks.Remove(SelectedBook);
}
public Book GetBookById(int bookId)
{
return(AllBooks.FirstOrDefault(b => b.BookId == bookId));
}
public void UpdateShelfBooks()
{
ShelfBooks = new ObservableCollection <Book>(AllBooks.Where(x => x.Shelf));
}
public List<Book> Get(AllBooks request)
{
return Repo.GetAllBooks();
}
