public async Task TestDeleteReservation(bool isSuccessful, int id)
{
try
{
var selectQuery = $"select * from ReservationRequests";
var before = RemoteQueryDatabase(selectQuery);
await _service.DeleteReservation(id);
var after = RemoteQueryDatabase(selectQuery);
if (isSuccessful)
{
Assert.AreEqual(before.Rows.Count - 1, after.Rows.Count);
}
else
{
Assert.AreEqual(before.Rows.Count, after.Rows.Count);
}
}
catch (Exception ex)
{
_logger.Error(ex.Message);
throw new Exception(ex.InnerException.Message);
}
}
public void CRUD_CreateAndDeleteReservation_CheckSuccress()
{
//arrange
IReservationRepository reservationRepository = new MySqlReservationRepository(Connstr);
IReservationService sut = new ReservationService(reservationRepository);
DateTime startDate = new DateTime(2019, 04, 25, 10, 00, 00);
DateTime endDate = new DateTime(2019, 04, 29, 10, 00, 00);
bool isPickedUp = false;
int customerFk = 1;
int carFk = 1;
decimal carPricePerDay = 30.35m;
//act
int reservationCountBefor = sut.GetAllReservation().Count;
sut.AddReservation(startDate, endDate, isPickedUp, customerFk, carFk, carPricePerDay);
IReadOnlyList <Reservation> reservations = sut.GetAllReservation();
int reservationCountAfter = reservations.Count;
int reservationId = reservations[reservationCountAfter - 1].ReservationId;
sut.UpdateReservation(true, reservationId);
sut.DeleteReservation(reservationId);
//assert
Assert.IsTrue(reservationCountBefor < reservationCountAfter);
}
public IActionResult ReturnBook(string isbn)
{
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
_ReservationService.DeleteReservation(isbn, userId);
return(RedirectToAction("ReservationListForUserID", "Reservations"));
}
// GET: Reservation/Delete/5
public ActionResult Delete(int id)
{
reservationService.DeleteReservation(id);
var hs = reservationService.GetAllReservationByUser(currentUser.id);
return(RedirectToAction("Indexreservation", hs));
}
public IActionResult DeleteConfirmed(int id)
{
var reservation = _reservationService.GetReservationByCondition(b => b.ReservationID == id).FirstOrDefault();
_reservationService.DeleteReservation(reservation);
_reservationService.Save();
return(RedirectToAction(nameof(Index)));
}
// GET: Reservation/AnnulerReservation/5
public ActionResult AnnulerReservation(int id)
{
var hs = reservationService.GetAllReservationByUser(currentUser.id);
reservationService.DeleteReservation(id);
return(RedirectToAction("Reserver", hs));
}
public async Task ClubServiceTest()
{
ImportDataTest import = new ImportDataTest();
import.InitContext();
try
{
_context = import._context;
IReservationRepository reservationRepository = new ReservationRepository(_context);
cr = new ReservationService(reservationRepository);
AircraftReservation ar = new AircraftReservation();
ar.DateFrom = DateTime.Now;
ar.DateTo = DateTime.Now.AddHours(1);
ar.TailNumber = "4xCGC";
ar.IdNumber = "123456";
_context.AircraftReservations.Add(ar);
_context.SaveChanges();
var reser = await cr.GetReservation();
await cr.AddReservation(ar);
ar.IdNumber = "098765";
await cr.EditReservation(ar);
reser = await cr.GetAircraftReservation(ar.TailNumber);
var aa = await cr.AddReservation(ar);
AircraftReservation ab = new AircraftReservation();
ab.DateFrom = ar.DateTo;
ab.DateTo = ab.DateFrom.AddHours(5);
ab.TailNumber = ar.TailNumber;
aa = await cr.AddReservation(ab);
reser = await cr.GetReservation();
reser = await cr.GetPilotReservation(ar.IdNumber);
await cr.DeleteReservation(ar.Id);
reser = await cr.GetReservation();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
public async Task ClubServiceAddTest()
{
ImportDataTest import = new ImportDataTest();
import.InitContext();
try
{
_context = import._context;
IReservationRepository reservationRepository = new ReservationRepository(_context);
IMemberRepository memberRepository = new MemberRepository(_context);
mr = new MemberService(memberRepository);
Pilot p = await mr.GetPilotById(15);
cr = new ReservationService(reservationRepository);
AircraftReservation ar = new AircraftReservation();
ar.DateFrom = new DateTime(2019, 08, 29, 14, 23, 00);
ar.DateTo = new DateTime(2019, 08, 29, 19, 20, 00);
ar.TailNumber = "4xCGC";
ar.IdNumber = "123456";
ar.AircraftId = 8;
ar.ReservationInfo = new UserInfo(p).GetJason();
var reser = await cr.GetReservation();
await cr.AddReservation(ar);
ar.DateFrom = new DateTime(2019, 08, 29, 19, 22, 00);
ar.DateTo = new DateTime(2019, 08, 29, 20, 20, 00);
await cr.AddReservation(ar);
reser = await cr.GetReservation();
reser = await cr.GetPilotReservation(ar.IdNumber);
await cr.DeleteReservation(ar.Id);
reser = await cr.GetReservation();
await cr.AddReservation(ar);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
private void DeleteButton_Click(object sender, EventArgs e)
{
Program app = Program.GetInstance();
UserService userService = app.GetService <UserService>("users");
ReservationService reservationService = app.GetService <ReservationService>("reservations");
// Ask for confirmation
if (!GuiHelper.ShowConfirm("Weet je zeker dat je deze reservering wilt verwijderen?"))
{
return;
}
if (!reservationService.DeleteReservation(reservation))
{
GuiHelper.ShowError("Kon reservering niet verwijderen");
return;
}
// Redirect to screen
ReservationList reservationListScreen = app.GetScreen <ReservationList>("reservationList");
app.ShowScreen(reservationListScreen);
GuiHelper.ShowInfo("Reservering succesvol verwijderd");
}
public async Task <IActionResult> DeleteConfirmed(int id)
{
await _service.DeleteReservation(id);
return(RedirectToAction(nameof(Index)));
}
public void DeleteReservation(string CarId, string CustomerId)
{
int.TryParse(CarId, out int parsedCarId);
int.TryParse(CustomerId, out int parsedCustomerId);
_service.DeleteReservation(parsedCarId, parsedCustomerId);
}
public async Task <bool> DeleteReservation(int id)
{
return(await _reservationService.DeleteReservation(id));
}