public JsonResult Get(Models.BootstrapDataTable.Request pDataTableRequest) { if (!User.Identity.IsAuthenticated) { return(Json(JsonError.AUTHENTICATED_DENIED, JsonRequestBehavior.AllowGet)); } if (!Request.IsAjaxRequest()) { return(Json(JsonError.AJAX_DENIED, JsonRequestBehavior.AllowGet)); } try { IEnumerable <StatusModel> vStatusModelList = db.TitiushkoStatus.ToCustomModelList(); //Total de todos los registros int vTotalRows = vStatusModelList.Count(); //Buscar si pDataTableRequest.search se encuentra en Name o Description if (!string.IsNullOrWhiteSpace(pDataTableRequest.search)) { pDataTableRequest.search = pDataTableRequest.search.ToLower(); vStatusModelList = vStatusModelList.Where(m => m.Name.ToLower().Contains(pDataTableRequest.search) || m.Description.ToLower().Contains(pDataTableRequest.search)); } //Ordenar por pDataTableRequest.order (ascendente o descendente) la columna pDataTableRequest.sort Func <StatusModel, string> vOrderingFunction = (m => pDataTableRequest.sort.Equals("Name") ? m.Name : pDataTableRequest.sort.Equals("Description") ? m.Description : pDataTableRequest.sort.Equals("DateCreated") ? m.DateCreated : pDataTableRequest.sort.Equals("UserCreated") ? m.UserCreated : pDataTableRequest.sort.Equals("DateModified") ? m.DateModified : pDataTableRequest.sort.Equals("UserModified") ? m.UserModified : m.Name /*Ordenamiento predeterminado*/); if (pDataTableRequest.order.Equals("asc")) { vStatusModelList = vStatusModelList.OrderBy(vOrderingFunction); } else if (pDataTableRequest.order.Equals("desc")) { vStatusModelList = vStatusModelList.OrderByDescending(vOrderingFunction); } //Obtener paginación desde pDataTableRequest.offset hasta pDataTableRequest.limit vStatusModelList = vStatusModelList.Skip(pDataTableRequest.offset).Take(pDataTableRequest.limit); return(Json(new JsonResponse() { Content = new Models.BootstrapDataTable.Response() { total = vTotalRows, rows = vStatusModelList } }, JsonRequestBehavior.AllowGet)); } catch (Exception vException) { Logging.Logger.Error(vException); return(Json(JsonError.EXCEPCION(vException).SetContent(new Models.BootstrapDataTable.Response()), JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(StatusModel pStatusModel) { if (!User.Identity.IsAuthenticated) { return(Json(JsonError.AUTHENTICATED_DENIED)); } if (!Request.IsAjaxRequest()) { return(Json(JsonError.AJAX_DENIED)); } try { JsonResponse vJsonResponse = new JsonResponse(); if (ModelState.IsValid) { TitiushkoStatus vTitiushkoStatus = db.TitiushkoStatus.Find(pStatusModel.Id); if (vTitiushkoStatus == null) { return(Error404()); } vTitiushkoStatus.Name = pStatusModel.Name; vTitiushkoStatus.Description = pStatusModel.Description; vTitiushkoStatus.DateModified = DateTime.Now; vTitiushkoStatus.UserModified = User.Identity.Name; db.SaveChanges(); vJsonResponse.Message.Add(string.Format(Resources.Resource.TextEditSuccessFor, Resources.Resource.ModuleStatusName)); } else { vJsonResponse.SetErrorMessage(ModelState, string.Format(Resources.Resource.TextEditErrorFor, Resources.Resource.ModuleStatusName)); } return(Json(vJsonResponse)); } catch (DbEntityValidationException vEntityException) { Logging.Logger.Error(vEntityException); return(Json(JsonError.EXCEPCION(vEntityException))); } catch (Exception vException) { Logging.Logger.Error(vException); return(Json(JsonError.EXCEPCION(vException))); } }
public JsonResult Create(StatusModel pStatusModel) { if (!User.Identity.IsAuthenticated) { return(Json(JsonError.AUTHENTICATED_DENIED)); } if (!Request.IsAjaxRequest()) { return(Json(JsonError.AJAX_DENIED)); } try { JsonResponse vJsonResponse = new JsonResponse(); if (ModelState.IsValid) { db.TitiushkoStatus.Add(new TitiushkoStatus() { Name = pStatusModel.Name, Description = pStatusModel.Description, DateCreated = DateTime.Now, UserCreated = User.Identity.Name, DateModified = DateTime.Now, UserModified = User.Identity.Name }); db.SaveChanges(); vJsonResponse.Message.Add(string.Format(Resources.Resource.TextCreateSuccessFor, Resources.Resource.ModuleStatusName)); } else { vJsonResponse.SetErrorMessage(ModelState, string.Format(Resources.Resource.TextCreateErrorFor, Resources.Resource.ModuleStatusName)); } return(Json(vJsonResponse)); } catch (DbEntityValidationException vEntityException) { Logging.Logger.Error(vEntityException); return(Json(JsonError.EXCEPCION(vEntityException))); } catch (Exception vException) { Logging.Logger.Error(vException); return(Json(JsonError.EXCEPCION(vException))); } }
public JsonResult GetResource(string pResource) { if (!Request.IsAjaxRequest()) { return(Json(JsonError.AJAX_DENIED, JsonRequestBehavior.AllowGet)); } try { return(Json(new JsonResponse() { Content = Resources.Functions.GetResource(pResource) }, JsonRequestBehavior.AllowGet)); } catch (Exception vException) { Logging.Logger.Error(vException); return(Json(JsonError.EXCEPCION(vException), JsonRequestBehavior.AllowGet)); } }
public JsonResult DeleteConfirmed(int?id) { if (!User.Identity.IsAuthenticated) { return(Json(JsonError.AUTHENTICATED_DENIED)); } if (!Request.IsAjaxRequest()) { return(Json(JsonError.AJAX_DENIED)); } try { if (id == null) { return(Json(JsonError.ERROR_400)); } TitiushkoStatus vTitiushkoStatus = db.TitiushkoStatus.Find(id); if (vTitiushkoStatus == null) { return(Json(JsonError.ERROR_404)); } db.TitiushkoStatus.Remove(vTitiushkoStatus); db.SaveChanges(); return(Json(new JsonResponse() { Message = new HashSet <string>() { string.Format(Resources.Resource.TextDeleteSuccessFor, Resources.Resource.ModuleStatusName) } })); } catch (DbEntityValidationException vEntityException) { Logging.Logger.Error(vEntityException); return(Json(JsonError.EXCEPCION(vEntityException))); } catch (Exception vException) { Logging.Logger.Error(vException); return(Json(JsonError.EXCEPCION(vException))); } }