private void ShowContents(Stmt_Select statement, DBRunner runner, ISQLExecuter executer, DBConnection conn)
{
DBRowCollection coll = runner.Select(executer, conn, statement);
String line = "";
foreach (DBMetaColumn meta in coll.Meta)
{
line += meta.ColumnName + ", ";
}
Output(line.Substring(0, line.Length - 2));
foreach (DBRow r in coll)
{
line = "";
int count = r.Count;
for (int i = 0; i < count; i++)
{
line += r[i] == null ? "null, " : (r[i] + ", ");
}
Output(line.Substring(0, line.Length - 2));
}
}
public DBRowCollection GetData(string selectStatement, string keyColumn)
{
var dataOut = new DBRowCollection();
var dataTable = GetDataTable(selectStatement);
foreach (DataRow row in dataTable.Rows)
{
try
{
var newDataRow = new DBFieldCollection();
foreach (DataColumn column in dataTable.Columns)
{
if (!column.ColumnName.Equals(keyColumn, StringComparison.InvariantCultureIgnoreCase))
{
newDataRow.Add(column.ColumnName, row[column.ColumnName].ToString());
}
}
dataOut.Add(row[keyColumn].ToString(), newDataRow);
}
catch (Exception ex)
{
throw new ApplicationException(string.Format("The file {0} was already found in the dataset. Please ensure the database is returning distinct filenames.", row[keyColumn].ToString()));
}
}
return(dataOut);
}
public static IEnumerable <SPDataRecord> ToSPDataRecords(this DBRowCollection inboundDBData, SPColumnMappings mappings)
{
var listOut = new List <SPDataRecord>();
foreach (string key in inboundDBData.Keys)
{
var fieldCollection = (DBFieldCollection)inboundDBData[key];
var dataRecord = fieldCollection.ToSPDataRecord(mappings, key);
listOut.Add(dataRecord);
}
return(listOut);
}
public DBRowCollection GetData(string selectStatement, string keyColumn)
{
var dataOut = new DBRowCollection();
var dataTable = GetDataTable(selectStatement);
foreach (DataRow row in dataTable.Rows)
{
try
{
var newDataRow = new DBFieldCollection();
foreach (DataColumn column in dataTable.Columns)
{
if (!column.ColumnName.Equals(keyColumn, StringComparison.InvariantCultureIgnoreCase))
newDataRow.Add(column.ColumnName, row[column.ColumnName].ToString());
}
dataOut.Add(row[keyColumn].ToString(), newDataRow);
}
catch (Exception ex)
{
throw new ApplicationException(string.Format("The file {0} was already found in the dataset. Please ensure the database is returning distinct filenames.", row[keyColumn].ToString()));
}
}
return dataOut;
}
