public void Add(CohortAggregateContainer parent, AggregateConfiguration child, int order)
{
CatalogueRepository.Insert(
"INSERT INTO CohortAggregateContainer_AggregateConfiguration (CohortAggregateContainer_ID, AggregateConfiguration_ID, [Order]) VALUES (@CohortAggregateContainer_ID, @AggregateConfiguration_ID, @Order)",
new Dictionary <string, object>
{
{ "CohortAggregateContainer_ID", parent.ID },
{ "AggregateConfiguration_ID", child.ID },
{ "Order", order }
});
}
public void AddSubContainer(IContainer parent, IContainer child)
{
_catalogueRepository.Insert(
"INSERT INTO AggregateFilterSubContainer(AggregateFilterContainer_ParentID,AggregateFilterContainer_ChildID) VALUES (@AggregateFilterContainer_ParentID,@AggregateFilterContainer_ChildID)",
new Dictionary <string, object>
{
{ "AggregateFilterContainer_ParentID", parent.ID },
{ "AggregateFilterContainer_ChildID", child.ID }
});
}
private void InsertNewValue(PermissableDefaults toChange, IExternalDatabaseServer externalDatabaseServer)
{
if (toChange == PermissableDefaults.None)
{
throw new ArgumentException("toChange cannot be None", "toChange");
}
_repository.Insert(
"INSERT INTO ServerDefaults(DefaultType,ExternalDatabaseServer_ID) VALUES (@DefaultType,@ExternalDatabaseServer_ID)",
new Dictionary <string, object>()
{
{ "DefaultType", StringExpansionDictionary[toChange] },
{ "ExternalDatabaseServer_ID", externalDatabaseServer.ID }
});
}
public void Link(GovernancePeriod governancePeriod, ICatalogue catalogue)
{
_catalogueRepository.Insert(string.Format(
@"INSERT INTO GovernancePeriod_Catalogue (Catalogue_ID,GovernancePeriod_ID) VALUES ({0},{1})", catalogue.ID, governancePeriod.ID), null);
}