public IHttpActionResult PutEmployee(int id, Employee employee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employee.Id) { 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 HttpResponseMessage DeleteUser(String email) { try { using (employeeDBEntities entities = new employeeDBEntities()) { var entity = entities.tblEmployees.FirstOrDefault(e => e.Email == email); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with Id = " + email + " not found to delete")); } else { var entityInfo = entity.tblEmployeeInfoes.FirstOrDefault(u => u.Id == entity.Id); entities.tblEmployeeInfoes.Remove(entityInfo); entities.tblEmployees.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage UpdateUser([FromBody] Employee employee) { try { using (var entities = new employeeDBEntities()) { var entity = entities.tblEmployees.FirstOrDefault(u => u.Email == employee.Email); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "User with email" + employee.Email.ToString() + " not present.")); } else { var entityInfo = entity.tblEmployeeInfoes.FirstOrDefault(u => u.Id == entity.Id); entityInfo.FirstName = employee.FirstName; entityInfo.LastName = employee.LastName; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, employee)); } } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public ActionResult SaveData(EmployeeInfo employeeInfo) { if (ModelState.IsValid) { db.EmployeeInfoes.Add(employeeInfo); db.SaveChanges(); return(Json(new { data = employeeInfo }, JsonRequestBehavior.AllowGet)); } return(View(employeeInfo)); }
public HttpResponseMessage AddNewUser([FromBody] Employee employee) { try { using (var entities = new employeeDBEntities()) { var entity = entities.tblEmployees.FirstOrDefault(u => u.Email == employee.Email); if (entity != null) { return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, "User with email" + employee.Email.ToString() + " already present.")); } else { tblEmployee employeeObj = new tblEmployee { Email = employee.Email }; tblEmployeeInfo employeeInfo = new tblEmployeeInfo { FirstName = employee.FirstName, LastName = employee.LastName, }; employeeInfo.tblEmployee = employeeObj; entities.tblEmployees.Add(employeeObj); entities.tblEmployeeInfoes.Add(employeeInfo); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, employee)); } } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }