public static List <AppointmentDataGrid> getAllAppointments() { var adb = new AppointmentDatabaseAccess(); var ddb = new DoctorDatabaseAccess(); var pdb = new PatientDatabaseAccess(); var appointmentList = adb.GetAllAppointments(); var appointments = new List <AppointmentDataGrid>(); foreach (var appointment in appointmentList) { //var appointmentid = int.Parse(appointment[0]); //var dateTime = DateTime.Parse(appointment[2]); //var doctorData = ddb.GetDoctorDataFromId(int.Parse(appointment[3])); //var doctorName = doctorData[0] + " " + doctorData[1]; //var description = appointment[4]; //var patientData = pdb.GetPatientDataFromId(int.Parse(appointment[1])); //var patientName = patientData[0] + " " + patientData[1]; //appointments.Add(new AppointmentDataGrid(appointmentid, dateTime, doctorName, description, int.Parse(appointment[1]), patientName)); var appointmentid = int.Parse(appointment[0]); var patientid = int.Parse(appointment[1]); var dateTime = DateTime.Parse(appointment[2]); var doctorData = ddb.GetDoctorDataFromId(int.Parse(appointment[3])); var doctorName = doctorData[0] + " " + doctorData[1]; var description = appointment[4]; var patientData = pdb.GetPatientDataFromId(patientid); var patientName = patientData[0] + " " + patientData[1]; var dob = new Date(DateTime.Parse(patientData[2])).ToString(); appointments.Add(new AppointmentDataGrid(appointmentid, dateTime, doctorName, description, patientid, patientName, dob, int.Parse(appointment[3]))); } return(appointments); }
/// <summary> /// Checks if appointment time passed. /// </summary> /// <param name="appointmentid">The appointmentid.</param> /// <param name="dateTime">The date time.</param> /// <returns></returns> public static bool checkIfAppointmentTimePassed(int appointmentid, DateTime dateTime) { var adb = new AppointmentDatabaseAccess(); var appointmentTime = adb.GetAppointmentTimeFromAppointmentid(appointmentid); return(dateTime > appointmentTime); }
/// <summary> /// Checks for doctor double book. /// </summary> /// <param name="requestedTime">The requested time.</param> /// <param name="doctorid">The doctorid.</param> /// <param name="appointmentid"></param> /// <returns></returns> public static bool checkForDoctorDoubleBook(DateTime requestedTime, int doctorid, int appointmentid = -1) { var adb = new AppointmentDatabaseAccess(); var takenAppointments = adb.GetAppointmentTimeFromDoctorid(doctorid, appointmentid); const int appointmentDuration = 30; //In minutes foreach (var takenAppointment in takenAppointments) { var takenDate = DateTime.Parse(takenAppointment); var unavailable = requestedTime - takenDate; if (Math.Abs(unavailable.TotalSeconds) <= appointmentDuration * 60) //&& unavailable.TotalSeconds > 0) { return(true); } } return(false); }
/// <summary> /// Gets the doctor name from appointmentid. /// </summary> /// <param name="appointmentid">The appointmentid.</param> /// <returns></returns> public static string getDoctorNameFromAppointmentid(int appointmentid) { var adb = new AppointmentDatabaseAccess(); return(adb.GetDoctorNameFromAppointmentid(appointmentid)); }
/// <summary> /// Updates the appointment. /// </summary> /// <param name="appointmentid">The appointmentid.</param> /// <param name="date">The date.</param> /// <param name="doctorid">The doctorid.</param> /// <param name="description">The description.</param> /// <returns></returns> public static bool EditAppointment(int appointmentid, DateTime date, int doctorid, string description) { var adb = new AppointmentDatabaseAccess(); return(adb.EditAppointment(appointmentid, date, doctorid, description)); }
/// <summary> /// Creates the appointment. /// </summary> /// <param name="patientid">The patientid.</param> /// <param name="date">The date.</param> /// <param name="doctorid">The doctorid.</param> /// <param name="description">The description.</param> /// <returns></returns> public static bool createAppointment(string patientid, DateTime date, string doctorid, string description) { var adb = new AppointmentDatabaseAccess(); return(adb.CreateAppointment(patientid, date, doctorid, description)); }
/// <summary> /// Deletes the appointment. /// </summary> /// <param name="appointmentid">The appointmentid.</param> /// <returns></returns> public static bool deleteAppointment(int appointmentid) { var adb = new AppointmentDatabaseAccess(); return(adb.DeleteAppointment(appointmentid)); }