public async Task <SessionDataSet> execute_query_statement_async(string sql)
{
TSExecuteStatementResp resp;
TSStatus status;
var client = client_lst.Take();
var req = new TSExecuteStatementReq(client.sessionId, sql, client.statementId);
req.FetchSize = this.fetch_size;
try{
resp = await client.client.executeQueryStatementAsync(req);
status = resp.Status;
}
catch (TException e) {
client_lst.Add(client);
var err_msg = String.Format("could not execute query statement");
throw new TException(err_msg, e);
}
if (util_functions.verify_success(status, SUCCESS_CODE) == -1)
{
client_lst.Add(client);
throw new TException("execute query failed", null);
}
client_lst.Add(client);
var session_dataset = new SessionDataSet(sql, resp, client_lst);
session_dataset.fetch_size = fetch_size;
return(session_dataset);
}
private void saveSession(string pathToFile)
{
SessionDataSet sds = new SessionDataSet();
foreach (TabPage tc in tcCommandInstances.TabPages)
{
var newRow = sds.CommandInstances.NewCommandInstancesRow();
foreach (Control c in tc.Controls)
{
if (c is CommandHostUserControl)
{
foreach (Control c2 in (c as CommandHostUserControl).Controls)
{
if (c2 is Panel)
{
newRow.Type = (c2.Controls[0] as ICommand).Type();
newRow.Settings = (c2.Controls[0] as ICommand).Settings;
break;
}
}
break;
}
}
sds.CommandInstances.AddCommandInstancesRow(newRow);
}
sds.WriteXml(pathToFile);
}
public override global::System.Data.DataSet Clone()
{
SessionDataSet cln = ((SessionDataSet)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
SessionDataSet ds = new SessionDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void loadSession(string pathToFile)
{
SessionDataSet sds = new SessionDataSet();
sds.ReadXml(pathToFile);
foreach (var ci in sds.CommandInstances)
{
if (ci.Type == new CutNRCommandUserControl().Type())
{
CutNRCommandUserControl cutnr = new CutNRCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new ChangeAudioNRCommandUserControl().Type())
{
ChangeAudioNRCommandUserControl cutnr = new ChangeAudioNRCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new IntToProgCommandUserControl().Type())
{
IntToProgCommandUserControl cutnr = new IntToProgCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new ChangeSpeedCommandUserControl().Type())
{
ChangeSpeedCommandUserControl cutnr = new ChangeSpeedCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new ResizeCommandUserControl().Type())
{
ResizeCommandUserControl cutnr = new ResizeCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new HardcodeSubCommandUserControl().Type())
{
HardcodeSubCommandUserControl cutnr = new HardcodeSubCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new CarPlayerConversionCommandUserControl().Type())
{
CarPlayerConversionCommandUserControl cutnr = new CarPlayerConversionCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new CropCommandUserControl().Type())
{
CropCommandUserControl cutnr = new CropCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
else if (ci.Type == new ConvertToMPThreeCommandUserControl().Type())
{
ConvertToMPThreeCommandUserControl cutnr = new ConvertToMPThreeCommandUserControl()
{
Settings = ci.Settings
};
addCommandAsTabPage(cutnr);
}
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
SessionDataSet ds = new SessionDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "CommandInstancesDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
