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));
}
