public ActionResult Get(string tablename)
{
ActionResult result = null;
try
{
List <KeyValuePair <string, string> > parameters = GetParameters();
MySqlConnector connector = new MySqlConnector(_connectionString);
List <List <KeyValuePair <string, string> > > records = connector.GetRecords(tablename, parameters);
List <object> objectList = null;
foreach (List <KeyValuePair <string, string> > record in records)
{
Dictionary <string, string> values = new Dictionary <string, string>();
foreach (KeyValuePair <string, string> pair in record)
{
values.Add(pair.Key, pair.Value);
}
string jsonString = JsonConvert.SerializeObject(values);
if (objectList == null)
{
objectList = new List <object>();
}
objectList.Add(JsonConvert.DeserializeObject(jsonString));
}
result = Ok(objectList);
}
catch (Exception ex)
{
result = StatusCode(500, new { Error = ex.Message });
}
return(result);
}
