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