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());
}
