//Changes the start or end date of a reservation
public int ChangeReservation(int reservationNumber, DateTime startDate, DateTime endDate)
{
e errCode = e.success;
if (Validation.invalidRes(reservationNumber))
{
errCode = e.invalidRes;
}
else if (Validation.activeRes(reservationNumber))
{
errCode = e.activeRes;
}
else if (Validation.sBeforeToday(startDate))
{
errCode = e.sBeforeToday;
}
else if (Validation.sAfterEnd(startDate, endDate))
{
errCode = e.sAfterEnd;
}
else
{
ReservationDB resDB = new ReservationDB();
if (!resDB.Update(reservationNumber, startDate, endDate))
{
errCode = e.updateFail;
}
}
return(Convert.ToInt16(errCode));
}
public List <Reservation> ListReservations()
{
ReservationDB resDB = new ReservationDB();
DataTable data = resDB.GetReservationWithOwnerNumbers();
return(GetReservations(data));
}
//Cancels a reservation
public int CancelReservation(int reservationNumber)
{
e errCode = e.success;
if (Validation.invalidRes(reservationNumber))
{
errCode = e.invalidRes;
}
if (Validation.activeRes(reservationNumber))
{
errCode = e.activeRes;
}
else
{
ReservationDB resDB = new ReservationDB();
PetReservation pr = new PetReservation();
Discount d = new Discount();
d.removeDiscount(reservationNumber);
pr.RemoveEntireRes(reservationNumber);
if (!resDB.Delete(reservationNumber))
{
errCode = e.deleteFail;
}
}
return(Convert.ToInt16(errCode));
}
public static int deleteDogFromReservation(int reservationNumber, int petNumber)
{
Search search = new HawkeyehvkBLL.Search();
if (!search.validateReservationNumber(reservationNumber))// check reservation number
{
return(1);
}
else if (!search.validatePetNumber(petNumber))// check pet number
{
return(2);
}
else if (!ReservationDB.isDogInReservation(reservationNumber, petNumber))// check that dog is in reservation
{
return(3);
}
else if (isReservationActive(reservationNumber))//check is res is active
{
return(4);
}
else
{
// before running check if the reservation is going from 3 to 2 dogs in order to remove the discount
int count = PetReservation.listPetRes(reservationNumber).Count;
if (count == 3)
{
Discount.deleteReservationDiscount(2, reservationNumber);
}
return(ReservationDB.deleteDogFromReservationDB(reservationNumber, petNumber));
}
}
public static int updateReservation(int resNum, DateTime startDate, DateTime endDate, int petNumber, int runNumber)
{
ReservationDB db = new ReservationDB();
Search check = new Search();
if (check.validateReservationNumber(resNum))
{
if (check.validatePetNumber(petNumber) == false)
{
return(-10);
}
//return -11 Start Date In the past
if (startDate < DateTime.Now)
{
return(-11);
}
//return -12 Start Date After end date
if (startDate > endDate)
{
return(-12);
}
//return -13 Dog has reservation for all or part of period
if (check.validateConflictingReservations(petNumber, startDate, endDate) == false)
{
return(-13);
}
//return -14 No Run Available
if (Run.checkRunAvailability(startDate, endDate, check.getPetSize(petNumber)) <= 0)
{
return(-14);
}
//return -15 Insert Failed
if (Reservation.updateReservation(resNum, startDate, endDate, petNumber, runNumber) == 1)
{
return(1);
}
else
{
return(-15);
}
//return -1 if expired or missing Vaccinations
int count = PetVaccination.checkVaccinations(petNumber, endDate);
if (count == -1)
{
return(-1);
}
else
{
return(0);
}
}
else
{
return(-2);
}
}
//crée une nouvelle reservation
public static int NewReservation(String NameClient, String FirstNameClient, DateTime CheckIn, DateTime CheckOut, int idRoom, int PriceIncreased)
{
int IdReservation = ReservationDB.NewReservation(NameClient, FirstNameClient, CheckIn, CheckOut);
RoomReservationManager.NewRoomReservation(IdReservation, idRoom, PriceIncreased);
return(IdReservation);
}
/// <summary>
/// Delete a reservation:
/// 1. delete all RoomReservation
/// 2. delete Reservation
/// 3. delete Client
/// </summary>
public static void DeleteReservation(int idReservation)
{
Reservation reservation = ReservationDB.GetReservation(idReservation);
ReservationDB.DeleteRoomReservation(idReservation);
ReservationDB.DeleteReservation(idReservation);
ClientDB.DeleteClient(reservation.Client.IdClient);
}
//resCancaled
//Makes a reservation for a dog alone in a run
public List <int> AddReservation(int petNumber, DateTime startDate, DateTime endDate)
{
e errCode = e.success;
int resNumber = -1;
List <int> retVals = new List <int>();
if (Validation.sBeforeToday(startDate))
{
errCode = e.sBeforeToday;
}
else if (Validation.sAfterEnd(startDate, endDate))
{
errCode = e.sAfterEnd;
}
else if (Validation.invalidPet(petNumber))
{
errCode = e.invalidPet;
}
else if (Validation.runUnavailable(startDate, endDate, petNumber))
{
errCode = e.runUnavailable;
}
else if (Validation.alreadyReserved(startDate, endDate, petNumber))
{
errCode = e.alreadyReserved;
}
else
{
ReservationDB resDB = new ReservationDB();
resNumber = resDB.Add(startDate, endDate);
if (resNumber < 0)
{
errCode = e.insertFail;
}
else
{
if (AddToReservation(resNumber, petNumber) < -10)
{
errCode = e.insertFail;
}
else
{
if (ListExpOrMissVaccs(petNumber, endDate).Count != 0)
{
errCode = e.vaccInvalid;
}
}
}
}
retVals.Add(Convert.ToInt16(errCode));
retVals.Add(resNumber);
return(retVals);
}
public static List <Run> listAvailableRuns(DateTime start, DateTime end)
{
List <Run> runs = new List <Run>();
ReservationDB db = new ReservationDB();
foreach (DataRow row in db.listAvailableRunsDB(start, end).Tables["hvk_runsAvail"].Rows)
{
runs.Add(convertToRun(row));
}
return(runs);
}
/// <summary>
/// Check data before inserting into database
/// </summary>
public static int AddReservation(string firstName, string lastName, DateTime arrival, DateTime departure, int[] roomIds)
{
//Insert the reservation
int idClient = ClientDB.AddClient(firstName, lastName);
int idReservation = ReservationDB.AddReservation(arrival, departure, idClient);
foreach (int roomId in roomIds)
{
ReservationDB.AddRoomReservation(idReservation, roomId);
}
return(idReservation);
}
public static bool IsExistIsCorrect(string firstname, string lastname, int idReservation)
{
Reservation reservation = ReservationDB.GetReservation(idReservation);
if (!reservation.Client.Firstname.Equals(firstname))
{
return(false);
}
if (!reservation.Client.Lastname.Equals(lastname))
{
return(false);
}
return(true);
}
public static Reservation getReservation(int resNum)
{
ReservationDB db = new ReservationDB();
DataSet ds = db.getReservationDB(resNum);
Reservation res = fillReservationModified(ds)[0];
ReservedService rs = new ReservedService();
res.petReservationList.ForEach(delegate(PetReservation pres) {
List <ReservedService> ser = rs.listReservedService(pres.petResNumber);
if (ser.Count != 0)
{
pres.serviceList = rs.listReservedService(pres.petResNumber);
}
});
return(res);
}
public static int cancelReservation(int reservationNumber)
{
Search search = new HawkeyehvkBLL.Search();
// check reservation number
if (!search.validateReservationNumber(reservationNumber))// check reservation number
{
return(1);
}
else if (isReservationActive(reservationNumber))
{
return(4);
}
else
{
return(ReservationDB.cancelReservationDB(reservationNumber));
}
}
public ReservationController()
{
//***instantiate the EmployeeDB object to communicate with the database
reservationDB = new ReservationDB();
reservations = reservationDB.AllReservations;
reservation = new Reservation();
reservedRooms = new bool[31, 5];
for (int x = 0; x < 31; x++)
{
for (int y = 0; y < 5; y++)
{
reservedRooms[x, y] = false;
}
}
determineBookedRooms();
}
public static int addToReservation(int reservationNumber, int petNumber)
{
ReservationDB db = new ReservationDB();
Search search = new Search();
try
{
if (!search.validatePetNumber(petNumber))
{
return(-1);
}
else if (!search.validateReservationNumber(reservationNumber))
{
return(-2);
}
else if (Search.validateOwnerForPet(reservationNumber, petNumber) < 0)
{
return(-4);
}
else if (search.validateReservationForPet(petNumber, reservationNumber))
{
return(-3);
}
// add discount if we are adding a third pet reservation
int count = PetReservation.listPetRes(reservationNumber).Count;
if (count == 2)
{
Discount.addReservationDiscount(2, reservationNumber);
}
db.addToReservationDB(reservationNumber, petNumber);
return(1);
}
catch
{
//Exception msg goes here
return(-4);
}
}
public static List <Reservation> listReservations()
{
ReservationDB db = new ReservationDB();
DataSet ds = db.listResevationsDB();
List <Reservation> reservationList = fillReservationModified(ds);
ReservedService rs = new ReservedService();
reservationList.ForEach(delegate(Reservation res) {
res.petReservationList.ForEach(delegate(PetReservation pres) {
List <ReservedService> ser = rs.listReservedService(pres.petResNumber);
if (ser.Count != 0)
{
pres.serviceList = rs.listReservedService(pres.petResNumber);
}
});
});
return(reservationList);
}
public static int changeReservation(int reservationNumber, DateTime startDate, DateTime endDate)
{
Search search = new HawkeyehvkBLL.Search();
if (!search.validateReservationNumber(reservationNumber))// check reservation number
{
return(1);
}
else if (startDate > endDate) // check that dates are in a valid order
{
return(2);
}
List <Pet> pets = Pet.listPetsByReservation(reservationNumber);
int largeDogs = 0;
foreach (Pet pet in pets)
{
if (pet.size == 'L')
{
largeDogs++;
}
}
// check that there are available runs
if (Run.checkRunAvailability(startDate, endDate, 'L') < largeDogs ||
Run.checkRunAvailability(startDate, endDate, 'R') < pets.Count)
{
return(3);
}
// change the res dates
try
{
ReservationDB db = new ReservationDB();
db.changeReservationDB(reservationNumber, startDate, endDate);
} catch
{
return(4);
}
return(0);
}
// Appelle la requête qui permet d'ajouter une réservation à la table
public static int AddReservation(DateTime dateReservation, string clientFirstname, string clientLastname, DateTime dateStart, DateTime dateEnd, decimal totalPrice)
{
return(ReservationDB.AddReservation(dateReservation, clientFirstname, clientLastname, dateStart, dateEnd, totalPrice));
}
//SUpprime une réservation en fonction d'un id
public static void DeleteReservationRoom(int IdReservation)
{
RoomReservationDB.DeleteReservationRoom(IdReservation);
ReservationDB.DeleteReservation(IdReservation);
}
/// <summary>
/// Return a reservation, selected with id
/// </summary>
public static Reservation GetReservation(int idReservation)
{
return(ReservationDB.GetReservation(idReservation));
}
public VisualisationPage()
{
InitializeComponent();
reservationDB = new ReservationDB();
populate();
}
//recupère une réservation en fonction du nom, de l'id de la reservation et du prenom
public static Reservation GetReservationByIdName(int idReservation, String FirstName, String LastName)
{
return(ReservationDB.GetReservationByIdName(idReservation, FirstName, LastName));
}
// Appelle la requête qui permet de supprimer une réservation de la table (en fonction de son identifiant en paramètre)
public static void RemoveReservation(int idReservation)
{
ReservationDB.RemoveReservation(idReservation);
}
public static bool CancelReservationFromId(int IdReservation)
{
return(ReservationDB.CancelReservationFromId(IdReservation));
}
public static Reservation GetReservationsFromId(int idRes)
{
return(ReservationDB.GetReservationsFromId(idRes));
}
public static List <Reservation> GetReservationsFromUserId(int idUser)
{
return(ReservationDB.GetReservationsFromUserId(idUser));
}
public static int SaveReservation(Reservation reservation)
{
return(ReservationDB.SaveReservation(reservation));
}
// Appelle la requête qui permet de vérifier l'existence d'une réservation dans la table
public static Boolean LoginReservation(int idReservation, string firstname, string lastname)
{
return(ReservationDB.LoginReservation(idReservation, firstname, lastname));
}
//recupère toutes les réservations
public static List <Reservation> GetAllReservation()
{
return(ReservationDB.GetAllReservation());
}
