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