// GET api/<controller>
//public IEnumerable<string> Get() {
// return new string[] { "value1", "value2" };
//}
//// GET api/<controller>/5
//public string Get(int id) {
// return "value";
//}
// POST api/values returns json
/// <summary>
/// Json-t vár POST data-ként:
/// </summary>
/// <param name="value">Json-t vár POST data-ként, pl: {sessions:{db:'Ostomy',action:'list_sessions',pars:{sid:'0',machineid:'1'}}}</param>
/// <returns>Json-ként formázott DataSet. Pl: { "sessions": [ { "sid": 30, "machineid": 1, "machinename": "A200", "startdate": "2015-12-01T13:55:29.8", "shid": 1, "shname": "T1", "enddate": "2015-12-10T08:34:21.45", "prodid": 78, "prodcode": "1703597", "lotid": "123123", "goodamount": 1 } ] }</returns>
public DataSet Post([FromBody]string value) {
using (DataSet ds = new DataSet()) {
var oJsons = new Dictionary<string, JsonRequest>();
try {
oJsons = JsonConvert.DeserializeObject<Dictionary<string, JsonRequest>>(value);
}
catch (Exception) {
try {
var Json = JsonConvert.DeserializeObject<JsonRequest>(value);
oJsons.Add("0", Json);
}
catch (Exception) {
throw new Exception("Nem sikerült értelmezni a JSON adatot. A helyes formátum pl: {sessions:{db:'Ostomy',action:'list_sessions',pars:{sid:'0',machineid:'1'}}}");
}
}
//var oJson = JsonConvert.DeserializeObject<JsonRequest>(value);
foreach (KeyValuePair<string, JsonRequest> item in oJsons) {
JsonRequest oJson = item.Value;
_sql = new Sql(getConnectionString(oJson.db));
using (DataTable dt = _sql.spExecuters[oJson.action](oJson.pars)) {
dt.TableName = item.Key;
ds.Tables.Add(dt);
}
}
return ds;
}
}
//// GET api/<controller>
//public IEnumerable<string> Get() {
// return new string[] { "value1", "value2" };
//}
//// GET api/<controller>/5
//public string Get(int id) {
// return "value";
//}
// POST api/values returns json
/// <summary>
/// Json-t vár POST data-ként:
/// </summary>
/// <param name="value">Json-t vár POST data-ként, pl: {db:'Ostomy',action:'list_sessions',pars:{sid:'0',machineid:'1'}}</param>
/// <returns>Json-ként formázott DataSet. Pl: [ { "sid": 30, "machineid": 1, "machinename": "A200", "startdate": "2015-12-01T13:55:29.8", "shid": 1, "shname": "T1", "enddate": "2015-12-10T08:34:21.45", "prodid": 78, "prodcode": "1703597", "lotid": "123123", "goodamount": 1 } ] </returns>
public DataTable Post([FromBody]object value) {
JsonRequest oJson;
try {
oJson = JsonConvert.DeserializeObject<JsonRequest>(value.ToString());
}
catch (Exception) {
throw new Exception("Nem sikerült értelmezni a JSON adatot. A helyes formátum pl: {db:'Ostomy',action:'list_sessions',pars:{sid:'0',machineid:'1'}}");
}
//var oJson = JsonConvert.DeserializeObject<JsonRequest>(value);
_sql = new Sql(getConnectionString(oJson.db));
using (DataTable dt = _sql.spExecuters[oJson.action](oJson.pars)) {
return dt;
}
}