protected override void OnNavigatedTo(NavigationEventArgs e)
{
try
{
job = new Job();
jobModel = new JobViewModel();
job = jobModel.getJobs();
oldAge = new OldAge();
oldModel = new OldAgeViewModel();
oldAge = oldModel.getOldAges();
orphanage = new Orphanage();
orphanageModel = new OrphanageViewModel();
orphanage = orphanageModel.getOrphanages();
if (job == null)
{
//populate jobs table if empty
jobModel.addJobManually("TUT Jobs", "http://www.tut.ac.za");
jobModel.addJobManually("Carees 24", "http://www.carees24.com");
jobModel.addJobManually("Goverment Jobs", "http://www.goverment.ac.za");
jobModel.addJobManually("Indeed Jobs", "http://www.indeed.com");
}
//now populate old ages table if empty
if (oldAge != null)
{
oldModel.addOldAgeManually("Overall Search", "https://www.google.co.za/?gfe_rd=cr&ei=M13pVZSSGYKp8weova_IDw&gws_rd=ssl#q=oldAge");
oldModel.addOldAgeManually("Vermount Old Age", "http://community-services.blaauwberg.net/old-age-homes/old-age-homes-western-cape/Vermont-Old-Aged-Home-Hornlee");
oldModel.addOldAgeManually("SeniorServices Old Age", "https://www.google.co.za/?gfe_rd=cr&ei=M13pVZSSGYKp8weova_IDw&gws_rd=ssl#q=seniorservice");
oldModel.addOldAgeManually("Mothwa Haven Old Age", "http://www.yellowpages.co.za/business/SA_5878392_BUS");
}
//now populate orphanages table if empty
if (orphanage != null)
{
orphanageModel.addOphenagebManually("Tshwaraganang", "http://www.tshwaraganang.org.za/index.php/component/content/?view=featured");
orphanageModel.addOphenagebManually("Arcadia Home", "http://www.jhbchev.co.za/pages/default.aspx");
orphanageModel.addOphenagebManually("Sunnyside Orphanage Home", "http://www.soh.org.za/");
orphanageModel.addOphenagebManually("Overall Search", "https://www.google.co.za/?gfe_rd=cr&ei=M13pVZSSGYKp8weova_IDw&gws_rd=ssl#q=orphanage+");
}
}
catch (Exception ex)
{
}
base.OnNavigatedTo(e);
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
try
{
job = new Job();
jobModel = new JobViewModel();
job = jobModel.getJobs();
oldAge = new OldAge();
oldModel = new OldAgeViewModel();
oldAge = oldModel.getOldAges();
orphanage = new Orphanage();
orphanageModel = new OrphanageViewModel();
orphanage = orphanageModel.getOrphanages();
if (job == null)
{
//populate jobs table if empty
jobModel.addJobManually("TUT Jobs", "http://www.tut.ac.za");
jobModel.addJobManually("Carees 24", "http://www.carees24.com");
jobModel.addJobManually("Goverment Jobs", "http://www.goverment.ac.za");
jobModel.addJobManually("Indeed Jobs", "http://www.indeed.com");
}
//now populate old ages table if empty
if (oldAge == null)
{
oldModel.addOldAgeManually("Vermount Old Age", "http://www.vermount.ac.za");
oldModel.addOldAgeManually("Vermount Old Age", "http://www.vermount.ac.za");
oldModel.addOldAgeManually("Vermount Old Age", "http://www.vermount.ac.za");
}
//now populate orphanages table if empty
if (orphanage == null)
{
orphanageModel.addOphenagebManually("Thabang Lebese");
orphanageModel.addOphenagebManually("Thabang Lebese");
orphanageModel.addOphenagebManually("Thabang Lebese");
}
}
catch (Exception ex)
{
}
base.OnNavigatedTo(e);
}
public ObservableCollection <JobViewModel> getAllJobs()
{
job = new ObservableCollection <JobViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Table <Job>();
foreach (var j in query)
{
var jo = new JobViewModel()
{
ID = j.Id,
JOB_NAME = j.name,
Address = j.address
};
job.Add(jo);
}
}
return(job);
}
public ObservableCollection<JobViewModel> getAllJobs()
{
job = new ObservableCollection<JobViewModel>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Table<Job>();
foreach (var j in query)
{
var jo = new JobViewModel()
{
ID = j.Id,
JOB_NAME = j.name,
Address = j.address
};
job.Add(jo);
}
}
return job;
}