public DataTable GetFullFoodInfo()
{
// dsHvkTableAdapters.HVK_FOODTableAdapter adapter = new dsHvkTableAdapters.HVK_FOODTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_FOOD"));
}
public DataTable GetVaccinationInfoForPet(int petNumber)
{
// dsHvkTableAdapters.PetVaccinationInformationTableAdapter adapter = new dsHvkTableAdapters.PetVaccinationInformationTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData(petNumber);
return(HVK_SqlConnection.GetData("HVK_PET_VACCINATION", "select * from HVK_PET_VACCINATION where pet_pet_number = " + petNumber));
}
public DataTable GetFullDiscountInfo()
{
// dsHvkTableAdapters.HVK_DISCOUNTTableAdapter adapter = new dsHvkTableAdapters.HVK_DISCOUNTTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_DISCOUNT"));
}
public DataTable GetFullReservationInfo()
{
// dsHvkTableAdapters.HVK_RESERVATIONTableAdapter adapter = new dsHvkTableAdapters.HVK_RESERVATIONTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_RESERVATION"));
}
public DataTable GetFullPetVaccinationInfo()
{
// dsHvkTableAdapters.HVK_PET_VACCINATIONTableAdapter adapter = new dsHvkTableAdapters.HVK_PET_VACCINATIONTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_PET_VACCINATION"));
}
public DataTable GetFullVetInfo()
{
// dsHvkTableAdapters.HVK_VETERINARIANTableAdapter adapter = new dsHvkTableAdapters.HVK_VETERINARIANTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_VETERINARIAN"));
}
public DataTable GetFullServiceInfo()
{
// dsHvkTableAdapters.HVK_SERVICETableAdapter adapter = new dsHvkTableAdapters.HVK_SERVICETableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_SERVICE"));
}
public DataTable GetDataByOwnerNumber(int ownerNumber)
{
// dsHvkTableAdapters.HVK_PETTableAdapter adapter = new dsHvkTableAdapters.HVK_PETTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetDataByOwnerNumber(ownerNumber);
return(HVK_SqlConnection.GetData("HVK_PET", "select * from HVK_PET where own_owner_number = " + ownerNumber));
}
public DataTable GetFullLogInfo()
{
// dsHvkTableAdapters.HVK_KENNEL_LOGTableAdapter adapter = new dsHvkTableAdapters.HVK_KENNEL_LOGTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_KENNEL_LOG"));
}
public DataTable GetFullRateInfo()
{
// Original Code
// dsHvkTableAdapters.HVK_DAILY_RATETableAdapter adapter = new dsHvkTableAdapters.HVK_DAILY_RATETableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_DAILY_RATE"));
}
public DataTable GetPetResDiscountInfo()
{
return(HVK_SqlConnection.GetData("",
"SELECT DISCOUNT_NUMBER, DISCOUNT_DESCRIPTION, DISCOUNT_PERCENTAGE, DISCOUNT_TYPE, PR_PET_RES_NUMBER " +
"FROM HVK_DISCOUNT d " +
"LEFT JOIN HVK_PET_RESERVATION_DISCOUNT prd " +
"ON DISCOUNT_NUMBER = DISC_DISCOUNT_NUMBER "
));
}
public DataTable GetFullOwnerInfo()
{
// Original code
// dsHvkTableAdapters.HVK_OWNERTableAdapter adapter = new dsHvkTableAdapters.HVK_OWNERTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetData();
return(HVK_SqlConnection.GetData("HVK_OWNER"));
} // GetFullOwnerInfo
public int Add(int petPetNumber, int resResNumber, int?runRunNumber = null)
{
int seqNextVal = Convert.ToInt16(HVK_SqlConnection.GetData("", "SELECT hvk_pet_res_seq.NEXTVAL FROM DUAL").Rows[0][0]);
string cmdStr = "Insert into hvk_pet_reservation (PET_RES_NUMBER, PET_PET_NUMBER, RES_RESERVATION_NUMBER," +
"RUN_RUN_NUMBER)" +
" values (" + seqNextVal + "," + petPetNumber + "," + resResNumber + ", null" +
")";
return(HVK_SqlConnection.AddRow(cmdStr) != -1 ? seqNextVal : -1);
}
public DataTable GetReservationByOwnerNumber(int ownerNumber)
{
return(HVK_SqlConnection.GetData("HVK_RESERVATION", @"select r.* from
hvk_reservation r
inner join hvk_pet_reservation pr
on pr.res_reservation_number = r.reservation_number
inner join hvk_pet p
on p.pet_number = pr.pet_pet_number
where p.own_owner_number = " + ownerNumber));
}
public DataTable GetReservationWithOwnerNumbers()
{
return(HVK_SqlConnection.GetData("",
@"SELECT DISTINCT r.reservation_number, r.reservation_start_Date, r.reservation_end_date, p.own_owner_number
FROM hvk_reservation r
left join hvk_pet_reservation pr
ON pr.res_reservation_number = r.reservation_number
left join hvk_pet p
ON p.pet_number = pr.pet_pet_number"));
}
public DataTable GetReservationByOwnerNumber(int ownerNumber)
{
// dsHvkTableAdapters.HVK_RESERVATIONTableAdapter adapter = new dsHvkTableAdapters.HVK_RESERVATIONTableAdapter();
// adapter.ClearBeforeFill = true;
// return adapter.GetDataByOwnerNumber(ownerNumber);
return(HVK_SqlConnection.GetData("HVK_RESERVATION", @"select r.* from
hvk_reservation r
inner join hvk_pet_reservation pr
on pr.res_reservation_number = r.reservation_number
inner join hvk_pet p
on p.pet_number = pr.pet_pet_number
where p.own_owner_number = " + ownerNumber));
}
public int Add(DateTime startDate, DateTime endDate)
{
int seqNextVal = Convert.ToInt16(HVK_SqlConnection.GetData("", "SELECT HVK_RESERVATION_SEQ.NEXTVAL FROM DUAL").Rows[0][0]);
string cmdStr = @"
Insert into hvk_reservation (
RESERVATION_NUMBER, RESERVATION_START_DATE, RESERVATION_END_DATE
) values (
" + seqNextVal + ", to_date('" + startDate.ToString("dd-MM-yy") + "', 'dd-MM-yy')," +
"to_date('" + endDate.ToString("dd-MM-yy") + "', 'dd-MM-yy') " +
")";
HVK_SqlConnection.AddRow(cmdStr);
return(seqNextVal);
}
public DataTable GetFullPetResInfo()
{
return(HVK_SqlConnection.GetData("HVK_PET_RESERVATION"));
}
public DataTable GetFullRateInfo()
{
return(HVK_SqlConnection.GetData("HVK_DAILY_RATE"));
}
public DataTable GetFullReservationDiscountInfo()
{
return(HVK_SqlConnection.GetData("HVK_RESERVATION_DISCOUNT"));
}
public DataTable GetFullDiscountInfo()
{
return(HVK_SqlConnection.GetData("HVK_DISCOUNT"));
}
public DataTable GetFullReservationInfo()
{
return(HVK_SqlConnection.GetData("HVK_RESERVATION"));
}
public DataTable GetFullPetVaccinationInfo()
{
return(HVK_SqlConnection.GetData("HVK_PET_VACCINATION"));
}
public DataTable GetFullServiceInfo()
{
return(HVK_SqlConnection.GetData("HVK_SERVICE"));
}
public DataTable GetFullPetReservationServiceInfo()
{
return(HVK_SqlConnection.GetData("HVK_PET_RESERVATION_SERVICE"));
}
public DataTable GetFullOwnerInfo()
{
return(HVK_SqlConnection.GetData("HVK_OWNER"));
}
public DataTable GetFullPetInfo()
{
return(HVK_SqlConnection.GetData("HVK_PET"));
}
public DataTable GetOwnerInfo(int ownerNumber)
{
return(HVK_SqlConnection.GetData("HVK_OWNER", "Select * FROM HVK_OWNER WHERE HVK_OWNER.OWNER_NUMBER = " + ownerNumber));
}
public DataTable GetDataByOwnerNumber(int ownerNumber)
{
return(HVK_SqlConnection.GetData("HVK_PET", "select * from HVK_PET where own_owner_number = " + ownerNumber));
}
public DataTable GetVaccinationInfoForPet(int petNumber)
{
return(HVK_SqlConnection.GetData("HVK_PET_VACCINATION", "select * from HVK_PET_VACCINATION where pet_pet_number = " + petNumber));
}
