/// <summary>
/// Añade un filtro a la columna en el HAVIG
/// </summary>
public DimensionRequestBuilder WithHaving(FilterRequestModel.ConditionType condition, object value)
{
FilterRequestBuilder filter = GetFilter(condition, FilterRequestBuilder.FilterEvaluation.Having);
// Asigna el valor al filtro
filter.WithValue(value);
// Devuelve este generador
return(this);
}
public FilterRequestBuilder(DimensionRequestBuilder builder, FilterRequestModel.ConditionType condition, FilterEvaluation mode)
{
// Obtiene los objetos
Builder = builder;
Filter = new FilterRequestModel
{
Condition = condition
};
// Asigna el filtro a la solicitud al punto adecuado
switch (mode)
{
case FilterEvaluation.Where:
builder.Column.FiltersWhere.Add(Filter);
break;
case FilterEvaluation.Having:
builder.Column.FiltersHaving.Add(Filter);
break;
}
}
/// <summary>
/// Comprueba los datos introducidos
/// </summary>
private bool ValidateData(ListItemReportColumnFilterViewModel filter)
{
bool validated = false;
FilterRequestModel.ConditionType condition = filter.GetSelectedCondition();
// Comprueba los datos introducidos
if (condition == FilterRequestModel.ConditionType.Undefined)
{
ReportViewModel.ReportingSolutionViewModel.SolutionViewModel.MainController.SystemController.ShowMessage("Seleccione la condición");
}
else if (condition == FilterRequestModel.ConditionType.Contains && string.IsNullOrWhiteSpace(filter.Value1?.ToString()))
{
ReportViewModel.ReportingSolutionViewModel.SolutionViewModel.MainController.SystemController.ShowMessage("Seleccione el valor");
}
else
{
validated = true;
}
// Devuelve el valor que indica si los datos son correctos
return(validated);
}
internal QueryFilterModel(FilterRequestModel.ConditionType condition, List <object> values)
{
Condition = condition;
Values = values;
}
/// <summary>
/// Añade un filtro a la columna en el HAVING (y permite agregarle valores)
/// </summary>
public FilterRequestBuilder WithHaving(FilterRequestModel.ConditionType condition)
{
return(GetFilter(condition, FilterRequestBuilder.FilterEvaluation.Having));
}
/// <summary>
/// Añade un filtro a la columna en el WHERE (y permite agregarle valores)
/// </summary>
public FilterRequestBuilder WithWhere(FilterRequestModel.ConditionType condition)
{
return(GetFilter(condition, FilterRequestBuilder.FilterEvaluation.Where));
}
/// <summary>
/// Obtiene un generador para el filtro
/// </summary>
private FilterRequestBuilder GetFilter(FilterRequestModel.ConditionType condition, FilterRequestBuilder.FilterEvaluation mode)
{
return(new FilterRequestBuilder(this, condition, FilterRequestBuilder.FilterEvaluation.Where));
}
