public void InsertReportColumnMapping(ReportColumnMapping value)
{
using (var scope = _reportColumnMappingRepository.CreateTransaction())
{
_reportColumnMappingRepository.Add(value, scope);
scope.Commit();
}
// reload mappings
_columnProviderCacheService.ClearMappings(value.DataSourceTypeId, value.OrganizationId);
_reportColumnMappingQueryService.GetReportColumnMappingsByOrganizationId(value.DataSourceTypeId, value.OrganizationId); // to ensure that all columns are reloaded
}
public void UpdateReportColumnMapping(ReportColumnMapping value)
{
value.CalculatedValues.Clear();
using (var scope = _reportColumnMappingRepository.CreateTransaction())
{
var entity = _reportColumnMappingRepository.GetReportColumnMapping(value.Id);
entity.ActionSpecId = value.ActionSpecId;
entity.CanGroupBy = value.CanGroupBy;
entity.DataSourceTypeId = value.DataSourceTypeId;
entity.DbType = value.DbType;
entity.DisplayName = value.DisplayName;
entity.FieldAggregationMethod = value.FieldAggregationMethod;
entity.FieldName = value.FieldName;
entity.IsCalculated = value.IsCalculated;
entity.IsPrivate = value.IsPrivate;
entity.KnownTable = value.KnownTable;
entity.LifetimeFieldName = value.LifetimeFieldName;
entity.MainCategory = value.MainCategory;
entity.OrganizationId = value.OrganizationId;
entity.Selectable = value.Selectable;
entity.SubCategory = value.SubCategory;
entity.UniqueName = value.UniqueName;
UpdateMetaData(entity, value);
_reportColumnMappingRepository.Update(entity, scope);
scope.Commit();
}
// reload mappings
_columnProviderCacheService.ClearMappings(value.DataSourceTypeId, value.OrganizationId);
_reportColumnMappingQueryService.GetReportColumnMappingsByOrganizationId(value.DataSourceTypeId, value.OrganizationId); // to ensure that all columns are reloaded
}
public override void ClearCache(int dataSourceTypeId)
{
_columnProviderCacheService.ClearMappings(dataSourceTypeId, organizationId: null);
}
