public bool DeleteResDis(int resNumber)
{
string cmd = @"Delete from hvk_reservation_discount
where res_reservation_number = " + resNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool Delete(int ownerNumber)
{
string cmd = @"Delete from hvk_owner
where owner_number = " + ownerNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool Delete(int discountNumber)
{
string cmd = @"Delete from hvk_discount
where discount_number = " + discountNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool RemovePetRes(int petNumber)
{
string cmd = @"Delete from hvk_pet_reservation
where PET_PET_NUMBER = " + petNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool Delete(int petResNumber)
{
string cmd = @"Delete from hvk_pet_reservation_discount
where pr_pet_res_number = " + petResNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool DeleteService(int serviceNumber)
{
string cmd = @"Delete from hvk_service
where service_number = " + serviceNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool Delete(int resNumber)
{
string cmd = @"Delete from hvk_pet_reservation
where res_reservation_number = " + resNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool Delete(int dailyNumber)
{
string cmd = @"Delete from hvk_daily_rate
where daily_rate_number = " + dailyNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool DeletePetVaccination(int petNumber)
{
string cmd = @"Delete from hvk_pet_vaccination
where pet_pet_number = " + petNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool DeleteVaccination(int vaccNumber)
{
string cmd = @"Delete from hvk_vaccination
where vaccination_number = " + vaccNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool Delete(int runNumber)
{
string cmd = @"Delete from hvk_run
where run_number = " + runNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool RemovePetFromRes(int petNumber, int resNumber)
{
string cmd = @"Delete from hvk_pet_reservation
where res_reservation_number = " + resNumber
+ "and pet_pet_number = " + petNumber;
return(HVK_SqlConnection.Delete(cmd));
}
public bool DeleteServiceForPet(int petResNumber, int servNumber)
{
string query = @"
DELETE FROM hvk_pet_reservation_service
WHERE pr_pet_res_number = " + petResNumber +
" AND serv_service_number = " + servNumber;
return(HVK_SqlConnection.Delete(query));
}
public bool Delete(int petNumber)
{
//Change this to Different DB Class Calls
//string cmd1 = @"Delete from hvk_pet_vaccination where PET_PET_NUMBER = " + petNumber;
VaccinationDB vaccDB = new VaccinationDB();
//vaccDB.DeletePetVaccination(petNumber);
string cmd2 = @"Delete from HVK_PET_RESERVATION_SERVICE
WHERE PR_PET_RES_NUMBER IN
(SELECT pr.PET_RES_NUMBER
FROM HVK_PET_RESERVATION pr
JOIN HVK_PET_RESERVATION_SERVICE prs
ON pr.PET_RES_NUMBER = prs.PR_PET_RES_NUMBER
WHERE pr.PET_PET_NUMBER = " + petNumber + ")";
//string cmd3 = "Delete from hvk_pet_reservation where PET_PET_NUMBER = " + petNumber;
PetReservationDB petDB = new PetReservationDB();
//petDB.RemovePetRes(petNumber);
string cmd4 = @"Delete from hvk_pet where pet_number = " + petNumber;
if (vaccDB.DeletePetVaccination(petNumber))
{
if (HVK_SqlConnection.Delete(cmd2))
{
if (petDB.RemovePetRes(petNumber))
{
if (HVK_SqlConnection.Delete(cmd4))
{
return(true);
}
}
}
}
return(false);
}
public bool RemoveEntireRes(int petResNumber)
{
string cmd = @"Delete from hvk_pet_reservation where res_reservation_number = " + petResNumber;
return(HVK_SqlConnection.Delete(cmd));
}
