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