public ActionResult EditTipoPermiso(TipoPermisoDTO param) { try { //----------------------------------------------------------------------------------------------- var ctx = new SOLPEREntities(); var tp = param.GetTipoPermiso(); string msg; //----------------------------------------------------------------------------------------------- if (param.EsNuevo()) { ctx.TIPO_PERMISO.Add(tp); msg = "Tipo de permiso añadido exitosamente."; } else { ctx.TIPO_PERMISO.Attach(tp); ctx.Entry(tp).State = EntityState.Modified; msg = "Tipo de permiso actualizado exitosamente."; } //----------------------------------------------------------------------------------------------- ctx.SaveChanges(); //----------------------------------------------------------------------------------------------- return(Json(new { Code = 1, Mensaje = msg }, "txt/json", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Code = 3, Mensaje = ex.Message }, "txt/json", JsonRequestBehavior.AllowGet)); } }
public ActionResult GetTiposPermiso() { try { var ctx = new SOLPEREntities(); var data = ctx.TIPO_PERMISO.ToList(); return(Json(new { Code = 1, data }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { Code = 3, Mensaje = e.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetTipoPermiso(long id) { try { var ctx = new SOLPEREntities(); var tp = ctx.TIPO_PERMISO.FirstOrDefault(u => u.Id == id); var tipoPermiso = new TipoPermisoDTO(tp); return(Json(new { Code = 1, TipoPermiso = tipoPermiso }, "txt/json", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Code = 3, Mensaje = ex.Message }, "txt/json", JsonRequestBehavior.AllowGet)); } }
public ActionResult DeletePermiso(long id) { using (SOLPEREntities ctx = new SOLPEREntities()) { try { var p = ctx.PERMISOS.FirstOrDefault(u => u.Id == id); ctx.PERMISOS.Remove(p); ctx.SaveChanges(); return(Json(new { Code = 1, Mensaje = "El pedido ha sido eliminado exitosamente." }, "txt/json", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { Code = 3, Mensaje = ex.Message }, "txt/json", JsonRequestBehavior.AllowGet)); } } }
public ActionResult PermisoTableHandler([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest param) { try { //----------------------------------------------------------------------------------------------- var ordenPor = param.Columns.FirstOrDefault(c => c.IsOrdered); var seBusca = !param.Search.Value.IsNullOrWhiteSpace(); var b = seBusca ? param.Search.Value.ToLower() : ""; var ctx = new SOLPEREntities(); //----------------------------------------------------------------------------------------------- var query = (from p in ctx.PERMISOS join tp in ctx.TIPO_PERMISO on p.TipoPermiso equals tp.Id select new { Id = p.Id, NombreEmpleado = p.NombreEmpleado, ApellidosEmpleado = p.ApellidosEmpleado, Descripcion = tp.Descripcion, FechaPermiso = p.FechaPermiso.ToString() }) .Where(c => (!seBusca || c.NombreEmpleado.ToLower().Contains(b) || c.ApellidosEmpleado.ToLower().Contains(b) || c.Descripcion.ToLower().Contains(b))); //----------------------------------------------------------------------------------------------- var count = query.Count(); //----------------------------------------------------------------------------------------------- var list = query .SelectPage(o => o.ValorProp(ordenPor?.Name ?? nameof(o.NombreEmpleado)), ordenPor?.SortDirection == Column.OrderDirection.Descendant, param.Start, param.Length.IfMenorCero(999)) .ToList(); //----------------------------------------------------------------------------------------------- var data = new DataTablesResponse(param.Draw, list, count, count); return(Json(new { Code = 1, Data = data }, JsonRequestBehavior.AllowGet)); //----------------------------------------------------------------------------------------------- } catch (Exception e) { return(Json(new { Code = 2, Data = new DataTablesResponse(param.Draw, new object[] { }, 0, 0), Mensaje = e.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult TiposPermisoTableHandler([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest param) { try { //----------------------------------------------------------------------------------------------- var ordenPor = param.Columns.FirstOrDefault(c => c.IsOrdered); var seBusca = !param.Search.Value.IsNullOrWhiteSpace(); var b = seBusca ? param.Search.Value.ToLower() : ""; var ctx = new SOLPEREntities(); //----------------------------------------------------------------------------------------------- var query = ctx.TIPO_PERMISO .Where(c => (!seBusca || c.Descripcion.ToLower().Contains(b))) .Select(c => new { c.Id, c.Descripcion }); //----------------------------------------------------------------------------------------------- var count = query.Count(); //----------------------------------------------------------------------------------------------- var list = query .SelectPage(o => o.ValorProp(ordenPor?.Name ?? nameof(o.Descripcion)), ordenPor?.SortDirection == Column.OrderDirection.Descendant, param.Start, param.Length.IfMenorCero(999)) .ToList(); //----------------------------------------------------------------------------------------------- var data = new DataTablesResponse(param.Draw, list, count, count); return(Json(new { Code = 1, Data = data }, JsonRequestBehavior.AllowGet)); //----------------------------------------------------------------------------------------------- } catch (Exception e) { return(Json(new { Code = 2, Data = new DataTablesResponse(param.Draw, new object[] { }, 0, 0), Mensaje = e.Message }, JsonRequestBehavior.AllowGet)); } }