public IHttpActionResult PutTblUser(int id, TblUser tblUser) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblUser.Id) { return(BadRequest()); } db.Entry(tblUser).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TblUserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutEmployeeInfo(int id, EmployeeInfo employeeInfo) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != employeeInfo.Id) { return(BadRequest()); } db.Entry(employeeInfo).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EmployeeInfoExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public HttpResponseMessage Put(int id, [FromBody] Employee employee) { try { using (EmployeeDbEntities entities = new EmployeeDbEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "employee id: " + id.ToString() + " not found to update")); } else { entity.FirstName = employee.FirstName; entity.Salary = employee.Salary; entity.Gender = employee.Gender; entity.LastName = employee.LastName; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Delete(int id) { try { using (EmployeeDbEntities entities = new EmployeeDbEntities()) { var entity = entities.Employees.FirstOrDefault(e => e.ID == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NoContent, "employee id : " + id.ToString() + " not found to delete")); } else { entities.Employees.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// DELETE public HttpResponseMessage Delete(int id) { try { using (EmployeeDbEntities db = new EmployeeDbEntities()) { Employee employee = db.Employees.Find(id); if (employee != null) { db.Employees.Remove(employee); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + " not found to delete.")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// PUT public HttpResponseMessage Put(int id, [FromBody] Employee employee) { try { using (EmployeeDbEntities db = new EmployeeDbEntities()) { Employee entity = db.Employees.Find(id); if (entity != null) { entity.FirstName = employee.FirstName; entity.LastName = employee.LastName; entity.Gender = employee.Gender; entity.Salary = employee.Salary; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Employee with ID = " + id.ToString() + " not found to update.")); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public void DeleteEmployee(long id) { using (var db = new EmployeeDbEntities()) { var existingEmployee = db.Employees.Where(x => x.Id == id).FirstOrDefault(); if (existingEmployee != null) { db.Entry(existingEmployee).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); } } }
public void SaveEmployee(Employee employee) { using (var db = new EmployeeDbEntities()) { db.Employees.Add(new Employee() { Name = employee.Name, Email = employee.Email, Type = string.IsNullOrEmpty(employee.Type) ? "Permanent" : employee.Type, DateOfJoining = employee.DateOfJoining == null ? DateTime.Now.Date : employee.DateOfJoining }); db.SaveChanges(); } }
public void UpdateEmployee(long id, Employee employee) { using (var db = new EmployeeDbEntities()) { var existingEmployee = db.Employees.Where(x => x.Id == id).FirstOrDefault(); if (existingEmployee != null) { existingEmployee.Name = employee.Name; existingEmployee.Email = employee.Email; existingEmployee.Type = employee.Type; existingEmployee.DateOfJoining = employee.DateOfJoining; db.Entry(existingEmployee).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } }
public HttpResponseMessage Post([FromBody] Employees employee) { try { using (EmployeeDbEntities db = new EmployeeDbEntities()) { db.Employees.Add(employee); db.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)); } }
//Employee public void AddEmployee(Employee employee) { Ee.Employees.Add(employee); Ee.SaveChanges(); }
//Country public void AddCountry(Country country) { Ee.Countries.Add(country); Ee.SaveChanges(); }
public void SaveEmployee(Employee emp) { _dbContext = new EmployeeDbEntities(); _dbContext.Employees.Add(emp); _dbContext.SaveChanges(); }