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