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; }