public System.Collections.Generic.IEnumerable <IConceptInfo> CreateNewConcepts()
{
var activePropertyInfo = new BoolPropertyInfo
{
DataStructure = Entity,
Name = "Active"
};
var composableFilterActiveAndThis = new QueryFilterExpressionInfo
{
Expression = @"(items, parameter) =>
{
if (parameter != null && parameter.ItemID.HasValue)
return items.Where(item => item.Active == null || item.Active.Value || item.ID == parameter.ItemID.Value);
else
return items.Where(item => item.Active == null || item.Active.Value);
}",
Parameter = "Rhetos.Dom.DefaultConcepts.ActiveItems",
Source = Entity
};
var systemRequired = new SystemRequiredInfo {
Property = activePropertyInfo
};
return(new IConceptInfo[] { activePropertyInfo, composableFilterActiveAndThis, systemRequired });
}
public IEnumerable <IConceptInfo> CreateNewConcepts()
{
var filterParameter = new ParameterInfo
{
Module = Property.DataStructure.Module,
Name = Property.Name + "_RegExMatchFilter",
};
string filterExpression = string.Format(@"(source, parameter) =>
{{
var items = source.Where(item => !string.IsNullOrEmpty(item.{0})).Select(item => new {{ item.ID, item.{0} }}).ToList();
var regex = new System.Text.RegularExpressions.Regex({1});
var invalidItemIds = items.Where(item => !regex.IsMatch(item.{0})).Select(item => item.ID).ToList();
return Filter(source, invalidItemIds);
}}",
Property.Name,
CsUtility.QuotedString("^" + RegularExpression + "$"));
var itemFilter = new QueryFilterExpressionInfo
{
Expression = filterExpression,
Parameter = filterParameter.Module.Name + "." + filterParameter.Name,
Source = Property.DataStructure
};
var invalidData = new InvalidDataInfo
{
Source = Property.DataStructure,
FilterType = itemFilter.Parameter,
ErrorMessage = ErrorMessage
};
var invalidProperty = new InvalidDataMarkProperty2Info
{
InvalidData = invalidData,
MarkProperty = Property
};
return(new IConceptInfo[] { filterParameter, itemFilter, invalidData, invalidProperty });
}
public IEnumerable <IConceptInfo> CreateNewConcepts(ItemFilterInfo conceptInfo, IDslModel existingConcepts)
{
var newConcepts = new List <IConceptInfo>();
ParameterInfo filterParameter = GetGeneratedFilter(conceptInfo);
// Existing filter parameter does not have to be a ParameterInfo. Any DataStructureInfo is allowed.
if (existingConcepts.FindByKey($"DataStructureInfo {filterParameter.Module.Name}.{filterParameter.Name}") == null)
{
newConcepts.Add(filterParameter);
}
var composableFilter = new QueryFilterExpressionInfo
{
Source = conceptInfo.Source,
Parameter = filterParameter.GetKeyProperties(),
Expression = "(source, parameter) => source.Where(" + conceptInfo.Expression + ")"
};
newConcepts.Add(composableFilter);
return(newConcepts);
}
public IEnumerable <IConceptInfo> CreateNewConcepts()
{
string limitSnippet = MinValueInfo.LimitSnippetByType
.Where(snippet => snippet.Key.IsAssignableFrom(Property.GetType()))
.Select(snippet => snippet.Value.Invoke(Value))
.Single();
var filterParameter = new ParameterInfo
{
Module = Property.DataStructure.Module,
Name = Property.Name + "_MaxValueFilter"
};
var filter = new QueryFilterExpressionInfo
{
Expression = String.Format(@"(items, parameter) => {{ {1}; return items.Where(item => item.{0} != null && item.{0} > limit); }}", Property.Name, limitSnippet),
Parameter = filterParameter.Module.Name + "." + filterParameter.Name,
Source = Property.DataStructure
};
var invalidData = new InvalidDataInfo
{
Source = Property.DataStructure,
FilterType = filter.Parameter,
ErrorMessage = "Maximum value of {0} is {1}."
};
var messageParameters = new InvalidDataMessageParametersConstantInfo
{
InvalidData = invalidData,
MessageParameters = CsUtility.QuotedString(Property.Name) + ", " + CsUtility.QuotedString(Value)
};
var invalidProperty = new InvalidDataMarkProperty2Info
{
InvalidData = invalidData,
MarkProperty = Property
};
return(new IConceptInfo[] { filterParameter, filter, invalidData, messageParameters, invalidProperty });
}
public IEnumerable <IConceptInfo> CreateNewConcepts(EntityHistoryInfo conceptInfo, IDslModel existingConcepts)
{
var newConcepts = new List <IConceptInfo>();
var atTimeSqlFunction = new SqlFunctionInfo {
Module = conceptInfo.Entity.Module, Name = conceptInfo.Entity.Name + "_AtTime", Arguments = $"@ContextTime {_dateTimeSqlColumnType}", Source = AtTimeSqlSnippet(conceptInfo)
};
newConcepts.Add(atTimeSqlFunction);
var historySqlQueryable = new SqlQueryableInfo {
Module = conceptInfo.Entity.Module, Name = conceptInfo.Entity.Name + "_History", SqlSource = HistorySqlSnippet(conceptInfo)
};
newConcepts.Add(historySqlQueryable);
var write = new WriteInfo {
DataStructure = historySqlQueryable, SaveImplementation = HistorySaveFunction(conceptInfo)
};
newConcepts.Add(write);
// Expand the base entity:
var activeSinceProperty = new DateTimePropertyInfo {
DataStructure = conceptInfo.Entity, Name = "ActiveSince"
}; // TODO: SystemRequired, Default 1.1.1900., after implementing optimization for multiple simple property validations.
var activeSinceHistory = new EntityHistoryPropertyInfo {
Property = activeSinceProperty
};
newConcepts.AddRange(new IConceptInfo[] { activeSinceProperty, activeSinceHistory });
// InvalidData for base entity: it is not allowed to save with ActiveSince older than last one used in History
var denyFilter = new QueryFilterExpressionInfo
{
Parameter = "Common.OlderThanHistoryEntries",
Source = conceptInfo.Entity,
Expression = String.Format(
@"(items, parameter) => items.Where(item =>
_domRepository.{0}.{1}_Changes.Subquery.Where(his => his.ActiveSince >= item.ActiveSince && his.Entity == item).Count() > 0)",
conceptInfo.Entity.Module.Name,
conceptInfo.Entity.Name)
};
var invalidDataValidation = new InvalidDataInfo {
FilterType = "Common.OlderThanHistoryEntries",
Source = conceptInfo.Entity,
ErrorMessage = "ActiveSince is not allowed to be older than last entry in history."
};
newConcepts.AddRange(new IConceptInfo[]
{
denyFilter,
invalidDataValidation,
new ParameterInfo {
Module = new ModuleInfo {
Name = "Common"
}, Name = "OlderThanHistoryEntries"
},
new InvalidDataMarkProperty2Info {
InvalidData = invalidDataValidation, MarkProperty = activeSinceProperty
}
});
// Create a new entity for history data:
var currentProperty = new ReferencePropertyInfo {
DataStructure = conceptInfo.Dependency_ChangesEntity, Name = "Entity", Referenced = conceptInfo.Entity
};
var historyActiveSinceProperty = new DateTimePropertyInfo {
DataStructure = conceptInfo.Dependency_ChangesEntity, Name = activeSinceProperty.Name
};
newConcepts.AddRange(new IConceptInfo[] {
currentProperty,
new ReferenceDetailInfo {
Reference = currentProperty
},
new RequiredPropertyInfo {
Property = currentProperty
}, // TODO: SystemRequired, after implementing optimization for multiple simple property validations.
new PropertyFromInfo {
Destination = conceptInfo.Dependency_ChangesEntity, Source = activeSinceProperty
},
historyActiveSinceProperty,
new UniqueMultiplePropertiesInfo {
DataStructure = conceptInfo.Dependency_ChangesEntity, PropertyNames = $"{currentProperty.Name} {historyActiveSinceProperty.Name}"
}
});
// InvalidData for history entity: it is not allowed to save with ActiveSince newer than current entity
var denyFilterHistory = new QueryFilterExpressionInfo
{
Parameter = "Common.NewerThanCurrentEntry",
Source = conceptInfo.Dependency_ChangesEntity,
Expression = @"(items, parameter) => items.Where(item => item.ActiveSince > item.Entity.ActiveSince)"
};
var invalidDataValidationHistory = new InvalidDataInfo
{
FilterType = "Common.NewerThanCurrentEntry",
Source = conceptInfo.Dependency_ChangesEntity,
ErrorMessage = "ActiveSince of history entry is not allowed to be newer than current entry."
};
newConcepts.AddRange(new IConceptInfo[]
{
denyFilterHistory,
invalidDataValidationHistory,
new ParameterInfo {
Module = new ModuleInfo {
Name = "Common"
}, Name = "NewerThanCurrentEntry"
},
new InvalidDataMarkProperty2Info {
InvalidData = invalidDataValidationHistory, MarkProperty = historyActiveSinceProperty
}
});
// Create ActiveUntil SqlQueryable:
var activeUntilSqlQueryable = new SqlQueryableInfo {
Module = conceptInfo.Entity.Module, Name = conceptInfo.Entity.Name + "_ChangesActiveUntil", SqlSource = ActiveUntilSqlSnippet(conceptInfo)
};
newConcepts.AddRange(new IConceptInfo[] {
activeUntilSqlQueryable,
new DateTimePropertyInfo {
DataStructure = activeUntilSqlQueryable, Name = "ActiveUntil"
},
new SqlDependsOnDataStructureInfo {
Dependent = activeUntilSqlQueryable, DependsOn = conceptInfo.Dependency_ChangesEntity
},
new SqlDependsOnDataStructureInfo {
Dependent = activeUntilSqlQueryable, DependsOn = conceptInfo.Entity
},
new DataStructureExtendsInfo {
Base = conceptInfo.Dependency_ChangesEntity, Extension = activeUntilSqlQueryable
}
});
// Configure History SqlQueryable:
newConcepts.AddRange(new IConceptInfo[] {
new SqlDependsOnDataStructureInfo {
Dependent = historySqlQueryable, DependsOn = conceptInfo.Entity
},
new SqlDependsOnDataStructureInfo {
Dependent = historySqlQueryable, DependsOn = conceptInfo.Dependency_ChangesEntity
},
new SqlDependsOnDataStructureInfo {
Dependent = historySqlQueryable, DependsOn = activeUntilSqlQueryable
},
new DateTimePropertyInfo {
DataStructure = historySqlQueryable, Name = "ActiveUntil"
},
new AllPropertiesFromInfo {
Source = conceptInfo.Dependency_ChangesEntity, Destination = historySqlQueryable
}
});
// Configure AtTime SqlFunction:
newConcepts.Add(new SqlDependsOnDataStructureInfo {
Dependent = atTimeSqlFunction, DependsOn = historySqlQueryable
});
return(newConcepts);
}