public ActionResult AddEditPosting(VacancyEditViewModel model) { var job_type = _context.job_types.ToList(); var experience_levels = _context.experience_levels.OrderBy(x => x.id).ToList(); var education_levels = _context.education_levels.ToList(); var userId = User.Identity.GetUserId(); if (model.id == 0) { var vacancy = new vacancy(); vacancy.name = model.name; vacancy.description = model.description; vacancy.contact = model.contact; vacancy.education_level = education_levels.Where(x => x.id == model.education_level).FirstOrDefault(); vacancy.experience_level = experience_levels.Where(x => x.id == model.experience_level).FirstOrDefault(); vacancy.job_type = job_type.Where(x => x.id == model.job_type).FirstOrDefault(); vacancy.company = _context.companies.FirstOrDefault(x => x.company_id == userId); _context.vacancies.Add(vacancy); _context.SaveChanges(); } if (model.id != 0) { var vacancy = _context.vacancies.Where(x => x.id == model.id).FirstOrDefault(); vacancy.name = model.name; vacancy.description = model.description; vacancy.contact = model.contact; vacancy.education_level = education_levels.Where(x => x.id == model.education_level).FirstOrDefault(); vacancy.experience_level = experience_levels.Where(x => x.id == model.experience_level).FirstOrDefault(); vacancy.job_type = job_type.Where(x => x.id == model.job_type).FirstOrDefault(); _context.SaveChanges(); } return(RedirectToAction("JobsPostings")); }
public static void LocalMain() { List <vacancy> vacancies = new List <vacancy>(); int countOfVacancies = JsonConvert.DeserializeObject <Responce>(Task.Run(async() => await Helper.GetContentAsync(0)).Result).meta.total; int countOfPages = countOfVacancies / 100 + 1; for (int offset = 0; offset < countOfPages; offset++) { string json = Task.Run(async() => await Helper.GetContentAsync(offset)).Result; var resultObjects = Helper.AllChildren(JObject.Parse(json)) .First(c => c.Type == JTokenType.Array && c.Path.Contains("vacancies")) .Children <JObject>(); foreach (JObject result in resultObjects) { foreach (JProperty property in result.Properties()) { vacancy vacancy = JsonConvert.DeserializeObject <vacancy>(property.Value.ToString()); vacancies.Add(vacancy); Console.WriteLine(property.Name + " " + property.Value); } } } Console.WriteLine($"{countOfPages}\n{countOfVacancies}"); }
public ActionResult DeleteConfirmed(int id) { vacancy vacancy = db.vacancies.Find(id); db.vacancies.Remove(vacancy); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "vacancyid,title,text,users_userid,date")] vacancy vacancy) { if (ModelState.IsValid) { db.Entry(vacancy).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.users_userid = new SelectList(db.AspNetUsers, "Id", "Email", vacancy.users_userid); return(View(vacancy)); }
// GET: Vacancies/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } vacancy vacancy = db.vacancies.Find(id); if (vacancy == null) { return(HttpNotFound()); } return(View(vacancy)); }
// GET: Vacancies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } vacancy vacancy = db.vacancies.Find(id); if (vacancy == null) { return(HttpNotFound()); } ViewBag.users_userid = new SelectList(db.AspNetUsers, "Id", "Email", vacancy.users_userid); return(View(vacancy)); }
public ActionResult Create([Bind(Include = "vacancyid,title,text,users_userid,date")] vacancy vacancy) { if (ModelState.IsValid) { string username = User.Identity.Name.ToString(); var userid = db.AspNetUsers.SqlQuery("SELECT * FROM AspNetUsers WHERE UserName = "******"'" + username + "'").ToList(); AspNetUser user = userid[0]; vacancy.users_userid = user.Id; vacancy.date = DateTime.Now; db.vacancies.Add(vacancy); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.users_userid = new SelectList(db.AspNetUsers, "Id", "Email", vacancy.users_userid); return(View(vacancy)); }
public bool Update(vacancy Entity) { _db.Vacancies.Update(Entity); return(Save()); }
public bool Delete(vacancy Entity) { _db.Vacancies.Remove(Entity); return(Save()); }
public bool Create(vacancy Entity) { _db.Vacancies.Add(Entity); return(Save()); }