public async Task <List <IdProof> > GetIdProof()
{
List <IdProof> idproofs = new List <IdProof>();
IdProof idproof = null;
Console.WriteLine("Connect to SQL Server and demo Create, Read, Update and Delete operations.");
Console.Write("Connecting to SQL Server ... ");
using (SqlConnection connection = new SqlConnection(this._connectionString))
{
connection.Open();
Console.WriteLine("Done.");
using (SqlCommand command = new SqlCommand("get_id_proof", connection))
{
command.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = await command.ExecuteReaderAsync())
{
while (reader.Read())
{
idproof = new IdProof();
idproof.id_proof_id = Convert.ToInt32(reader["id_proof_id"]);
idproof.id_proof_type = Convert.ToString(reader["proof_type"]).Trim();
idproofs.Add(idproof);
}
;
}
}
}
Console.WriteLine("All done. Press any key to finish...");
return(idproofs);
}
public static StudentApplicationDataLookup GetApplicationAllLookups()
{
HttpResponse response = HttpContext.Current.Response;
//response.AppendHeader("Access-Control-Allow-Origin", "*");
//response.AppendHeader("Access-Control-Allow-Methods", "*");
//headers.set('Access-Control-Allow-Headers', 'true');
//headers.set('Access-Control-Allow-Methods','GET, POST, PATCH, PUT, DELETE, OPTIONS');
//headers.set('Access-Control-Allow-Credentials', 'Origin, Content-Type, X-Auth-Token');
Files.dbConnection con = new Files.dbConnection();
StudentApplicationDataLookup lkp = new StudentApplicationDataLookup();
try
{
#region Course List
List <Course> courses = new List <Course>();
string sqlCourses = string.Concat("[dbo].[sp_getCourses]");
DataTable tempTableCourse = null;
tempTableCourse = con.executeSelectNoParameter(sqlCourses); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCourse != null) || (tempTableCourse.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCourse.Rows)
{
Course course = new Course();
course.CourseID = Convert.ToInt32(drr["CourseID"]);
course.CourseName = drr["Course"].ToString();
course.CourseCode = drr["CourseCode"].ToString();
courses.Add(course);
}
}
lkp.course = courses;
#endregion
#region Get Campus
List <Campus> campuses = new List <Campus>();
string sqlCampuses = string.Concat("[dbo].[sp_getAllCampus]");
DataTable tempTableCampus = null;
tempTableCampus = con.executeSelectNoParameter(sqlCampuses); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCampus != null) || (tempTableCampus.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCampus.Rows)
{
Campus campus = new Campus();
campus.campusID = Convert.ToInt32(drr["CampusID"].ToString());
campus.campusName = drr["Campus"].ToString();
campuses.Add(campus);
}
}
lkp.campus = campuses;
#endregion
#region Get CourseCampus
List <CourseCampus> ccCollection = new List <CourseCampus>();
string sqlCC = string.Concat("[dbo].[sp_getCourseCampus]");
DataTable tempTableCC = null;
tempTableCC = con.executeSelectNoParameter(sqlCC); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCC != null) || (tempTableCC.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCC.Rows)
{
CourseCampus cc = new CourseCampus();
cc.campusID = Convert.ToInt32(drr["CampusID"].ToString());
cc.courseID = Convert.ToInt32(drr["CourseId"].ToString());
cc.courseCampusID = Convert.ToInt32(drr["CourseCampusID"].ToString());
cc.campusName = drr["Campus"].ToString();
ccCollection.Add(cc);
}
}
lkp.courseCampus = ccCollection;
#endregion
#region Get Country
List <Country> countries = new List <Country>();
string sqlCountry = string.Concat("[dbo].[sp_getCountry]");
DataTable tempTableCountry = null;
tempTableCountry = con.executeSelectNoParameter(sqlCountry); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTableCountry != null) || (tempTableCountry.Rows.Count >= 0))
{
foreach (DataRow drr in tempTableCountry.Rows)
{
Country country = new Country();
country.countryID = Convert.ToInt32(drr["CountryID"].ToString());
country.country = drr["Country"].ToString();
countries.Add(country);
}
}
lkp.country = countries;
#endregion
#region Get Residency
List <Residency> residencyCollection = new List <Residency>();
string sqlResidency = string.Concat("[dbo].[sp_getResidency]");
DataTable tempResidency = null;
tempResidency = con.executeSelectNoParameter(sqlResidency); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempResidency != null) || (tempResidency.Rows.Count >= 0))
{
foreach (DataRow drr in tempResidency.Rows)
{
Residency residency = new Residency();
residency.residencyId = Convert.ToInt32(drr["ResidencyId"].ToString());
residency.vrt_australiancitizenshipresidency = drr["Residency"].ToString();
residency.type = drr["Type"].ToString();
residencyCollection.Add(residency);
}
}
lkp.vrt_australiancitizenshipresidency = residencyCollection;
#endregion
#region Get Aboriginal
List <Aboriginal> aboriginalCollection = new List <Aboriginal>();
string sqlAboriginal = string.Concat("[dbo].[sp_getIndigenousAustralians]");
DataTable tempAboriginal = null;
tempAboriginal = con.executeSelectNoParameter(sqlAboriginal); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempAboriginal != null) || (tempAboriginal.Rows.Count >= 0))
{
foreach (DataRow drr in tempAboriginal.Rows)
{
Aboriginal aboriginal = new Aboriginal();
aboriginal.statusId = Convert.ToInt32(drr["StatusId"].ToString());
aboriginal.vrt_aboriginalortorresstraitislander = drr["Status"].ToString();
aboriginalCollection.Add(aboriginal);
}
}
lkp.vrt_aboriginalortorresstraitislander = aboriginalCollection;
#endregion
#region Get Qualification
List <Qualification> qualificationCollection = new List <Qualification>();
string sqlQualification = string.Concat("[dbo].[sp_getQualification]");
DataTable tempsqlQualification = null;
tempsqlQualification = con.executeSelectNoParameter(sqlQualification); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlQualification != null) || (tempsqlQualification.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlQualification.Rows)
{
Qualification qualification = new Qualification();
qualification.qualificationID = Convert.ToInt32(drr["QualificationID"].ToString());
qualification.qualification = drr["Qualification"].ToString();
qualification.internalName = drr["internalName"].ToString();
qualification.selected = false;
qualification.qualificationCode = drr["qualificationCode"].ToString() ?? "";
qualificationCollection.Add(qualification);
}
}
lkp.txtQualification = qualificationCollection;
#endregion
#region Get State
List <State> stateCollection = new List <State>();
string sqlState = string.Concat("[dbo].[sp_getState]");
DataTable tempsqlState = null;
tempsqlState = con.executeSelectNoParameter(sqlState); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlState != null) || (tempsqlState.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlState.Rows)
{
State state = new State();
state.stateID = Convert.ToInt32(drr["StateID"].ToString());
state.state = drr["State"].ToString();
stateCollection.Add(state);
}
}
lkp.state = stateCollection;
#endregion
#region Get IdProof
List <IdProof> idProofCollection = new List <IdProof>();
string idProofState = string.Concat("[dbo].[sp_getIdentityProof]");
DataTable tempsqlIdProof = null;
tempsqlIdProof = con.executeSelectNoParameter(idProofState); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlIdProof != null) || (tempsqlIdProof.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlIdProof.Rows)
{
IdProof idProof = new IdProof();
idProof.proofId = Convert.ToInt32(drr["ProofId"].ToString());
idProof.idProofName = drr["IdentityProof"].ToString();
idProof.type = drr["Type"].ToString();
idProof.internalName = drr["InternalName"].ToString();
idProofCollection.Add(idProof);
}
}
lkp.idProof = idProofCollection;
#endregion
#region Get WhatBroughtYouHere
List <WhatBroughtYouHere> whatBroughtYouHereCollection = new List <WhatBroughtYouHere>();
string sqlwhatBroughtYouHereCollection = string.Concat("[dbo].[sp_getReasonToChooseBKI]");
DataTable tempsqlWhatBroughtYouHere = null;
tempsqlWhatBroughtYouHere = con.executeSelectNoParameter(sqlwhatBroughtYouHereCollection); //con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempsqlWhatBroughtYouHere != null) || (tempsqlWhatBroughtYouHere.Rows.Count >= 0))
{
foreach (DataRow drr in tempsqlWhatBroughtYouHere.Rows)
{
WhatBroughtYouHere state = new WhatBroughtYouHere();
state.reasonToChooseBKIID = Convert.ToInt32(drr["ReasonToChooseBKIID"].ToString());
state.vrt_whatbroughtyoutothekanganinstitutewebsite = drr["ReasonToChooseBKI"].ToString();
whatBroughtYouHereCollection.Add(state);
}
}
lkp.whatBroughtYouHere = whatBroughtYouHereCollection;
#endregion
}
catch (Exception e)
{
}
return(lkp);
}
