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> /// Gets the name of the doctor. /// </summary> /// <param name="doctorid">The doctorid.</param> /// <returns></returns> public static List <string> getDoctorName(int doctorid) { var ddb = new DoctorDatabaseAccess(); return(ddb.GetDoctorNameFromId(doctorid)); }
public static List <int> GetEveryDoctorId() { var ddb = new DoctorDatabaseAccess(); return(ddb.GetEveryDoctorId()); }