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;
}
