public ActionResult Delete(JobPositionsViewModel model) { if (JobPositionDAL.Delete(model.Id)) { return(RedirectToAction("Index")); } else { return(View(JobPositionDAL.GetById(model.Id))); } }
public ActionResult Edit(JobPositionsViewModel model) { if (JobPositionDAL.Update(model)) { return(RedirectToAction("Index")); } else { return(View(model)); } }
public static JobPositionsViewModel GetById(int id) { JobPositionsViewModel result = new JobPositionsViewModel(); using (EmplDataContext db = new EmplDataContext()) { result = (from j in db.MST_JobPositions where j.Id == id select new JobPositionsViewModel { Id = j.Id, Name = j.Name }).FirstOrDefault(); } return(result); }
public static bool Add(JobPositionsViewModel model) { bool result = false; using (EmplDataContext db = new EmplDataContext()) { MST_JobPositions mstJobPosition = new MST_JobPositions(); mstJobPosition.Name = model.Name; try { db.MST_JobPositions.Add(mstJobPosition); db.SaveChanges(); result = true; } catch { result = false; } } return(result); }
public static bool Update(JobPositionsViewModel model) { bool result = false; using (EmplDataContext db = new EmplDataContext()) { MST_JobPositions mstJobPosition = db.MST_JobPositions.Where(x => x.Id == model.Id).FirstOrDefault(); mstJobPosition.Name = model.Name; mstJobPosition.ModifiedBy = 1; mstJobPosition.ModifiedOn = DateTime.Now; try { db.SaveChanges(); result = true; } catch { result = false; } } return(result); }