public IEnumerable <Funcion> GetFunByModuloRol(RolModulo_Model obj) { try { /* * var entities = _db.dbSetFuncion. * Where(e => e.Estado == 1 && e.IdModulo == obj.modulo && !_db.dbSetFuncionesRol * .Select(f => f.IdFuncion) * .Contains(e.FuncionesId) * ); */ var entities = from c in _db.dbSetFuncion where !(from o in _db.dbSetFuncionesRol where o.IdRol == obj.rol select o.IdFuncion).Contains(c.FuncionesId) && c.Estado == 1 && c.IdModulo == obj.modulo select c; int enumeracion = entities.Count(); if (enumeracion == 0) { entities = _db.dbSetFuncion .Where(e => e.Estado == 1 && e.IdModulo == obj.modulo); } return(entities); } catch (Exception e) { throw new Exception(e.Message, e); } }
public IHttpActionResult GetFunByModuloRol([FromBody] RolModulo_Model obj) { try { log.Info(new MDCSet(this.ControllerContext.RouteData)); var campo = _repository.GetFunByModuloRol(obj); return(Ok(campo)); } catch (Exception e) { log.Error(new MDCSet(this.ControllerContext.RouteData), e); return(InternalServerError(e)); } }