public ActionResult DeleteStorageTank(long id) { var gVal = new GenericValidator(); try { if (id < 1) { gVal.Code = -1; gVal.Error = "Invalid selection"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var delStatus = new StorageTankServices().DeleteStorageTank(id); if (delStatus < 1) { gVal.Code = -1; gVal.Error = "StorageTank could not be deleted. Please try again later."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } gVal.Code = 5; gVal.Error = "StorageTank Information was successfully deleted"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public ActionResult EditStorageTank(StorageTankObject storageTank) { var gVal = new GenericValidator(); try { if (string.IsNullOrEmpty(storageTank.TankNo.Trim())) { gVal.Code = -1; gVal.Error = "Please provide StorageTank."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } if (Session["_StorageTank"] == null) { gVal.Code = -1; gVal.Error = "Session has timed out."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var oldStorageTank = Session["_StorageTank"] as StorageTankObject; if (oldStorageTank == null) { gVal.Code = -1; gVal.Error = "Session has timed out."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } oldStorageTank.TankNo = storageTank.TankNo; oldStorageTank.TankNo = storageTank.TankNo.Trim(); var docStatus = new StorageTankServices().UpdateStorageTank(oldStorageTank); if (docStatus < 1) { gVal.Code = -1; gVal.Error = "StorageTank information could not be updated. Please try again later"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } gVal.Code = oldStorageTank.Id; gVal.Error = "StorageTank information was successfully updated"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { gVal.Code = -1; gVal.Error = "StorageTank information could not be updated. Please try again later"; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetStorageTankObjects(JQueryDataTableParamModel param) { try { IEnumerable <StorageTankObject> filteredParentMenuObjects; var countG = 0; var pagedParentMenuObjects = GetStorageTanks(param.iDisplayLength, param.iDisplayStart, out countG); if (!string.IsNullOrEmpty(param.sSearch)) { filteredParentMenuObjects = new StorageTankServices().Search(param.sSearch); } else { filteredParentMenuObjects = pagedParentMenuObjects; } if (!filteredParentMenuObjects.Any()) { return(Json(new List <StorageTankObject>(), JsonRequestBehavior.AllowGet)); } var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]); Func <StorageTankObject, string> orderingFunction = (c => sortColumnIndex == 1 ? c.TankNo : c.Capacity.ToString()); var sortDirection = Request["sSortDir_0"]; // asc or desc filteredParentMenuObjects = sortDirection == "desc" ? filteredParentMenuObjects.OrderBy(orderingFunction) : filteredParentMenuObjects.OrderByDescending(orderingFunction); var displayedPersonnels = filteredParentMenuObjects; var result = from c in displayedPersonnels select new[] { Convert.ToString(c.Id), c.TankNo, c.Capacity.ToString(), c.DepotName, c.ProductName, c.Measurement }; return(Json(new { param.sEcho, iTotalRecords = countG, iTotalDisplayRecords = countG, aaData = result }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message); return(Json(new List <StorageTankObject>(), JsonRequestBehavior.AllowGet)); } }
public ActionResult GetStorageTank(long id) { try { var storageTank = new StorageTankServices().GetStorageTank(id); if (storageTank == null || storageTank.Id < 1) { return(Json(new StorageTankObject(), JsonRequestBehavior.AllowGet)); } Session["_StorageTank"] = storageTank; return(Json(storageTank, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new StorageTankObject(), JsonRequestBehavior.AllowGet)); } }
public ActionResult AddStorageTank(StorageTankObject storageTank) { var gVal = new GenericValidator(); try { var importerInfo = GetLoggedOnUserInfo(); if (importerInfo.Id < 1) { gVal.Error = "Your session has timed out"; gVal.Code = -1; return(Json(gVal, JsonRequestBehavior.AllowGet)); } var validationResult = ValidateStorageTank(storageTank); if (validationResult.Code == 1) { return(Json(validationResult, JsonRequestBehavior.AllowGet)); } var appStatus = new StorageTankServices().AddStorageTank(storageTank); if (appStatus < 1) { validationResult.Code = -1; validationResult.Error = appStatus == -2 ? "StorageTank upload failed. Please try again." : "The StorageTank Information already exists"; return(Json(validationResult, JsonRequestBehavior.AllowGet)); } gVal.Code = appStatus; gVal.Error = "StorageTank was successfully added."; return(Json(gVal, JsonRequestBehavior.AllowGet)); } catch (Exception) { gVal.Error = "StorageTank storageTanking failed. Please try again later"; gVal.Code = -1; return(Json(gVal, JsonRequestBehavior.AllowGet)); } }