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