private LineDataTable PopulateData(LineDataTable newTable, LineDataTable table)
{
if (newTable != null && table != null)
{
foreach (DataRow newrow in newTable.Rows)
{
foreach (DataRow oldrow in table.Rows)
{
if ((double)newrow["From"] >= (double)oldrow["From"] &&
(double)newrow["To"] <= (double)oldrow["To"])
{
var count = 2; // skipping "From" and "To" coloumns
while (count < newTable.Columns.Count)
{
var evidence = new VertexEvidence();
evidence.Value = (oldrow[count] as VertexEvidence).Value;
// newrow[count] = oldrow[count];
newrow[count] = evidence;
count++;
}
}
}
}
}
return(newTable);
}
private DataTable GetModifiedTable(LineDataTable table, DataTableCollection tables, List <double> newList)
{
var newTable = new LineDataTable(table.TableName);
foreach (DataColumn col in table.Columns)
{
/*if (col.ColumnName == "ID")
* {
* newTable.Columns.Add("ID", typeof (string));
* }*/
if (col.ColumnName == "From")
{
newTable.Columns.Add("From", typeof(double));
}
else if (col.ColumnName == "To")
{
newTable.Columns.Add("To", typeof(double));
}
else
{
newTable.Columns.Add(col.ColumnName, typeof(VertexEvidence));
}
}
if (newList != null)
{
var i = 0;
while (i < newList.Count - 1)
{
var newRow = newTable.NewRow();
newRow["From"] = newList[i];
newRow["To"] = newList[i + 1];
newTable.Rows.Add(newRow);
i++;
}
}
Console.WriteLine("no of rows before deletion= {0} ", newTable.Rows.Count);
// identifying the spurious rows to be deleted
var deleteRows = new List <DataRow>();
foreach (DataRow newrow in newTable.Rows)
{
if (newrow["From"].Equals(newrow["To"]))
{
var pointvalue = newrow["From"];
foreach (DataTable oldtable in tables)
{
foreach (DataRow oldRow in oldtable.Rows)
{
if (oldRow["From"].Equals(oldRow["To"]))
{
if (oldRow["From"].Equals(pointvalue) && oldRow["To"].Equals(pointvalue))
{
// do nothing
}
else
{
deleteRows.Add(newrow);
}
}
}
}
}
}
// deleting the spurious rows
foreach (var row in deleteRows)
{
if (row != null)
{
Console.WriteLine("delete rows= {0}, {1}", row["From"], row["To"]);
newTable.Rows.Remove(row);
}
}
Console.WriteLine("no of rows after deletion= {0} ", newTable.Rows.Count);
// populate data for newTable
newTable = PopulateData(newTable, table);
// printing table with new data
foreach (DataRow row in newTable.Rows)
{
foreach (DataColumn col in newTable.Columns)
{
Console.Write("{0}-", row[col]);
}
Console.WriteLine("");
}
return(newTable);
}
