/// <summary>
/// Creates <see cref="DataSourceConverter{DataRow}"/>s based off the <see cref="DataTable"/>. Defaults to all
/// columns defined in each <see cref="DataTable"/>
/// </summary>
/// <param name="table">DataTable</param>
/// <returns>DataSource Converter</returns>
public static DataSourceConverter<DataRow> CreateDefaultDataTableConverter(DataTable table)
{
DataSourceConverter<DataRow> converter = new DataSourceConverter<DataRow>();
foreach (DataColumn column in table.Columns)
{
converter.Fields.Add(new AdapterBoundField<DataRow>(column.ColumnName));
}
return converter;
}
/// <summary>
/// Builds data repository from sources and handle conversion of data sources
/// </summary>
private void GetDataSourceDefinitions()
{
// read new sources from remote
byte[] buf = ApplicationSourcesManager.GetInstance().ReadSource(dataDefinitionIdsUrl, true);
this.DataSourceBuilder.DataSourceReader = GetDataSourceBuffer;
new DataSourceDefinitionManagerSaxHandler(buf, this);
if (CommandsProcessorManager.SessionStatus == CommandsProcessorManager.SessionStatusEnum.Remote)
{
// handle data source conversion if modified definition have any change related to database
DataSourceConverter dataSourceConverter = ClientManager.Instance.LocalManager.DataSourceConverter = new DataSourceConverter();
dataSourceConverter.NewDataSourceRepositoryContents = buf;
dataSourceConverter.HandleRepositoryChanges(this, dataDefinitionIdsUrl);
}
}
public void WithCustomConverters()
{
DataSetConverter converter = new DataSetConverter();
DataSourceConverter<DataRow> table1Converter = new DataSourceConverter<DataRow>();
table1Converter.Fields.Add(new AdapterBoundField<DataRow>("Name", "Character Name"));
table1Converter.Fields.Add(new AdapterBoundField<DataRow>("Age", "Age", "{0:###}"));
converter.TableAdapters.Add(table1Converter);
converter.TableAdapters.Add(DataSetConverter.CreateDefaultDataTableConverter(_data.Tables[1]));
XlsDocument doc = new XlsDocument();
converter.CreateDocument(doc, _data);
Assert.AreEqual(_data.Tables.Count, doc.Workbook.Worksheets.Count);
DataSourceConverterTest.ValidateWorksheetFromDataTable(doc.Workbook.Worksheets[0], _data.Tables[0]);
ValidateSheetFromDataTable(doc.Workbook.Worksheets[1], _data.Tables[1]);
}
public SqlFileConnectionProperties(string defaultInstanceName)
{
_defaultDataSource = ".";
if (defaultInstanceName != null && defaultInstanceName.Length > 0)
{
_defaultDataSource += "\\" + defaultInstanceName;
}
else
{
DataSourceConverter conv = new DataSourceConverter();
System.ComponentModel.TypeConverter.StandardValuesCollection coll = conv.GetStandardValues(null);
if (coll.Count > 0)
{
_defaultDataSource = coll[0] as string;
}
}
LocalReset();
}
public SqlFileConnectionProperties(string defaultInstanceName)
{
_defaultDataSource = ".";
if (defaultInstanceName != null && defaultInstanceName.Length > 0)
{
_defaultDataSource += "\\" + defaultInstanceName;
}
else
{
DataSourceConverter conv = new DataSourceConverter();
System.ComponentModel.TypeConverter.StandardValuesCollection coll = conv.GetStandardValues(null);
if (coll.Count > 0)
{
_defaultDataSource = coll[0] as string;
}
}
LocalReset();
}
