/// <summary>
/// Create a new Filter
/// </summary>
/// <param name="filter">The entity we are going to insert</param>
/// <param name="ctk">CancellationToken</param>
/// <returns>Custom Filter Entity</returns>
public Task <CustomFilter> CreateFilter(CustomFilter filter, CancellationToken ctk = default)
{
filter.Validate();
var url = "/filter";
return(_client.Exec <CustomFilter, CustomFilter>(HttpMethod.Post, url, filter));
}
public void AddFilter(CustomFilter newFilter)
{
WorkBook workBook = manager.ActiveWorkBook();
workBook.CustomFilters.Add(newFilter.Name, newFilter);
LoadFilterData(); // Property changed event handlers will be connected in this function
}
public void ConvertHandlesCustomFilters()
{
string argName = "-filter";
var filter = new CustomFilter("hqdn3d=4:4:3:3");
Assert.AreEqual($"{argName} {filter.Data}", _converter.Convert(argName, new IFilter[] { filter }));
}
/// <summary>
/// Update specific Filter
/// </summary>
/// <param name="filterId">The entity id</param>
/// <param name="filter">The entity we are going to update</param>
/// <param name="ctk">CancellationToken</param>
/// <returns>Custom Filter Entity</returns>
public Task <CustomFilter> UpdateFilter(int filterId, CustomFilter filter, CancellationToken ctk = default)
{
filter.Validate();
var url = "/filter".AppendPathSegment(filterId);
return(_client.Exec <CustomFilter, CustomFilter>(HttpMethod.Put, url, filter));
}
protected void ctnSaveFilter_Click(object sender, EventArgs e)
{
List <String> listOfIngredients = new List <String>();
foreach (ListItem li in lbxViewableFilterList.Items)
{
listOfIngredients.Add(li.ToString());
}
if (Session["CustomerFilter1"] == null)
{
CustomFilter cf1 = new CustomFilter(txtFilterTitle.Text, listOfIngredients);
Session["CustomFilter1"] = cf1;
}
else if (Session["CustomerFilter2"] == null)
{
CustomFilter cf2 = new CustomFilter(txtFilterTitle.Text, listOfIngredients);
Session["CustomFilter2"] = cf2;
}
else if (Session["CustomerFilter3"] == null)
{
CustomFilter cf3 = new CustomFilter(txtFilterTitle.Text, listOfIngredients);
Session["CustomFilter3"] = cf3;
}
else
{
}
Response.Redirect("Main.aspx");
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="query">Query to create the instance from</param>
public FilterQueryViewModel(string query)
{
_filter = new CustomFilter(query);
YalvRegistry.Instance.ActualWorkspace.CurrentAnalysis.AddFilter(_filter);
_active = true;
CommandCancelQuery = new CommandRelay(ExecuteCancelQuery, CanExecuteCancelQuery);
}
internal SLCustomFilters()
{
var cf = new CustomFilter();
cf.Operator = FilterOperatorValues.Equal;
cf.Val = "";
}
private void saveFilterButton_Click(object sender, RoutedEventArgs e)
{
CustomFilter customFilter = new CustomFilter();
customFilter.Function = this.customFunctionArrayFromCanvas();
this.applyFilter(customFilter);
}
public CustomFilterEditor()
{
filter = new CustomFilter();
pointCollection = new List <Point>();
InitializeComponent();
}
public virtual GridResponse <T> GetAllByFilterGrid(object entity)
{
Grid search = entity as Grid;
var q = _context.Set <T>().Where(CustomFilter <T> .FilterGrid(entity));
if (search.Sort != null && search.Sort.Count > 0)
{
foreach (Sort s in search.Sort)
{
PropertyInfo info = CustomFilter <T> .SortGrid(s);
if (s.SortType == "ASC")
{
q = q.OrderBy(x => info.GetValue(x, null));
}
else if (s.SortType == "DESC")
{
q = q.OrderByDescending(x => info.GetValue(x, null));
}
}
}
var n = q.Count();
if (search.Pagination != null)
{
q = q.Skip(search.Pagination.NumberDisplay * (search.Pagination.PageNumber - 1)).Take(search.Pagination.NumberDisplay);
}
var q_enum = q.AsEnumerable();
return(new GridResponse <T>
{
Data = q_enum,
NumberData = n
});
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["LoginId"] != null)
{
lblUsername.Text = (string)Session["LoginName"];
btnLogin.Visible = false;
pnlLogin.Visible = true;
}
if (Session["CustomFilter1"] != null || Session["CustomFilter2"] != null || Session["CustomerFilter3"] != null)
{
if (Session["CustomFilter3"] != null && Session["CustomFilter2"] != null && Session["CustomFilter1"] != null)
{
CustomFilter cf1 = (CustomFilter)Session["CustomFilter1"];
CustomFilter cf2 = (CustomFilter)Session["CustomFilter2"];
CustomFilter cf3 = (CustomFilter)Session["CustomFilter3"];
cblFilters.Items.FindByValue("0").Text = cf1.Title;
cblFilters.Items.FindByValue("1").Text = cf2.Title;
cblFilters.Items.FindByValue("2").Text = cf3.Title;
}
else if (Session["CustomFilter2"] != null && Session["CustomFilter1"] != null)
{
CustomFilter cf1 = (CustomFilter)Session["CustomFilter1"];
CustomFilter cf2 = (CustomFilter)Session["CustomFilter2"];
cblFilters.Items.FindByValue("0").Text = cf1.Title;
cblFilters.Items.FindByValue("1").Text = cf2.Title;
}
else
{
CustomFilter cf1 = (CustomFilter)Session["CustomFilter1"];
cblFilters.Items.FindByValue("0").Text = cf1.Title;
}
}
}
/// <summary>
/// Add the query to the list of queries
/// </summary>
/// <param name="filter"> filter containing the query </param>
public void AddQuery(CustomFilter filter)
{
var filtertoAdd = new FilterQueryViewModel(filter);
_queries.Add(filtertoAdd);
filtertoAdd.QueryDeleted += ExecuteCancel;
filtertoAdd.PropertyChanged += (sender, args) => NotifyPropertyChanged(() => Queries);
NotifyPropertyChanged(() => Queries);
}
public HttpResponseMessage Save(CustomFilterDto customFilterDto)
{
CustomFilter customFilter = this._mapper.Map <CustomFilter>(customFilterDto);
customFilter.UserId = CurrentUserId.Value;
ServiceResult result = _customFilterService.AddOrUpdate(customFilter);
return(Request.CreateResponse(result.Succeeded ? HttpStatusCode.OK : HttpStatusCode.BadRequest));
}
protected virtual Command Filter(CustomFilter filter)
{
//Validating if there are filters defined
if (filter == null)
{
return(null);
}
return(filter.Filter);
}
public bool sortSymbol = true; //排序顺序
public CheckItem(ObjectChecker checker, string t, int w = 80, CheckType ty = CheckType.String, CustomClickOption option = null, CustomFilter f = null)
{
title = t;
width = w;
type = ty;
customFilter = f;
clickOption = option;
order = checker.checkItem.Count;
checker.checkItem.Add(this);
}
public void CreateCustomFilter()
{
#region radspreadprocessing-features-filtering_1
CustomFilterCriteria critera1 =
new CustomFilterCriteria(ComparisonOperator.EqualsTo, "Test string");
CustomFilterCriteria critera2 =
new CustomFilterCriteria(ComparisonOperator.GreaterThan, "-5");
CustomFilter filter = new CustomFilter(0, critera1, LogicalOperator.Or, critera2);
#endregion
}
/// <summary>
/// Checks if an object passes the test or not.
/// </summary>
/// <param name="Object">Untyped object</param>
/// <returns>If the object passes the test.</returns>
public bool Passes(object Object)
{
if (this.ChildFilter is ICustomFilter CustomFilter)
{
return(!CustomFilter.Passes(Object));
}
else
{
return(false);
}
}
public int InsertCustomFilter(CustomFilter filter)
{
try
{
return(Util.PostDataToService <int>(String.Concat(Config.BaseAddress, "api/filters/customfilter"), filter));
}
catch (Exception ex)
{
throw Util.HandleAPIException(ex, "InsertCustomFilter");
}
}
/// <summary>
/// Checks if an object passes the test or not.
/// </summary>
/// <param name="Object">Untyped object</param>
/// <returns>If the object passes the test.</returns>
public bool Passes(object Object)
{
foreach (Filter F in this.ChildFilters)
{
if (F is ICustomFilter CustomFilter && CustomFilter.Passes(Object))
{
return(true);
}
}
return(false);
}
static ICollection <Customer> GetCustomers(ICollection <Customer> customers, CustomFilter filter)
{
List <Customer> resultList = new List <Customer>();
foreach (var customer in customers)
{
if (filter(customer))
{
resultList.Add(customer);
}
}
return(resultList);
}
public StressBindingInfo(DeterministicRandom random)
{
libraries = new Library[] { new Library(0.0, random), new Library(0.1, random), new Library(0.2, random) };
xmlLibraries = new XmlDocument[] { libraries[0].ToXmlDocument(),
libraries[1].ToXmlDocument(),
libraries[2].ToXmlDocument() };
adoLibraries = new DataTable[] { libraries[0].ToDataTable(),
libraries[1].ToDataTable(),
libraries[2].ToDataTable() };
sortDescriptionArray = new SortDescriptionCollection[4];
SortDescriptionCollection sortDescriptionCollection = new SortDescriptionCollection();
sortDescriptionCollection.Add(new SortDescription("Title", random.NextEnum <ListSortDirection>()));
sortDescriptionArray[0] = sortDescriptionCollection;
sortDescriptionCollection = new SortDescriptionCollection();
sortDescriptionCollection.Add(new SortDescription("Genre", random.NextEnum <ListSortDirection>()));
sortDescriptionCollection.Add(new SortDescription("Price", random.NextEnum <ListSortDirection>()));
sortDescriptionArray[1] = sortDescriptionCollection;
sortDescriptionCollection = new SortDescriptionCollection();
sortDescriptionCollection.Add(new SortDescription("Price", random.NextEnum <ListSortDirection>()));
sortDescriptionArray[2] = sortDescriptionCollection;
sortDescriptionCollection = new SortDescriptionCollection();
sortDescriptionCollection.Add(new SortDescription("Author", random.NextEnum <ListSortDirection>()));
sortDescriptionArray[3] = sortDescriptionCollection;
groupDescriptionArray = new PropertyGroupDescription[3];
PropertyGroupDescription propertyGroupDescription = new PropertyGroupDescription();
propertyGroupDescription.PropertyName = "Title";
groupDescriptionArray[0] = propertyGroupDescription;
propertyGroupDescription = new PropertyGroupDescription();
propertyGroupDescription.PropertyName = "Genre";
groupDescriptionArray[1] = propertyGroupDescription;
propertyGroupDescription = new PropertyGroupDescription();
propertyGroupDescription.PropertyName = "Author";
groupDescriptionArray[2] = propertyGroupDescription;
CustomFilter myfilter = new CustomFilter();
filters = new Predicate <object>[] { new Predicate <object>(myfilter.Over50), new Predicate <object>(myfilter.NotOver50) };
}
private void FindPopups()
{
foreach (var headerCell in RadGridView1.ChildrenOfType <GridViewHeaderCell>())
{
var popUp = headerCell.ChildrenOfType <Popup>()
.FirstOrDefault();
// we only have once possible pop up here in this simple case so no complex handling code
if (popUp != null)
{
var filterInstance = new CustomFilter(RadGridView1.Columns["Department"], popUp);
_mainViewModel.CustomFilterInstance = filterInstance;
RadGridView1.Columns["Department"].FilteringControl = _mainViewModel.CustomFilterInstance;
}
}
}
public static CustomFilterResource ToResource(this CustomFilter model)
{
if (model == null)
{
return(null);
}
return(new CustomFilterResource
{
Id = model.Id,
Type = model.Type,
Label = model.Label,
Filters = STJson.Deserialize <List <ExpandoObject> >(model.Filters)
});
}
public void ApplyFilter(MainWindow mainWindow)
{
if (mainWindow.imageHandler != null)
{
List <byte> functionMapper = new List <byte>();
for (int i = 0; i < lines.Count; i++)
{
Line line = lines.ElementAt(i);
int x0 = (int)line.X1;
int y0 = 255 - (int)line.Y1;
int x1 = (int)line.X2;
int y1 = 255 - (int)line.Y2;
int length = x1;
if (i == lines.Count - 1)
{
length++;
}
for (int x = x0; x < length; x++)
{
double yDiff = y1 - y0;
double xDiff = x1 - x0;
int y;
if (xDiff < 1)
{
y = y0;
}
else
{
double m = yDiff / xDiff;
double diff = (x - x0);
double d_y = y0 + diff * m;
y = (int)d_y;
}
functionMapper.Add((byte)y);
}
}
CustomFilter filter = new CustomFilter(functionMapper);
mainWindow.imageHandler.ApplyFilter(image => filter.ApplyFilter(image));
mainWindow.filteredImage.Source = BitmapLoader.loadBitmap(mainWindow.imageHandler.getFiltered());
}
}
public void CustomFilter_ReadFilter()
{
using (var httpTest = new HttpTest())
{
var mds = new MarketDataService(_cfg);
var filter = new CustomFilter();
var mdq = mds.ReadFilter(1).ConfigureAwait(true).GetAwaiter().GetResult();
httpTest.ShouldHaveCalledPath($"{_cfg.BaseAddress}v2.1/filter/")
.WithVerb(HttpMethod.Get)
.WithHeadersTest()
.Times(1);
}
}
public IEnumerable <EmployeeListViewModel> GetEmployeeList(CustomFilter customFilter, out int totalCount)
{
try
{
int totalCount1 = 0;
var result = EmployeeManager.Instance.GetEmployeeList(customFilter, out totalCount1).ToList();
totalCount = totalCount1;
return(result);
}
catch (Exception ex)
{
totalCount = 0;
logger.LogMessage(ex.ToString());
return(Enumerable.Empty <EmployeeListViewModel>());
}
}
public GridResponse <SubDepartment> GetAllByFilterGrid(object entity)
{
Grid search = entity as Grid;
var q = _context.SubDepartments.Where(CustomFilter <SubDepartment> .FilterGrid(entity));
if (search.Sort != null && search.Sort.Count > 0)
{
foreach (Sort s in search.Sort)
{
PropertyInfo info = CustomFilter <SubDepartment> .SortGrid(s);
if (s.SortType == "ASC")
{
q = q.OrderBy(x => info.GetValue(x, null));
}
else if (s.SortType == "DESC")
{
q = q.OrderByDescending(x => info.GetValue(x, null));
}
}
}
var n = q.Count();
if (search.Pagination != null)
{
q = q.Skip(search.Pagination.NumberDisplay * (search.Pagination.PageNumber - 1)).Take(search.Pagination.NumberDisplay);
}
var q_enum = q.Include(x => x.Departemen).Select(x => new SubDepartment
{
Kode = x.Kode,
Departemen = new Department
{
DirektoratKode = x.Departemen.DirektoratKode,
Kode = x.Departemen.Kode,
NamaDepartemen = x.Departemen.NamaDepartemen
},
DepartemenKode = x.DepartemenKode,
NamaSubDepartemen = x.NamaSubDepartemen
}).AsEnumerable();
return(new GridResponse <SubDepartment>
{
Data = q_enum,
NumberData = n
});
}
internal CustomFilters ToCustomFilters()
{
var cfs = new CustomFilters();
if ((And != null) && And.Value)
{
cfs.And = And.Value;
}
CustomFilter cf;
if (OneCustomFilter)
{
cf = new CustomFilter();
if (HasFirstOperator)
{
cf.Operator = FirstOperator;
}
cf.Val = FirstVal;
cfs.Append(cf);
}
else
{
cf = new CustomFilter();
if (HasFirstOperator)
{
cf.Operator = FirstOperator;
}
cf.Val = FirstVal;
cfs.Append(cf);
cf = new CustomFilter();
if (HasSecondOperator)
{
cf.Operator = SecondOperator;
}
cf.Val = SecondVal;
cfs.Append(cf);
}
return(cfs);
}
internal CustomFilters ToCustomFilters()
{
CustomFilters cfs = new CustomFilters();
if (this.And != null && this.And.Value)
{
cfs.And = this.And.Value;
}
CustomFilter cf;
if (this.OneCustomFilter)
{
cf = new CustomFilter();
if (HasFirstOperator)
{
cf.Operator = this.FirstOperator;
}
cf.Val = this.FirstVal;
cfs.Append(cf);
}
else
{
cf = new CustomFilter();
if (HasFirstOperator)
{
cf.Operator = this.FirstOperator;
}
cf.Val = this.FirstVal;
cfs.Append(cf);
cf = new CustomFilter();
if (HasSecondOperator)
{
cf.Operator = this.SecondOperator;
}
cf.Val = this.SecondVal;
cfs.Append(cf);
}
return(cfs);
}
public IActionResult AdopterPagedList([FromQuery] CustomFilter filter)
{
try
{
var result = new PagingResultViewModel <AdopterListViewModel>();
var pagingAdopters = _adopterService.GetAdopters(filter.Page.Value, filter.PageSize.Value, filter.Search, filter.IsActive);
if (pagingAdopters.Elements.Any())
{
var animalsListViewModel = pagingAdopters.Elements.Select(adopter => new AdopterListViewModel()
{
Id = adopter.Id,
Name = adopter.Name,
PhoneNumber = adopter.ContactInfo.FormatPhoneNumber,
Email = adopter.ContactInfo.Email,
Status = adopter.Status
});
result = new PagingResultViewModel <AdopterListViewModel>(filter.Page.Value, filter.PageSize.Value)
{
Elements = animalsListViewModel,
ElementsCount = pagingAdopters.ElementsCount
};
}
else
{
return(RequestResponse(HttpStatusCode.NotFound, "hipets/api/v1/adopters", result: "No content"));
}
return(IsAValidOperation()
? RequestResponse(HttpStatusCode.OK, result: result)
: RequestResponse(HttpStatusCode.NotFound, "hipets/api/v1/adopters", isError: true));
}
catch (Exception ex)
{
var error = JsonConvert.SerializeObject(ex);
_logger.LogError(error);
return(RequestResponse(HttpStatusCode.BadRequest, isError: true, result: "Ocorreu um erro ao listar os clientes"));
}
}
/// <summary>
/// Gets filters list.
/// </summary>
/// <param name="filtersDescriptors">Filters descriptors.</param>
/// <returns>Filters list.</returns>
public static List<CustomFilter> GetFilters(IList<IFilterDescriptor> filtersDescriptors)
{
var filters = new List<CustomFilter>();
var descriptors = new List<FilterDescriptor>();
foreach (var filterDescriptor in filtersDescriptors)
{
descriptors.AddRange(GetDescriptors(filterDescriptor));
}
foreach (FilterDescriptor filter in descriptors)
{
var customFilter = new CustomFilter()
{
Member = filter.Member,
MemberType = filter.Value.GetType(),
Value = filter.Value
};
switch (filter.Operator)
{
case FilterOperator.Contains:
customFilter.Operator = CustomOperator.Contains;
break;
case FilterOperator.IsGreaterThan:
customFilter.Operator = CustomOperator.Greater;
break;
case FilterOperator.IsLessThan:
customFilter.Operator = CustomOperator.Less;
break;
case FilterOperator.IsGreaterThanOrEqualTo:
customFilter.Operator = CustomOperator.GreaterOrEqual;
break;
case FilterOperator.IsLessThanOrEqualTo:
customFilter.Operator = CustomOperator.LessOrEqual;
break;
}
filters.Add(customFilter);
}
return filters;
}
internal SLCustomFilters()
{
CustomFilter cf = new CustomFilter();
cf.Operator = FilterOperatorValues.Equal;
cf.Val = "";
}
private static void PopulateAutoFilter(XLAutoFilter xlAutoFilter, AutoFilter autoFilter)
{
var filterRange = xlAutoFilter.Range;
autoFilter.Reference = filterRange.RangeAddress.ToString();
foreach (var kp in xlAutoFilter.Filters)
{
var filterColumn = new FilterColumn {ColumnId = (UInt32)kp.Key - 1};
var xlFilterColumn = xlAutoFilter.Column(kp.Key);
var filterType = xlFilterColumn.FilterType;
if (filterType == XLFilterType.Custom)
{
var customFilters = new CustomFilters();
foreach (var filter in kp.Value)
{
var customFilter = new CustomFilter {Val = filter.Value.ToString()};
if (filter.Operator != XLFilterOperator.Equal)
customFilter.Operator = filter.Operator.ToOpenXml();
if (filter.Connector == XLConnector.And)
customFilters.And = true;
customFilters.Append(customFilter);
}
filterColumn.Append(customFilters);
}
else if (filterType == XLFilterType.TopBottom)
{
var top101 = new Top10 {Val = (double)xlFilterColumn.TopBottomValue};
if (xlFilterColumn.TopBottomType == XLTopBottomType.Percent)
top101.Percent = true;
if (xlFilterColumn.TopBottomPart == XLTopBottomPart.Bottom)
top101.Top = false;
filterColumn.Append(top101);
}
else if (filterType == XLFilterType.Dynamic)
{
var dynamicFilter = new DynamicFilter
{Type = xlFilterColumn.DynamicType.ToOpenXml(), Val = xlFilterColumn.DynamicValue};
filterColumn.Append(dynamicFilter);
}
else
{
var filters = new Filters();
foreach (var filter in kp.Value)
{
filters.Append(new Filter {Val = filter.Value.ToString()});
}
filterColumn.Append(filters);
}
autoFilter.Append(filterColumn);
}
if (xlAutoFilter.Sorted)
{
var sortState = new SortState
{
Reference =
filterRange.Range(filterRange.FirstCell().CellBelow(), filterRange.LastCell()).RangeAddress.
ToString()
};
var sortCondition = new SortCondition
{
Reference =
filterRange.Range(1, xlAutoFilter.SortColumn, filterRange.RowCount(),
xlAutoFilter.SortColumn).RangeAddress.ToString()
};
if (xlAutoFilter.SortOrder == XLSortOrder.Descending)
sortCondition.Descending = true;
sortState.Append(sortCondition);
autoFilter.Append(sortState);
}
}
public static string GetFilterValue(CustomFilter filter)
{
Type type = filter.GetType();
FieldInfo fi = type.GetField(filter.ToString());
CustomFilterValueAttribute[] attrs = fi.GetCustomAttributes(typeof(CustomFilterValueAttribute), false) as CustomFilterValueAttribute[];
return attrs[0].FilterValue;
}
internal CustomFilters ToCustomFilters()
{
CustomFilters cfs = new CustomFilters();
if (this.And != null && this.And.Value) cfs.And = this.And.Value;
CustomFilter cf;
if (this.OneCustomFilter)
{
cf = new CustomFilter();
if (HasFirstOperator) cf.Operator = this.FirstOperator;
cf.Val = this.FirstVal;
cfs.Append(cf);
}
else
{
cf = new CustomFilter();
if (HasFirstOperator) cf.Operator = this.FirstOperator;
cf.Val = this.FirstVal;
cfs.Append(cf);
cf = new CustomFilter();
if (HasSecondOperator) cf.Operator = this.SecondOperator;
cf.Val = this.SecondVal;
cfs.Append(cf);
}
return cfs;
}
public void SetCustomFilterTwo(CustomFilter field, FilterOperators operatorTwo, string value)
{
UIUtil.DefaultProvider.SelectWithValue("crFilters_customFilters_ddlFieldFilter_1", CustomFilterValueAttribute.GetFilterValue(field), LocateBy.Id);
UIUtil.DefaultProvider.SelectWithValue("crFilters_customFilters_ddlFilterOperator_1", CustomStringAttribute.GetCustomString(operatorTwo), LocateBy.Id);
UIUtil.DefaultProvider.Type("crFilters_customFilters_tbValue_1", value, LocateBy.Id);
}
