public ActionResult MapQuery(string sitename, int queryId, string slug) { Revision revision = QueryUtil.GetMigratedRevision(queryId, MigrationType.Saved); if (revision == null) { return(PageNotFound()); } if (slug.HasValue()) { slug = "/" + slug; } return(new RedirectPermanentResult("/" + sitename + "/query/" + revision.QuerySet.Id + slug)); }
public ActionResult MapQuery(string sitename, int queryId, string slug) { var revision = QueryUtil.GetMigratedRevision(queryId, MigrationType.Normal); if (revision == null) { return(PageNotFound()); } if (slug.HasValue()) { slug = "/" + slug; } // find the first queryset with the revision var querySetId = Current.DB.Query <int>(@"select top 1 QuerySetId from QuerySetRevisions where RevisionId = @Id order by Id asc", new { revision.Id }).First(); return(new RedirectPermanentResult("/" + sitename + "/query/" + querySetId + slug)); }