// PUT api/values/5 public HttpResponseMessage Put(int id, [FromBody] EmployeeMo value) { bool status = objEmployye.UpdateEmployee(id, value); if (status) { return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } }
// POST api/values public HttpResponseMessage Post([FromBody] EmployeeMo value) { bool Status = objEmployye.SaveEmployee(value); if (Status) { return(Request.CreateResponse(HttpStatusCode.Created)); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed)); } }
public bool UpdateEmployee(int id, EmployeeMo ObjEmp) { try { using (SqlConnection conn = new SqlConnection(ConString)) { string Query = "update Employee set FirstName = '" + ObjEmp.FirstName + "',LastName = '" + ObjEmp.LastName + "',Age = '" + ObjEmp.Age + "',Gender = '" + ObjEmp.Gender + "',JoinedDate = '" + ObjEmp.JoinedDate + "' where ID = " + id; using (SqlCommand cmd = new SqlCommand(Query, conn)) { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } return(true); } catch (Exception ex) { return(false); } }
public bool SaveEmployee(EmployeeMo ObjEmp) { try { using (SqlConnection conn = new SqlConnection(ConString)) { string Query = "insert into Employee(FirstName,LastName,Age,Gender,JoinedDate) values('" + ObjEmp.FirstName + "','" + ObjEmp.LastName + "','" + ObjEmp.Age + "','" + ObjEmp.Gender + "','" + ObjEmp.JoinedDate + "')"; using (SqlCommand cmd = new SqlCommand(Query, conn)) { conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } return(true); } catch (Exception ex) { return(false); } }