public static ApplicantList GetList()
{
ApplicantList applicants = new ApplicantList();
using (OracleConnection localDbConn =
new OracleConnection(
ConnStringFactory.getConnString(
ConnStringFactory.ConnStringType.Oracle))) {
localDbConn.Open();
using (OracleCommand getAllApplicantCommand = new OracleCommand()) {
getAllApplicantCommand.CommandType = CommandType.StoredProcedure;
getAllApplicantCommand.CommandText = "ApplicantsPKG.getAllApplicants";
getAllApplicantCommand.Connection = localDbConn;
OracleParameter outputCursor = new OracleParameter("IO_CURSOR", OracleType.Cursor);
outputCursor.Direction = ParameterDirection.Output;
getAllApplicantCommand.Parameters.Add(outputCursor);
using (OracleDataReader applicantListReader =
getAllApplicantCommand.ExecuteReader()) {
if (applicantListReader.HasRows) {
while (applicantListReader.Read()) {
applicants.Add(FillDataRecord(applicantListReader));
}
}
}
}
}
return applicants;
}
/// <summary>
/// It inserts the applicant, if it's not already in the list.
/// </summary>
/// <param name="applicant">The applicant to be inserted.</param>
public void InsertRecord(Applicant applicant)
{
if (ApplicantList.IndexOf(applicant) == -1)
{
ApplicantList.Add(applicant);
}
SaveToFile();
}
/// <summary>
/// It inserts the applicant, if it's not already in the list.
/// </summary>
/// <param name="applicant">The applicant to be inserted.</param>
public void InsertRecord(Applicant applicant)
{
Debug.Assert(applicant != null);
Debug.Assert(ApplicantList.IndexOf(applicant) == -1);
if (ApplicantList.IndexOf(applicant) == -1)
{
ApplicantList.Add(applicant);
}
SaveToFile();
}
public async Task Init()
{
if (UniversityList.Count == 0)
{
var universityList = await _serviceUniversity.Get <List <University> >(null);
foreach (var k in universityList)
{
UniversityList.Add(k);
}
}
if (SelectedUniversity != null)
{
var listApplicants = await _serviceApplicant.Get <List <Applicant> >(_search);
ApplicantList.Clear();
foreach (var m in listApplicants)
{
if (m.UniversityId == SelectedUniversity.UniversityId)
{
ApplicantList.Add(m);
}
}
}
else
{
var listApplicants = await _serviceApplicant.Get <List <Applicant> >(_search);
ApplicantList.Clear();
foreach (var x in listApplicants)
{
ApplicantList.Add(x);
}
}
}
