this is my service
[HttpPost]
public AgentMasterEntity AgentLogin([FromBody]string username)
{
AgentMasterEntity Agent = new AgentMasterEntity();
Agent = am.AgentLogin(username[0].ToString(),username[1].ToString());
return Agent;
}
public AgentMasterEntity AgentLogin([FromBody]string username)
{
AgentMasterEntity Agent = new AgentMasterEntity();
Agent = am.AgentLogin(username[0].ToString(),username[1].ToString());
return Agent;
}
this my jquery to call that sevice:
function testapi()
{
alert("enter");
var username = "santu";
var password = "hgf";
$.ajax({
type: "POST",
url:"http://localhost:1427/api/Agent/AgentLogin",
data:JSON.stringify([username,password]),
contentType: "application/json; charset=utf-8",
dataType: "text json",
success: function (resp) {
alert("ahi");
},
error: function (jqXHR, exception) {
if (jqXHR.status === 0) {
msg = 'Not connect.\n Verify Network.';
} else if (jqXHR.status == 404) {
msg = 'Requested page not found. [404]';
} else if (jqXHR.status == 500) {
msg = 'Internal Server Error [500].';
} else if (exception === 'parsererror') {
msg = 'Requested JSON parse failed.';
} else if (exception === 'timeout') {
msg = 'Time out error.';
} else if (exception === 'abort') {
msg = 'Ajax request aborted.';
} else {
msg = 'Uncaught Error.\n' + jqXHR.responseText;
}
alert(msg);
}
});
}
{
alert("enter");
var username = "santu";
var password = "hgf";
$.ajax({
type: "POST",
url:"http://localhost:1427/api/Agent/AgentLogin",
data:JSON.stringify([username,password]),
contentType: "application/json; charset=utf-8",
dataType: "text json",
success: function (resp) {
alert("ahi");
},
error: function (jqXHR, exception) {
if (jqXHR.status === 0) {
msg = 'Not connect.\n Verify Network.';
} else if (jqXHR.status == 404) {
msg = 'Requested page not found. [404]';
} else if (jqXHR.status == 500) {
msg = 'Internal Server Error [500].';
} else if (exception === 'parsererror') {
msg = 'Requested JSON parse failed.';
} else if (exception === 'timeout') {
msg = 'Time out error.';
} else if (exception === 'abort') {
msg = 'Ajax request aborted.';
} else {
msg = 'Uncaught Error.\n' + jqXHR.responseText;
}
alert(msg);
}
});
}
out5 put shows Internal Server error:
please help me im new to web api...
is my code wrong and how can i pass values frombody values
Manish kumarPosted Nov 29, 2016, 10:02 AM
2-2-11/11/2016-40
3-3-11/11/2016-30
<%@page import="java.sql.*"%>
<%@ page import="java.util.Calendar" %>
<%
//java Code 25/11/2016
try
{
String date = (new java.util.Date()).toString();
String OrderDate=request.getParameter("OrderDate");
int OrderID = Integer.parseInt(request.getParameter("OrderID"));
int Amount = Integer.parseInt(request.getParameter("Amount"));
int Running_Total=Integer.parseInt(request.getParameter("Running_Total"));
String sql_debit="select OrderID,OrderDate,Amount,(select sum(Amount) from CustomerOrders where OrderID <= OrderID)'Running_Total' from CustomerOrders";
String s="jdbc:odbc:Database2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(s);
Statement pstmt=conn.createStatement();
Calendar calendar = Calendar.getInstance();
java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime());
ResultSet result = pstmt.executeQuery(sql_debit);
//int count = 0;
while (result.next())
{
//result.getInt("Running_Total");
Running_Total = result.getInt(1);
//result.getInt(1);
String output = "User #%d: %s ";
System.out.println(String.format(output, Running_Total));
}
conn.close();
}
catch(Exception ex)
{
System.err.println(ex.getMessage());
}
%>