public void FilterJewelryBy(DynamicSQLWhereObject dynamicFilter)
{
if (dynamicFilter != null && dynamicFilter.Pattern!="AnyMatch")
{
HasFilter = true;
filter = dynamicFilter;
}
}
public DynamicSQLWhereObject DynamicSQLByFilterValue(int filterValue)
{
if (filterValue == 0)
{
var dynamic = new DynamicSQLWhereObject();
dynamic.DoNothing();
return dynamic;
}
return new DynamicSQLWhereObject("JEWELSUBTYPE_ID = @0", filterValue);
}
private static DynamicSQLWhereObject DynamicSQLWhereObject()
{
const string pattern = "jeweltype_id = @0 and category_id = @1";
var values = new List<object>() { 2, 7 };
var dynamicSQL = new DynamicSQLWhereObject(pattern, values);
return dynamicSQL;
}
public InMemoryFilterItem(int id,string displayname,string pattern,List<object> valueslist )
{
FilterItemID = id;
FilterDisplayName = displayname;
DynamicSQL = new DynamicSQLWhereObject(pattern,valueslist);
}
public JewelryDynamicFilter(DynamicSQLWhereObject dynamicFilterSQL)
{
}
public void AddFilter(DynamicSQLWhereObject filter)
{
customFilters.Add(filter);
}
public virtual List<Jewel> GetJewelsByDynamicSQL(DynamicSQLWhereObject dynamicSQL)
{
var jewelrylist = new List<Jewel>();
using (var db = new JONEntities())
{
var items = db.v_jewel_items.Where(dynamicSQL.Pattern, dynamicSQL.Valuelist.ToArray());
if (HasFilter)
{
items = items.Where(filter.Pattern, filter.Valuelist.ToArray());
}
items = items.Where(ParseMetalFilter(requestedJewelMediaTypeByUser));
foreach (var customfilter in customFilters)
{
if (!customfilter.IsDoingNothing)
{
items = items.Where(customfilter.Pattern, customfilter.Valuelist.ToArray());
}
}
items = items.OrderBy(orderBy.SQLString);
totalItems = items.Count();
items = items.Skip(itemsPerPage*(page - 1)).Take(itemsPerPage);
foreach (var item in items)
{
var jewel = JewelClassFactory(item);
jewelrylist.Add(jewel);
}
currentPage = page;
}
return jewelrylist;
}
public List<Jewel> GetJewelsByDynamicSQL(DynamicSQLWhereObject dynamicSQL)
{
var list = new List<Jewel>();
var items = dbmock.Where(dynamicSQL.Pattern, dynamicSQL.Valuelist.ToArray());
if (HasFilter)
{
items = items.Where(filter.Pattern, filter.Valuelist.ToArray());
}
items = items.Where(ParseMetalFilter(requestedJewelMediaTypeByUser));
//must call orderby before skip
items = items.OrderBy(ParseOrderBy());
totalItems = items.ToList().Count;
items = items.Skip(itemsPerPage * (page - 1)).Take(itemsPerPage);
foreach (var jewel in items)
{
list.Add(JewelClassFactory(jewel));
}
return list;
}
public void AddFilter(DynamicSQLWhereObject filter)
{
throw new NotImplementedException();
}
