private async Task <HttpResponseMessageResult> ExecuteAggregatePrimeum(long referenceSequence, int OrderSequence, SelectorInstance selectorInstance, WorkflowInstance wfInstance)
{
HttpResponseMessageResult res = new HttpResponseMessageResult()
{
IsSuccess = true
};
await ConfigVariableDomain.LoadVariables();
string nomDimension = await GetActionParameter(referenceSequence, OrderSequence, Constant.PARAMETER_ACTION_AGGREGATE_PRIMEUM_ALIGNMENTNAME);
long idDimension = await GetIdDimensionTree(nomDimension, Constant.PARAMETER_ACTION_AGGREGATE_PRIMEUM_ALIGNMENTNAME, wfInstance);
// niveau utiisateur
CriteriaValues cvTree = await UnitOfWork.GetDbContext().CriteriaValues
.Include(cv => cv.Criteria)
.ThenInclude(c => c.Dimension)
.Where(cv => cv.SelectorInstanceModifier != null && cv.SelectorInstanceModifier.Id == selectorInstance.Id && cv.Criteria.Dimension.Id == idDimension)
.AsNoTracking()
.FirstOrDefaultAsync();
string valueTopUser = cvTree?.Value;
int levelTopUser = 0;
if (!string.IsNullOrWhiteSpace(valueTopUser))
{
levelTopUser = valueTopUser.Split(ConfigVariableDomain.AlignmentChar).Length;
}
Dictionary <long, Tuple <ValueObject, int, string, bool> > dicVo = await ValueObjectDomain.CreateDictionaryVO(nomDimension, selectorInstance);
// Construction des arbres
int topLvl = dicVo.Values.Select(t => t.Item2).Min();
int bottomLvl = dicVo.Values.Select(t => t.Item2).Max();
IEnumerable <TreeValueObject> lstTree = ValueObjectDomain.BuildTreeVO(dicVo, nomDimension, topLvl, bottomLvl);
// On part du dernier niveau editable pour remonter jusqu'au niveau user.
int bottom = dicVo.Values.Where(t => t.Item4).Select(t => t.Item2).Max();
HashSet <long> idsAlreadyComputed = new HashSet <long>();
HashSet <KeyValuePair <long, double> > modifiedValues = new HashSet <KeyValuePair <long, double> >();
foreach (TreeValueObject tvo in lstTree)
{
for (int currentLvl = bottom; currentLvl > levelTopUser; currentLvl--)
{
IEnumerable <TreeValueObject> nodes = TreeValueObject.GetNodesFromLevel(tvo, currentLvl);
foreach (TreeValueObject child in nodes)
{
if ((child.Parent == null) || idsAlreadyComputed.Contains(child.Parent.Node.Id) || (child.Parent.Level <= levelTopUser))
{
continue;
}
double sum = child.Parent.Children.Select(subnode => ValueObjectDomain.GetMostCurrentValue(subnode.Node)).Sum();
child.Parent.Node.FutureValue = sum;
modifiedValues.Add(new KeyValuePair <long, double>(child.Parent.Node.Id, sum));
idsAlreadyComputed.Add(child.Parent.Node.Id);
}
}
}
// On sauve les modifications
int nbr = await UnitOfWork.GetDbContext().SaveChangesAsync();
// Mise à jour de la table temporaire
res.Append(await GridConfigurationDomain.SaveDataInTemporyTable(selectorInstance, wfInstance, modifiedValues));
return(res);
}
private async Task <HttpResponseMessageResult> CheckTreeSum(long referenceSequence, int ordreSequence, ConstraintLevelEnum level, SelectorInstance selectorInstance, WorkflowInstance workflowInstance)
{
HttpResponseMessageResult res = new HttpResponseMessageResult()
{
IsSuccess = true
};
await ConfigVariableDomain.LoadVariables();
string nomDimension = await GetConstraintParameter(referenceSequence, ordreSequence, Constant.PARAMETER_CONSTRAINT_ALIGNMENTNAME);
Dictionary <long, Tuple <ValueObject, int, string, bool> > dicVo = await ValueObjectDomain.CreateDictionaryVO(nomDimension, selectorInstance);
// Construction des arbres
int topLvl = dicVo.Values.Select(t => t.Item2).Min();
int bottomLvl = dicVo.Values.Select(t => t.Item2).Max();
IEnumerable <TreeValueObject> lstTree = ValueObjectDomain.BuildTreeVO(dicVo, nomDimension, topLvl, bottomLvl);
// On parcours les arbres et on vérifie les valeurs
HashSet <long> idsAlreadyComputed = new HashSet <long>();
//Dictionary<long, Tuple<double, double>> outOfConstraint = new Dictionary<long, Tuple<double, double>>();
Dictionary <long, object> outOfConstraint = new Dictionary <long, object>();
foreach (TreeValueObject tvo in lstTree)
{
string format = await ValueObjectDomain.GetNumericalFormat(tvo.Node.TypeValue, workflowInstance.DataSetId);
for (int currentLvl = bottomLvl; currentLvl > topLvl; currentLvl--)
{
IEnumerable <TreeValueObject> nodes = TreeValueObject.GetNodesFromLevel(tvo, currentLvl);
foreach (TreeValueObject child in nodes)
{
if ((child.Parent == null) || idsAlreadyComputed.Contains(child.Parent.Node.Id))
{
continue;
}
double sumComputed = child.Parent.Children.Select(subnode => ValueObjectDomain.GetMostCurrentValue(subnode.Node)).Sum();
double sumParent = ValueObjectDomain.GetMostCurrentValue(child.Parent.Node);
if (!ValueObjectHelper.AlmostEqual(sumComputed, sumParent, format))
{
outOfConstraint.Add(child.Parent.Node.Id, new { expected = sumParent, computed = sumComputed });
}
idsAlreadyComputed.Add(child.Parent.Node.Id);
}
}
}
if (outOfConstraint.Count > 0)
{
res.Json = JsonConvert.SerializeObject(outOfConstraint);
res.Message = "Some values are not sum of their children.";
if ((level == ConstraintLevelEnum.Info) || (level == ConstraintLevelEnum.Warning))
{
res.IsSuccess = true;
}
if (level == ConstraintLevelEnum.Error)
{
res.IsSuccess = false;
}
}
return(res);
}
/// <summary>
/// Seconde méthode de répartition, par copie de valeur sur les noeuds inférieurs (typiquement pour des valeurs qui ne sont pas sommables).
/// </summary>
/// <param name="referenceSequence">Référence de la séquence d'action</param>
/// <param name="OrderSequence">Numéro d'ordre de l'action dans la séquence</param>
/// <param name="selectorInstance">SelectorInstance</param>
/// <param name="wfInstance">WorkflowInstance</param>
/// <returns>Message de retour</returns>
private async Task <HttpResponseMessageResult> ExecuteSplitCopy(long referenceSequence, int OrderSequence, SelectorInstance selectorInstance, WorkflowInstance wfInstance)
{
HttpResponseMessageResult res = new HttpResponseMessageResult()
{
IsSuccess = true
};
// Récupération du nom de la dimension de la secto et du dictionnaire des objects.
string nomDimension = await Split_GetDimensionName(referenceSequence, OrderSequence, wfInstance);
Dictionary <long, Tuple <ValueObject, int, string, bool> > dicAllVo = await ValueObjectDomain.CreateDictionaryVO(nomDimension, selectorInstance);
HashSet <KeyValuePair <long, double> > modifiedValues = new HashSet <KeyValuePair <long, double> >();
// On créé la queue pour parcourir l'arbre procéduralement.
Queue <ValueObject> voToSplit = new Queue <ValueObject>();
foreach (ValueObject vo in dicAllVo.Values.Where(val => val.Item4).OrderBy(val => val.Item2).Select(val => val.Item1).ToList())
{
voToSplit.Enqueue(vo);
}
// Parcours des noeuds
while (voToSplit.Count > 0)
{
ValueObject node = voToSplit.Dequeue();
IEnumerable <ValueObject> children = GetChildren(node, nomDimension, dicAllVo);
if ((children != null) && (children.Count() > 0))
{
Split_CopyToOnChildren(node, children, voToSplit, dicAllVo, modifiedValues);
}
}
// On sauve les modifications
int nbr = await UnitOfWork.GetDbContext().SaveChangesAsync();
// Mise à jour de la table temporaire
res.Append(await GridConfigurationDomain.SaveDataInTemporyTable(selectorInstance, wfInstance, modifiedValues));
return(res);
}
