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 int Capacity()
{
n = 0;
try
{
daAppointment = new TblAppointmentTableAdapter();
n = Convert.ToInt32(daAppointment.GetNoOfAppointments(Convert.ToDateTime(AppointmentInfo.Appointment.ToString("yyyy/MM/dd"))));
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load Appointment Information\n" + ex.Message, "Database connection failure");
}
return(n + 1);
}
internal static int DeleteAppointment()
{
n = 0;
try
{
daAppointment = new TblAppointmentTableAdapter();
n = daAppointment.Delete1(AppointmentInfo.AppointmentID);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not Deleted!");
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);
}
