public String getDataJson()
{
int x = 0;
StringBuilder Row = new StringBuilder();
Data = new StringBuilder();
using (var ctx = new ExponentPortalEntities())
using (var cmd = ctx.Database.Connection.CreateCommand())
{
ctx.Database.Connection.Open();
cmd.CommandText = setOrderFilterPaging(SQL);
using (var reader = cmd.ExecuteReader())
{
//For each row
while (reader.Read())
{
if (x > 0)
{
Row.AppendLine(",");
}
else
{
_TotalRecords = Int32.Parse(reader["_TotalRecords"].ToString());
}
StringBuilder Columns = new StringBuilder();
for (int i = 0; i < reader.FieldCount; i++)
{
String DisplayValue = getFieldVal(reader, i);
if (i > 0)
{
Columns.AppendLine(",");
}
Columns.Append("\"" + reader.GetName(i) + "\"");
Columns.Append(" : ");
Columns.Append("\"" + Util.toSQL(DisplayValue) + "\"");
}
Row.Append("{");
Row.Append(Columns);
Row.Append("}");
x = x + 1;
}//while
}
}
Data.AppendLine("{");
Data.AppendLine("\"recordsTotal\" : " + _TotalRecords + ",");
Data.AppendLine("\"recordsFiltered\" : " + _TotalRecords + ",");
Data.AppendLine("\"searchDelay\" : 1000,");
Data.AppendLine("\"data\" : [");
Data.Append(Row);
Data.AppendLine("]");
Data.AppendLine("}");
return(Data.ToString());
}//getData
}//DisplayField()
public int saveCheckListItem(int DroneCheckListID) {
String SQL = "";
SQL = "INSERT INTO [DroneCheckListItem](\n" +
" [DroneCheckListID],\n" +
" [DroneCheckListItemID],\n" +
" [FieldValue],\n" +
" [FieldNote]\n" +
") VALUES(\n" +
" " + DroneCheckListID.ToString() + ",\n" +
" " + ID.ToString() + ",\n" +
" '" + Util.toSQL(FieldValue) + "',\n" +
" '" + Util.toSQL(FieldNote) + "'\n" +
")";
Util.doSQL(SQL);
return 0;
}
