public ActionResult editSources()
{
System.Collections.Specialized.NameValueCollection RequestParams = ControllerContext.RequestContext.HttpContext.Request.Params;
bool result = false;
if (RequestParams.Count > 0)
{
Helpers.jqGrid <Models.SourceCrud> jqgrid = new Helpers.jqGrid <Models.SourceCrud>();
Models.SourceCrud crudVars = jqgrid.getReqParamsAsObject(RequestParams);
if (crudVars == null)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
Models.Source rowToEdit = Helpers.SourcesAdapter.getcachedRow(crudVars.Id, cachedSessionId);
if (rowToEdit != null && crudVars.oper != null)
{
if (crudVars.oper == "edit")
{
if (Helpers.SourcesAdapter.editSource(crudVars))
{
result = false;
Helpers.SourcesAdapter.editcachedRow(crudVars, cachedSessionId);
}
}
else if (crudVars.oper == "del")
{
if (Helpers.SourcesAdapter.deleteSourceAsync(rowToEdit))
{
result = true;
}
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> getImports()
{
Helpers.jqGrid <Models.jqgridLoad> jqgrid = new Helpers.jqGrid <Models.jqgridLoad>();
Models.jqgridData data = new Models.jqgridData();
System.Collections.Specialized.NameValueCollection RequestParams = ControllerContext.RequestContext.HttpContext.Request.Params;
Models.jqgridLoad loadVars = jqgrid.getReqParamsAsObject(RequestParams);
if (loadVars != null)
{
Helpers.jqGrid <Models.FileImportview> jqView = new Helpers.jqGrid <Models.FileImportview>();
if (loadVars.paging == false && loadVars.FilterFlag == false)
{
Models.IndexViewModel viewObject = new Models.IndexViewModel();
viewObject = await Helpers.MCSAdapter.getImportRecords(DateTime.Now.AddDays(-7), DateTime.Now);
if (viewObject != null)
{
if (viewObject.FileImportview.Count > 0)
{
Helpers.MCSAdapter.insertIntoCache(viewObject.FileImportview, cachedSessionId);
Helpers.MCSAdapter.insertIntoCache(viewObject.FileImportview, cachedSessionId + ".displayed");
}
data.rows = jqView.loadPageRecords(loadVars.PageCnt, loadVars.rows, viewObject.FileImportview);
data.records = viewObject.FileImportview.Count;
data.page = loadVars.PageCnt;
data.total = (int)Math.Ceiling((decimal)viewObject.FileImportview.Count / loadVars.rows);
}
}
else if (loadVars.FilterFlag == true)
{
List <Models.FileImportview> cachedImports = Helpers.MCSAdapter.getFromCache(cachedSessionId);
if (cachedImports != null && cachedImports.Count > 0)
{
List <Models.FileImportview> filteredSet = new List <Models.FileImportview>();
if (loadVars.Filter1 != "ALL")
{
filteredSet = jqView.FilterType("Source", loadVars.Filter1, cachedImports);
}
else
{
filteredSet = Helpers.MCSAdapter.getFromCache(cachedSessionId);
}
if (filteredSet != null && filteredSet.Count > 0)
{
Helpers.MCSAdapter.insertIntoCache(filteredSet, cachedSessionId + ".displayed");
data.rows = jqView.loadPageRecords(loadVars.PageCnt, loadVars.rows, filteredSet);
data.records = filteredSet.Count;
data.page = loadVars.PageCnt;
data.total = (int)Math.Ceiling((decimal)filteredSet.Count / loadVars.rows);
}
}
}
else
{
List <Models.FileImportview> cachedImports = Helpers.MCSAdapter.getFromCache(cachedSessionId + ".displayed");
if (cachedImports != null && cachedImports.Count > 0)
{
data.rows = jqView.loadPageRecords(loadVars.PageCnt, loadVars.rows, cachedImports);
data.records = cachedImports.Count;
data.page = loadVars.PageCnt;
data.total = (int)Math.Ceiling((decimal)cachedImports.Count / loadVars.rows);
}
}
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
