public ActionResult DeleteConfirmed(int id) { try { db.Applications.RemoveRange(db.Applications.Where(m => m.job_posting == id)); Job_Postings job_Postings = db.Job_Postings.Find(id); db.Job_Postings.Remove(job_Postings); db.SaveChanges(); return(RedirectToAction("Admin")); } catch (DbUpdateException dbException) { ViewBag.DbExceptionMessage = dbException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (EntityException entityException) { ViewBag.EntityExceptionMessage = entityException.InnerException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (SqlException sqlException) { ViewBag.SqlExceptionNumber = sqlException.Number; ViewBag.SqlExceptionMessage = sqlException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (Exception e) { ViewBag.ExceptionMessage = e.Message; return(View("~/Views/Errors/Details.cshtml")); } }
public ActionResult Edit(int?id) { try { if (id == null) { //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); RedirectToAction("Admin"); } Job_Postings job_Postings = db.Job_Postings.Find(id); if (job_Postings == null) { //return HttpNotFound(); RedirectToAction("Admin"); } ViewBag.dept = new SelectList(db.Departments, "Id", "Name", job_Postings.dept); return(View(job_Postings)); } catch (DbUpdateException dbException) { ViewBag.DbExceptionMessage = dbException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (EntityException entityException) { ViewBag.EntityExceptionMessage = entityException.InnerException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (SqlException sqlException) { ViewBag.SqlExceptionNumber = sqlException.Number; ViewBag.SqlExceptionMessage = sqlException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (Exception e) { ViewBag.ExceptionMessage = e.Message; return(View("~/Views/Errors/Details.cshtml")); } }
public ActionResult Create([Bind(Include = "job_id,job_title,job_description,job_type,job_openings,job_posted_date,job_closing_date,dept")] Job_Postings job_Postings) { try { if (ModelState.IsValid) { job_Postings.job_posted_date = DateTime.Today; db.Job_Postings.Add(job_Postings); db.SaveChanges(); return(RedirectToAction("Admin")); } ViewBag.dept = new SelectList(db.Departments, "Id", "Name", job_Postings.dept); return(View(job_Postings)); } catch (DbUpdateException dbException) { ViewBag.DbExceptionMessage = dbException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (EntityException entityException) { ViewBag.EntityExceptionMessage = entityException.InnerException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (SqlException sqlException) { ViewBag.SqlExceptionNumber = sqlException.Number; ViewBag.SqlExceptionMessage = sqlException.Message; return(View("~/Views/Errors/Details.cshtml")); } catch (Exception e) { ViewBag.ExceptionMessage = e.Message; return(View("~/Views/Errors/Details.cshtml")); } }