public static bool Delete(int id) { bool result = false; using (EmplDataContext db = new EmplDataContext()) { MST_JobPositions mstJobPosition = db.MST_JobPositions.Where(x => x.Id == id).FirstOrDefault(); try { db.MST_JobPositions.Remove(mstJobPosition); db.SaveChanges(); result = true; } catch { result = false; } } 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); }