public ActionResult <List <TransactionLists> > GetByEndDate()
{
List <RentalContract> listofExpiringRentalContracts = new List <RentalContract>();
List <TransactionLists> RentalTransactions = new List <TransactionLists>();
var currentDate = DateTime.Today;
//need to get a list of rental contracts
var listOfAllRentals = _context.RentalContracts.ToList();
foreach (var rentalUser in listOfAllRentals)
{
if (rentalUser.EndDate == currentDate)
{
//bado: list fiya book name DONE start data DONE end date DONE branch name DONE and user name Done
listofExpiringRentalContracts.Add(rentalUser);
//set the is available to 1
var currentRentalID = rentalUser.ContractID ?? default(int);
var containsBookCopyID =
_context.Contain.FirstOrDefault(x => x.Rental_ContractcontractID == currentRentalID);
var currentBookCopyID = containsBookCopyID.Book_CopycopyID;
var bookCopy = _context.BookCopies.FirstOrDefault(x => x.CopyID == currentBookCopyID);
var bookIsbn = bookCopy.ISBN;
var currentBook = _context.Books.FirstOrDefault(x => x.ISBN == bookIsbn);
var bookName = currentBook.Name;
var startDate = rentalUser.StartDate;
var endDate = rentalUser.EndDate;
var ownerContractID = bookCopy.OWNERcontractId;
var ownerContractCurrent =
_context.OwnerContracts.FirstOrDefault(x => x.ContractID == ownerContractID);
var branchId = ownerContractCurrent.BranchID;
var currentBranch = _context.Branches.FirstOrDefault(x => x.BranchID == branchId);
var branchName = currentBranch.Name;
var userID = ownerContractCurrent.UserID;
var user = _context.Users.FirstOrDefault(x => x.UserId == userID);
var userName = user.Name;
var tran = new TransactionLists(bookName, startDate, endDate, branchName, userName);
RentalTransactions.Add(tran);
bookCopy.IsAvailable = true;
}
}
return(RentalTransactions);
}
public ActionResult <List <TransactionLists> > GetOwnersByEndDate()
{
List <OwnerContract> listofExpiringOwnerContracts = new List <OwnerContract>();
List <TransactionLists> listOfOwnersToClear = new List <TransactionLists>();
var currentDate = DateTime.Today;
var listOfAllOwners = _context.OwnerContracts.ToList();
foreach (var ownerUser in listOfAllOwners)
{
if (ownerUser.EndDate == currentDate)
{
listofExpiringOwnerContracts.Add(ownerUser);
var branchId = ownerUser.BranchID;
var userID = ownerUser.UserID;
var startDate = ownerUser.StartDate;
var endDate = ownerUser.EndDate;
var ownerContractID = ownerUser.ContractID;
var bookCopy = _context.BookCopies.FirstOrDefault(x => x.OWNERcontractId == ownerContractID);
var bookISBN = bookCopy.ISBN;
var book = _context.Books.FirstOrDefault(x => x.ISBN == bookISBN);
var bookName = book.Name;
var branch = _context.Branches.FirstOrDefault(x => x.BranchID == branchId);
var branchName = branch.Name;
var user = _context.Users.FirstOrDefault(x => x.UserId == userID);
var userName = user.Name;
var transactionOwner = new TransactionLists(bookName, startDate, endDate, branchName, userName);
listOfOwnersToClear.Add(transactionOwner);
}
}
return(listOfOwnersToClear);
}