public async Task <IActionResult> Edit(int id, [Bind("BookCopiesID,BookBarcode,BookID,RetailerID,PurchasePrice,RFID,UpdatedDateTime")] BookCopies bookCopies)
{
if (id != bookCopies.BookCopiesID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(bookCopies);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BookCopiesExists(bookCopies.BookCopiesID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["BookID"] = new SelectList(_context.Set <Book>(), "BookID", "Name", bookCopies.BookID);
ViewData["RetailerID"] = new SelectList(_context.Set <Retailer>(), "RetailerID", "Name", bookCopies.RetailerID);
return(View(bookCopies));
}
public void ClearDatabase()
{
#if MSSQL
Console.WriteLine("qfklqsjdfkljqsdlfjiljsdfkljqsdkldfjklsqdjdhfjsqdhfjqsdhljkfklqsdjfklqsdjfkljsqddlkfjlsqdkjf");
RentalItems.RemoveRange(RentalItems);
Rentals.RemoveRange(Rentals);
Users.RemoveRange(Users);
BookCopies.RemoveRange(BookCopies);
Books.RemoveRange(Books);
Categories.RemoveRange(Categories);
#else
#endif
SaveChanges();
Reseed(nameof(Users));
Reseed(nameof(Books));
Reseed(nameof(Rentals));
Reseed(nameof(BookCopies));
Reseed(nameof(Categories));
Reseed(nameof(RentalItems));
/**
* Décommenter la ligne suivante pour réinitialiser le compteur de clef autoincrementée
*/
//Reseed(nameof(Messages));
}
public BookCopies GetAllLoanByMemberID(int id)
{
Connection();
List <BookCopies> bookCopiesList = new List <BookCopies>();
BookCopies bookCopies = new BookCopies();
SqlCommand com = new SqlCommand("CountLoan", _connect);
com.Parameters.AddWithValue("@MemberID", id);
com.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
_connect.Open();
da.Fill(dt);
_connect.Close();
bookCopiesList = (from DataRow dr in dt.Rows
select new BookCopies()
{
Quantities = Convert.ToInt32(dr["NoOfBooks"])
}).ToList();
bookCopies = bookCopiesList[0];
return(bookCopies);
}
public void ClearDatabase()
{
#if MSSQL
Categories.RemoveRange(Categories);
RentalItems.RemoveRange(RentalItems);
BookCopies.RemoveRange(BookCopies);
Books.RemoveRange(Books);
Rentals.RemoveRange(Rentals);
Users.RemoveRange(Users);
#else
Categories.RemoveRange(Categories);
BookCopies.RemoveRange(BookCopies
.Include(nameof(BookCopy.RentalItems))
);
Books.RemoveRange(Books);
Users.RemoveRange(Users
.Include(nameof(User.Rentals))
);
#endif
SaveChanges();
Reseed(nameof(Users));
Reseed(nameof(Books));
Reseed(nameof(BookCopies));
Reseed(nameof(Categories));
Reseed(nameof(Rentals));
Reseed(nameof(RentalItems));
}
public ActionResult AddCopies(BookCopies bookCopies)
{
try
{
copiesRepository copiesRepository = new copiesRepository();
for (int i = 0; i < bookCopies.Quantities; i++)
{
CopiesModel copiesModel = new CopiesModel()
{
BookId = bookCopies.BookModel.BookId,
CopyNo = i + 1,
DateBought = bookCopies.CopiesModel.DateBought,
Location = bookCopies.CopiesModel.Location
};
copiesRepository.AddCopies(copiesModel);
var profileData = Session["UserProfile"] as UserSession;
var logModel = new LogModel
{
UserId = profileData.UserID,
TableName = "Copies",
Activity = "Copies Added",
LogDate = DateTime.Now
};
var logRepository = new logRepository();
logRepository.AddLog(logModel);
}
return(RedirectToAction("Dashboard", "Home"));
}
catch
{
return(RedirectToAction("Dashboard", "Home"));
}
}
public void ClearDatabase()
{
#if MSSQL
Books.RemoveRange(Books);
Users.RemoveRange(Users);
BookCopies.RemoveRange(BookCopies);
RentalItems.RemoveRange(RentalItems);
Rentals.RemoveRange(Rentals);
Categories.RemoveRange(Categories
.Include(nameof(Category.Books))
);
#else
Categories.RemoveRange(Categories
.Include(nameof(Category.Books))
);
#endif
SaveChanges();
/**
* Décommenter la ligne suivante pour réinitialiser le compteur de clef autoincrementée
*/
Reseed(nameof(Users));
Reseed(nameof(Books));
Reseed(nameof(BookCopies));
Reseed(nameof(Categories));
Reseed(nameof(Rentals));
Reseed(nameof(RentalItems));
}
public IActionResult OnGet(int bookId, int libraryId)
{
BookCopy = bookCopiesService.GetBookCopyById(bookId, libraryId);
if (BookCopy == null)
{
return(RedirectToPage("NotFound"));
}
return(Page());
}
public IActionResult Delete(BookCopies bookCopies)
{
var tempBookCopies = bookCopiesData.DeleteBookCopies(bookCopies.Id);
if (tempBookCopies == null)
{
return(RedirectToAction("Detail", "Library", new { libraryId = bookCopies.LibraryId }));
}
bookCopiesData.Commit();
TempData["Message"] = "The object is deleted";
return(RedirectToAction("Detail", "Library", new { libraryId = bookCopies.LibraryId }));
}
public BookCopy CreateBookCopy(
Book book,
DateTime aquisitiondate)
{
BookCopy bc = BookCopies.Create();
bc.Book = book;
bc.AquisitionDate = aquisitiondate;
BookCopies.Add(bc);
SaveChanges();
return(bc);
}
public IActionResult EditCopyInLibrary(int bookId, int libraryId)
{
var copy = new BookCopies();
copy = bookCopiesService.GetBookCopyById(bookId, libraryId);
if (copy == null)
{
return(View("NotFound"));
}
return(View(copy));
}
public IActionResult OnGet(int id)
{
Library = libraryService.GetLibraryById(id);
if (Library == null)
{
return(RedirectToPage("NotFound"));
}
SelectBook = FilterBooks();
BookCopy = new BookCopies();
return(Page());
}
public BookWithReservedCopies(Book book)
{
Id = book.Id;
Title = book.Title;
Author = book.Author;
PublisherText = book.PublisherText;
GuidedReadingLevel = book.GuidedReadingLevel;
Isbn = book.Isbn;
BoxNumber = book.BoxNumber;
CreatedDate = book.CreatedDate;
ModifiedDate = book.ModifiedDate;
BookCopies.AddRange(book.BookCopies);
}
public async Task <IActionResult> Create([Bind("BookCopiesID,BookBarcode,BookID,RetailerID,PurchasePrice,RFID,UpdatedDateTime")] BookCopies bookCopies)
{
if (ModelState.IsValid)
{
_context.Add(bookCopies);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["BookID"] = new SelectList(_context.Set <Book>(), "BookID", "Name", bookCopies.BookID);
ViewData["RetailerID"] = new SelectList(_context.Set <Retailer>(), "RetailerID", "Name", bookCopies.RetailerID);
return(View(bookCopies));
}
public IActionResult EditCopyInLibrary(BookCopies copy)
{
if (ModelState.IsValid)
{
copy = bookCopiesService.UpdateCopy(copy);
bookCopiesService.Commit();
TempData["Message"] = "Changes in copies applied!";
return(RedirectToAction("Details", "Library", new { id = copy.LibraryId }));
}
return(View(copy));
}
public IActionResult OnGet(int id)
{
Book = bookService.GetBookById(id);
if (Book == null)
{
return(RedirectToPage("NotFound"));
}
BookCopy = new BookCopies();
SelectLibrary = FilterList();
return(Page());
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
BookCopy = bookCopiesService.UpdateCopy(BookCopy);
bookCopiesService.Commit();
TempData["Message"] = "Changes in copies applied!";
return(RedirectToPage("BookCopiesList"));
}
return(Page());
}
//------------------------ A Mettre à jour -------------------------------------------------------------------- !!
public void ClearDatabase()
{
Users.RemoveRange(Users.Include(nameof(User.Rentals)));
Rentals.RemoveRange(Rentals.Include(nameof(Rental.Items)));
Books.RemoveRange(Books.Include(nameof(Book.Copies)).Include(nameof(Book.Categories)));
Categories.RemoveRange(Categories.Include(nameof(Category.Books)));
BookCopies.RemoveRange(BookCopies.Include(nameof(BookCopy.RentalItems)));
RentalItems.RemoveRange(RentalItems);
Reseed(nameof(Users));
Reseed(nameof(Rentals));
Reseed(nameof(Books));
Reseed(nameof(Categories));
Reseed(nameof(BookCopies));
Reseed(nameof(RentalItems));
this.SaveChanges();
}
public void ClearDatabase()
{
Users.RemoveRange(Users);
Rentals.RemoveRange(Rentals);
RentalItems.RemoveRange(RentalItems);
BookCopies.RemoveRange(BookCopies);
Books.RemoveRange(Books);
Categories.RemoveRange(Categories);
Reseed(nameof(Users));
Reseed(nameof(Books));
Reseed(nameof(Rentals));
Reseed(nameof(BookCopies));
Reseed(nameof(Categories));
Reseed(nameof(RentalItems));
SaveChanges();
}
public IActionResult UpdateLending(int id, int clientId, int libraryId, LendingForUpdateDto lending)
{
if (!_repo.ClientExists(clientId))
{
return(NotFound());
}
var lendingFromRepo = _repo.GetLending(clientId, id);
if (lendingFromRepo == null)
{
return(NotFound());
}
var library = _repo.GetLibrary(libraryId);
if (library != null && lendingFromRepo.ReturnDate == null && lending.ReturnDate != null)
{
var bookCopies = _repo.GetBookCopiesForLibrary(libraryId)
.SingleOrDefault(b => b.BookId == lendingFromRepo.BookId);
if (bookCopies == null)
{
var newBookCopies = new BookCopies()
{
LibraryId = libraryId,
BookId = lendingFromRepo.BookId,
NumberOfCopies = 1
};
_repo.CreateBookCopies(libraryId, newBookCopies);
}
else
{
bookCopies.NumberOfCopies++;
_repo.UpdateBookCopies(bookCopies);
}
}
if (lending.WitdrawDate == null)
{
lending.WitdrawDate = lendingFromRepo.WitdrawDate;
}
_mapper.Map(lending, lendingFromRepo);
_repo.UpdateLending(lendingFromRepo);
_repo.Save();
return(NoContent());
}
public Book CreateBook(string isbn, string title, string author, string editor, int numCopies)
{
Book book = Books.Create();
book.Isbn = isbn;
book.Title = title;
book.Author = author;
book.Editor = editor;
Books.Add(book);
BookCopy copy = App.Model.BookCopies.Create();
copy.BookId = book;
copy.AcquisitionDate = DateTime.Now;
BookCopies.Add(copy);
SaveChanges();
return(book);
}
public IActionResult PartialyUpdateLending(int id, int clientId, int libraryId, JsonPatchDocument <LendingForUpdateDto> patchDoc)
{
if (!_repo.ClientExists(clientId))
{
return(NotFound());
}
var lendingFromRepo = _repo.GetLending(clientId, id);
if (lendingFromRepo == null)
{
return(NotFound());
}
var lendingDto = _mapper.Map <LendingForUpdateDto>(lendingFromRepo);
var library = _repo.GetLibrary(libraryId);
patchDoc.ApplyTo(lendingDto);
if (library != null && lendingFromRepo.ReturnDate == null && lendingDto.ReturnDate != null)
{
var bookCopies = _repo.GetBookCopiesForLibrary(libraryId)
.SingleOrDefault(b => b.BookId == lendingFromRepo.BookId);
if (bookCopies == null)
{
var newBookCopies = new BookCopies()
{
LibraryId = libraryId,
BookId = lendingFromRepo.BookId,
NumberOfCopies = 1
};
_repo.CreateBookCopies(libraryId, newBookCopies);
}
else
{
bookCopies.NumberOfCopies++;
_repo.UpdateBookCopies(bookCopies);
}
}
_mapper.Map(lendingDto, lendingFromRepo);
_repo.UpdateLending(lendingFromRepo);
_repo.Save();
return(NoContent());
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
BookCopy.LibraryId = Library.Id;
BookCopy = bookCopiesService.CreateBookCopy(BookCopy);
TempData["Message"] = "Book Copies Added to Library";
Library.BookCopies.Add(BookCopy);
bookCopiesService.Commit();
return(RedirectToPage("/Libraries/LibraryDetails", new { id = BookCopy.LibraryId }));
}
SelectBook = bookService.GetBooks().Select(b => new SelectListItem
{
Value = b.Id.ToString(),
Text = b.Title
});
return(Page());
}
public ActionResult AddCopies(int id)
{
var profileData = Session["UserProfile"] as UserSession;
if (profileData == null)
{
return(RedirectToAction("Index", "Home"));
}
BookRepository bookRepository = new BookRepository();
ShelfRepository shelfRepository = new ShelfRepository();
BookCopies bookCopies = new BookCopies();
BookModel bookModel = bookRepository.SearchBookById(id);
bookCopies.BookModel = bookModel;
List <ShelfModel> shelfList = shelfRepository.GetAllShelf();
bookCopies.ShelfList = shelfList;
return(View(bookCopies));
}
public void UpdateBookCopies(BookCopies bookCopies)
{
}
public void DeleteBookCopies(BookCopies bookCopies)
{
_context.BookCopies.Remove(bookCopies);
}
public BookCopies CreateBookCopies(BookCopies bookCopies)
{
dbContext.BookCopies.Add(bookCopies);
return(bookCopies);
}
public BookCopies CreateBookCopy(BookCopies bookCopy)
{
var temp = dbContext.BookCopies.Add(bookCopy);
return(temp.Entity);
}
public BookCopies UpdateCopy(BookCopies bookCopy)
{
dbContext.Entry(bookCopy).State = EntityState.Modified;
return(bookCopy);
}
public ActionResult AddLoan(LoanModel loanModel)
{
try
{
LoanRepository loanRepository = new LoanRepository();
copiesRepository copiesRepository = new copiesRepository();
BookRepository bookRepository = new BookRepository();
ContentRatingRepository contentRatingRepository = new ContentRatingRepository();
MemberRepository memberRepository = new MemberRepository();
MembershipRepository membershipRepository = new MembershipRepository();
List <MemberModel> memberList = new List <MemberModel>();
LoanModel newLoanModel = new LoanModel();
newLoanModel.MemberList = memberRepository.GetAllMember();
CopiesModel copiesModel = new CopiesModel();
copiesModel = copiesRepository.SearchCopyById(loanModel.CopiesId);
BookModel bookModel = new BookModel();
bookModel = bookRepository.SearchBookById(copiesModel.BookId);
if (bookModel.BookType.Equals("Reference Book"))
{
ViewBag.Message = "Reference Books Can't be Loaned";
return(View(newLoanModel));
}
ContentRatingModel contentRatingModel = new ContentRatingModel();
contentRatingModel = contentRatingRepository.GetByContentId(bookModel.ContentRatingId);
MemberModel memberModel = new MemberModel();
memberModel = memberRepository.SearchMemberById(loanModel.MembershipId);
if (contentRatingModel.ContentRatingName.Equals("18+"))
{
var today = DateTime.Today;
var age = Convert.ToDateTime(memberModel.Dob);
var todayAge = today.Year - age.Year;
if (todayAge < 18)
{
ViewBag.Message = "Age Restricted Books Are Not Allowed";
return(View(newLoanModel));
}
}
MembershipModel membershipModel = new MembershipModel();
membershipModel = membershipRepository.GetMembershipByID(memberModel.MembershipId);
BookCopies bookCopiesModel = new BookCopies();
bookCopiesModel = loanRepository.GetAllLoanByMemberID(memberModel.MemberId);
if (bookCopiesModel.Quantities >= membershipModel.NoOfBooks)
{
ViewBag.Message = "No More Books Can be Loaned";
return(View(newLoanModel));
}
DateTime returnedDate = Convert.ToDateTime(loanModel.LoanDate);
loanModel.ReturnDate = returnedDate.AddDays(14).ToString("yyyy MMMM dd");
loanRepository.AddLoan(loanModel);
copiesRepository.UpdateCopiesStatus(loanModel.CopiesId);
var profileData = Session["UserProfile"] as UserSession;
var logModel = new LogModel
{
UserId = profileData.UserID,
TableName = "Loan",
Activity = "Added Loan",
LogDate = DateTime.Now
};
var logRepository = new logRepository();
logRepository.AddLog(logModel);
return(RedirectToAction("Dashboard", "Home"));
}
catch
{
return(RedirectToAction("Index", "Home"));
}
}
public void CreateBookCopies(int libraryId, BookCopies bookCopies)
{
var library = _context.Libraries.SingleOrDefault(l => l.Id == libraryId);
library.BookCopies.Add(bookCopies);
}
