/// <summary>
/// Gets cartridges for rent list
/// </summary>
/// <returns>List of cartridges for rent</returns>
public async Task <IEnumerable <CartridgeForRentList> > CartridgesForRent()
{
var cartridgesDb = await CartridgeRepo
.GetAll()
.Include(c => c.Movie)
.AsNoTracking()
.ToListAsync();
var result = new List <CartridgeForRentList>(cartridgesDb.Count);
foreach (var c in cartridgesDb)
{
var cartridgeResult = Mapper.Map <CartridgeForRentList>(c);
cartridgeResult.MovieCoverUrl = await MovieService.GetMovieCoverUrl(c.MovieId);
cartridgeResult.CopiesAvaible = await CartridgeCopyRepo
.GetAll(cc => cc.CartridgeId == c.Id)
.Where(cc => cc.Avaible)
.CountAsync();
cartridgeResult.Language = c.Language;
result.Add(cartridgeResult);
}
return(result);
}
/// <summary>
/// Gets cartridge for rent by id
/// </summary>
/// <param name="id">Cartridge id</param>
/// <returns>Cartridge for rent</returns>
public async Task <CartridgeForRent> CartridgeForRent(Guid id)
{
var cartridgeDb = await CartridgeRepo
.GetAll()
.Include(c => c.Movie)
.ThenInclude(m => m.Images)
.ThenInclude(i => i.Image)
.AsNoTracking()
.FirstOrDefaultAsync(c => c.Id == id);
if (cartridgeDb == null)
{
return(null);
}
var result = Mapper.Map <CartridgeForRent>(cartridgeDb);
result.Avaible = await CartridgeCopyRepo
.GetAll(cc => cc.CartridgeId == result.Id)
.Where(cc => cc.Avaible)
.CountAsync();
result.OtherLanguages = await CartridgeRepo
.GetAll(c => c.MovieId == cartridgeDb.MovieId && c.Id != id)
.Select(c => new LanguageLink {
CartridgeId = c.Id, Language = c.Language
})
.ToListAsync();
return(result);
}
/// <summary>
/// Gets cartridge by id
/// </summary>
/// <param name="id">Cartridge id</param>
/// <returns>Cartridge with details</returns>
public async Task <CartridgeDetails> GetCartridge(Guid id)
{
var cartridgeDb = await CartridgeRepo
.GetAll()
.Include(c => c.Copies)
.Include(c => c.Movie)
.FirstOrDefaultAsync(c => c.Id == id);
var cartridge = Mapper.Map <CartridgeDetails>(cartridgeDb);
cartridge.CopiesAvaible = cartridgeDb.Copies.Count(copy => copy.Avaible);
cartridge.CopiesUnavaible = cartridgeDb.Copies.Count - cartridge.CopiesAvaible;
return(cartridge);
}
/// <summary>
/// Gets cartridges for list/table display
/// </summary>
/// <returns>List of cartridges</returns>
public async Task <IEnumerable <CartridgeForList> > GetForList()
{
var cartridgesDb = await CartridgeRepo
.GetAll()
.Include(c => c.Copies)
.Include(c => c.Movie)
.ToListAsync();
var cartridges = cartridgesDb.Select(c =>
{
var cartridge = Mapper.Map <CartridgeForList>(c);
cartridge.CopiesAvaible = c.Copies.Count(copy => copy.Avaible);
cartridge.CopiesUnavaible = c.Copies.Count - cartridge.CopiesAvaible;
return(cartridge);
});
return(cartridges);
}
/// <summary>
/// Allows to add new cartridge
/// </summary>
/// <param name="request">Cartridge add request</param>
public async Task AddCartridge(CartridgeAddRequest request)
{
var cartridgeToAdd = Mapper.Map <Cartridge>(request);
await CartridgeRepo.CreateAsync(cartridgeToAdd);
await CartridgeRepo.SaveChangesAsync();
var cartridgeDb = await CartridgeRepo
.GetAll()
.AsNoTracking()
.FirstOrDefaultAsync(c => c.Id == cartridgeToAdd.Id);
var copiesAmount = request.AvaibleAmount + request.UnavaibleAmount;
if (copiesAmount == 0)
{
return;
}
await AddCopies(copiesAmount, request.AvaibleAmount, cartridgeDb.Id);
}
/// <summary>
/// Gets cartridges details for edition
/// </summary>
/// <param name="id">Cartridge id</param>
/// <returns>Cartridge edit details</returns>
public async Task <CartridgeEditDetails> GetEditDetails(Guid id)
{
var cartridgeDb = await CartridgeRepo
.GetAll()
.Include(c => c.Copies)
.Include(c => c.Movie)
.FirstOrDefaultAsync(c => c.Id == id);
var cartridge = Mapper.Map <CartridgeEditDetails>(cartridgeDb);
cartridge.CopiesRented = await RentalRepo
.GetAll()
.Where(r => r.Returned != null && cartridgeDb.Copies.Select(c => c.Id).Contains(r.CartridgeCopyId))
.CountAsync();
cartridge.CopiesAvaible = cartridgeDb.Copies.Count(c => c.Avaible);
cartridge.CopiesUnavaible = cartridgeDb.Copies.Count(c => !c.Avaible);
cartridge.MaxCopiesToMakeAvaible = cartridge.CopiesUnavaible - cartridge.CopiesRented;
cartridge.MaxCopiesToMakeUnavaible = cartridge.CopiesAvaible;
return(cartridge);
}
/// <summary>
/// Updates cartridge
/// </summary>
/// <param name="cartridgeId">Cartridge to update id</param>
/// <param name="request">Update data request</param>
/// <returns>True if successful</returns>
public async Task <bool> UpdateCartridge(Guid cartridgeId, CartridgeUpdateRequest request)
{
var cartridgeDb = await CartridgeRepo
.GetAll()
.FirstOrDefaultAsync(c => c.Id == cartridgeId);
if (cartridgeDb == null)
{
return(false);
}
Mapper.Map(request, cartridgeDb);
await MakeCopiesAvaOrUnava(request.CopiesToMakeAva, true, cartridgeDb.Id);
await MakeCopiesAvaOrUnava(request.CopiesToMakeUnava, false, cartridgeDb.Id);
var copiesAmount = request.CopiesToAddAva + request.CopiesToAddUnava;
var copies = new List <CartridgeCopy>(copiesAmount);
for (int i = 0; i < copiesAmount; ++i)
{
copies.Add(new CartridgeCopy
{
CartridgeId = cartridgeDb.Id,
Avaible = i < request.CopiesToAddAva
});
}
CartridgeCopyRepo.AddRange(copies);
await CartridgeRepo.SaveChangesAsync();
CartridgeRepo.Update(cartridgeDb);
await CartridgeRepo.SaveChangesAsync();
return(true);
}
/// <summary>
/// Gets data for given cartridge rent form
/// </summary>
/// <param name="cartridgeId">Cartridge to rent id</param>
/// <param name="userId">User that wants to rent it</param>
/// <returns>Data for cartridge rental form</returns>
public async Task <CartridgeRental> CartridgeForRentForm(Guid cartridgeId, Guid userId)
{
var userDb = await ShopUserRepo
.GetAll()
.AsNoTracking()
.FirstOrDefaultAsync(u => u.UserId == userId.ToString());
if (userDb == null)
{
return(null);
}
var unsettledRentals = await RentalRepo
.GetAll(r => r.ShopUserId == userDb.Id)
.Where(r => r.Returned == null)
.ToListAsync();
var result = new CartridgeRental();
if (unsettledRentals.Count >= 3)
{
result.UserCanBorrow = false;
return(result);
}
if (unsettledRentals.Any(r => DateTime.UtcNow > r.Rented.AddDays(r.DaysToReturn)))
{
result.UserCanBorrow = false;
return(result);
}
result.UserCanBorrow = true;
var cartridgeDb = await CartridgeRepo
.GetAll()
.AsNoTracking()
.Include(c => c.Movie)
.FirstOrDefaultAsync(c => c.Id == cartridgeId);
if (cartridgeDb == null)
{
return(null);
}
var copiesAvaible = await CartridgeCopyRepo
.GetAll(c => c.CartridgeId == cartridgeId)
.CountAsync(c => c.Avaible);
result.Avaible = copiesAvaible;
if (copiesAvaible <= 0)
{
return(result);
}
Mapper.Map(cartridgeDb, result);
var userAddressesDb = await AddressRepo
.GetAll(a => a.UserId == userId.ToString() && a.IsActive)
.ToListAsync();
result.Addresses = Mapper.Map <IEnumerable <AddressDto> >(userAddressesDb);
return(result);
}
/// <summary>
/// Rents 1st of avaible catridge copies by given cartridge id to given user
/// Adds new Rental to database
/// </summary>
/// <param name="cartridgeId">Cartridge id</param>
/// <param name="userId">User that wants to rent id</param>
/// <param name="request">Rental request</param>
/// <returns>Null if cartridge or user is not found. True if user could rent given cartridge, false otherwise.</returns>
public async Task <bool?> RentCartridge(Guid cartridgeId, Guid userId, CartridgeRentRequest request)
{
var cartridge = await CartridgeRepo
.GetAll()
.AsNoTracking()
.FirstOrDefaultAsync(c => c.Id == cartridgeId);
if (cartridge == null)
{
return(null);
}
var copy = await CartridgeCopyRepo
.GetAll()
.FirstOrDefaultAsync(c => c.CartridgeId == cartridgeId && c.Avaible);
if (copy == null)
{
return(false);
}
var address = new Address();
if (request.Delivery == collectionInPerson)
{
address = null;
}
else if (request.AddAddress)
{
request.NewAddress.UserId = userId.ToString();
address = await AddressService.CreateAddress(request.NewAddress);
}
else
{
address = await AddressRepo
.GetAll()
.FirstOrDefaultAsync(a => a.Id == new Guid(request.AddressId));
if (address == null)
{
return(null);
}
}
var shopUser = await ShopUserRepo
.GetAll()
.AsNoTracking()
.FirstOrDefaultAsync(su => su.UserId == userId.ToString());
var rental = new Rental
{
DaysToReturn = cartridge.DaysToReturn,
RentPrice = cartridge.RentPrice,
Rented = DateTime.UtcNow,
AddressId = address?.Id,
CartridgeCopyId = copy.Id,
Delivery = request.Delivery,
ShopUserId = shopUser.Id,
};
copy.Avaible = false;
await CartridgeCopyRepo.SaveChangesAsync();
await RentalRepo.CreateAsync(rental);
await RentalRepo.SaveChangesAsync();
return(true);
}