//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));
}
}
