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)); }