public DataSet getVaccinations(int vacNum) { VaccinationDB vaccDB = new VaccinationDB(); DataSet vals = vaccDB.getVaccinationDB(vacNum); return(vals); }
public static int checkVaccinations(int petNum, DateTime byDate) { Search look = new Search(); if (!look.validatePetNumber(petNum)) { return(-10); } else { VaccinationDB vaccDB = new VaccinationDB(); List <PetVaccination> petVaccList = new List <PetVaccination>(); foreach (DataRow row in vaccDB.checkVaccinationsDB(petNum, byDate).Tables["hvk_vaccination"].Rows) { petVaccList.Add(fillVaccination(row)); } if (petVaccList.Count == 6) { return(-1); } else { return(0); } } }
public DataSet listAllVaccinations() { VaccinationDB vaccDB = new VaccinationDB(); DataSet vals = vaccDB.listVaccinationsDB(); return(vals); }
public static int addPetVaccination(DateTime expiryDate, int vacNumber, int petNumber) { Search search = new Search(); if (!search.validatePetNumber(petNumber)) { return(-2); } else if (!search.validateVaccNumber(vacNumber)) { return(-3); } bool hasVacc = false; listVaccinations(petNumber).ForEach(delegate(PetVaccination vac) { if (vac.vaccination.vaccinationNumber == vacNumber) { hasVacc = true; } }); if (hasVacc) // if the pet already has the vaccination just update it. { updatePetVaccinationExpiry(expiryDate, vacNumber, petNumber); } return(VaccinationDB.addPetVaccinationDB(expiryDate, vacNumber, petNumber)); }
public List <Vaccination> ListBasicVaccinations() { VaccinationDB vaccDB = new VaccinationDB(); DataTable v = vaccDB.GetFullVaccinationInfo(); return(GetBasicVaccinations(v)); }
public List <Vaccination> ListVaccinations(int petNumber) { VaccinationDB vaccDB = new VaccinationDB(); DataTable pv = vaccDB.GetVaccinationInfoForPet(petNumber); DataTable v = vaccDB.GetFullVaccinationInfo(); return(GetVaccinations(pv, v)); }
public List <Vaccination> ListVaccinations() { VaccinationDB vaccDB = new VaccinationDB(); DataTable pv = vaccDB.GetFullPetVaccinationInfo(); DataTable v = vaccDB.GetFullVaccinationInfo(); return(GetVaccinations(pv, v)); }
public static List <PetVaccination> listVaccinations(int petNum) { VaccinationDB vaccDB = new VaccinationDB(); List <PetVaccination> vaccList = new List <PetVaccination>(); foreach (DataRow row in vaccDB.listVaccinationsDB(petNum).Tables["hvk_vaccination"].Rows) { vaccList.Add(fillVaccination(row)); } return(vaccList); }
public e Update(DateTime expirationDate, int vaccinationNum, int petNum, bool vaccinationChecked) { e errCode = e.success; VaccinationDB vaccDB = new VaccinationDB(); if (vaccDB.Update(expirationDate, vaccinationNum, petNum, vaccinationChecked ? 'Y' : 'N') == false) { errCode = e.updateFail; } return(errCode); }
}//add vaccination where pet number isnt specified (for a new pet) public e Insert(DateTime expirationDate, int vaccinationNum, int petNum, bool vaccinationChecked) { e errCode = e.success; VaccinationDB vaccDB = new VaccinationDB(); if (vaccDB.Add(expirationDate, vaccinationNum, petNum, vaccinationChecked ? 'Y' : 'N') != 0) { errCode = e.insertFail; } return(errCode); }
public e Insert(DateTime expirationDate, int vaccinationNum, bool vaccinationChecked) { e errCode = e.success; VaccinationDB vaccDB = new VaccinationDB(); if (vaccDB.Add(expirationDate, vaccinationNum, vaccinationChecked ? 'Y' : 'N') != 0) { errCode = e.insertFail; } return(errCode); }//add vaccination where pet number isnt specified (for a new pet)
public static int updatePetVaccinationExpiry(DateTime expiryDate, int vacNumber, int petNumber) { Search search = new Search(); if (!search.validatePetNumber(petNumber)) { return(-2); } if (!search.validateVaccNumber(vacNumber)) { return(-3); } return(VaccinationDB.updatePetVaccinationExpiryDB(expiryDate, vacNumber, petNumber)); }
public static int updatePetVaccinationChecked(char isChecked, int vacNumber, int petNumber) { Search search = new Search(); if (!search.validatePetNumber(petNumber)) { return(-2); } if (!search.validateVaccNumber(vacNumber)) { return(-3); } return(VaccinationDB.updatePetVaccinationCheckedDB(isChecked, vacNumber, petNumber)); }
public static List <PetVaccination> checkVaccinations(int petNum, int resNum) { Search look = new Search(); List <PetVaccination> petVaccList = new List <PetVaccination>(); if (look.validatePetNumber(petNum) == false) { } else if (!look.validateReservationNumber(resNum)) { } else { VaccinationDB vaccDB = new VaccinationDB(); foreach (DataRow row in vaccDB.checkVaccinationsDB(petNum, resNum).Tables["hvk_vaccination"].Rows) { petVaccList.Add(fillVaccination(row)); } } return(petVaccList); }