// called by FooTableDesigner_Load
public Task<DataTable> __FooTable_Select()
{
var n = new ScriptedNotificationsV2ScriptedNotifications();
#region auto reset and reinit?
if (n.Count() == 0)
{
ScriptedNotificationsV2.GetDataSet().Tables[0].Rows.AsEnumerable().WithEach(
x => n.Insert(x)
);
}
#endregion
// why cannot we do a direct AsDataTable ?
return n.AsEnumerable().AsDataTable().AsResult();
#if V1
var ro = ScriptedNotifications.GetDataTable();
var rw = new FooTable().Select();
var merge = new DataTable();
// X:\jsc.svn\examples\java\JVMCLRDataTableMerge\JVMCLRDataTableMerge\Program.cs
Console.WriteLine("before Merge ro");
merge.Merge(ro);
if (rw.Rows.Count > 0)
{
Console.WriteLine("before Merge rw");
// Additional information: <target>.delay and <source>.delay have conflicting properties: DataType property mismatch.
merge.Merge(rw);
}
// merge with ro data
var columnNames = merge.Columns.AsEnumerable().Select(k => k.ColumnName).ToArray();
var distinct = merge.DefaultView.ToTable(
distinct: true,
columnNames: columnNames
);
// ToTable: { c = delay, value = 500 }
//ToTable: { c = delay, xvalue = 500 }
//ToTable: { c = text, value = howdy! }
//ToTable: { c = text, xvalue = howdy! }
//ToTable: { c = delay, value = 5000 }
//ToTable: { c = delay, xvalue = 5000 }
//ToTable: { c = text, value = how can we help you? }
//ToTable: { c = text, xvalue = how can we help you? }
//ToTable: { c = delay, value = 25000 }
//ToTable: { c = delay, xvalue = 25000 }
//ToTable: { c = text, value = do you like our site? }
//ToTable: { c = text, xvalue = do you like our site? }
//__FooTable_Select
//{ ColumnName = delay, value = }
//{ ColumnName = text, value = }
//{ ColumnName = delay, value = }
//{ ColumnName = text, value = }
//{ ColumnName = delay, value = }
//{ ColumnName = text, value = }
//var xml = ScriptCoreLib.Library.StringConversionsForDataTable.ConvertToString(
// distinct
//);
//Console.WriteLine(new { xml });
return distinct.ToTaskResult();
#endif
}
// http://192.168.43.252:11528/xml/get_Item Failed to load resource: the server responded with a status of 500 (Internal Server Error)
// tested by ?
public Task<string[]> this[long delayfrom, long delayto]
{
get
{
var n = new ScriptedNotificationsV2ScriptedNotifications();
#region auto reset and reinit?
if (n.Count() == 0)
{
ScriptedNotificationsV2.GetDataSet().Tables[0].Rows.AsEnumerable().WithEach(
x => n.Insert(x)
);
}
#endregion
return Enumerable.ToArray(
from row in n.AsEnumerable()
let delay = row.delay
where delay >= delayfrom
where delay <= delayto
select row.text
).ToTaskResult();
#if V1
var merge = __FooTable_Select().Result;
// !! merge now has a Debug Visualizer, pause here to inspect
return Enumerable.ToArray(
from row in merge.Rows.AsEnumerable()
where !string.IsNullOrEmpty((string)row["delay"])
let delay = Convert.ToInt64((string)row["delay"])
let text = (string)row["text"]
where delay >= delayfrom
where delay <= delayto
select text
).ToTaskResult();
#endif
}
}