/* * update availability of the staff */ public Boolean updateAvailability(StaffAvailability staffAvailability) { using (var db = new DentalPracticeContext()) { db.staff_availability_details.Add(staffAvailability); int result = db.SaveChanges(); return(result != 0? true:false); } }
/* * add staff details * */ public int addStaff(Staff staff) { using (var db = new DentalPracticeContext()) { db.staff_details.Add(staff); db.SaveChanges(); return(staff.ID); } }
// add patient public int addPatient(Patient patient) { using (var db = new DentalPracticeContext()) { db.Patients.Add(patient); db.SaveChanges(); return(patient.patientID); } }
/* * insert treatment plan * */ public int addTreatmentPlan(TreatmentPlan treatmentPlan) { using (var db = new DentalPracticeContext()) { db.treatmentPlans.Add(treatmentPlan); int result = db.SaveChanges(); return(result); } }
// add booking public int addBooking(Appointment appointment) { using (var db = new DentalPracticeContext()) { db.appointments.Add(appointment); int value = db.SaveChanges(); return(value); } }