public String ExecuteQueryJson(int QuestionId, String Query, int UserId)
{
try
{
var db = new Database(_da);
var results = db.ExecuteUserQuery(QuestionId, Query, UserId);
var dtModel = DataTableModelHelper.DataTableToModel(results);
return(new JavaScriptSerializer().Serialize(dtModel));
}
catch (Exception ex)
{
return(ControllerHelpers.TranslateQueryException(ex.Message));
}
}
public void rows_and_columns_should_be_in_the_same_order()
{
var dt = new DataTable();
dt.Columns.Add("ColumnX");
dt.Columns.Add("ColumnY");
dt.Rows.Add(new object[] { "somestring", "anotherstring" });
var model = DataTableModelHelper.DataTableToModel(dt);
var firstRow = model.Rows[0].ToArray();
Assert.AreEqual("somestring", firstRow[0].Value);
Assert.AreEqual("anotherstring", firstRow[1].Value);
Assert.AreEqual("ColumnX", model.Columns[0].Name);
Assert.AreEqual("ColumnY", model.Columns[1].Name);
}