I Have a Problem. I have a REST Api thats working pretty well. Does everything i want it to Do. Now when I Load it inside Postman, it works fine Like this
Now it works fine in Postman, Should i then move it into the Smartobject Tester, it does not show anything. Looking Like this in Smartobject Tester
REST API in SmartObject Tester
Could it be because I didnt make it to Return the Values in Json?
PS
My code Looks somewhat Like this ::
using EmployeeRESTAPI.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
namespace EmployeeRESTAPI.Controllers
{
public class EmployeeDBController : ApiController
{
string MyconnectionString = "Data Source=DLX;Initial Catalog=EmployeeDB;Integrated Security=True";
// GET api/<controller>
public IEnumerable<EmployeeDB> Get()
{
SqlConnection con = new SqlConnection(MyconnectionString);
DataTable dt = new DataTable();
con.Open();
string query = "select* from [EmployeeDB].[dbo].[EmployeeTable]";
SqlDataAdapter adapter = new SqlDataAdapter(query, con);
adapter.Fill(dt);
List<EmployeeDB> empdb = new List<Models.EmployeeDB>(dt.Rows.Count);
if (dt.Rows.Count > 0)
{
foreach (DataRow empdbrecord in dt.Rows)
{
empdb.Add(new ReadEmployee(empdbrecord));
}
}
return empdb;
}
// GET api/<controller>/5
public IEnumerable<EmployeeDB> Get(string accountnumber)
{
SqlConnection con = new SqlConnection(MyconnectionString);
DataTable dt = new DataTable();
con.Open();
string query = "select * from [EmployeeDB].[dbo].[EmployeeTable] where accountnumber = '" + accountnumber + "'";
SqlDataAdapter adapter = new SqlDataAdapter(query, con);
adapter.Fill(dt);
List<EmployeeDB> empdb = new List<Models.EmployeeDB>(dt.Rows.Count);
if (dt.Rows.Count > 0)
{
foreach (DataRow empdbrecord in dt.Rows)
{
empdb.Add(new ReadEmployee(empdbrecord));
}
}
return empdb;
}
// POST api/<controller>
public void Post([FromBody]string value)
{
}
// PUT api/<controller>/5
public void Put(int id, [FromBody]string value)
{
}
// DELETE api/<controller>/5
public void Delete(int id)
{
}
}
}