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