// Checks to see if the appointment data in session is in the database
private void ValidateSessionAppointmentData(string mrn, string physician, DateTime clinicDate)
{
EFormsDa da = new EFormsDa();
// UPDATE this to reference eformcontroller method
DataTable table = da.GetPatientAppointmentRecord(mrn, physician, clinicDate);
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
// populate controls with appointment data
object objApptVisitType = row["ApptVisitType"];
if (objApptVisitType != DBNull.Value)
{
EncType.Value = row["ApptVisitType"].ToString();
}
EncPhysician.Value = physician;
string clinicDateString = clinicDate.ToShortDateString();
EncDateText.Text = clinicDateString;
EncDate.Value = clinicDateString;
}
}
/// <summary>
/// Determine if combination of session vars is a valid record in the appointments table
/// </summary>
/// <param name="mrn"></param>
/// <param name="physician"></param>
/// <param name="clinicDate"></param>
public DataTable ValidateSessionAppointmentData(object mrn, object physician, object clinicDate)
{
DataTable table = new DataTable();
if (mrn != null && physician != null && clinicDate != null)
{
EFormsDa da = new EFormsDa();
table = da.GetPatientAppointmentRecord(mrn.ToString(), physician.ToString(), DateTime.Parse(clinicDate.ToString()));
}
return(table);
}
// Checks to see if the appointment data in session is in the database
private void ValidateSessionAppointmentData(string mrn, string physician, DateTime clinicDate)
{
EFormsDa da = new EFormsDa();
// UPDATE this to reference eformcontroller method
DataTable table = da.GetPatientAppointmentRecord(mrn, physician, clinicDate);
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
string clinicDateString = clinicDate.ToShortDateString();
EncDateText_1.Text = clinicDateString;
EncDate_1.Value = clinicDateString;
}
}