public void DeleteEmployee(int id) { using (var db = new CRUDDBEntities()) { var empToDelete = db.Employees.FirstOrDefault(x => x.EmployeeID == id); if (empToDelete != null) { db.Employees.Remove(empToDelete); db.SaveChanges(); } } }
public void InsertEmployee(EmployeeModel model) { using (var db = new CRUDDBEntities()) { var empToAdd = db.Employees.FirstOrDefault(x => x.EmployeeID == model.EmployeeID); if (empToAdd != null) { empToAdd.EmployeeID = model.EmployeeID; empToAdd.Age = model.Age; empToAdd.Salary = model.Salary; empToAdd.Name = model.Name; empToAdd.Position = model.Position; db.Entry(empToAdd).State = EntityState.Modified; db.SaveChanges(); } } }
public void UpdateEmployee(EmployeeModel model) { using (var db = new CRUDDBEntities()) { var EmpToEdit = db.Employees.FirstOrDefault(x => x.EmployeeID == model.EmployeeID); if (EmpToEdit != null) { EmpToEdit.EmployeeID = model.EmployeeID; EmpToEdit.Age = model.Age; EmpToEdit.Salary = model.Salary; EmpToEdit.Position = model.Position; EmpToEdit.Name = model.Name; db.Entry(EmpToEdit).State = EntityState.Modified; db.SaveChanges(); } } }