public bool commitDelete(int _id) { hospitalDataContext objHospital = new hospitalDataContext(); using (objHospital) { mic_book_appointment objDelAppointment = objHospital.mic_book_appointments.Single(x => x.Id == _id); objHospital.mic_book_appointments.DeleteOnSubmit(objDelAppointment); objHospital.SubmitChanges(); return(true); } }
public bool commitInsert(DateTime _date, DateTime _date_only) { hospitalDataContext objHospital = new hospitalDataContext(); using (objHospital) { mic_book_appointment objBook = new mic_book_appointment(); objBook.date = _date; objBook.date_only = _date_only; objHospital.mic_book_appointments.InsertOnSubmit(objBook); objHospital.SubmitChanges(); return(true); } }
public bool commitUpdate(int _id, string _fname, string _lname, string _address, string _city, string _province, string _postal_code, string _phone, string _reason, bool _booked) { hospitalDataContext objHospital = new hospitalDataContext(); using (objHospital) { mic_book_appointment objBook = objHospital.mic_book_appointments.Single(x => x.Id == _id); objBook.fname = _fname; objBook.lname = _lname; objBook.address = _address; objBook.city = _city; objBook.province = _province; objBook.postal_code = _postal_code; objBook.phone = _phone; objBook.reason = _reason; objBook.booked = _booked; objHospital.SubmitChanges(); return(true); } }