/// <summary>
/// Load profile of patient
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void loadprofile(object sender, MouseButtonEventArgs e)
{
ListViewItem itm = sender as ListViewItem;
AppointmentHolder appointment = itm.Content as AppointmentHolder;
subparent.loadPatientInfo(appointment.PatientID, "appointment");
}
/// <summary>
/// get appointments that held
/// </summary>
public void loadAttendedAppointment()
{
DataTable qry = parent.query("select scheduleid,patientid,(select PCODE from patient where patient.patientid=schedule.patientid) as pcode, (select concat(lastname,' ',firstname) from patient where patient.patientid=schedule.patientid) as name, status as attended, schedule.date as schedule, date_added as created from schedule where doctorid=" + subparent.DoctorId + " and date < now() and status='Yes'");
foreach (DataRow rw in qry.Rows)
{
AppointmentHolder appointment = new AppointmentHolder();
appointment.ID = int.Parse(rw["scheduleid"].ToString());
appointment.PatientID = int.Parse(rw["patientid"].ToString());
appointment.patient_code = (rw["pcode"].ToString());
appointment.patient_name = (rw["name"].ToString());
appointment.attended = (rw["attended"].ToString());
appointment.schedule = (rw["schedule"].ToString());
appointment.created = (rw["created"].ToString());
listView4.Items.Add(appointment);
}
}
/// <summary>
/// Get tomorrow's appointments
/// </summary>
public void loadTomorrowAppointment()
{
DataTable qry = parent.query("select scheduleid,patientid,(select PCODE from patient where patient.patientid=schedule.patientid) as pcode, (select concat(lastname,' ',firstname) from patient where patient.patientid=schedule.patientid) as name, status as attended, schedule.date as schedule, date_added as created from schedule where doctorid=" + subparent.DoctorId + " and extract(day from date)=extract(day from date_add(now(),INTERVAL 1 DAY)) and extract(Month from date)=extract(month from date_add(now(),INTERVAL 1 DAY)) and extract(year from date)=extract(year from date_add(now(),INTERVAL 1 DAY))");
foreach (DataRow rw in qry.Rows)
{
AppointmentHolder appointment = new AppointmentHolder();
appointment.ID = int.Parse(rw["scheduleid"].ToString());
appointment.PatientID = int.Parse(rw["patientid"].ToString());
appointment.patient_code = (rw["pcode"].ToString());
appointment.patient_name = (rw["name"].ToString());
appointment.attended = (rw["attended"].ToString());
appointment.schedule = (rw["schedule"].ToString());
appointment.created = (rw["created"].ToString());
listView2.Items.Add(appointment);
}
loadMissedAppointment();
}
