public bool RemoveEmployee(int EmpNo = 0) { DeveloperEntities db = new DeveloperEntities(); Employee Obj = db.Employees.Single(t => t.EmpNo == EmpNo); if (Obj != null) { Obj.IsActive = 0; db.Entry(Obj).State = EntityState.Modified; db.SaveChanges(); } return(true); }
public static int UpdateEmployee(Employee model, int EmpNo = 0) { DeveloperEntities db = new DeveloperEntities(); bool IsExist = db.Employees.Where(P => P.EmpNo != model.EmpNo).Any(R => R.EmpName == model.EmpName); if (IsExist == true) { return(0); } else { // model.UserId = ESrNo; db.Employees.Attach(model); db.Entry(model).State = EntityState.Modified; return(db.SaveChanges()); } }