public bool Update(int ownerNumber, 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 cmd = @"Update hvk_owner
set owner_first_name = :fName,
owner_last_name = :lName,
owner_street = :street,
owner_city = :city,
owner_province = :province,
owner_postal_code = :postalCode,
owner_phone = :phone,
owner_email = :email,
emergency_contact_first_name = :eFName,
emergency_contact_last_name = :eLName,
emergency_contact_phone = :ePhone,
vet_vet_number = :vet
where owner_number = :oNumber;";
List <string> list = new List <string>();
list.Add("oNumber~" + ownerNumber);
list.Add("fName~" + first);
list.Add("lName~" + last);
list.Add("street~" + street);
list.Add("city~" + city);
list.Add("province~" + province);
list.Add("postalCode~" + postal);
list.Add("email~" + email);
list.Add("eFName~" + emgFirst);
list.Add("eLName~" + emgLast);
list.Add("ePhone~" + emgPhone);
list.Add("vet~" + vet);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int petNumber, string name, char gender, char isFixed, string breed,
DateTime birthdate, int ownerNumber, char dogSize, string notes)
{
string cmd = @"Update hvk_pet
set pet_name = :name,
pet_gender = :gender,
pet_fixed = :isFixed,
pet_breed = :breed,
pet_birthdate = :birthdate,
own_owner_number = :ownerNumber,
dog_size = :dogSize,
special_notes = :notes
where pet_number = :petNumber;";
List <string> list = new List <string>();
list.Add("petNumber~" + petNumber);
list.Add("name~" + name);
list.Add("gender~" + gender);
list.Add("isFixed~" + isFixed);
list.Add("breed~" + breed);
list.Add("birthdate~" + birthdate.ToShortDateString());
list.Add("ownerNumber~" + ownerNumber);
list.Add("dogSize~" + dogSize);
list.Add("notes~" + notes);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int serviceNumber, string serviceDesc)
{
string cmd = "Update hvk_service " +
"set service_description = '" + serviceDesc +
"' where service_number = " + serviceNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int vaccinationNumber, string vaccinationName)
{
string cmd = "Update hvk_vaccination " +
"set vaccination_name = '" + vaccinationName +
"' where vaccination_number = " + vaccinationNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int resNumber, DateTime startDate, DateTime endDate)
{
string cmd = "Update hvk_reservation " +
"set reservation_start_date = to_date('" + startDate.ToString("yyyy/mm/dd") + "', 'yyyy/mm/dd')" +
", reservation_end_date = to_date('" + endDate.ToString("yyyy/mm/dd") + "', 'yyyy/mm/dd')" +
" where reservation_number = " + resNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int serviceFrequency, int petResNumber, int serviceNumber)
{
string cmd = "Update hvk_pet_reservation_service " +
"set service_frequency = " + serviceFrequency +
"where pr_pet_res_number = " + petResNumber +
" and serv_service_number = " + serviceNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(DateTime expiryDate, int vaccinationNumber, int petNumber, char vacChecked)
{
string cmd = "Update hvk_pet_vaccination " +
"set vaccination_expiry_date = to_date('" + expiryDate.ToString("yyyy/MM/dd") + "', 'yyyy/mm/dd')" +
", vaccination_checked_status = '" + vacChecked +
"' where vacc_vaccination_number = " + vaccinationNumber +
" and pet_pet_number = " + petNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int dNumber, string desc, double percentage, char dType)
{
string cmd = "Update hvk_discount " +
"set discount_description = '" + desc +
"', discount_percentage = " + percentage +
", discount_type = '" + dType +
"' where discount_number = " + dNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(DateTime date, int sequence, string notes, int petResNumber)
{
string cmd = "Update hvk_kennel_log " +
"set kennel_log_notes = '" + notes +
"' where kennel_log_date = to_date('" + date.ToString("yyyy/mm/dd") + "','yyyy/mm/dd')" +
" and kennel_log_sequence_number = " + sequence +
" and pr_pet_res_number = " + petResNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int petResNumber, int petPetNumber, int resResNumber, int?runRunNumber = null)
{
string cmd = "Update hvk_pet_reservation " +
"set pet_pet_number = " + petPetNumber +
", res_reservation_number = " + resResNumber +
", run_run_number = " + ((runRunNumber == null) ? "null" : runRunNumber.ToString()) +
" where pet_res_number = " + petResNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int discountNumber, int petResNumber)
{
string cmd = @"Update hvk_pet_reservation_discount
set disc_discount_number = :discountNumber
where pr_pet_res_number = :petResNumber;";
List <string> list = new List <string>();
list.Add("discountNumber~" + discountNumber);
list.Add("petResNumber~" + petResNumber);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int runNumber, char size, char covered, char location, int status)
{
string cmd = "Update hvk_run " +
"set run_size = '" + size +
"', run_covered = '" + covered +
"', run_location = '" + location +
"', run_status = " + status +
"where run_number = " + runNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int vaccinationNumber, string vaccinationName)
{
string cmd = @"Update hvk_vaccination
set vaccination_name = :vaccinationName
where vaccination_number = :vaccinationNumber";
List <string> list = new List <string>();
list.Add("vaccinationNumber~" + vaccinationNumber);
list.Add("vaccinationName~" + vaccinationName);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int serviceNumber, string serviceDesc)
{
string cmd = @"Update hvk_service
set service_description = :serviceDesc
where service_number = :serviceNumber";
List <string> list = new List <string>();
list.Add("serviceNumber~" + serviceNumber);
list.Add("serviceDesc~" + serviceDesc);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int drNumber, double dailyRate, char dogSize, int serviceNumber)
{
string cmd = "Update hvk_daily_rate " +
"set daily_rate = " + dailyRate +
", daily_rate_dog_size = '" + dogSize + "', " +
"serv_service_number = " + serviceNumber + ", " +
"where daily_rate_number = " + drNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int resNumber, DateTime startDate, DateTime endDate)
{
string cmd = @"Update hvk_reservation
set reservation_start_date = :sDate,
reservation_end_date = :eDate
where reservation_number = " + resNumber + ";";
List <string> list = new List <string>();
list.Add("sDate~" + startDate.ToShortDateString());
list.Add("eDate~" + endDate.ToShortDateString());
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int foodNumber, string brand, string variety)
{
string cmd = @"Update hvk_food
set food_brand = :brand,
food_variety = :variety
where food_number = :foodNumber;";
List <string> list = new List <string>();
list.Add("foodNumber~" + foodNumber);
list.Add("brand~" + brand);
list.Add("variety~" + variety);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int serviceFrequency, int petResNumber, int serviceNumber)
{
string cmd = @"Update hvk_pet_reservation_service
set service_frequency = :serviceFrequency
where pr_pet_res_number = :petResNumber and
serv_service_number = :serviceNumber";
List <string> list = new List <string>();
list.Add("serviceFrequency~" + serviceFrequency);
list.Add("petResNumber~" + petResNumber);
list.Add("serviceNumber~" + serviceNumber);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int drNumber, double dailyRate, char dogSize, int serviceNumber)
{
string cmd = @"Update hvk_daily_rate
set daily_rate = :dailyRate,
daily_rate_dog_size = :dogSize,
serv_service_number = :serviceNumber,
where daily_rate_number = :drNumber;";
List <string> list = new List <string>();
list.Add("drNumber~" + drNumber);
list.Add("dogSize~" + dogSize);
list.Add("serviceNumber~" + serviceNumber);
list.Add("dailyRate~" + dailyRate);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int dNumber, string desc, double percentage, char dType)
{
string cmd = @"Update hvk_discount
set discount_description = :desc,
discount_percentage = :percentage,
discount_type = :dType
where discount_number = :dNumber;";
List <string> list = new List <string>();
list.Add("dNumber~" + dNumber);
list.Add("desc~" + desc);
list.Add("percentage~" + percentage);
list.Add("dType~" + dType);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int frequency, string quantity, int petResNumber, int foodNumber)
{
string cmd = @"Update hvk_pet_food
set pet_food_frequency = :frequency,
pet_food_quantity = :quantity,
food_food_number = :foodNumber
where pr_pet_res_number = :petResNumber;";
List <string> list = new List <string>();
list.Add("frequency~" + frequency);
list.Add("quantity~" + quantity);
list.Add("petResNumber~" + petResNumber);
list.Add("foodNumber~" + foodNumber);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(DateTime expiryDate, int vaccinationNumber, int petNumber, char vacChecked)
{
string cmd = @"Update hvk_pet_vaccination
set vaccination_expiry_date = :expiryDate,
vaccination_checked_status = :vacChecked
where vacc_vaccination_number = :vaccinationNumber and
pet_pet_number = :petNumber";
List <string> list = new List <string>();
list.Add("expiryDate~" + expiryDate.ToShortDateString());
list.Add("vaccinationNumber~" + vaccinationNumber);
list.Add("petNumber~" + petNumber);
list.Add("vacChecked~" + vacChecked);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(DateTime date, int sequence, string notes, int petResNumber)
{
string cmd = @"Update hvk_kennel_log
set kennel_log_notes = :notes
where kennel_log_date = :date and
kennel_log_sequence_number = :sequence and
pr_pet_res_number = :petResNumber;";
List <string> list = new List <string>();
list.Add("date~" + date);
list.Add("sequence~" + sequence);
list.Add("notes~" + notes);
list.Add("petResNumber~" + petResNumber);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int petNumber, string name, char gender, char isFixed, string breed,
DateTime birthdate, int ownerNumber, char dogSize, string notes)
{
string cmd = "Update hvk_pet " +
"set pet_name = '" + name +
"', pet_gender = '" + gender +
"', pet_fixed = '" + isFixed +
"', pet_breed = '" + breed +
"', pet_birthdate = to_date('" + birthdate.ToString("yyyy/MM/dd") + "', 'yyyy/mm/dd')" +
", own_owner_number = " + ownerNumber +
", dog_size = '" + dogSize +
"', special_notes = '" + notes +
"' where pet_number = " + petNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int runNumber, char size, char covered, char location, int status)
{
string cmd = @"Update hvk_run
set run_size = :size,
run_covered = :covered,
run_location = :location,
run_status = :status
where run_number = :runNumber;";
List <string> list = new List <string>();
list.Add("runNumber~" + runNumber);
list.Add("size~" + size);
list.Add("covered~" + covered);
list.Add("location~" + location);
list.Add("status~" + status);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int petResNumber, int petPetNumber, int resResNumber, int runRunNumber, int prSharing)
{
string cmd = @"Update hvk_pet_reservation
set pet_pet_number = :petPetNumber,
res_reservation_number = :resResNumber,
run_run_number = :runRunNumber,
pr_sharing_with = :prSharing
where pet_res_number = :petResNumber;";
List <string> list = new List <string>();
list.Add("petResNumber~" + petResNumber);
list.Add("petPetNumber~" + petPetNumber);
list.Add("resResNumber~" + resResNumber);
list.Add("runRunNumber~" + runRunNumber);
list.Add("prSharing~" + prSharing);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int medNumber, string name, string dosage, string instructions, DateTime endDate,
int petResNumber)
{
string cmd = @"Update hvk_medication
set medication_name = :name,
medication_dosage = :dosage,
medication_special_instruct = :instructions,
medication_end_date = :endDate,
pr_pet_res_number = :petResNumber
where medication_number = :medNumber;";
List <string> list = new List <string>();
list.Add("medNumber~" + medNumber);
list.Add("name~" + name);
list.Add("dosage~" + dosage);
list.Add("instructions~" + instructions);
list.Add("endDate~" + endDate.ToShortDateString());
list.Add("petResNumber~" + petResNumber);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
public bool Update(int ownerNumber, string first, string last, string street, string city,
string province, string postal, string phone, string email, string emgFirst, string emgLast,
string emgPhone)
{
string cmd = "Update hvk_owner set owner_first_name = '" + first +
"', owner_last_name = '" + last
+ "', owner_street = '" + street +
"', owner_city = '" + city +
"', owner_province = '" + province +
"', owner_postal_code = '" + postal +
"', owner_phone = '" + phone +
"', owner_email = '" + email +
"', emergency_contact_first_name = '" + emgFirst +
"', emergency_contact_last_name = '" + emgLast +
"', emergency_contact_phone = '" + emgPhone +
"' where owner_number = " + ownerNumber;
return(HVK_SqlConnection.UpdateRow(cmd));
}
public bool Update(int vetNumber, string name, string phone, string street, string city,
string province, string postal)
{
string cmd = @"Update hvk_veterinarian
set vet_name = :name,
vet_phone = :phone,
vet_street = :street,
vet_city = :city,
vet_province = :province,
vet_postal_code = :postal
where vet_number = :vetNumber;";
List <string> list = new List <string>();
list.Add("vetNumber~" + vetNumber);
list.Add("name~" + name);
list.Add("phone~" + phone);
list.Add("street~" + street);
list.Add("city~" + city);
list.Add("province~" + province);
list.Add("postal~" + postal);
return(HVK_SqlConnection.UpdateRow(cmd, list));
}
