//public HttpResponseMessage Get(int id) //{ // OleDbConnection newConnection = new OleDbConnection(strconnection); // string query = "select * from EmployeeTable where ID="+id+""; // OleDbCommand cmd = new OleDbCommand(query,newConnection); // OleDbDataReader reader = cmd.ExecuteReader(); // return reader.; //} public HttpResponseMessage Post([FromBody] EmployeeTable employee) { try { OleDbConnection newConnection = new OleDbConnection(strconnection); string InsertQuery = "insert into EmployeeTable ([EmpName],[Salary],[Location]) values ('" + employee.EmpName + "'," + employee.Salary + ",'" + employee.Location + "')"; OleDbCommand cmd = new OleDbCommand(InsertQuery, newConnection); newConnection.Open(); cmd.ExecuteNonQuery(); newConnection.Close(); 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)); } }
public HttpResponseMessage Put(int id, [FromBody] EmployeeTable employee) { try { OleDbConnection newConnection = new OleDbConnection(strconnection); string UpdateQuery = "update EmployeeTable set [EmpName]='" + employee.EmpName + "',[Salary]=" + employee.Salary + ",[Location]='" + employee.Location + "' where ID=" + id + ""; OleDbCommand cmd = new OleDbCommand(UpdateQuery, newConnection); newConnection.Open(); int ans = cmd.ExecuteNonQuery(); newConnection.Close(); if (ans == 0) { return(Request.CreateResponse(HttpStatusCode.NotFound, "Employee with id='" + id + "' not found")); } return(Request.CreateResponse(HttpStatusCode.OK, "Updated")); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }