public List<sp_GetBookedTimeResult> getBookedTimes(string doctorUserId, DateTime appointmentDate) { List<sp_GetBookedTimeResult> myList = new List<sp_GetBookedTimeResult>(); try { AppointmentsDataContext obj = new AppointmentsDataContext(); myList = obj.sp_GetBookedTime(Guid.Parse(doctorUserId), appointmentDate).ToList(); } catch (Exception ex) { clsCommon.saveError(ex); } return myList; }
public List<sp_SearchAppsByDoctorIdResult> getAppointmentsByDoctorId(string applicationName, string patientName, Guid docId) { List<sp_SearchAppsByDoctorIdResult> myList = new List<sp_SearchAppsByDoctorIdResult>(); try { AppointmentsDataContext obj = new AppointmentsDataContext(); myList = obj.sp_SearchAppsByDoctorId(applicationName, patientName, docId).ToList(); } catch (Exception ex) { clsCommon.saveError(ex); } return myList; }
public void bookAppointment(string patientUserId, string doctorUserId, string appointmentDate, string appointmentTime, string reason, string approvalStatus) // save new record into databse { try { // create a new table with one row and this table is similar in schema with the table in database brdhc_PatientAppointment svTable = new brdhc_PatientAppointment() { PatientUserId = new Guid(patientUserId), DoctorUserId = new Guid(doctorUserId), AppointmentDate = Convert.ToDateTime(appointmentDate), AppointmentTime = appointmentTime, Reason = reason, approvalStatus = approvalStatus }; AppointmentsDataContext objApp = new AppointmentsDataContext(); // call the function to save the row into actual database table objApp.brdhc_PatientAppointments.InsertOnSubmit(svTable); objApp.SubmitChanges(); } catch (Exception ex) { clsCommon.saveError(ex); } }
public void updateAppointment(string appointmentId, string patientUserId, string doctorUserId, string appointmentDate, string appointmentTime, string reason, string approvalStatus) { try { AppointmentsDataContext objApp = new AppointmentsDataContext(); // select that particular row that is to be updated var appointment = objApp.brdhc_PatientAppointments.Single(p => p.AppointmentId == Convert.ToInt32(appointmentId)); // make the changes appointment.PatientUserId = new Guid(patientUserId); appointment.DoctorUserId = new Guid(doctorUserId); appointment.AppointmentDate = Convert.ToDateTime(appointmentDate); appointment.AppointmentTime = appointmentTime; appointment.Reason = reason; appointment.approvalStatus = approvalStatus; appointment.CreatedOnDate = DateTime.Now; // update the datebase table with new values objApp.SubmitChanges(); } catch (Exception ex) { clsCommon.saveError(ex); } }
public void updateAppointmentRequest(int appointmentId, string approvalStatus) { AppointmentsDataContext objApp = new AppointmentsDataContext(); var appointment = objApp.brdhc_PatientAppointments.Single(p => p.AppointmentId == Convert.ToInt32(appointmentId)); appointment.approvalStatus = approvalStatus;// Jagsir I have changed this - Reshma objApp.SubmitChanges(); }
public List<sp_getAppByDocIDResult> getAppByDocID(Guid docID) // added by REshma { List<sp_getAppByDocIDResult> myList = new List<sp_getAppByDocIDResult>(); AppointmentsDataContext obj = new AppointmentsDataContext(); return obj.sp_getAppByDocID(docID).ToList(); }
public List<sp_getAppByPatientIDResult> getAppByPatientID(Guid pid) //added by REshma { AppointmentsDataContext obj = new AppointmentsDataContext(); return obj.sp_getAppByPatientID(pid).ToList(); }
public void deleteAppointment(string appointmentId) { try { AppointmentsDataContext objApp = new AppointmentsDataContext(); // select the particular records from databse table and delete it var appointments = from a in objApp.brdhc_PatientAppointments where (a.AppointmentId == Convert.ToInt32(appointmentId)) select a; // call the function to delete it and submit the changes objApp.brdhc_PatientAppointments.DeleteAllOnSubmit(appointments); objApp.SubmitChanges(); } catch (Exception ex) { clsCommon.saveError(ex); } }