public JsonResult addNewEmployee(Employeedata emp) { tbl_employees employee = new tbl_employees() { emp_first_name = emp.firstName, emp_last_name = emp.lastName, emp_email = emp.email, emp_gender = emp.gender, emp_password = emp.password, emp_dob = emp.dob, emp_status = 1 }; db.tbl_employees.Add(employee); int a = db.SaveChanges(); if (a > 0) { my_response res = new my_response() { message = "Employee created successfully", status = "success" }; return(Json(res, JsonRequestBehavior.AllowGet)); } else { my_response res = new my_response() { message = "Employee creation failed.", status = "error" }; return(Json(res, JsonRequestBehavior.AllowGet)); } }
public IHttpActionResult Puttbl_employees(int id, tbl_employees tbl_employees) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_employees.id) { return(BadRequest()); } db.Entry(tbl_employees).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tbl_employeesExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Gettbl_employees(int id) { tbl_employees tbl_employees = db.tbl_employees.Find(id); if (tbl_employees == null) { return(NotFound()); } return(Ok(tbl_employees)); }
public IHttpActionResult Posttbl_employees(tbl_employees tbl_employees) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_employees.Add(tbl_employees); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tbl_employees.id }, tbl_employees)); }
public IHttpActionResult Deletetbl_employees(int id) { tbl_employees tbl_employees = db.tbl_employees.Find(id); if (tbl_employees == null) { return(NotFound()); } db.tbl_employees.Remove(tbl_employees); db.SaveChanges(); return(Ok(tbl_employees)); }