public List <PetReservation> ListPetReservations()
{
PetReservationDB prDB = new PetReservationDB();
DataTable data = prDB.GetFullPetResInfo();
return(GetPetReservations(data));
}
public e Update(int petResNumber, int petNumber, int reservationNumber)
{
e errCode = e.success;
PetReservationDB prDB = new PetReservationDB();
if (!prDB.Update(petResNumber, petNumber, reservationNumber))
{
errCode = e.updateFail;
}
return(errCode);
}
public e RemovePetFromRes(int petNumber, int resNumber)
{
e errCode = e.success;
PetReservationDB prDB = new PetReservationDB();
Service ser = new Service();
ser.Delete(ListPetReservations().Find(pr => pr.petNum == petNumber && pr.reservationNum == resNumber).petResNum);
if (!prDB.RemovePetFromRes(petNumber, resNumber))
{
errCode = e.deleteFail;
}
return(errCode);
}
//Adds a new dog to an existing reservation
public int AddToReservation(int reservationNumber, int petNumber)
{
e errCode = e.success;
if (Validation.invalidRes(reservationNumber))
{
errCode = e.invalidRes;
}
else if (Validation.invalidPet(petNumber))
{
errCode = e.invalidPet;
}
else if (Validation.differentOwner(petNumber, reservationNumber))
{
errCode = e.differentOwner;
}
else if (Validation.petInRes(petNumber, reservationNumber))
{
errCode = e.petInRes;
}
else if (Validation.runUnavailable(petNumber, reservationNumber))
{
errCode = e.runUnavailable;
}
else
{
PetReservationDB resDB = new PetReservationDB();
if (resDB.Add(petNumber, reservationNumber) < 0)
{
errCode = e.insertFail;
}
else
{
if (CheckVaccinations(petNumber, ListReservations().Find(r => r.number == reservationNumber).eDate) != 0)
{
errCode = e.vaccInvalid;
}
}
}
return(Convert.ToInt16(errCode));
}
public List <int> Add(int petNumber, int reservationNumber)
{
e errCode = e.success;
int petResNum = -1;
List <int> retVals = new List <int>();
PetReservationDB prDB = new PetReservationDB();
petResNum = prDB.Add(petNumber, reservationNumber);
if (petResNum < 0)
{
errCode = e.insertFail;
}
retVals.Add(Convert.ToInt16(errCode));
retVals.Add(petResNum);
return(retVals);
}
public static List <PetReservation> listPetRes(int ReservationNumber)
{
PetReservationDB pres = new PetReservationDB();
List <PetReservation> list = new List <PetReservation>();
foreach (DataRow row in pres.listPetResDB(ReservationNumber).Tables["hvk_pet_reservation"].Rows)
{
PetReservation petRes = new PetReservation();
try
{
petRes.petResNumber = Convert.ToInt32(row["reservation_number"].ToString());
petRes.pet = Pet.getOnePet(Convert.ToInt32(row["PET_PET_NUMBER"]));
}
catch (Exception e) {
Console.Write(e);
}
}
return(list);
}
public e RemoveEntireRes(int resNumber)
{
e errCode = e.success;
PetReservationDB prDB = new PetReservationDB();
Service serv = new Service();
foreach (PetReservation pr in ListPetReservations().Where(r => r.reservationNum == resNumber))
{
if (serv.Delete(pr.petResNum) < 0)
{
errCode = e.deleteFail;
}
}
if (!prDB.RemoveEntireRes(resNumber))
{
errCode = e.deleteFail;
}
return(errCode);
}