internal static DataTable GetAllAppointmentsByID()
{
try
{
AppointmentInfo.Recs = false;
dt = new DataTable();
daAppointment = new TblAppointmentTableAdapter();
dtAppointment = new DsLiveOutlook.TblAppointmentDataTable();
daAppointment.FillByID(dtAppointment, AppointmentInfo.AppointmentID);
dt = dtAppointment;
if (dt.Rows.Count > 0)
{
AppointmentInfo.Recs = true;
}
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load Appointment Information\n" + ex.Message, "Database connection failure");
}
return(dt);
}
internal static int UpdateAppointment()
{
n = 0;
try
{
daAppointment = new TblAppointmentTableAdapter();
dtAppointment = new DsLiveOutlook.TblAppointmentDataTable();
daAppointment.FillByID(dtAppointment, AppointmentInfo.AppointmentID);
drwAppointment = dtAppointment[0];
drwAppointment.BeginEdit();
drwAppointment.RegNo = AppointmentInfo.RegNo.Trim();
drwAppointment.Appointment = AppointmentInfo.Appointment;
drwAppointment.Appointment = AppointmentInfo.Appointment;
drwAppointment.Period = AppointmentInfo.Period;
drwAppointment.PeriodName = AppointmentInfo.PeriodName;
drwAppointment.SeenBy = AppointmentInfo.SeenBy.Trim().ToUpper();
drwAppointment.VisitDate = AppointmentInfo.VisitDate;
drwAppointment.VisitStatus = AppointmentInfo.VisitStatus;
drwAppointment.AStatus = AppointmentInfo.AStatus;
drwAppointment.EndEdit();
n = daAppointment.Update(dtAppointment);
daAppointment.UpdateDates();
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
