public List <DiskInformation> GetInformationDisk(string title)
{
List <DiskInformation> lstDiskInformation = new List <DiskInformation>();
TitleDisk titleDisk = _context.TitleDisks.Find(title);
if (titleDisk != null)
{
List <DiskInformation> lstDiskRented = (from disk in titleDisk.Disks
join detail in _context.RentalRecordDetails
on disk.DiskID equals detail.DiskID
join record in _context.RentalRecords
on detail.RentalRecordID equals record.RentalRecordID
orderby detail.DateReturn
where disk.Status.Equals(StatusOfDisk.RENTED) &&
detail.LateCharge is null &&
detail.DateReturnActual is null
select(
new DiskInformation
{
DiskID = disk.DiskID,
Status = disk.Status,
CustomerName = record.Customer.Name,
DateReturn = detail.DateReturn,
DateResevartion = null
})).ToList();
List <DiskInformation> lstDiskOn_Hold = (from disk in titleDisk.Disks
join res in _context.Reservations
on disk.DiskID equals res.DiskID
orderby res.DateReservation
where disk.Status.Equals(StatusOfDisk.ON_HOLD)
select(
new DiskInformation
{
DiskID = disk.DiskID,
Status = disk.Status,
CustomerName = res.Customer.Name,
DateReturn = null,
DateResevartion = res.DateReservation
})).ToList();
List <DiskInformation> lstDiskOn_Shelf = (from disk in titleDisk.Disks
where disk.Status.Equals(StatusOfDisk.ON_SHELF)
select(
new DiskInformation
{
DiskID = disk.DiskID,
Status = disk.Status,
CustomerName = null,
DateReturn = null,
DateResevartion = null
})).ToList();
lstDiskInformation = lstDiskRented;
lstDiskInformation.AddRange(lstDiskOn_Shelf);
lstDiskInformation.AddRange(lstDiskOn_Hold);
}
return(lstDiskInformation.OrderBy(x => x.DiskID).Where(w => w.Status != StatusOfDisk.DELETE).ToList());
}
/// <summary>
/// Kiểm tra xóa tựa đề
/// </summary>
/// <param name="title"></param>
/// <returns>true : tựa đề không có đĩa quá hạn hoặc đang cho thuê</returns>
/// <returns>false : tựa đề có đĩa quá hạn hoặc đang cho thuê</returns>
///
public bool IsDelete(TitleDisk title)
{
if (titleResponsitory.IsDelete(title.Title))
{
return(true);
}
return(false);
}
public void AddReservation(Customer customer, TitleDisk titleDisk)
{
Reservation reservation = new Reservation();
reservation.CustomerID = customer.CustomerID;
reservation.DateReservation = DateTime.Now;
reservation.Title = titleDisk.Title;
reservationRepository.AddReservation(reservation);
}
/// <summary>
/// Thêm tựa đề
/// </summary>
/// <param name="title">tựa đề</param>
public void AddTitle(TitleDisk title)
{
titleResponsitory.Insert(title);
}
