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