public IHttpActionResult PutEmployee(int id, Employee employee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employee.EmployeeID) { return(BadRequest()); } db.Entry(employee).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmployeeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public static void DeleteEmployee() { EmployeesDBEntities context = new EmployeesDBEntities(); var employees = context.Employees; var employee = new Employee { EmpID = 4 }; employees.Attach(employee); employees.Remove(employee); context.SaveChanges(); }
public static void ModifyEmployee() { EmployeesDBEntities context = new EmployeesDBEntities(); var employee = context.Employees; var empList = from emp in employee orderby emp.Salary select emp; foreach (var emp in empList) { if (emp.EmpID == 1) { emp.Name = "mathew mcdonald"; } } context.SaveChanges(); }
public HttpResponseMessage Post([FromBody] Employee employee) { try { using (var entities = new EmployeesDBEntities()) { entities.Employees.Add(employee); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, employee); message.Headers.Location = new Uri(Request.RequestUri + employee.ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }