예제 #1
0
        private List <Permission> Get_Permission_By_Id(int id_rol = 1)
        {
            var list = (from permission in connection.SGA_PERMISOS
                        join rolU in connection.SGA_ROLES_PERMISOS
                        on new { x = permission.ID, y = id_rol } equals new { x = rolU.ID_PERMISO, y = rolU.ID_ROL }
                        into UnionValues
                        from rolU in UnionValues.DefaultIfEmpty()
                        select new Permission
            {
                ID = permission.ID,
                Category = permission.CATEGORIA.Value,
                Description = permission.NOMBRE,
                Active = (rolU == null ? false : true)
            });

            return(list.ToList());
        }
예제 #2
0
        public List <Product> Get_Products_By_Mov(string Id_Move = "0")
        {
            BMS_DATA_DENTEntities connection = BDConnection.Get_Connection();
            var model = (from seri in connection.INV_MOVS
                         join prod in connection.INV_PROD
                         on new { x = seri.CIA, y = seri.COD_PROD } equals new { x = prod.CIA, y = prod.COD_PROD }
                         into UnionValues
                         from product in UnionValues.DefaultIfEmpty()
                         where seri.NUM_DOC == Id_Move &&
                         seri.CIA == "003"
                         select new Product {
                id = seri.CONSECUTIVO,
                cod_prod = seri.COD_PROD,
                description = product.NOMBRE_1,
                serial_number = seri.SERIE,
                category = product.NOTAS
            }).ToList();

            return(model);
        }