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