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