protected void OnQuery(object sender, CustomExpressionEventArgs e) { bool genericTypes = Convert.ToBoolean(e.Values.First().Value); if (genericTypes) { e.Query = e.Query.Cast <TypeWrapper>().Where(t => t.Type.IsGenericType); } }
protected void ProductsWithCategory(object sender, CustomExpressionEventArgs e) { if (e.Values["CategoryName"] != null) { var catnames = e.Values["CategoryName"].ToString().Split(','); e.Query = from p in e.Query.Cast <Product>() where catnames.Contains(p.Category.CategoryName) select p; } }
protected void Unnamed_Querying(object sender, CustomExpressionEventArgs e) { if (IsPostBack) { var compIds = Convert.ToInt32(lbContractor.SelectedValue); if (compIds != 0) { e.Query = e.Query.Cast <YASA_PL.Score>().Where( c => compIds == c.Contractor_Order.ContractorId); } } }
protected void FilterEventsByRange(object sender, CustomExpressionEventArgs e) { // Parse all parameters if available float min = float.MinValue; float max = float.MaxValue; bool enabled = false; try { if (e.Values["enabled"] != null) { enabled = Boolean.Parse(e.Values["enabled"].ToString()); } if (e.Values["rangeFrom"] != null) { min = float.Parse(e.Values["rangeFrom"].ToString()); } if (e.Values["rangeTo"] != null) { max = float.Parse(e.Values["rangeTo"].ToString()); } } catch (Exception) { } if (enabled) { e.Query = from m in e.Query.Cast <Event>() where m.Level >= min && m.Level <= max select m; } // End of if(..) else { e.Query = from m in e.Query.Cast <Event>() select m; } }
protected void FilterMeasuresByUser(object sender, CustomExpressionEventArgs e) { // Check if User is Administrator / Normal user if (this.Page.User.IsInRole("Administrator") && !OnlyUser) { // Get username as parameter String username = ""; if (e.Values["username"] != null) { username = e.Values["username"].ToString(); } e.Query = from m in e.Query.Cast <Measure>() where m.aspnet_Users.UserName.Contains(username) select m; } else { e.Query = from m in e.Query.Cast <Measure>() where m.aspnet_Users.UserName == this.UserName select m; } }
protected void OnQuery(object sender, CustomExpressionEventArgs e) { bool genericTypes = Convert.ToBoolean(e.Values.First().Value); if (genericTypes) { e.Query = e.Query.Cast<TypeWrapper>().Where(t => t.Type.IsGenericType); } }
public void FilterAccounts(object sender, CustomExpressionEventArgs e) { var userID = SessionManager.CurrentUser.ID; e.Query = e.Query.Cast <ACCOUNT>().Where(a => a.USER.Any(u => u.ID == userID)); }
protected void FilterProducts(object sender, CustomExpressionEventArgs e) { e.Query = from p in e.Query.Cast <Product>() where p.UnitPrice >= 10 select p; }
protected void FilterMeasuresByRange(object sender, CustomExpressionEventArgs e) { // Parse all parameters if available float min = float.MinValue; float max = float.MaxValue; string selectedColumn = ""; bool enabled = false; try { if (e.Values["enabled"] != null) { enabled = Boolean.Parse(e.Values["enabled"].ToString()); } if (e.Values["column"] != null) { selectedColumn = e.Values["column"].ToString(); } if (e.Values["rangeFrom"] != null) { min = float.Parse(e.Values["rangeFrom"].ToString()); } if (e.Values["rangeTo"] != null) { max = float.Parse(e.Values["rangeTo"].ToString()); } } catch (Exception) { } if (enabled) { switch (selectedColumn) { case "acc": e.Query = from m in e.Query.Cast <Measure>() where m.Acceleration >= min && m.Acceleration <= max select m; break; case "blox": e.Query = from m in e.Query.Cast <Measure>() where m.BloodOxygen >= min && m.BloodOxygen <= max select m; break; case "temp": e.Query = from m in e.Query.Cast <Measure>() where m.Temperature >= min && m.Temperature <= max select m; break; case "pulse": e.Query = from m in e.Query.Cast <Measure>() where m.Pulse >= (int)min && m.Pulse <= (int)max select m; break; default: e.Query = from m in e.Query.Cast <Measure>() select m; break; } // End of switch(..) } // End of if(..) else { e.Query = from m in e.Query.Cast <Measure>() select m; } }
protected void FilterProducts(object sender, CustomExpressionEventArgs e) { e.Query = from p in e.Query.Cast<Product>() where p.UnitPrice >= 10 select p; }