My question is how can I pass multiple parameter to DELETE request.
My controller class as follow,
namespace MYAPI1.Controllers
{
public class TaskController : ApiController
{
// DELETE: api/Task/5
[Route("api/Task/id1/id2/{id3}")]
public void Delete(int id,int id2, string id3)
{
TaskPersistent tp = new TaskPersistent();
tp.deleteTask(id,id2,id3);
}
}
}
TaskPersistent.class as follow,
public class TaskPersistent
{
public void deleteTask(int id, int id2, string id3)
{
try
{
string sqlString = "DELETE from devproj WHERE (DeveloperID, ProjectID, WorkDate) = VALUES ('" + id + "', '" + id2 + "', '" + id3 + "');";
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sqlString, conn);
cmd.ExecuteNonQuery();
long x = cmd.LastInsertedId;
}
catch (Exception x)
{
Console.WriteLine(x);
}
}
}
I try to consume this using postman like this,http://localhost:10927/api/Task?id1=1&id2=5&id3="2018-03-14"
but which not working, please help me to solve this.
Try the following
[Route("api/Task/{id:int}/{id2:int}/{id3}")]
public void Delete(int id,int id2, string id3)
{
TaskPersistent tp = new TaskPersistent();
tp.deleteTask(id,id2,id3);
}
Call it via: http://localhost:10927/api/Task/1/2/"2018-03-14"
--- OR ---
[Route("api/Task")]
public void Delete(int id,int id2, string id3)
{
TaskPersistent tp = new TaskPersistent();
tp.deleteTask(id,id2,id3);
}
Call it via: http://localhost:10927/api/Task?id=1&id2=2&id3="2018-03-14"