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