WebAPI giving GET method error when called in browser

Question

hi!

I am currently following below link to learn WebAPI

Link: http://www.c-sharpcorner.com/blogs/consuming-json-rest-or-restful-web-services-response-using-net-c-sharp-client1

I am getting error while calling POST method to Add Record.

Error message:

<Error><Message>The requested resource does not support http method 'GET'.</Message></Error>

POST method is :

[HttpPost]
public void AddEmployee(Employee employee)
{
//int maxId = listEmp.Max(e => e.ID);
//employee.ID = maxId + 1;
//listEmp.Add(employee);

SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = @"Server=192.168.200.26;Database=DBCompany;User ID=xyz;Password=1234;";
//SqlCommand sqlCmd = new SqlCommand("INSERT INTO tblEmployee (EmployeeId,Name,ManagerId) Values (@EmployeeId,@Name,@ManagerId)", myConnection);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "INSERT INTO tblEmployee (EmployeeId,Name,ManagerId) Values (@EmployeeId,@Name,@ManagerId)";
sqlCmd.Connection = myConnection;

sqlCmd.Parameters.AddWithValue("@EmployeeId", employee.EmployeeId);
sqlCmd.Parameters.AddWithValue("@Name", employee.Name);
sqlCmd.Parameters.AddWithValue("@ManagerId", employee.ManagerId);
myConnection.Open();
int rowInserted = sqlCmd.ExecuteNonQuery();
myConnection.Close();
}

please tell me what is the right way of consuming this WEBAPI.

shashi kant · Answer

Thank you all for your responses. Now I tried consuming it in following way but still getting error. POST method is : [HttpPost] public void AddEmployee(Employee employee) { //int maxId = listEmp.Max(e => e.ID); //employee.ID = maxId + 1; //listEmp.Add(employee); SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = @Server=192.168.200.26;Database=DBCompany;User ID=abc;Password=1234;; //SqlCommand sqlCmd = new SqlCommand(INSERT INTO tblEmployee (EmployeeIdNameManagerId) Values (@EmployeeId@Name@ManagerId) myConnection); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = INSERT INTO tblEmployee (EmployeeIdNameManagerId) Values (@EmployeeId@Name@ManagerId); sqlCmd.Connection = myConnection; sqlCmd.Parameters.AddWithValue(@EmployeeId employee.EmployeeId); sqlCmd.Parameters.AddWithValue(@Name employee.Name); sqlCmd.Parameters.AddWithValue(@ManagerId employee.ManagerId); myConnection.Open(); int rowInserted = sqlCmd.ExecuteNonQuery(); myConnection.Close(); } To consume : I have created a class named Employee Class Employee.cs using System; using System.Collections.Generic; using System.Text; namespace TestWebAPIConsume { class Employee { public int EmployeeId { get; set; } public string Name { get; set; } public int ManagerId { get; set; } } } On Default.aspx Page: protected void Page_Load(object sender EventArgs e) { HttpClient client = new HttpClient(); string serviceUrl = http://localhost/WebApiDemo/api/Employees/AddEmployee; var Employee = new Employee() { EmployeeId = 44 Name = AmitKumar ManagerId = 21 }; try { HttpResponseMessage response = client.PostAsJsonAsync(serviceUrl Employee).Result; if (response.IsSuccessStatusCode) { Console.WriteLine(EmployeeAdded); } else { Console.WriteLine({0}({1}) (int)response.StatusCode response.ReasonPhrase); } } catch (Exception ex) { lblmsg.Text= ex.Message.ToString(); } } Error Details: {StatusCode: 500 ReasonPhrase: 'Internal Server Error' Version: 1.1 Content: System.Net.Http.StreamContent Headers: { Pragma: no-cache Cache-Control: no-cache Date: Fri 15 Jul 2016 06:55:07 GMT Server: Microsoft-IIS/8.0 X-AspNet-Version: 4.0.30319 X-Powered-By: ASP.NET Content-Length: 172 Content-Type: application/json; charset=utf-8 Expires: -1 }}

Manas Mohapatra · Answer

You are getting exception because your method supports only POST http verb. Mostly you are sending the request as GET http verb. So you are getting exception. In order to resolve problem you need to add attributes which will accept for GET/POST: [System.Web.Http.AcceptVerbs( GET  POST )] [System.Web.Http.HttpGet] public void AddEmployee(Employeeemployee) { //Yourlogic }

Bikesh Srivastava · Answer

Hi You can test only get method web api on browser not post method web apibecause browser by default support get method. Best option to test web pi use POSTMAN client install plugin on your chrome browser. use it.

shashi kant · Answer

Sorry for the wrong link. Actually the correct link which I am following is http://www.c-sharpcorner.com/UploadFile/97fc7a/webapi-restful-operations-in-webapi-using-ado-net-objects-a/ Method I am having problem is AddEmployee @Rajeev: Dear Rajeev I tried your solution but getting false in IsSuccessStatusCode. Error Details: response.ReasonPhrase : Internal Server Error Status Code: System.Net.HttpStatusCode.InternalServerError Please help!

Rajeev Punhani · Answer

Hi ShashiKant Please find the below code snippet. serviceUrl= api/employee ; //ApicompleteUrl var anEmployee= new Employee(){ lastname= Smith  firstname= Adam  title= Economist  titleofcourtesy= Dr.  birthdate=Convert.ToDateTime( 1958-12-05 ) hiredate=Convert.ToDateTime( 1990-01-01 ) address= 188BayStreet  city= London  region=   postalcode= A1B2Z3  country= UK  phone= (71)234-8228  mgrid=1}; HttpResponseMessageresponse=client.PostAsJsonAsync(serviceUrlanEmployee).Result; if (response.IsSuccessStatusCode) { Console.WriteLine( EmployeeAdded ); } else { Console.WriteLine( {0}({1}) ( int )response.StatusCoderesponse.ReasonPhrase); } If the above solution is helpful then accept the answer.