public BorrowService(BorrowRepository borrowRepository,
ReaderRepository readerRepository,
BookRepository bookRepository)
{
BorrowRepository = borrowRepository;
ReaderRepository = readerRepository;
}
public BorrowsDashboard()
{
InitializeComponent();
_borrowRepository = new BorrowRepository();
borrow = new Borrow();
Load_Datagridview_Data();
EditBorrowForm.OnLoadData += Load_Datagridview_Data;
EditBorrowForm.OnLoadData += SetupTextboxes;
}
public static bool HasActiveBorrows(string PersonId)
{
if (BorrowRepository.GetActiveBorrowListByPersonId(PersonId).Count > 0)
{
return(true);
}
return(false);
}
public static void RenewAllLoans(borrower br, List <BorrowedBookCopy> borrowes)
{
DateTime ToBeReturnedDate = DateTime.Today.AddDays(CategoryRepository.GetCategoryById(br.CategoryId).Period);
foreach (BorrowedBookCopy b in borrowes)
{
BorrowRepository.UpdateBorrowDates(br.PersonId, b.Borrow.Barcode, ToBeReturnedDate);
}
}
public static Borrow DoesAlreadyEnrolledBySameUser(int userId, int stockId)
{
IBorrowRepository borrowRepository = new BorrowRepository();
Borrow borrow = borrowRepository.GetSingle(x => x.User_Id.Equals(userId) && x.Stock_Id.Equals(stockId),
x => x.Item,
x => x.Stock, x => x.User);
return(borrow != null ? borrow : null);
}
public ReaderBooksViewModel GetReaderBooks(int bookId)
{
ReaderBooksViewModel viewModel = new ReaderBooksViewModel()
{
Reader = ReaderRepository.GetSingleReader(ReaderRepository.CurrentId),
Books = BorrowRepository.GetBooksForReader(ReaderRepository.CurrentId)
};
return(viewModel);
}
public Students()
{
InitializeComponent();
_students = new StudentRepository();
_borrows = new BorrowRepository();
foreach (var student in _students.GetStudentsList().OrderBy(student => student.LastName))
{
StudentsListBox.Items.Add(student);
}
}
public static void ManageBorrow(Borrow borrow, EntityState entityState)
{
IBorrowRepository borrowRepository = new BorrowRepository();
borrow.EntityState = entityState;
if (borrow.Quantity == 0 && entityState == EntityState.Modified)
{
borrow.IsReturn = true;
borrow.ReturnTime = DateTime.Now;
}
borrowRepository.Update(borrow);
}
private void LoadForm()
{
BooksListBox.Items.Clear();
_books = new BookRepository();
_borrows = new BorrowRepository();
_students = new StudentRepository();
foreach (var book in _books.GetBooksList().OrderBy(book => book.Name))
{
BooksListBox.Items.Add(book.ToString());
}
}
public static bool RemoveBorrower(borrower b)
{
if (HasActiveBorrows(b.PersonId))
{
return(false);
}
BorrowRepository.RemoveBorrowsByPersonId(b.PersonId);
UserRepository.RemoveUser(b.PersonId);
BorrowerRepository.RemoveBorrower(b);
return(true);
}
public AddBorrow()
{
InitializeComponent();
_books = new BookRepository();
_students = new StudentRepository();
_borrows = new BorrowRepository();
foreach (var student in _students.GetStudentsList().OrderBy(student => student.LastName))
{
StudentComboBox.Items.Add(student);
}
BorrowDatePicker.MinDate = new DateTime(2019, 1, 1);
BorrowDatePicker.MaxDate = new DateTime(2020, 1, 1);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "return")
{
BorrowRepository repo = new BorrowRepository();
List <MRSLibrary.CustomizeDisplay.BorrowReturned> br = new List <MRSLibrary.CustomizeDisplay.BorrowReturned>();
long id = Convert.ToInt64(e.CommandArgument);
repo.ReturnMovieForBorrow(id);
br = repo.GetReturnedData(id);
DetailsView1.DataSource = br;
DetailsView1.DataBind();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "issue")
{
RequestRepository repo = new RequestRepository();
BorrowRepository repo1 = new BorrowRepository();
List <MRSLibrary.CustomizeDisplay.BorrowIssued> br = new List <MRSLibrary.CustomizeDisplay.BorrowIssued>();
long id = Convert.ToInt64(e.CommandArgument);
repo.IssueMovieForRequest(id);
br = repo1.GetIssuedData(id);
DetailsView1.DataSource = br;
DetailsView1.DataBind();
}
}
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}");
}
}
}
}
}
}
protected void btnRequestid_Click(object sender, EventArgs e)
{
BorrowRepository br = new BorrowRepository();
List <MRSLibrary.Database.BorrowTable> lst = new List <MRSLibrary.Database.BorrowTable>();
lst = br.GetBorrowsForRequestForReturn(Convert.ToInt32(txtRequestid.Text));
if (lst == null)
{
Label4.Visible = true;
GridView1.Visible = false;
}
else
{
Label4.Visible = false;
GridView1.DataSource = lst;
GridView1.DataBind();
}
}
protected void btnNotReturned_Click(object sender, EventArgs e)
{
BorrowRepository br = new BorrowRepository();
List <MRSLibrary.Database.BorrowTable> lst = new List <MRSLibrary.Database.BorrowTable>();
lst = br.GetBorrowNotReturned();
if (lst == null)
{
Label4.Visible = true;
GridView1.Visible = false;
}
else
{
Label4.Visible = false;
GridView1.DataSource = lst;
GridView1.DataBind();
}
}
protected void btnBorrowid_Click(object sender, EventArgs e)
{
BorrowRepository br = new BorrowRepository();
MRSLibrary.Database.BorrowTable lst = new MRSLibrary.Database.BorrowTable();
lst = br.GetBorrowForBorrowID(Convert.ToInt32(txtBorrowid.Text));
if (lst == null)
{
Label4.Visible = true;
GridView1.Visible = false;
}
else
{
Label4.Visible = false;
GridView1.DataSource = lst;
GridView1.DataBind();
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
BorrowRepository br = new BorrowRepository();
List <MRSLibrary.Database.BorrowTable> lst = new List <MRSLibrary.Database.BorrowTable>();
int val = Convert.ToInt16(DropDownList1.SelectedValue);
lst = br.GetBorrowForDateForReturn(val, Calendar1.SelectedDate);
if (lst == null)
{
Label4.Visible = true;
GridView1.Visible = false;
}
else
{
Label4.Visible = false;
GridView1.DataSource = lst;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BorrowRepository br = new BorrowRepository();
List <MRSLibrary.Database.BorrowTable> lst = new List <MRSLibrary.Database.BorrowTable>();
lst = br.GetAllBorrows();
if (lst == null)
{
Label4.Visible = true;
GridView1.Visible = false;
}
else
{
Label4.Visible = false;
GridView1.DataSource = lst;
GridView1.DataBind();
}
}
}
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);
}
public static List <BorrowedBookCopy> GetHistoryBorrowedBooks(string PersonId)
{
return(MapBorrow(BorrowRepository.GetHistoryBorrowListByPersonId(PersonId)));
}
public AddBorrowForm()
{
InitializeComponent();
_borrowRepository = new BorrowRepository();
}
public EditBorrowForm(Borrow borrow)
{
InitializeComponent();
_borrowRepository = new BorrowRepository();
_borrow = borrow;
}
public ReaderBooksViewModel Borrow(int bookId)
{
BorrowRepository.Borrow(bookId);
return(GetReaderBooks(bookId));
}
public static IList <Borrow> GetBorrows(bool isReturned)
{
IBorrowRepository borrowRepository = new BorrowRepository();
return(borrowRepository.GetAll(x => x.IsReturn.Equals(isReturned)).Select(x => x = borrowRepository.GetSingle(y => y.Id.Equals(x.Id))).ToList());
}
public void Back(int bookId)
{
BorrowRepository.Back(bookId);
}
public static void RenewLoad(borrower br, string barcode)
{
DateTime ToBeReturnedDate = DateTime.Today.AddDays(CategoryRepository.GetCategoryById(br.CategoryId).Period);
BorrowRepository.UpdateBorrowDates(br.PersonId, barcode, ToBeReturnedDate);
}
