public static string getJsonString(projectResults ProjectResults)
{
StringWriter sw = new StringWriter();
JsonTextWriter json = new JsonTextWriter(sw);
json.WriteStartObject();
json.WritePropertyName("results");
json.WriteStartArray();
//TODO context projResults needs to update for multiple query operation
foreach (results rslts in ProjectResults.results)
{
json.WriteStartObject();
// ProjectID and QueryID
json.WritePropertyName("ProjectID");
// get projectid, for subjhow
json.WriteValue((rslts.schema.Count > 0) ? rslts.schema[0].project : ProjectResults.results[0].schema[0].project);
json.WritePropertyName("QueryID");
json.WriteValue((rslts.schema.Count > 0) ? rslts.schema[0].name : String.Format("{0}.subquery", ProjectResults.results[0].schema[0].name));
if (rslts.schema.Count > 0)
{
// parameters
json.WritePropertyName("parameters");
getParameterJsonStringArray(json, rslts.schema[0].parameters);
// paging
json.WritePropertyName("paging");
string pagingstring = JsonConvert.SerializeObject(rslts.schema[0].paging);
json.WriteRawValue(pagingstring);
}
// fields
json.WritePropertyName("fields");
getFieldJsonStringArray(json, (rslts.schema.Count > 0) ? rslts.schema[0].fields : ProjectResults.results[0].schema[0].fields);
// results
json.WritePropertyName("result");
getRowJsonStringArray(json, rslts.result, (rslts.schema.Count > 0) ? rslts.schema[0].fields : ProjectResults.results[0].schema[0].fields);
json.WriteEndObject();
}
json.WriteEndArray();
json.WriteEndObject();
json.Flush();
sw.Flush();
return(sw.ToString());
}
public static void getProjectGrouped(projectResults ProjectResults, XmlWriter XWriter, params string[] Grouped)
{
try
{
if (Timing != null)
{
Timing.Start("getResultGrouped");
}
foreach (var results in ProjectResults.results)
{
getResultGrouped(results, XWriter, Grouped);
}
}
finally
{
Timing.End("getResultGrouped");
}
}
public static void getProjectGrouped(projectResults ProjectResults, XmlWriter XWriter, params string[] Grouped)
{
foreach (var results in ProjectResults.results)
{
getResultGrouped(results, XWriter, Grouped);
}
}
public static string getJsonString(projectResults ProjectResults)
{
StringWriter sw = new StringWriter();
JsonTextWriter json = new JsonTextWriter(sw);
json.WriteStartObject();
json.WritePropertyName("results");
json.WriteStartArray();
//TODO context projResults needs to update for multiple query operation
foreach (results rslts in ProjectResults.results)
{
json.WriteStartObject();
// ProjectID and QueryID
json.WritePropertyName("ProjectID");
// get projectid, for subjhow
json.WriteValue((rslts.schema.Count > 0 ) ? rslts.schema[0].project : ProjectResults.results[0].schema[0].project);
json.WritePropertyName("QueryID");
json.WriteValue((rslts.schema.Count > 0 ) ? rslts.schema[0].name : String.Format("{0}.subquery", ProjectResults.results[0].schema[0].name));
if (rslts.schema.Count > 0)
{
// parameters
json.WritePropertyName("parameters");
getParameterJsonStringArray(json, rslts.schema[0].parameters);
// paging
json.WritePropertyName("paging");
string pagingstring = JsonConvert.SerializeObject(rslts.schema[0].paging);
json.WriteRawValue(pagingstring);
}
// fields
json.WritePropertyName("fields");
getFieldJsonStringArray(json, (rslts.schema.Count > 0) ? rslts.schema[0].fields : ProjectResults.results[0].schema[0].fields);
// results
json.WritePropertyName("result");
getRowJsonStringArray(json, rslts.result, (rslts.schema.Count > 0) ? rslts.schema[0].fields : ProjectResults.results[0].schema[0].fields);
json.WriteEndObject();
}
json.WriteEndArray();
json.WriteEndObject();
json.Flush();
sw.Flush();
return sw.ToString();
}
public static bool LoadFromFile(string fileName, out projectResults obj)
{
System.Exception exception = null;
return LoadFromFile(fileName, out obj, out exception);
}
/// <summary>
/// Deserializes xml markup from file into an projectResults object
/// </summary>
/// <param name="fileName">string xml file to load and deserialize</param>
/// <param name="obj">Output projectResults object</param>
/// <param name="exception">output Exception value if deserialize failed</param>
/// <returns>true if this XmlSerializer can deserialize the object; otherwise, false</returns>
public static bool LoadFromFile(string fileName, out projectResults obj, out System.Exception exception)
{
exception = null;
obj = default(projectResults);
try {
obj = LoadFromFile(fileName);
return true;
}
catch (System.Exception ex) {
exception = ex;
return false;
}
}
public static bool Deserialize(string xml, out projectResults obj)
{
System.Exception exception = null;
return Deserialize(xml, out obj, out exception);
}
/// <summary>
/// Deserializes workflow markup into an projectResults object
/// </summary>
/// <param name="xml">string workflow markup to deserialize</param>
/// <param name="obj">Output projectResults object</param>
/// <param name="exception">output Exception value if deserialize failed</param>
/// <returns>true if this XmlSerializer can deserialize the object; otherwise, false</returns>
public static bool Deserialize(string xml, out projectResults obj, out System.Exception exception)
{
exception = null;
obj = default(projectResults);
try {
obj = Deserialize(xml);
return true;
}
catch (System.Exception ex) {
exception = ex;
return false;
}
}
public DatabaseQuery(DatabaseConnection Connection, ProjectFlx.Schema.projectResults ProjectResults)
{
_database = Connection;
_Projresults = ProjectResults;
}