public async Task <ActionResult> getSources()
{
int pageLimit = 25;
int PageCnt = 1;
Helpers.jqGrid <Models.Source> jqgrid = new Helpers.jqGrid <Models.Source>();
Models.jqgridData data = new Models.jqgridData();
Models.SourceViewModel sources = await Helpers.SourcesAdapter.getAllSources();
List <Models.Source> sourcesList = sources.Sources as List <Models.Source>;
Helpers.SourcesAdapter.insertIntoCache(sourcesList, cachedSessionId);
System.Collections.Specialized.NameValueCollection RequestParams = ControllerContext.RequestContext.HttpContext.Request.Params;
if (RequestParams["rows"] != null)
{
pageLimit = Convert.ToInt32(RequestParams["rows"]);
}
if (RequestParams["PageCnt"] != null)
{
PageCnt = Convert.ToInt32(RequestParams["PageCnt"]);
}
if (sources != null)
{
data.rows = jqgrid.loadPageRecords(PageCnt, pageLimit, sources.Sources);
data.records = sources.Sources.Count;
data.page = PageCnt;
data.total = (int)Math.Ceiling((decimal)sources.Sources.Count / pageLimit);
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> Sources()
{
Models.SourceViewModel view = new Models.SourceViewModel();
view = await Helpers.SourcesAdapter.getAllSources();
return(View(view));
}
public static async Task <Models.SourceViewModel> getAllSources()
{
Models.SourceViewModel viewObject = new Models.SourceViewModel();
var cachedSource = (List <Models.Source>)HttpContext.Current.Cache["FileSources." + MCS.Controllers.HomeController.cachedSessionId];
if (cachedSource != null)
{
viewObject.Sources = cachedSource;
}
else
{
using (var _db = new Models.BleacherDb())
{
_db.Configuration.ProxyCreationEnabled = false;
var query = from x in _db.Sources
select x;
viewObject.Sources = await query.ToListAsync();
}
}
return(viewObject);
}
