private Dictionary <int, List <int> > GetPackageContentsDictionary()
{
Dictionary <int, List <int> > toReturn = new Dictionary <int, List <int> >();
using (var con = _repository.GetConnection())
{
var r = _repository.DiscoveredServer.GetCommand("SELECT * FROM ExtractableDataSetPackage_ExtractableDataSet ORDER BY ExtractableDataSetPackage_ID", con).ExecuteReader();
var lastPackageId = -1;
while (r.Read())
{
var packageID = Convert.ToInt32(r["ExtractableDataSetPackage_ID"]);
var dataSetID = Convert.ToInt32(r["ExtractableDataSet_ID"]);
if (lastPackageId != packageID)
{
toReturn.Add(packageID, new List <int>());
lastPackageId = packageID;
}
toReturn[packageID].Add(dataSetID);
}
return(toReturn);
}
}
public void IntroduceOrphan()
{
var cols = _configuration.GetAllExtractableColumnsFor(_extractableDataSet).Cast <ExtractableColumn>().ToArray();
var name = cols.Single(c => c.GetRuntimeName().Equals("Name"));
using (var con = DataExportRepository.GetConnection())
{
DataExportRepository.DiscoveredServer.GetCommand(
"UPDATE ExtractableColumn set CatalogueExtractionInformation_ID = " + int.MaxValue + " where ID = " +
name.ID, con).ExecuteNonQuery();
}
}
/// <summary>
/// Fetches all containers and filters out of the <paramref name="repository"/> and sets the class up to provide
/// fast access to them.
/// </summary>
/// <param name="repository"></param>
/// <param name="childProvider"></param>
public DataExportFilterManagerFromChildProvider(DataExportRepository repository, DataExportChildProvider childProvider) : base(repository)
{
_containersToFilters = childProvider.AllDeployedExtractionFilters.Where(f => f.FilterContainer_ID.HasValue).GroupBy(f => f.FilterContainer_ID.Value).ToDictionary(gdc => gdc.Key, gdc => gdc.ToList());
var server = repository.DiscoveredServer;
using (var con = repository.GetConnection())
{
var r = server.GetCommand("SELECT * FROM FilterContainerSubcontainers", con).ExecuteReader();
while (r.Read())
{
var parentId = Convert.ToInt32(r["FilterContainer_ParentID"]);
var subcontainerId = Convert.ToInt32(r["FilterContainerChildID"]);
if (!_subcontainers.ContainsKey(parentId))
{
_subcontainers.Add(parentId, new List <FilterContainer>());
}
_subcontainers[parentId].Add(childProvider.AllContainers[subcontainerId]);
}
r.Close();
}
}