private void LoadInfo()
{
InfoBox.Items.Clear();
if (StudentsListBox.CheckedItems.Any())
{
foreach (var student in _students.GetStudentsList())
{
if (student.ToString() == StudentsListBox.CheckedItems[0].ToString())
{
InfoBox.Items.Add($"First name: {student.FirstName}");
InfoBox.Items.Add($"Last name: {student.LastName}");
InfoBox.Items.Add($"Birth date: {student.BirthDate:dd/MM/yyyy}");
InfoBox.Items.Add($"Sex: {student.Sex}");
InfoBox.Items.Add($"Grade: {student.Grade}");
}
}
InfoBox.Items.Add("");
var noneFlag = true;
InfoBox.Items.Add("Un-returned books:");
foreach (var borrow in _borrows.GetBorrowsList())
{
if ($"{borrow.Student.FirstName} {borrow.Student.LastName}" == StudentsListBox.CheckedItems[0].ToString() && borrow.ReturnDate == null)
{
InfoBox.Items.Add(borrow.Book.Name);
noneFlag = false;
}
}
if (noneFlag)
{
InfoBox.Items.Add("None");
}
InfoBox.Items.Add("");
noneFlag = true;
InfoBox.Items.Add("Previously borrowed books:");
foreach (var borrow in _borrows.GetBorrowsList())
{
if ($"{borrow.Student.FirstName} {borrow.Student.LastName}" == StudentsListBox.CheckedItems[0].ToString() && borrow.ReturnDate.HasValue)
{
InfoBox.Items.Add(borrow.Book.Name);
noneFlag = false;
}
}
if (noneFlag)
{
InfoBox.Items.Add("None");
}
}
}
private void LoadBooks()
{
BookComboBox.Items.Clear();
foreach (var book in _books.GetBooksList().OrderBy(book => book.Name))
{
BookComboBox.Items.Add(book.Name);
}
foreach (var borrow in _borrows.GetBorrowsList())
{
if (_students.ReadStudent(StudentComboBox.Text).StudentId == borrow.StudentId && borrow.ReturnDate == null)
{
BookComboBox.Items.Remove(borrow.Book.Name);
}
}
}
private void LoadForm()
{
var students = new StudentRepository();
var books = new BookRepository();
var borrows = new BorrowRepository();
var borrowedBooks = borrows.GetBorrowsList().Count(borrow => borrow.ReturnDate == null);
BorrowsListBox.Items.Clear();
var numberOfAvailableTitles = books.GetBooksList().Count(book => book.NumberOfBooks > borrows.GetBorrowsList().Count(borrow => borrow.BookId == book.BookId && borrow.ReturnDate == null));
BorrowsListBox.Items.Add($"Available titles: {numberOfAvailableTitles}");
var availableTitles = books.GetBooksList().Where(book => book.NumberOfBooks > borrows.GetBorrowsList().Count(borrow => borrow.BookId == book.BookId && borrow.ReturnDate == null));
foreach (var availableTitle in availableTitles)
{
var copiesLeft = availableTitle.NumberOfBooks - borrows.GetBorrowsList().Count(borrow => borrow.BookId == books.ReadBook(availableTitle.Name).BookId&& borrow.ReturnDate == null);
BorrowsListBox.Items.Add($" - {availableTitle} ({copiesLeft})");
}
BorrowsListBox.Items.Add("");
BorrowsListBox.Items.Add($"Borrowed books: {borrowedBooks}");
foreach (var student in students.GetStudentsList().OrderBy(student => student.LastName))
{
foreach (var borrow in borrows.GetBorrowsList())
{
if (borrow.StudentId == students.ReadStudent($"{student.FirstName} {student.LastName}").StudentId&& borrow.ReturnDate == null)
{
if (!BorrowsListBox.Items.Contains($"{student}:"))
{
BorrowsListBox.Items.Add($"{student}:");
}
foreach (var book in books.GetBooksList())
{
if (books.ReadBook(book.Name).BookId == borrow.BookId)
{
BorrowsListBox.Items.Add($" - {book}");
}
}
}
}
}
}
private void LoadBooks()
{
BookComboBox.Items.Clear();
foreach (var borrow in _borrows.GetBorrowsList())
{
if (_students.ReadStudent(StudentComboBox.Text).StudentId == borrow.StudentId && !borrow.ReturnDate.HasValue)
{
BookComboBox.Items.Add(borrow.Book.Name);
}
}
}
private void LoadInfo()
{
InfoBox.Items.Clear();
if (BooksListBox.CheckedItems.Any())
{
var rented = 0;
foreach (var borrow in _borrows.GetBorrowsList())
{
if (BooksListBox.CheckedItems[0].ToString() == borrow.Book.Name && borrow.ReturnDate == null)
{
rented++;
}
}
foreach (var book in _books.GetBooksList())
{
if (book.Name == BooksListBox.CheckedItems[0].ToString())
{
InfoBox.Items.Add($"Author: {book.Author}");
InfoBox.Items.Add($"Publisher: {book.Publisher}");
InfoBox.Items.Add($"Number of pages: {book.NumberOfPages.ToString()}");
InfoBox.Items.Add($"Number of copies: {book.NumberOfBooks.ToString()}");
InfoBox.Items.Add($"Genre: {book.Genre.ToString()}");
InfoBox.Items.Add("");
InfoBox.Items.Add($"Currently available: {book.NumberOfBooks - rented}");
InfoBox.Items.Add($"Currently rented by: {rented}");
}
}
foreach (var borrow in _borrows.GetBorrowsList())
{
if (_books.ReadBook(BooksListBox.CheckedItems[0].ToString()).BookId == borrow.BookId && borrow.ReturnDate == null)
{
InfoBox.Items.Add($"{_students.ReadStudentById(borrow.StudentId)}");
}
}
}
}
public ReturnBook()
{
InitializeComponent();
_books = new BookRepository();
_students = new StudentRepository();
_borrows = new BorrowRepository();
foreach (var student in _students.GetStudentsList().OrderBy(student => student.LastName))
{
foreach (var borrow in _borrows.GetBorrowsList())
{
if (borrow.StudentId == _students.ReadStudent($"{student.FirstName} {student.LastName}").StudentId&& borrow.ReturnDate == null && !(StudentComboBox.Items.Contains(student)))
{
StudentComboBox.Items.Add(student);
}
}
}
ReturnDatePicker.MinDate = new DateTime(2018, 1, 1);
ReturnDatePicker.MaxDate = new DateTime(2020, 1, 1);
}