c# - how to return results that have a date of yesterday and before -

c# - how to return results that have a date of yesterday and before -

i returning results using llblgen adapter model. using break points because cannot them populate kendo grid yet, can see coming back. need homecoming results have date property of yesterday , prior. not familiar @ using kendo grid nor llbl adapter. bulk of other examples out there using entity framework. here have far. there no error messages because stuck @ how setup filter?

controller

public actionresult bundlestatus() { homecoming view(); } [httppost] public actionresult bundlestatusread([datasourcerequest] datasourcerequest request) { var span = datetime.today.adddays(-1); dataaccessadapter adapter = new dataaccessadapter(); entitycollection allbundles = new entitycollection(new carrierbundleentityfactory()); adapter.fetchentitycollection(allbundles, null); var results = allbundles; homecoming json(results.todatasourceresult(request)); } }

view

@{ viewbag.title = "bundlestatusget"; } <div> @(html.kendo().grid<zoomaudits.dal.entityclasses.carrierbundleentity>() .name("grid") .columns(columns => { columns.bound(c => c.bundleid).width(140); columns.bound(c => c.carrierid).width(190); columns.bound(c => c.date); columns.bound(c => c.issent).width(110); }) .htmlattributes(new { style = "height: 380px;" }) .scrollable() .groupable() .sortable() .pageable(pageable => pageable .refresh(true) .pagesizes(true) .buttoncount(5)) .selectable(selectable => selectable .mode(gridselectionmode.multiple) .type(gridselectiontype.cell)) //.events(events => events.change("onchange").sync("sync_handler"))) .datasource(datasource => datasource .ajax() .read(read => read.action("bundlestatusread", "bundlestatus")) //.update(update => update.action("editinginline_update", "grid")) ) )

update controller

public actionresult bundlestatusread([datasourcerequest] datasourcerequest request) { var span = datetime.today.adddays(-1); dataaccessadapter adapter = new dataaccessadapter(); entitycollection allbundles = new entitycollection(new carrierbundleentityfactory()); relationpredicatebucket filter = new relationpredicatebucket(carrierbundlefields.date == span); adapter.fetchentitycollection(allbundles, filter); var results = allbundles; homecoming json(results.todatasourceresult(request));

it not returning results? see when open break point @ var results llbl enumeration yielded no results

hi haven't used llblgen in while , prior adapter. however, found this documentation on using entitycollection<t> class, adapter llblgen. hope helps.

by way, can utilize [httpget] , set action result allow get.

return json(results.todatasourceresult(request)), jsonrequestbehavior.allowget);

if trying yesterday , prior use:

relationpredicatebucket filter = new relationpredicatebucket(carrierbundlefields.date <= span);

c# asp.net-mvc kendo-grid llblgenpro