// sets the column as hidden when not present in the list of visible columns
private void SetColHiddenProperty(DataColumn cl_dt)
{
OutputColumn currentCol = OutputColumns.FirstOrDefault(x => x.Name == cl_dt.ColumnName);
if (currentCol != null)
{
cl_dt.ExtendedProperties.Add("hidden", currentCol.Hidden);
}
else
{
cl_dt.ExtendedProperties.Add("hidden", false);
}
}
public void ReadEvent(PublishedEvent evt)
{
Prepare();
//
// Read event data
//
lock (eventsTable)
{
foreach (PublishedEventField fld in evt.Fields)
{
if (
!eventsTable.Columns.Contains(fld.Name) &&
(
OutputColumns.Count == 0 ||
OutputColumns.Exists(x => x.Name == fld.Name) ||
OutputColumns.Exists(x => x.Calculated && Regex.IsMatch(x.Name, @"\s+AS\s+.*" + fld.Name, RegexOptions.IgnoreCase)) ||
(Filter != null && Filter.Contains(fld.Name))
)
)
{
OutputColumn col = OutputColumns.FirstOrDefault(x => x.Name == fld.Name);
if (col == null)
{
col = new OutputColumn()
{
Name = fld.Name,
ColumnType = OutputColumn.ColType.Column
};
}
Type t;
DataColumn dc;
bool disallowed = false;
if (DataTableTSQLAdapter.AllowedDataTypes.Contains(fld.Type.ToString()))
{
t = fld.Type;
}
else
{
t = Type.GetType("System.String");
}
dc = eventsTable.Columns.Add(fld.Name, t);
dc.ExtendedProperties.Add("subtype", "field");
dc.ExtendedProperties.Add("disallowedtype", disallowed);
dc.ExtendedProperties.Add("calculated", false);
dc.ExtendedProperties.Add("coltype", col.ColumnType);
SetColHiddenProperty(dc);
}
}
foreach (PublishedAction act in evt.Actions)
{
if (
!eventsTable.Columns.Contains(act.Name) &&
(
OutputColumns.Count == 0 ||
OutputColumns.Exists(x => x.Name == act.Name) ||
OutputColumns.Exists(x => x.Calculated && Regex.IsMatch(x.Name, @"\s+AS\s+.*" + act.Name, RegexOptions.IgnoreCase))
)
)
{
OutputColumn col = OutputColumns.FirstOrDefault(x => x.Name == act.Name);
if (col == null)
{
col = new OutputColumn()
{
Name = act.Name,
ColumnType = OutputColumn.ColType.Column
};
}
Type t;
DataColumn dc;
bool disallowed = false;
if (DataTableTSQLAdapter.AllowedDataTypes.Contains(act.Type.ToString()))
{
t = act.Type;
}
else
{
t = Type.GetType("System.String");
}
dc = eventsTable.Columns.Add(act.Name, t);
dc.ExtendedProperties.Add("subtype", "action");
dc.ExtendedProperties.Add("disallowedtype", disallowed);
dc.ExtendedProperties.Add("calculated", false);
dc.ExtendedProperties.Add("coltype", col.ColumnType);
SetColHiddenProperty(dc);
}
}
// add calculated columns
for (int i = 0; i < OutputColumns.Count; i++)
{
string outCol = OutputColumns[i].Name;
if (!eventsTable.Columns.Contains(outCol))
{
if (Regex.IsMatch(outCol, @"\s+AS\s+", RegexOptions.IgnoreCase))
{
var tokens = Regex.Split(outCol, @"\s+AS\s+", RegexOptions.IgnoreCase);
string colName = tokens[0];
string colDefinition = tokens[1];
DataColumn dc;
dc = eventsTable.Columns.Add();
dc.ColumnName = colName;
dc.Expression = colDefinition;
dc.ExtendedProperties.Add("subtype", "calculated");
dc.ExtendedProperties.Add("disallowedtype", false);
dc.ExtendedProperties.Add("calculated", true);
dc.ExtendedProperties.Add("coltype", OutputColumns[i].ColumnType);
SetColHiddenProperty(dc);
//change OutputColumns
OutputColumns[i].Name = colName;
}
}
}
}
DataTable tmpTab = eventsTable.Clone();
DataRow row = tmpTab.NewRow();
if (row.Table.Columns.Contains("name"))
{
row.SetField("name", evt.Name);
}
if (row.Table.Columns.Contains("collection_time"))
{
row.SetField("collection_time", evt.Timestamp.LocalDateTime);
}
foreach (PublishedEventField fld in evt.Fields)
{
if (row.Table.Columns.Contains(fld.Name))
{
if ((bool)row.Table.Columns[fld.Name].ExtendedProperties["disallowedtype"])
{
row.SetField(fld.Name, fld.Value.ToString());
}
else
{
row.SetField(fld.Name, fld.Value);
}
}
}
foreach (PublishedAction act in evt.Actions)
{
if (row.Table.Columns.Contains(act.Name))
{
if ((bool)row.Table.Columns[act.Name].ExtendedProperties["disallowedtype"])
{
row.SetField(act.Name, act.Value.ToString());
}
else
{
row.SetField(act.Name, act.Value);
}
}
}
if (!String.IsNullOrEmpty(Filter))
{
DataView dv = new DataView(tmpTab);
dv.RowFilter = Filter;
tmpTab.Rows.Add(row);
lock (eventsTable)
{
foreach (DataRow dr in dv.ToTable().Rows)
{
eventsTable.ImportRow(dr);
}
}
}
else
{
tmpTab.Rows.Add(row);
lock (eventsTable)
{
foreach (DataRow dr in tmpTab.Rows)
{
eventsTable.ImportRow(dr);
}
}
}
}
