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 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)); }
public JsonResult dispatch(string inputs, string type, string CID) { System.Web.Script.Serialization.JavaScriptSerializer jser = new System.Web.Script.Serialization.JavaScriptSerializer(); Helpers.CtxService service = new Helpers.CtxService(null, CID); string userMessage = ""; int msid = 0; if (inputs.Length == 0) { return(Json("Input Box Objects cannot be empty.", JsonRequestBehavior.AllowGet)); } try { FlagBoard_mvc.Models.pageInputs[] inputObjects = jser.Deserialize <FlagBoard_mvc.Models.pageInputs[]>(inputs); Helpers.jqGrid <FlagBoard_mvc.Models.schedule> jq = new Helpers.jqGrid <FlagBoard_mvc.Models.schedule>(); FlagBoard_mvc.Models.schedule record = jq.mapToObjectProperty(inputObjects); switch (type) { case "edit": if (record.MS_Unscheduled_Reason.Trim().Length > 50) { throw new Exception("Unscheduled Reason cannot be greater than 50 characters long."); } int rows = service.Update(record); if (rows > 0 && record.MS_Maint_Code == 1 && record.MS_Main_Comp_Date == "True") { if (record.MS_Frequency < 1) { throw new Exception("Interval must be greater than 0"); } AutoAddScheduledOrder(record, service); } userMessage = "true"; break; case "add": if (record.MS_Unscheduled_Reason.Length > 50) { throw new Exception("Unscheduled Reason cannot be greater than 50 characters long."); } int rowsaff = service.Add(record); service.Dispose(); if (rowsaff == 0) { throw new Exception("unknown error adding rows. "); } userMessage = "true"; msid = service.rowKey; break; case "delete": service.delete(record.MS_Id); userMessage = "true"; break; } } catch (Exception ex) { userMessage = "ERROR: " + ex.Message; } finally { service.Dispose(); service.clearCache(); } return(Json(new { message = userMessage, id = msid }, JsonRequestBehavior.AllowGet)); }