public bool commitDelete(int _id)
{
appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
using (objAppointmentDC)
{
var objDelAppointment = objAppointmentDC.Appointments.Single(x => x.Id == _id);
objAppointmentDC.Appointments.DeleteOnSubmit(objDelAppointment);
objAppointmentDC.SubmitChanges();
return true;
}
}
public bool commitUpdate(int _id, DateTime _date, string _title)
{
appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
using (objAppointmentDC)
{
var objUpAppointment = objAppointmentDC.Appointments.Single(x => x.Id == _id);
//objUpAppointment.patientName = _pname;
objUpAppointment.date_time = _date;
objUpAppointment.appointment_title = _title;
objAppointmentDC.SubmitChanges();
return true;
}
}
public bool commitInsert(DateTime _date, string _title)
{
appointmentsDataContext objAppointmentDC = new appointmentsDataContext();
using (objAppointmentDC)
{
Appointment objNewAppointment = new Appointment();
//objNewAppointment.patientName = _pname;
objNewAppointment.date_time = _date;
objNewAppointment.appointment_title = _title;
objAppointmentDC.Appointments.InsertOnSubmit(objNewAppointment);
objAppointmentDC.SubmitChanges();
return true;
}
}
