/// <summary>
/// Returns a list of strings to display information about overdue books and their cardholders.
/// </summary>
/// <returns></returns>
public List <string> GetOverdueBookInformation()
{
List <CheckOutLogBLL> overdues = logs.GetOverdueLogs();
List <string> outputList = new List <string>();
if (overdues.Count == 0)
{
outputList.Add("There are no records of overdue books.");
}
else
{
//I have logs, now I need book and cardholder
overdues.Sort();
foreach (CheckOutLogBLL l in overdues)
{
BookBLL book = (from b in books
where b.BookID == l.BookID
select b).FirstOrDefault();
CardholderBLL cardholder = (CardholderBLL)(from c in people
where c is CardholderBLL
where c.ID == l.CardholderID
select c).FirstOrDefault();
//Build the string and add it to the listBox
string o = $"{book.ToString()} {l.ToString()} Cardholder: {cardholder.ToString()} ";
outputList.Add(o);
}
}
return(outputList);
}
/// <summary>
/// Finishes the cardholderBLL creation.
/// </summary>
public void CreateCardholder()
{
Cardholder = new CardholderBLL()
{
FirstName = firstName,
LastName = lastName,
Phone = phone,
LibraryCardID = libraryCardID,
ID = iD
};
}
/// <summary>
/// Creates a list of business logic layer objects from the database tables
/// </summary>
public void PopulatePeople()
{
using (LibraryDBEntities context = new LibraryDBEntities())
{
List <PersonBLL> newPeople = new List <PersonBLL>();
//Add the librarians
LibrarianBLL librarian = null;
foreach (Librarian l in context.Librarians)
{
librarian = new LibrarianBLL()
{
ID = l.Person.PersonID,
FirstName = l.Person.FirstName,
LastName = l.Person.LastName,
Phone = l.Phone,
UserID = l.UserID,
Password = l.Password
};
newPeople.Add(librarian);
}
//Add the authors
AuthorBLL author = null;
foreach (Author a in context.Authors)
{
author = new AuthorBLL()
{
ID = a.Person.PersonID,
FirstName = a.Person.FirstName,
LastName = a.Person.LastName,
Bio = a.Bio
};
newPeople.Add(author);
}
//Add cardholders
CardholderBLL cardholder = null;
foreach (Cardholder c in context.Cardholders)
{
cardholder = new CardholderBLL()
{
ID = c.Person.PersonID,
FirstName = c.Person.FirstName,
LastName = c.Person.LastName,
Phone = c.Phone,
LibraryCardID = c.LibraryCardID
};
newPeople.Add(cardholder);
}
people = newPeople;
}
Sort();
}