public DataTable GetTop5ooEnrollments()
{
DataTable dt = new DataTable();
daEnrollment = new TblEnrollmentTableAdapter();
dtEnrollment = new DsLiveOutlook.TblEnrollmentDataTable();
daEnrollment.SelectTop500(dtEnrollment);
dt = dtEnrollment;;
return(dt);
}
internal static DataTable GetAllEnrollmentsTop100()
{
try
{
dt = new DataTable();
daEnrollment = new TblEnrollmentTableAdapter();
dtEnrollment = new DsLiveOutlook.TblEnrollmentDataTable();
daEnrollment.FillByTop100(dtEnrollment);
dt = dtEnrollment;
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load Enrollment Information\n" + ex.Message, "Database connection failure");
}
return(dt);
}
internal static int UpdateEnrollment()
{
n = 0;
try
{
daEnrollment = new TblEnrollmentTableAdapter();
dtEnrollment = new DsLiveOutlook.TblEnrollmentDataTable();
daEnrollment.FillByID(dtEnrollment, EnrollmentInfo.RegNo);
drwEnrollment = dtEnrollment[0];
drwEnrollment.BeginEdit();
drwEnrollment.RegNo = EnrollmentInfo.NewRegNo.Trim().ToUpper();
drwEnrollment.Names = EnrollmentInfo.Names.Trim().ToUpper();
drwEnrollment.Age = EnrollmentInfo.Age;
drwEnrollment.AgeUnit = EnrollmentInfo.AgeUnit;
drwEnrollment.Sex = EnrollmentInfo.Sex.Trim().ToUpper();
drwEnrollment.RegDate = EnrollmentInfo.RegDate;
drwEnrollment.Residence = EnrollmentInfo.Residence.Trim().ToUpper();
drwEnrollment.ReferredBy = EnrollmentInfo.ReferredBy.Trim().ToUpper();
drwEnrollment.ReferredTo = EnrollmentInfo.ReferredTo.Trim().ToUpper();
drwEnrollment.Fcode = EnrollmentInfo.Fcode.Trim().ToUpper();
drwEnrollment.Category = EnrollmentInfo.Category.Trim();
drwEnrollment.ContactInfo = EnrollmentInfo.ContactInfo.Trim();
drwEnrollment.CurrentStatus = EnrollmentInfo.Outcome;
drwEnrollment.EndEdit();
n = daEnrollment.Update(dtEnrollment);
return(n);
}
catch (Exception ex)
{
Interactive.LInfoError(ex.Message, "Record was not saved !");
return(n);
}
}
internal static DataTable GetAllEnrollmentsByID()
{
try
{
EnrollmentInfo.Recs = false;
dt = new DataTable();
daEnrollment = new TblEnrollmentTableAdapter();
dtEnrollment = new DsLiveOutlook.TblEnrollmentDataTable();
daEnrollment.FillByID(dtEnrollment, EnrollmentInfo.RegNo);
dt = dtEnrollment;
if (dt.Rows.Count > 0)
{
EnrollmentInfo.Recs = true;
}
}
catch (Exception ex)
{
Interactive.LInfoError("Could not load Enrollment Information\n" + ex.Message, "Database connection failure");
}
return(dt);
}