/// <summary> /// Can return 3 different values: /// 1. "exists": No new jobs on the server. /// 2. "incorrectCache": If the cache indicates that local database got data that the server doesnt have. /// 3. "newData": There are new jobs available on the server. /// 4. null: Check if Authenticater.Authorized has been set to false, if not the app could most likely not reach the server. /// TODO Way to complicated logic, simplify this method if theres time /// </summary> /// <returns></returns> private async Task <string> CheckServerForNewData(List <string> studyGroups = null, Dictionary <string, string> filter = null) { //"api/v1/jobs/lastmodifed" string queryParams = CreateQueryParams(studyGroups, null, filter); string adress = Adress + "/" + "lastmodified" + queryParams; System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData - adress: " + adress); Uri url = new Uri(adress); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData - url.ToString: " + url.ToString()); var client = new HttpClient(); DbStudent dbStudent = new DbStudent(); string accessToken = dbStudent.GetStudentAccessToken(); if (string.IsNullOrWhiteSpace(accessToken)) { Authenticater.Authorized = false; return(null); } System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData - bearer: " + accessToken); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken); string jsonString = null; try { var response = await client.GetAsync(url); System.Diagnostics.Debug.WriteLine("CheckServerForNewData response " + response.StatusCode.ToString()); if (response.StatusCode == HttpStatusCode.Unauthorized) { System.Diagnostics.Debug.WriteLine("JobsController - CheckServerForNewData failed due to lack of Authorization"); Authenticater.Authorized = false; } else if (response.StatusCode == HttpStatusCode.OK) { //results = await response.Content.ReadAsAsync<IEnumerable<Job>>(); jsonString = await response.Content.ReadAsStringAsync(); } } catch (Exception e) { System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: await client.GetAsync(\"url\") Failed"); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: Exception msg: " + e.Message); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: Stack Trace: \n" + e.StackTrace); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: End Of Stack Trace"); return(null); } if (jsonString != null) { // using <string, object> instead of <string, string> makes the date be stored in the right format when using .ToString() Dictionary <string, object> dict = JsonConvert.DeserializeObject <Dictionary <string, object> >(jsonString); if (dict.ContainsKey("uuid") && dict.ContainsKey("modified") && dict.ContainsKey("hash") && dict.ContainsKey("amountOfJobs")) { string uuid = dict["uuid"].ToString(); DateTime dateTime = (DateTime)dict["modified"]; long modified = long.Parse(dateTime.ToString("yyyyMMddHHmmss")); string uuids = dict["hash"].ToString(); int amountOfJobs = 0; try { amountOfJobs = Int32.Parse(dict["amountOfJobs"].ToString()); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: await client.GetAsync(\"url\") Failed"); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: Exception msg: " + ex.Message); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: Stack Trace: \n" + ex.StackTrace); System.Diagnostics.Debug.WriteLine("JobController - CheckServerForNewData: End Of Stack Trace"); return(null); } DbJob db = new DbJob(); bool existInDb = db.ExistsInDb(uuid, modified); if (!existInDb) { return("newData"); //return existInDb; } var localJobs = db.GetJobsFromDbBasedOnFilter(studyGroups, filter, true); int localDbCount = localJobs.Count(); StringBuilder sb = new StringBuilder(); foreach (var job in localJobs) { sb.Append(job.uuid); } string localUuids = Hasher.CalculateMd5Hash(sb.ToString()); // if there is a greater amount of jobs on that search filter then the job that exist // in the database has been inserted throught another search filter if (uuids != localUuids) { if (amountOfJobs > localDbCount) { return("newData"); //return !existInDb; } return("incorrectCache"); } return("exists"); //return existInDb; } } return(null); }
/// <summary> /// Peter ikke se på denne metoden, den er kun for å teste databasen :D /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private async void TestJobsFilterDb_OnClicked(object sender, EventArgs e) { List <string> studyGroups = new List <string>(); string helse = Hasher.Base64Encode("helse"); string datateknologi = Hasher.Base64Encode("datateknologi"); studyGroups.Add(helse); studyGroups.Add(datateknologi); Dictionary <string, string> filter = new Dictionary <string, string>(); string vestagder = Hasher.Base64Encode("vestagder"); string heltid = Hasher.Base64Encode("heltid"); filter.Add("locations", vestagder); filter.Add("types", heltid); DbJob jc = new DbJob(); var jobs = jc.GetJobsFromDbBasedOnFilter(null, filter); if (jobs == null) { System.Diagnostics.Debug.WriteLine("TestJobsFilterDb: was null aka failed!"); } else { System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter: jobs.Count(): " + jobs.Count()); foreach (var job in jobs) { System.Diagnostics.Debug.WriteLine("Jobs title: " + job.title); if (job.companies != null) { System.Diagnostics.Debug.WriteLine("Companies is not null: " + job.companies[0].id); } } } var jobs2 = jc.GetJobsFromDbBasedOnFilter(studyGroups); if (jobs2 == null) { System.Diagnostics.Debug.WriteLine("TestJobsFilterDb: was null aka failed!"); } else { System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter: jobs2.Count(): " + jobs2.Count()); foreach (var job in jobs2) { System.Diagnostics.Debug.WriteLine("Jobs2 title: " + job.title); if (job.companies != null) { System.Diagnostics.Debug.WriteLine("Companies is not null: " + job.companies[0].id); System.Diagnostics.Debug.WriteLine("Companies is not null: " + job.companies[0].name); System.Diagnostics.Debug.WriteLine("Companies is not null: " + job.companies[0].logo); } } } var jobs3 = jc.GetJobsFromDbBasedOnFilter(studyGroups, filter); if (jobs3 == null) { System.Diagnostics.Debug.WriteLine("TestJobsFilterDb: was null aka failed!"); } else { System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter: jobs3.Count(): " + jobs3.Count()); foreach (var job in jobs3) { System.Diagnostics.Debug.WriteLine("Jobs3 title: " + job.title); if (job.companies != null) { System.Diagnostics.Debug.WriteLine("Companies is not null: " + job.companies[0].id); } } } Dictionary <string, string> filter2 = new Dictionary <string, string>(); //string internship = Hasher.Base64Encode("Internship"); filter2.Add("titles", "Internship"); var jobs4 = jc.GetJobsFromDbBasedOnFilter(studyGroups, filter2); if (jobs4 == null) { System.Diagnostics.Debug.WriteLine("TestJobsFilterDb: was null aka failed!"); } else { System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter: jobs4.Count(): " + jobs4.Count()); foreach (var job in jobs4) { System.Diagnostics.Debug.WriteLine("Jobs4 title: " + job.title); if (job.companies != null) { System.Diagnostics.Debug.WriteLine("Companies is not null: " + job.companies[0].id); } } } /* * StudyGroupsController sgc = new StudyGroupsController(); * sgc.UpdateStudyGroupsFromServer(); */ }
/// <summary> /// Gets a job based on optional filters. /// </summary> /// <param name="studyGroups">studyGroups can be a list of numerous studygroups ex: helse, idrettsfag, datateknologi </param> /// </param> /// <param name="filter">A dictionary where key can be: titles (values:title of the job), types (values: deltid, heltid, etc...), /// locations (values: vestagder, austagder), . /// Supports only 1 key at this current implementation!</param> /// <returns></returns> public async Task <IEnumerable <Job> > GetJobsBasedOnFilter(List <string> studyGroups = null, Dictionary <string, string> filter = null) { DbJob db = new DbJob(); //string adress = "http://kompetansetorgetserver1.azurewebsites.net/api/v1/jobs"; string instructions = await CheckServerForNewData(studyGroups, filter); if (!Authenticater.Authorized) { return(null); } if (instructions != null) { System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter - instructions: " + instructions); if (instructions == "exists") // "newData"; incorrectCache exists { IEnumerable <Job> filteredJobs = db.GetJobsFromDbBasedOnFilter(studyGroups, filter); filteredJobs = db.GetAllCompaniesRelatedToJobs(filteredJobs.ToList()); return(filteredJobs); } } DbStudent dbStudent = new DbStudent(); string accessToken = dbStudent.GetStudentAccessToken(); if (string.IsNullOrWhiteSpace(accessToken)) { Authenticater.Authorized = false; return(null); } string sortBy = "publish"; string queryParams = CreateQueryParams(studyGroups, sortBy, filter); Uri url = new Uri(Adress + queryParams); System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter - url: " + url.ToString()); var client = new HttpClient(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("bearer", accessToken); string jsonString = null; IEnumerable <Job> jobs = null; try { var response = await client.GetAsync(url).ConfigureAwait(false); System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter response " + response.StatusCode.ToString()); if (response.StatusCode == HttpStatusCode.Unauthorized) { System.Diagnostics.Debug.WriteLine("StudentsController - UpdateStudyGroupStudent failed due to lack of Authorization"); Authenticater.Authorized = false; } else if (response.StatusCode == HttpStatusCode.OK) { jsonString = await response.Content.ReadAsStringAsync(); //DeleteJobs(GetJobsFromDbBasedOnFilter(studyGroups, filter)); if (instructions != null && instructions == "incorrectCache") { var cachedJobs = db.GetJobsFromDbBasedOnFilter(studyGroups, filter); jobs = DeserializeMany(jsonString); // Get all jobs from that local dataset that was not in the data set provided by the server // These are manually deleted jobs and have to be cleared from cache. // linear search is ok because of small data set var manuallyDeletedJobs = cachedJobs.Where(j => !jobs.Any(cj2 => cj2.uuid == j.uuid)); db.DeleteObsoleteJobs(manuallyDeletedJobs.ToList()); } else { jobs = DeserializeMany(jsonString); } } else { System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter - Using the local database"); jobs = db.GetJobsFromDbBasedOnFilter(studyGroups, filter); jobs = db.GetAllCompaniesRelatedToJobs(jobs.ToList()); } return(jobs); } catch (Exception e) { // Hack workaround if mobil data and wifi is turned off try { jobs = db.GetJobsFromDbBasedOnFilter(studyGroups, filter); jobs = db.GetAllCompaniesRelatedToJobs(jobs.ToList()); return(jobs); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("JobsController - GetJobsBasedOnFilter: await client.GetAsync(\"url\") Failed"); System.Diagnostics.Debug.WriteLine("JobsController - GetJobsBasedOnFilter: Exception msg: " + ex.Message); System.Diagnostics.Debug.WriteLine("JobsController - GetJobsBasedOnFilter: Stack Trace: \n" + ex.StackTrace); System.Diagnostics.Debug.WriteLine("JobsController - GetJobsBasedOnFilter: End Of Stack Trace"); System.Diagnostics.Debug.WriteLine("GetJobsBasedOnFilter - Using the local database"); return(null); } } }