public int Add(string vaccinationName) { string cmdStr = "Insert into hvk_vaccination (VACCINATION_NUMBER, VACCINATION_NAME)" + " values (HVK_VACCINATION_SEQ.NEXTVAL," + vaccinationName + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_vaccination_seq")); }
public int Add(string brand, string variety) { string cmdStr = "Insert into hvk_food (FOOD_NUMBER, FOOD_BRAND, FOOD_VARIETY)" + " values (HVK_FOOD_SEQ.NEXTVAL," + brand + "," + variety + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_food_seq")); }
public int Add(string serviceDesc) { string cmdStr = "Insert into hvk_service (SERVICE_NUMBER, SERVICE_DESCRIPTION)" + " values (HVK_SERVICE_SEQ.NEXTVAL," + serviceDesc + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_service_seq")); }
/* * PET_RESERVATION_SERVICE */ public int Add(int petResNumber, int serviceNumber) { string cmdStr = "Insert into hvk_pet_reservation_service (PR_PET_RES_NUMBER, SERV_SERVICE_NUMBER)" + " values (" + petResNumber + ", " + serviceNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr)); }
public int Add(string desc, double percentage, char dType) { string cmdStr = "Insert into hvk_discount (DISCOUNT_NUMBER, DISCOUNT_DESCRIPTION," + "DISCOUNT_PERCENTAGE, DISCOUNT_TYPE)" + " values (HVK_DISCOUNT_SEQ.NEXTVAL," + desc + "," + percentage + "," + dType + ")"; return(HVK_SqlConnection.AddRow(cmdStr)); }
}//add vaccination for newly added pet public int Add(DateTime expiryDate, int vaccinationNumber, int petNumber, char vacChecked) { string cmdStr = "Insert into hvk_pet_vaccination (VACCINATION_EXPIRY_DATE,VACC_VACCINATION_NUMBER," + "PET_PET_NUMBER,VACCINATION_CHECKED_STATUS)" + " values (to_date('" + expiryDate.ToString("yyyy/MM/dd") + "', 'yyyy/mm/dd'), " + vaccinationNumber + ", " + petNumber + ", '" + vacChecked + "')"; return(HVK_SqlConnection.AddRow(cmdStr)); }
/* * RESERVATION_DISCOUNT */ public int AddResDis(int discountNumber, int reservationNumber) { string cmdStr = "Insert into hvk_reservation_discount (DISC_DISCOUNT_NUMBER," + "RES_RESERVATION_NUMBER)" + " values (" + discountNumber + "," + reservationNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr)); }
public int Add(int discountNumber, int petResNumber) { string cmdStr = "Insert into hvk_pet_reservation_discount (DISC_DISCOUNT_NUMBER," + "PR_PET_RES_NUMBER)" + " values (" + discountNumber + "," + petResNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "")); }
public int Add(int frequency, string quantity, int petResNumber, int foodNumber) { string cmdStr = "Insert into hvk_pet_food (PET_FOOD_FREQUENCY, PET_FOOD_QUANTITY," + "PR_PET_RES_NUMBER, FOOD_FOOD_NUMBER)" + " values (" + frequency + "," + quantity + "," + petResNumber + "," + foodNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "")); }
public int Add(DateTime date, int sequence, string notes, int petResNumber) { string cmdStr = "Insert into hvk_kennel_log (KENNEL_LOG_DATE,KENNEL_LOG_SEQUENCE_NUMBER," + "KENNEL_LOG_NOTES, PR_PET_RES_NUMBER, KENNEL_LOG_VIDEO)" + " values (" + date + "," + sequence + "," + notes + "," + petResNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "")); }
public int Add(char size, char covered, char location, int status) { string cmdStr = "Insert into hvk_run (RUN_NUMBER, RUN_SIZE, RUN_COVERED, RUN_LOCATION," + "RUN_STATUS)" + " values (HVK_RUN_SEQ.NEXTVAL," + size + "," + covered + "," + location + "," + status + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_run_seq")); }
public int Add(double dailyRate, char dogSize, int serviceNumber) { string cmdStr = "Insert into hvk_daily_rate (DAILY_RATE_NUMBER,DAILY_RATE," + "DAILY_RATE_DOG_SIZE, SERV_SERVICE_NUMBER)" + " values (HVK_DAILY_RATE_SEQ.NEXTVAL," + dailyRate + "," + dogSize + "," + serviceNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_daily_rate_seq")); }
public int Add(DateTime startDate, DateTime endDate) { string cmdStr = "Insert into hvk_reservation (RESERVATION_NUMBER, RESERVATION_START_DATE, " + "RESERVATION_END_DATE)" + " values (HVK_RESERVATION_SEQ.NEXTVAL," + startDate.ToShortDateString() + "," + endDate.ToShortDateString() + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_reservation_seq")); }
public int Add(int petPetNumber, int resResNumber, int runRunNumber, int prSharing) { string cmdStr = "Insert into hvk_pet_reservation (PET_RES_NUMBER, PET_PET_NUMBER, RES_RESERVATION_NUMBER," + "RUN_RUN_NUMBER, PR_SHARING_WITH)" + " values (hvk_pet_reservation_seq.nextval" + "," + petPetNumber + "," + resResNumber + "," + runRunNumber + "," + prSharing + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_pet_reservation_seq")); }
public int Add(string name, string phone, string street, string city, string province, string postal) { string cmdStr = "Insert into hvk_veterinarian (VET_NUMBER, VET_NAME, VET_PHONE, VET_STREET," + "VET_CITY, VET_PROVINCE, VET_POSTAL_CODE)" + " values (HVK_VETERINARIAN_SEQ.NEXTVAL," + name + "," + phone + "," + street + "," + city + "," + province + "," + postal + "," + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_veterinarian_seq")); }
public int Add(DateTime expiryDate, int vaccinationNumber, int petNumber, char vacChecked) { string cmdStr = "Insert into hvk_pet_vaccination (VACCINATION_EXPIRY_DATE,VACC_VACCINATION_NUMBER," + "PET_PET_NUMBER,VACCINATION_CHECKED_STATUS)" + " values (" + expiryDate.ToShortDateString() + ", " + vaccinationNumber + ", " + petNumber + ", " + vacChecked + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "")); }
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 int Add(string name, string dosage, string instructions, DateTime endDate, int petResNumber) { string cmdStr = "Insert into hvk_medication (MEDICATION_NUMBER, MEDICATION_NAME, MEDICATION_DOSAGE," + "MEDICATION_SPECIAL_INSTRUCT, MEDICATION_END_DATE, PR_PET_RES_NUMBER)" + " values (HVK_MEDICATION_SEQ.NEXTVAL," + name + "," + dosage + "," + instructions + "," + endDate.ToShortDateString() + "," + petResNumber + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_medication_seq")); }
public int Add(string name, char gender, char isFixed, string breed, DateTime birthdate, int ownerNumber, char dogSize, string notes) { string cmdStr = "Insert into hvk_pet (PET_NUMBER, PET_NAME, PET_GENDER," + "PET_FIXED, PET_BREED, PET_BIRTHDATE, OWN_OWNER_NUMBER, DOG_SIZE," + "SPECIAL_NOTES)" + " values (HVK_PET_SEQ.NEXTVAL," + name + "," + gender + "," + isFixed + "," + breed + "," + birthdate.ToShortDateString() + "," + ownerNumber + "," + dogSize + "," + notes + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_pet_seq")); }
} // GetFullOwnerInfo public int Add(string first, string last, string street, string city, string province, string postal, string phone, string email, string emgFirst, string emgLast, string emgPhone, int vet) { string cmdStr = "Insert into hvk_owner (OWNER_NUMBER, OWNER_FIRST_NAME, OWNER_LAST_NAME," + "OWNER_STREET, OWNER_CITY, OWNER_PROVINCE, OWNER_POSTAL_CODE, OWNER_PHONE," + "OWNER_EMAIL, EMERGENCY_CONTACT_FIRST_NAME, EMERGENCY_CONTACT_LAST_NAME," + "EMERGENCY_CONTACT_PHONE, VET_VET_NUMBER)" + " values (HVK_OWNER_SEQ.NEXTVAL," + first + "," + last + "," + street + "," + city + "," + province + "," + postal + "," + phone + "," + email + "," + emgFirst + "," + emgLast + "," + emgPhone + "," + vet + ")"; return(HVK_SqlConnection.AddRow(cmdStr, "hvk_owner_seq")); }
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 int Add(string name, char gender, char isFixed, string breed, DateTime?birthdate, int ownerNumber, char dogSize, string notes) { string cmdStr = null; if (birthdate.HasValue) { cmdStr = "Insert into hvk_pet (PET_NUMBER, PET_NAME, PET_GENDER," + "PET_FIXED, PET_BREED, PET_BIRTHDATE, OWN_OWNER_NUMBER, DOG_SIZE," + "SPECIAL_NOTES)" + " values (HVK_PET_SEQ.NEXTVAL,'" + name + "','" + gender + "','" + isFixed + "','" + breed + "', to_date('" + birthdate.Value.ToString("yyyy/MM/dd") + "', 'yyyy/mm/dd')," + ownerNumber + ",'" + dogSize + "','" + notes + "')"; } else { cmdStr = "Insert into hvk_pet (PET_NUMBER, PET_NAME, PET_GENDER," + "PET_FIXED, PET_BREED, PET_BIRTHDATE, OWN_OWNER_NUMBER, DOG_SIZE," + "SPECIAL_NOTES)" + " values (HVK_PET_SEQ.NEXTVAL,'" + name + "','" + gender + "','" + isFixed + "','" + breed + "','" + birthdate + "'," + ownerNumber + ",'" + dogSize + "','" + notes + "')"; } return(HVK_SqlConnection.AddRow(cmdStr)); }