public DbFilterFieldCollection FetchByQuery(Query qry)
{
DbFilterFieldCollection coll = new DbFilterFieldCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public DbFilterFieldCollection FetchBySourceForm(string sourceform)
{
//string _src = wwi_security.DecryptString(sourceform, "publiship");
DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", sourceform).Where("is_active", true).OrderByAsc("sort_order").Load();
return(coll);
}
public DbFilterFieldCollection FetchAll()
{
DbFilterFieldCollection coll = new DbFilterFieldCollection();
Query qry = new Query(DbFilterField.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return(coll);
}
public DbFilterFieldCollection FetchByContainers()
{
DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", "container").Load();
return(coll);
}
public DbFilterFieldCollection FetchByDeliveries()
{
DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", "delivery").Load();
return(coll);
}
public DbFilterFieldCollection FetchByActiveAdvance()
{
DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("applies_to", "advance").Where("is_active", true).OrderByAsc("sort_order").Load();
return(coll);
}
public DbFilterFieldCollection FetchByActiveAnonymous()
{
DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("is_quick_filter", true).Where("applies_to", "shipment").Where("login_required", false).OrderByAsc("sort_order").Load();
return(coll);
}
public DbFilterFieldCollection FetchByID(object FilterFieldId)
{
DbFilterFieldCollection coll = new DbFilterFieldCollection().Where("filter_field_ID", FilterFieldId).Load();
return(coll);
}
