private void btnSearchResource_Click(object sender, EventArgs e)
{
SearchResource sr = new SearchResource(dbContext, searchClicked);
sr.ShowDialog();
BookEdition eb = new BookEdition();
}
private void AddBook()
{
BookEdition book = new BookEdition();
EditBook(book);
dbContext.Positions.Add(book);
}
public void AddBookEditionWithEmptyBookTest()
{
using (var unitOfWork = new UnitOfWork(new AppDbContext()))
{
var book = new Book();
var publisher = new Publisher
{
Name = "PublisherTestCase"
};
var edition = new BookEdition
{
Book = book,
Publisher = publisher,
Copies = 80,
CopiesLibrary = 20,
Pages = 100,
Type = BookType.HardCover,
Year = "2000"
};
var result = unitOfWork.BookEditions.Add(edition);
Assert.AreEqual(false, result);
}
}
public void AddBookEditionWithNullPublisherTest()
{
using (var unitOfWork = new UnitOfWork(new AppDbContext()))
{
var book = new Book
{
Title = "Fake Title For Test",
Authors = new List <Author> {
new Author {
Firstname = "AuthorFNTest", Lastname = "AuthorLNTest"
}
},
Domains = new List <Domain> {
new Domain {
Name = "TestCaseDomain"
}
}
};
var edition = new BookEdition
{
Book = book,
Publisher = null,
Copies = 80,
CopiesLibrary = 20,
Pages = 100,
Type = BookType.HardCover,
Year = "2000"
};
var result = unitOfWork.BookEditions.Add(edition);
Assert.AreEqual(false, result);
}
}
public static BookEditionViewModel CreateFromBookEdition(BookEdition bookEdition,
bool includeBook = false,
bool includeDimensions = false,
bool includePublisher = false)
{
var dto = new BookEditionViewModel
{
Isbn = bookEdition.Isbn,
PageCount = bookEdition.PageCount,
PrintDate = bookEdition.PrintDate,
CreationDate = bookEdition.CreationDate,
CreatorId = bookEdition.CreatorId
};
if (includeBook)
{
dto.Book = BookViewModel.CreateFromBook(bookEdition.Book);
}
if (includeDimensions)
{
dto.Dimensions = DimensionViewModel.CreateFromDimension(bookEdition.Dimensions);
}
if (includePublisher)
{
dto.Publisher = PublisherViewModel.CreateFromPublisher(bookEdition.Publisher);
}
return(dto);
}
private void InitBookControls(Position position)
{
BookEdition book = (BookEdition)position;
txbBoxIsbn.Text = book.ISBN;
datePicker.Value = (DateTime)book.PublicationDate;
selectedBook = book.Book;
RefreshSelectedBookListView();
}
private void EditBook(Position position)
{
BookEdition editedBook = (BookEdition)position;
editedBook.ISBN = txbBoxIsbn.Text;
editedBook.PublicationDate = datePicker.Value;
editedBook.Number = 1;
editedBook.Publisher = dbContext.Publishers.Where(p => p.Name == publisherSpinner.Text).FirstOrDefault();
editedBook.Book = selectedBook;
}
public void EditEmptyBookEditionTest()
{
using (var unitOfWork = new UnitOfWork(new AppDbContext()))
{
var edition = new BookEdition();
var result = unitOfWork.BookEditions.EditBookEdition(edition);
Assert.AreEqual(false, result);
}
}
public static IBook NewBook(this IEntitySession session, BookEdition editions, BookCategory category, string title, string description,
IPublisher publisher, DateTime? publishedOn, decimal price, IImage coverImage = null)
{
var book = session.NewEntity<IBook>();
book.Editions = editions;
book.Category = category;
book.Title = title;
book.Description = description;
book.Publisher = publisher;
book.PublishedOn = publishedOn;
book.Price = price;
book.CoverImage = coverImage;
return book;
}
private string[] GenerateBookRow(Reservation reservation)
{
BookEdition book = (BookEdition)reservation.Resource.Position;
string authors = "";
foreach (Authorship authorship in book.Book.Authorship)
{
authors += authorship.Author.Name + " " + authorship.Author.Surname + "; ";
}
string[] row = { book.Book.Title, authors, "", reservation.RealizationDate.ToShortDateString() };
return(row);
}
private string[] GenerateBookRow(Borrowing borrowing)
{
BookEdition book = (BookEdition)borrowing.Resource.Position;
string authors = "";
foreach (Authorship authorship in book.Book.Authorship)
{
authors += authorship.Author.Name + " " + authorship.Author.Surname + "; ";
}
string[] row = { book.Book.Title, authors, "", borrowing.BorrowingDate.ToShortDateString(), borrowing.ReturnTerm.ToShortDateString() };
return(row);
}
public static IBook NewBook(this IEntitySession session, BookEdition editions, BookCategory category, string title, string description,
IPublisher publisher, DateTime?publishedOn, decimal price, IImage coverImage = null)
{
var book = session.NewEntity <IBook>();
book.Editions = editions;
book.Category = category;
book.Title = title;
book.Description = description;
book.Publisher = publisher;
book.PublishedOn = publishedOn;
book.Price = price;
book.CoverImage = coverImage;
return(book);
}
/// <summary>
/// updates the book
/// </summary>
public void Update()
{
CustomSqlConnection con = new CustomSqlConnection();
if (con.ConnectError())
{
return;
}
DeleteBookAuthors();
string command = "UPDATE [dbo].[t_s_buecher] set buch_titel = @bookTitle , buch_genre_id = @bookGenreId, " +
"buch_sprache_id = @bookLanguageId, buch_verlag_id = @bookPublisherId, buch_auflage = @bookEdition, " +
"buch_erscheinungsdatum = @bookDatePublication, buch_neupreis = @bookPrice, " +
"buch_image = @bookImage WHERE buch_isbn = @bookIsbn";
SqlCommand cmd = new SqlCommand(command, con.Con);
cmd.Parameters.AddWithValue("@bookTitle", BookTitle);
cmd.Parameters.AddWithValue("@bookGenreId", BookGenre.GenreId);
cmd.Parameters.AddWithValue("@bookLanguageId", BookLanguage.LanguageId);
cmd.Parameters.AddWithValue("@bookPublisherId", BookPublisher.PublisherId);
if (BookEdition == null || BookEdition.Equals(""))
{
cmd.Parameters.AddWithValue("@bookEdition", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@bookEdition", BookEdition);
}
cmd.Parameters.AddWithValue("@bookDatePublication", BookDatePublication);
cmd.Parameters.AddWithValue("@bookPrice", BookPrice);
cmd.Parameters.Add("@bookImage", SqlDbType.VarBinary, -1);
if (BookImage == null)
{
cmd.Parameters["@bookImage"].Value = DBNull.Value;
}
else
{
using (var ms = new MemoryStream())
{
BookImage.Save(ms, ImageFormat.Png);
cmd.Parameters["@bookImage"].Value = ms.ToArray();
}
}
cmd.Parameters.AddWithValue("@bookIsbn", BookIsbn);
cmd.ExecuteNonQuery();
AddBookAuthors();
con.Close();
}
public void DeleteBookEditionMockTest()
{
using (var unitOfWork = new UnitOfWork(new AppDbContext()))
{
var mock = new Mock <IRepository <BookEdition> >();
mock.Setup(m => m.Remove(It.IsAny <BookEdition>())).Returns(true);
var bookEdition = new BookEdition();
var obj = mock.Object;
var result = obj.Remove(bookEdition);
Assert.AreEqual(true, result);
}
}
public async Task <Unit> Handle(AddEditionCommand request, CancellationToken cancellationToken)
{
var book = await _context.Books.FindAsync(request.BooksId);
if (book == null)
{
throw new BookNotFoundException(request.BooksId);
}
var dimension = await _context.Dimensions.FindAsync(request.DimensionsId);
if (dimension == null)
{
throw new DimensionNotFoundException(request.DimensionsId);
}
var publisher = await _context.Publishers.FindAsync(request.PublishersId);
if (publisher == null)
{
throw new PublisherNotFoundException(request.PublishersId);
}
var bookEdition = new BookEdition
{
Isbn = request.Isbn,
PageCount = request.PageCount,
PrintDate = request.PrintDate,
Book = book,
Dimensions = dimension,
Publisher = publisher,
CreationDate = DateTime.UtcNow
// CreatorId =
// TODO (v0.5): add creator id.
};
_context.BookEditions.Add(bookEdition);
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes.");
}
private void RefreshBookEditions(List <Position> positions)
{
lstViewPositions.Columns.Clear();
lstViewPositions.Columns.Add("Tytuł");
lstViewPositions.Columns.Add("ISBN");
positionTagSet.Clear();
foreach (Position position in positions)
{
BookEdition be = (BookEdition)position;
string[] row = { be.Book.Title, be.ISBN };
ListViewItem item = new ListViewItem(row);
item.Tag = position.GetHashCode();
positionTagSet.Add(item.Tag.ToString(), position);
lstViewPositions.Items.Add(item);
}
}
private void RefreshBookResources(List <Resource> resources)
{
lstViewResources.Columns.Clear();
lstViewResources.Columns.Add("Ilość");
lstViewResources.Columns.Add("Tytuł");
lstViewResources.Columns.Add("ISBN");
resourceTagSet.Clear();
foreach (Resource resource in resources)
{
BookEdition be = (BookEdition)resource.Position;
string[] row = { resource.Amount.ToString(), be.Book.Title, be.ISBN };
ListViewItem item = new ListViewItem(row);
item.Tag = resource.GetHashCode();
resourceTagSet.Add(item.Tag.ToString(), resource);
lstViewResources.Items.Add(item);
}
}
public static bool IsSet(this BookEdition flags, BookEdition flag)
{
return (flags & flag) != 0;
}
public static bool IsSet(this BookEdition flags, BookEdition flag)
{
return((flags & flag) != 0);
}
