public async void getResv(Equipments equipments)
{
var today = int.Parse(DateTime.Now.ToString("yyyyMMdd"));
// Console.WriteLine(today);
var ResvEquipments = await _context.EquipmentsReserve
.Where(x => x.E_ID == equipments.E_ID)
.Where(x => x.Resv_status == "reserved")
.Where(x => x.Resv_time < today)
.ToListAsync();
foreach (var item in ResvEquipments)
{
EquipmentsReserve resv = await _context.EquipmentsReserve.FindAsync(item.Resv_ID);
Equipments Equipments = await _context.Equipments.FindAsync(item.E_ID);
User user = await _context.Users.FindAsync(item.Resv_by);
user.Reserved = 0;
resv.Resv_status = "overdue";
Equipments.E_amount += 1;
Equipments.E_resv -= 1;
}
await _context.SaveChangesAsync();
}
public async Task <IActionResult> getReserv([FromBody] int resvid)
{
EquipmentsReserve ResvItem = await _context.EquipmentsReserve.FindAsync(resvid);
User user = await _context.Users.FindAsync(ResvItem.Resv_by);
Equipments Equipments = await _context.Equipments.FindAsync(ResvItem.E_ID);
EquipmentForRentDto rentItem = new EquipmentForRentDto();
user.Reserved = 0;
Equipments.E_resv -= 1;
Equipments.E_amount += 1;
ResvItem.Resv_status = "rented";
rentItem.E_ID = ResvItem.E_ID;
rentItem.Rent_by = ResvItem.Resv_by;
await _context.SaveChangesAsync();
await Rent(rentItem);
return(StatusCode(201));
}
public async Task <IActionResult> Reserv([FromBody] EquipmentForResvDto equipmentForResvDto)
{
var ResvItem = new EquipmentsReserve();
ResvItem.E_ID = equipmentForResvDto.E_ID;
ResvItem.Resv_by = equipmentForResvDto.Resv_by;
ResvItem.Resv_time = int.Parse(DateTime.Now.ToString("yyyyMMdd"));
ResvItem.Resv_status = "reserved";
User user = await _context.Users.FindAsync(equipmentForResvDto.Resv_by);
user.Reserved = 1;
Equipments Equipments = await _context.Equipments.FindAsync(ResvItem.E_ID);
Equipments.E_amount -= 1;
Equipments.E_resv += 1;
await _context.EquipmentsReserve.AddAsync(ResvItem);
await _context.SaveChangesAsync();
return(StatusCode(201));
}
