/// <summary>
/// Updates the Orientation Code on SGBSTDN for student.
/// </summary>
/// <param name="ENumber"></param>
/// <param name="ORSN"></param>
/// <returns></returns>
public int UpdateSGBSTDN_ORSN_Code(string ENumber, string ORSN)
{
List <System.Data.Common.DbParameter> paramList = new List <System.Data.Common.DbParameter>();
OrientationDB _ODB = new OrientationDB();
paramList.Add(new OracleParameter(PARAM_ENUMBER, ENumber));
paramList.Add(new OracleParameter(PARAM_ORSN, ORSN));
int retVal = _DB.ExecuteSQLCommand(_QUERIES.GetQueryByName(SQL_UPDATE_SGBSTDN_ORSN_CODE).Sql, paramList);
return(retVal);
}
public int ReleaseHold(string ENumber, string HoldCode)
{
List <System.Data.Common.DbParameter> paramList = new List <System.Data.Common.DbParameter>();
OrientationDB _ODB = new OrientationDB();
paramList.Add(new OracleParameter(PARAM_ENUMBER, ENumber));
paramList.Add(new OracleParameter(PARAM_HOLD_CODE, HoldCode));
int retVal = _DB.ExecuteSQLCommand(_QUERIES.GetQueryByName(SQL_RELEASE_HOLD).Sql, paramList);
return(retVal);
}
/// <summary>
/// Inserts a row into the old SYRORIE table so the ID Card Data Extract can pickup the students
/// </summary>
/// <param name="Pidm"></param>
/// <param name="TERM"></param>
/// <param name="PAID_IND"></param>
/// <returns></returns>
public int INSERT_IDCARD_FLAG(string Pidm, string TERM, string PAID_IND)
{
List <System.Data.Common.DbParameter> paramList = new List <System.Data.Common.DbParameter>();
OrientationDB _ODB = new OrientationDB();
paramList.Add(new OracleParameter(PARAM_PIDM, Pidm));
paramList.Add(new OracleParameter(PARAM_TERM, TERM));
paramList.Add(new OracleParameter(PARAM_PAID_INDICATOR, PAID_IND));
int retVal = _DB.ExecuteSQLCommand(_QUERIES.GetQueryByName(SQL_INSERT_IDCARD_FLAG).Sql, paramList);
return(retVal);
}
public List <StudentSearchResult> GetDualAdmitOnlineOnly(string Term)
{
OracleParameter param = new OracleParameter(PARAM_TERM, Term);
OrientationDB _ODB = new OrientationDB();
List <StudentSearchResult> retVal = _DB.ExecuteSQLCommandAsDataTable(_QUERIES.GetQueryByName(SQL_GET_DUAL_ADMIT_ONLINE_ONLY).Sql, param).AsEnumerable().Select(e => new StudentSearchResult()
{
FirstName = e.Field <string>(2), LastName = e.Field <string>(3), ENumber = e.Field <string>(0), BirthDate = e.Field <DateTime?>(1)
}).ToList();
retVal.ForEach(e => e.Invitations = _ODB.tblInvitations.Where(f => f.ENumber == e.ENumber).ToList());
return(retVal);
}
public List <StudentSearchResult> GetStudentIDsByName(string FirstName, string LastName)
{
List <System.Data.Common.DbParameter> paramList = new List <System.Data.Common.DbParameter>();
OrientationDB _ODB = new OrientationDB();
paramList.Add(new OracleParameter(PARAM_FIRST_NAME, FirstName));
paramList.Add(new OracleParameter(PARAM_LAST_NAME, LastName));
List <StudentSearchResult> retVal = _DB.ExecuteSQLCommandAsDataTable(_QUERIES.GetQueryByName(SQL_GET_STUDENT_IDS_BY_NAME).Sql, paramList).AsEnumerable().Select(e => new StudentSearchResult()
{
FirstName = FirstName, LastName = LastName, ENumber = e.Field <string>(0), BirthDate = e.Field <DateTime?>(1)
}).ToList();
retVal.ForEach(e => e.Invitations = _ODB.tblInvitations.Where(f => f.ENumber == e.ENumber).ToList());
return(retVal);
}
public List <StudentSearchResult> GetStudentsByTestScore(string Term, string TestCode, string MinScore, string MaxScore)
{
List <System.Data.Common.DbParameter> paramList = new List <System.Data.Common.DbParameter>();
OrientationDB _ODB = new OrientationDB();
paramList.Add(new OracleParameter(PARAM_TERM, Term));
paramList.Add(new OracleParameter(PARAM_TEST_CODE, TestCode));
paramList.Add(new OracleParameter(PARAM_MIN_SCORE, MinScore));
paramList.Add(new OracleParameter(PARAM_MAX_SCORE, MaxScore));
List <StudentSearchResult> retVal = _DB.ExecuteSQLCommandAsDataTable(_QUERIES.GetQueryByName(SQL_GET_BY_TEST_SCORE).Sql, paramList).AsEnumerable().Select(e => new StudentSearchResult()
{
FirstName = e.Field <string>(2), LastName = e.Field <string>(3), ENumber = e.Field <string>(0), BirthDate = e.Field <DateTime?>(1)
}).ToList();
retVal.ForEach(e => e.Invitations = _ODB.tblInvitations.Where(f => f.ENumber == e.ENumber).ToList());
return(retVal);
}
public List <StudentSearchResult> GetWhitelist(int EventId)
{
OrientationDB _ODB = new OrientationDB();
var Event = _ODB.tblEvents.Where(e => e.ID == EventId).SingleOrDefault();
if (Event == null || String.IsNullOrWhiteSpace(Event.Whitelist))
{
return(new List <StudentSearchResult>());
}
else
{
OracleParameter param = new OracleParameter(PARAM_ENUMLIST, String.Format(",{0},", Event.Whitelist.Replace(' ', ',')));
List <StudentSearchResult> retVal = _DB.ExecuteSQLCommandAsDataTable(_QUERIES.GetQueryByName(SQL_GET_STUDENTS_BY_ENUMBER_LIST).Sql, param).AsEnumerable().Select(e => new StudentSearchResult()
{
FirstName = e.Field <string>(2), LastName = e.Field <string>(3), ENumber = e.Field <string>(0), BirthDate = e.Field <DateTime?>(1)
}).ToList();
retVal.ForEach(e => e.Invitations = _ODB.tblInvitations.Where(f => f.ENumber == e.ENumber).ToList());
return(retVal);
}
}
