public async Task AddSelected(AddSelectionRequest request) { Selection selection = new Selection() { ComponentType = request.ComponentType, Date = request.Date, ElementID = request.ElementID }; await _dbContext.Selections.AddAsync(selection); for (int i = 0; i < request.Properties.Count; i++) { var property = await _dbContext.Properties.Where(e => e.Component == request.ComponentType && e.Name == request.Properties.Keys.ElementAt(i)).FirstOrDefaultAsync(); var value = property.Values.Where(e => e.Value == request.Properties[property.Name]).FirstOrDefault(); SelectionProperties selectionProperties = new SelectionProperties() { PropertyValue = value, Selection = selection }; await _dbContext.SelectionProperties.AddAsync(selectionProperties); } await _dbContext.SaveChangesAsync(); }
public void RemoveSelectionProperty(QueryFromTable table, QueryFromProperty property) { var item = SelectionProperties.FirstOrDefault(s => s.StoreProperty.Name == property.StoreProperty.Name && s.FromTable.Alias == table.Alias); if (item != null) { SelectionProperties.Remove(item); } }
/// <summary> /// Gets a string representation of <see cref="T:BrowseSelection"/>. /// </summary> /// <returns></returns> public override string ToString() { StringBuilder buf = new StringBuilder(); buf.Append("name: ").Append(FieldName).Append(" "); buf.Append("values: " + string.Join(",", m_values.ToArray())).Append(" "); buf.Append("nots: " + string.Join(",", m_notValues.ToArray())).Append(" "); buf.Append("op: " + SelectionOperation.ToString()).Append(" "); buf.Append("sel props: " + SelectionProperties.ToDisplayString()); return(buf.ToString()); }
public void AddSelectionProperty(QueryFromTable table, QueryFromProperty property) { if (!SelectionProperties.Any(s => s.FromTable.Alias == table.Alias && s.StoreProperty.Name == property.StoreProperty.Name)) { var newSelectProperty = new QuerySelectProperty(table, property.StoreProperty) { IsOutput = true, Alias = property.Alias }; SelectionProperties.Add(newSelectProperty); } }
public void Clear() { // clear all values in controller StoreParameters.DataService = "MyDataService"; StoreParameters.QueryName = ""; StoreParameters.Namespace = "Default"; StoreParameters.QueryReturnType = ""; FromTables.Clear(); SelectionProperties.Clear(); FromTableLinks.Clear(); FromTableJoins.Clear(); WhereClause = ""; }
public void SetGroupByFunction(QuerySelectProperty property, string func) { property.GroupByFunction = func; if (func == "Group By All") { SelectionProperties.Where(p => p.IsOutput).ToList().ForEach(p => p.GroupByFunction = "Group By"); SelectionProperties.Where(p => !String.IsNullOrWhiteSpace(p.Filter)).ToList().ForEach(p => p.GroupByFunction = "Where"); } if (func == "Group By None") { SelectionProperties.ToList().ForEach(p => p.GroupByFunction = ""); } }
public SelectionTool(Project project) : base(project) { Type = SelectionType.Rectangle; Panel = new SelectionProperties(this); }
protected virtual void OnCommandBufferRefresh(IRTECamera camera) { HandleProperties.SetColor("_Color", HandlesColor); LineProperties.SetColor("_Color", LineColor); SelectionProperties.SetColor("_Color", SelectionColor); }