//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);
}
