internal static int AddAppointment() { n = 0; try { daAppointment = new TblAppointmentTableAdapter(); dtAppointment = new DsLiveOutlook.TblAppointmentDataTable(); drwAppointment = dtAppointment.NewTblAppointmentRow(); drwAppointment.RegNo = AppointmentInfo.RegNo.Trim(); 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; dtAppointment.AddTblAppointmentRow(drwAppointment); n = daAppointment.Update(dtAppointment); daAppointment.UpdateDates(); return(n); } catch (Exception ex) { Interactive.LInfoError(ex.Message, "Record was not saved !"); return(n); } }
internal static DataTable GetAllAppointments() { try { dt = new DataTable(); daAppointment = new TblAppointmentTableAdapter(); dtAppointment = new DsLiveOutlook.TblAppointmentDataTable(); daAppointment.Fill(dtAppointment); dt = dtAppointment; } catch (Exception ex) { Interactive.LInfoError("Could not load Appointment Information\n" + ex.Message, "Database connection failure"); } return(dt); }
internal static int UpdateAppointmentReturn() { n = 0; try { daAppointment = new TblAppointmentTableAdapter(); dtAppointment = new DsLiveOutlook.TblAppointmentDataTable(); n = daAppointment.UpdateVisit(AppointmentInfo.ReturnDate, AppointmentInfo.AppointmentID); return(n); } catch (Exception ex) { Interactive.LInfoError(ex.Message, "Appointment was not uypdated !"); return(n); } }
internal static DataTable GetAllAppointmentsByRegNo() { try { AppointmentInfo.Recs = false; dt = new DataTable(); daAppointment = new TblAppointmentTableAdapter(); dtAppointment = new DsLiveOutlook.TblAppointmentDataTable(); daAppointment.FillByRegNo(dtAppointment, AppointmentInfo.RegNo); 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); }