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