//Populates the Job table private void PopulateJob() { DateTime now = DateTime.Now; Job job = new Job() { uuid = Guid.NewGuid().ToString(), title = "Internship Allround Norway", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/internship-allround-norway", linkedInProfile = "", stepsToApply = "", expiryDate = new DateTime(2016, 08, 31), created = new DateTime(2016, 04, 11), published = new DateTime(2016, 04, 11), modified = new DateTime(2016, 04, 11) }; Company company = db.companies.First(x => x.id.Equals("travelbird")); Contact contact = db.contacts.First(x => x.id == 1); JobType praksis = db.jobTypes.First(x => x.id.Equals("praksis")); JobType heltid = db.jobTypes.First(x => x.id.Equals("heltid")); JobType deltid = db.jobTypes.First(x => x.id.Equals("deltid")); StudyGroup data = db.studyGroup.First(x => x.id.Equals("datateknologi")); StudyGroup idrett = db.studyGroup.First(x => x.id.Equals("idrett")); StudyGroup helse = db.studyGroup.First(x => x.id.Equals("helse")); StudyGroup historie = db.studyGroup.First(x => x.id.Equals("historie")); StudyGroup administrasjon = db.studyGroup.First(x => x.id.Equals("administrasjon")); StudyGroup ingeniør = db.studyGroup.First(x => x.id.Equals("ingeniør")); StudyGroup kunstfag = db.studyGroup.First(x => x.id.Equals("kunstfag")); StudyGroup ped = db.studyGroup.First(x => x.id.Equals("ped")); StudyGroup medie = db.studyGroup.First(x => x.id.Equals("medie")); StudyGroup musikk = db.studyGroup.First(x => x.id.Equals("musikk")); StudyGroup realfag = db.studyGroup.First(x => x.id.Equals("realfag")); StudyGroup samfunnsfag = db.studyGroup.First(x => x.id.Equals("samfunnsfag")); StudyGroup økonomi = db.studyGroup.First(x => x.id.Equals("økonomi")); StudyGroup språk = db.studyGroup.First(x => x.id.Equals("språk")); StudyGroup uspesifisert = db.studyGroup.First(x => x.id.Equals("uspesifisert")); Location va = db.locations.First(x => x.id.Equals("vestagder")); Location ut = db.locations.First(x => x.id.Equals("utlandet")); Location aker = db.locations.First(x => x.id.Equals("akershus")); Location aa = db.locations.First(x => x.id.Equals("austagder")); Location busk = db.locations.First(x => x.id.Equals("buskerud")); Location finn = db.locations.First(x => x.id.Equals("finnmark")); Location hed = db.locations.First(x => x.id.Equals("hedmark")); Location hord = db.locations.First(x => x.id.Equals("hordaland")); Location møre = db.locations.First(x => x.id.Equals("møreogromsdal")); Location nordl = db.locations.First(x => x.id.Equals("nordland")); Location nordt = db.locations.First(x => x.id.Equals("nordtrøndelag")); Location opp = db.locations.First(x => x.id.Equals("oppland")); Location oslo = db.locations.First(x => x.id.Equals("oslo")); Location roga = db.locations.First(x => x.id.Equals("rogaland")); Location sogn = db.locations.First(x => x.id.Equals("sognogfjordane")); Location sørt = db.locations.First(x => x.id.Equals("sørtrøndelag")); Location tele = db.locations.First(x => x.id.Equals("telemark")); Location troms = db.locations.First(x => x.id.Equals("troms")); Location vestf = db.locations.First(x => x.id.Equals("vestfold")); Location østf = db.locations.First(x => x.id.Equals("østfold")); Location svalb = db.locations.First(x => x.id.Equals("svalbard")); job.contacts.Add(contact); job.studyGroups.Add(uspesifisert); job.locations.Add(ut); job.jobTypes.Add(praksis); job.companies.Add(company); db.jobs.Add(job); db.SaveChanges(); Job job2 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Test Users for Apps & Websites wanted!", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/test-users-for-apps-websites-wanted", linkedInProfile = "", stepsToApply = "Send email", expiryDate = new DateTime(2017, 01, 01, 01, 01, 01), created = new DateTime(2016, 04, 01, 01, 01, 01), published = new DateTime(2016, 04, 01, 01, 01, 01), modified = new DateTime(2016, 04, 01, 01, 01, 01) }; Contact contact2 = db.contacts.First(x => x.id == 2); Company company2 = db.companies.First(x => x.id.Equals("testbirds")); job2.contacts.Add(contact2); job2.studyGroups.Add(idrett); job2.studyGroups.Add(data); job2.studyGroups.Add(medie); job2.studyGroups.Add(realfag); job2.studyGroups.Add(økonomi); job2.studyGroups.Add(språk); job2.studyGroups.Add(musikk); job2.studyGroups.Add(helse); job2.studyGroups.Add(historie); job2.studyGroups.Add(administrasjon); job2.studyGroups.Add(ingeniør); job2.studyGroups.Add(kunstfag); job2.studyGroups.Add(samfunnsfag); job2.studyGroups.Add(ped); job2.studyGroups.Add(uspesifisert); job2.locations.Add(va); job2.locations.Add(aker); job2.locations.Add(busk); job2.locations.Add(finn); job2.locations.Add(hed); job2.locations.Add(hord); job2.locations.Add(møre); job2.locations.Add(nordl); job2.locations.Add(opp); job2.locations.Add(oslo); job2.locations.Add(roga); job2.locations.Add(sogn); job2.locations.Add(sørt); job2.locations.Add(tele); job2.locations.Add(troms); job2.locations.Add(nordt); job2.locations.Add(aa); job2.locations.Add(vestf); job2.locations.Add(østf); job2.locations.Add(svalb); job2.locations.Add(ut); job2.jobTypes.Add(deltid); job2.companies.Add(company2); db.jobs.Add(job2); db.SaveChanges(); //htc.Student = student; Job job3 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Online Marketing internship", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/online-marketing-internship", linkedInProfile = "", stepsToApply = "Send email", expiryDate = new DateTime(2016, 12, 16), created = new DateTime(2016, 03, 14), published = new DateTime(2016, 03, 14), modified = new DateTime(2016, 03, 14) }; Contact contact3 = db.contacts.First(x => x.id == 3); Company company3 = db.companies.First(x => x.id.Equals("cuponation")); job3.contacts.Add(contact3); job3.studyGroups.Add(medie); job3.jobTypes.Add(praksis); job3.locations.Add(ut); job3.companies.Add(company3); db.jobs.Add(job3); db.SaveChanges(); Job job4 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Do you love languages?", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/do-you-love-languages", linkedInProfile = "", stepsToApply = "Send email", expiryDate = new DateTime(2016, 09, 15), created = new DateTime(2016, 03, 11), published = new DateTime(2016, 03, 11), modified = new DateTime(2016, 03, 11) }; Contact contact4 = db.contacts.First(x => x.id == 4); Company company4 = db.companies.First(x => x.id.Equals("beconnected")); job4.contacts.Add(contact4); job4.studyGroups.Add(ped); job4.studyGroups.Add(språk); job4.locations.Add(ut); job4.jobTypes.Add(deltid); job4.companies.Add(company4); db.jobs.Add(job4); db.SaveChanges(); //return RedirectToAction("About", "Home"); Job job5 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Testing av apper og nettsider", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/testing-av-apper-og-nettsider", linkedInProfile = "", stepsToApply = "Send email", expiryDate = new DateTime(2017, 01, 01), created = new DateTime(2016, 04, 01), published = new DateTime(2016, 04, 01), modified = new DateTime(2016, 04, 01) }; Contact contact5 = db.contacts.First(x => x.id == 2); Company company5 = db.companies.First(x => x.id.Equals("testbirds2")); job5.contacts.Add(contact5); job5.studyGroups.Add(idrett); job5.studyGroups.Add(data); job5.studyGroups.Add(medie); job5.studyGroups.Add(realfag); job5.studyGroups.Add(økonomi); job5.studyGroups.Add(språk); job5.studyGroups.Add(musikk); job5.studyGroups.Add(helse); job5.studyGroups.Add(historie); job5.studyGroups.Add(administrasjon); job5.studyGroups.Add(ingeniør); job5.studyGroups.Add(kunstfag); job5.studyGroups.Add(samfunnsfag); job5.studyGroups.Add(ped); job5.studyGroups.Add(uspesifisert); job5.locations.Add(va); job5.locations.Add(aker); job5.locations.Add(busk); job5.locations.Add(finn); job5.locations.Add(hed); job5.locations.Add(hord); job5.locations.Add(møre); job5.locations.Add(nordl); job5.locations.Add(opp); job5.locations.Add(oslo); job5.locations.Add(roga); job5.locations.Add(sogn); job5.locations.Add(sørt); job5.locations.Add(tele); job5.locations.Add(troms); job5.locations.Add(aa); job5.locations.Add(vestf); job5.locations.Add(østf); job5.locations.Add(svalb); job5.locations.Add(ut); job5.jobTypes.Add(deltid); job5.companies.Add(company5); db.jobs.Add(job5); db.SaveChanges(); Job job6 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Fleksibel deltidsjobb som privatunderviser", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/fleksibel-deltidsjobb-som-privatunderviser", linkedInProfile = "", stepsToApply = "Send email", expiryDate = new DateTime(2016, 11, 12), published = new DateTime(2015, 11, 12), created = new DateTime(2015, 11, 12), modified = new DateTime(2015, 11, 12) }; Contact contact6 = db.contacts.First(x => x.id == 5); Company company6 = db.companies.First(x => x.id.Equals("mentornorge")); job6.contacts.Add(contact6); job6.studyGroups.Add(idrett); job6.studyGroups.Add(data); job6.studyGroups.Add(medie); job6.studyGroups.Add(realfag); job6.studyGroups.Add(økonomi); job6.studyGroups.Add(språk); job6.studyGroups.Add(musikk); job6.studyGroups.Add(helse); job6.studyGroups.Add(historie); job6.studyGroups.Add(administrasjon); job6.studyGroups.Add(ingeniør); job6.studyGroups.Add(kunstfag); job6.studyGroups.Add(samfunnsfag); job6.studyGroups.Add(ped); job6.studyGroups.Add(uspesifisert); job6.jobTypes.Add(deltid); job6.companies.Add(company6); db.jobs.Add(job6); db.SaveChanges(); Job job7 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Internship", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/internship", linkedInProfile = "", stepsToApply = "Send email", published = new DateTime(2015, 11, 04), expiryDate = new DateTime(2016, 11, 04), created = new DateTime(2015, 11, 04), modified = new DateTime(2015, 11, 04), }; Contact contact7 = db.contacts.First(x => x.id == 6); Company company7 = db.companies.First(x => x.id.Equals("archipelagos")); job7.contacts.Add(contact7); job7.locations.Add(ut); job7.studyGroups.Add(medie); job7.studyGroups.Add(realfag); job7.studyGroups.Add(ingeniør); job7.studyGroups.Add(samfunnsfag); job7.jobTypes.Add(deltid); job7.companies.Add(company7); db.jobs.Add(job7); db.SaveChanges(); Job job8 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Tilkallingsvikarer natttjenesten - sykepleierstudenter - Berge gård", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/tilkallingsvikarer-nattjenesten-sykepleierstudenter-berge-gaard", linkedInProfile = "", stepsToApply = "Send email", published = new DateTime(2015, 09, 17), expiryDate = new DateTime(2016, 09, 17), created = new DateTime(2015, 09, 17), modified = new DateTime(2015, 09, 17) }; Contact contact8 = db.contacts.First(x => x.id == 7); Company company8 = db.companies.First(x => x.id.Equals("grimstadkommune")); job8.contacts.Add(contact8); job8.studyGroups.Add(uspesifisert); job8.jobTypes.Add(deltid); job8.companies.Add(company8); db.jobs.Add(job8); db.SaveChanges(); Job job9 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Fotballtrener ved Fotballfritidsordning", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/fotballtrener-ved-fotballfritidsordning", linkedInProfile = "", stepsToApply = "Send email", published = new DateTime(2015, 08, 17), expiryDate = new DateTime(2016, 08, 17), created = new DateTime(2015, 08, 17), modified = new DateTime(2015, 08, 17) }; Contact contact9 = db.contacts.First(x => x.id == 8); Company company9 = db.companies.First(x => x.id.Equals("ikstart")); job9.contacts.Add(contact9); job9.studyGroups.Add(idrett); job9.jobTypes.Add(deltid); job9.companies.Add(company9); db.jobs.Add(job9); db.SaveChanges(); Job job10 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Advisor / Senior Advisor, Financial Reporting Competence Center", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/advisor-senior-advisor-financial-reporting-competence-center", linkedInProfile = "", stepsToApply = "Send email", published = new DateTime(2015, 05, 08), expiryDate = new DateTime(2017, 05, 08), created = new DateTime(2015, 05, 08), modified = new DateTime(2015, 05, 08) }; Contact contact10 = db.contacts.First(x => x.id == 9); Company company10 = db.companies.First(x => x.id.Equals("accurateequity")); job10.contacts.Add(contact10); job10.studyGroups.Add(administrasjon); job10.studyGroups.Add(data); job10.studyGroups.Add(økonomi); job10.studyGroups.Add(uspesifisert); job10.jobTypes.Add(heltid); job10.companies.Add(company10); db.jobs.Add(job10); db.SaveChanges(); Job job11 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Spennende internship innen SEO, markedsføring og digital kommunikasjon hos Rabble", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/spennende-internship-innen-seo-markedsfoering-og-digital-kommunikasjon-hos-rabble", linkedInProfile = "", stepsToApply = "Send email", published = new DateTime(2015, 04, 15), expiryDate = new DateTime(2017, 06, 20), created = new DateTime(2015, 04, 15), modified = new DateTime(2015, 04, 15) }; Contact contact11 = db.contacts.First(x => x.id == 10); Company company11 = db.companies.First(x => x.id.Equals("accurateequity")); job11.contacts.Add(contact11); job11.locations.Add(ut); job11.studyGroups.Add(medie); job11.studyGroups.Add(økonomi); job11.studyGroups.Add(uspesifisert); job11.jobTypes.Add(heltid); job11.companies.Add(company11); db.jobs.Add(job11); db.SaveChanges(); }
public async Task<IHttpActionResult> PostJob(Job job) { if (!ModelState.IsValid) { return BadRequest(ModelState); } db.jobs.Add(job); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (JobExists(job.uuid)) { return Conflict(); } else { throw; } } return CreatedAtRoute("DefaultApi", new { id = job.uuid }, job); }
public void InsertTrenerJobb() { Job job9 = new Job() { uuid = Guid.NewGuid().ToString(), title = "Fotballtrener ved Fotballfritidsordning", description = "", webpage = "https://kompetansetorget.uia.no/stillinger/fotballtrener-ved-fotballfritidsordning", linkedInProfile = "", stepsToApply = "Send email", published = new DateTime(2015, 08, 17), expiryDate = new DateTime(2016, 08, 17), created = new DateTime(2015, 08, 17), modified = new DateTime(2015, 08, 17) }; Contact contact9 = db.contacts.First(x => x.id == 8); Company company9 = db.companies.First(x => x.id.Equals("ikstart")); job9.contacts.Add(contact9); StudyGroup idrett = db.studyGroup.First(x => x.id.Equals("idrett")); JobType deltid = db.jobTypes.First(x => x.id.Equals("deltid")); job9.studyGroups.Add(idrett); job9.jobTypes.Add(deltid); job9.companies.Add(company9); db.jobs.Add(job9); db.SaveChanges(); }
public async Task<IHttpActionResult> PutJob(string id, Job job) { if (!ModelState.IsValid) { return BadRequest(ModelState); } if (id != job.uuid) { return BadRequest(); } db.Entry(job).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!JobExists(id)) { return NotFound(); } else { throw; } } return StatusCode(HttpStatusCode.NoContent); }