public void AddNewEmployee(EmpTable emp) { var context = new EmpDBEntities(); context.EmpTables.Add(emp); context.SaveChanges(); }
public void UpdateEmployee(EmpTable emp) { var context = new EmpDBEntities(); var find = context.EmpTables.FirstOrDefault(e => e.EmpID == emp.EmpID); if (find == null) { throw new Exception("No Employee found to update"); } find.EmpAddress = emp.EmpAddress; find.EmpName = emp.EmpName; find.EmpSalary = emp.EmpSalary; find.DeptID = emp.DeptID; context.SaveChanges(); }