// Update PUT public List<Employee> Put(Employee obj) { EmployeeEntities empObj = new EmployeeEntities(); if (obj!=null && obj.EmployeeID!=0) { // Select the record ( LINQ ) Employee empUpdate = (from temp in empObj.Employees where temp.EmployeeID == obj.EmployeeID select temp).ToList<Employee>().SingleOrDefault<Employee>(); //Updates the details as per the details from the front page if(empUpdate!=null) { empUpdate.Name = obj.Name; empUpdate.Age = obj.Age; empUpdate.Address = obj.Address; empUpdate.Active = obj.Active; empUpdate.Employment = obj.Employment; empObj.SaveChanges(); } } List<Employee> empList = empObj.Employees.ToList<Employee>(); return empList; }
// Insert public List<Employee> Post(Employee obj) { EmployeeEntities empObj = new EmployeeEntities(); if (ModelState.IsValid) { // insert the customer object to database //Gets the max value of emp id int maxEmpId = empObj.Employees.Max<Employee>(x => x.EmployeeID); //makes sure that the emp id is unique and in order obj.EmployeeID = maxEmpId + 1; empObj.Employees.Add(obj); // Still in memory, not committed empObj.SaveChanges(); //Physical Commit } List<Employee> employeeList = empObj.Employees.ToList<Employee>(); //Gets the employee list from the employee table return employeeList; //Returns the employee list }
// Delete Delete public List<Employee> Delete(Employee obj) { EmployeeEntities empObj = new EmployeeEntities(); if (obj!=null && obj.EmployeeID!=0) { // Delete Employee empDelete = (from temp in empObj. Employees where temp.EmployeeID == obj.EmployeeID select temp).ToList<Employee>()[0]; empObj.Employees.Remove(empDelete); // changes still inside memory empObj.SaveChanges();// Physical commit } List<Employee> empList = empObj.Employees.ToList<Employee>(); return empList; }