public static Record CreateFromDataReader(IRecordsReader reader) { Record record = Create(); record.Id = reader.GetGuid("Id"); record.Form = reader.GetGuid("Form"); record.Created = reader.GetDateTime("Created"); record.Updated = reader.GetDateTime("Updated"); record.State = reader.GetInt("State"); record.currentPage = reader.GetGuid("currentPage"); record.umbracoPageId = reader.GetInt("umbracoPageId"); record.IP = reader.GetString("IP"); record.MemberKey = reader.GetString("MemberKey"); return(record); }
protected void PopulateMediaFromReader(IRecordsReader dr) { bool _hc = false; if (dr.GetInt("children") > 0) { _hc = true; } int?masterContentType = null; if (!dr.IsNull("masterContentType")) { masterContentType = dr.GetInt("masterContentType"); } SetupMediaForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetString("icon") , _hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , masterContentType , dr.GetInt("contentTypeId")); }
public List <object> GetRecordFieldValues(RecordField rf) { string sql = string.Format("SELECT * FROM UFRecordData{0} where [Key] = @key ORDER BY Id ASC", rf.DataTypeAlias); List <object> l = new List <object>(); IRecordsReader rr = sqlHelper.ExecuteReader(sql, sqlHelper.CreateParameter("@key", rf.Key)); while (rr.Read()) { switch (rf.DataType) { case FieldDataType.String: case FieldDataType.LongString: l.Add(rr.GetString("Value")); break; case FieldDataType.Integer: l.Add(rr.GetInt("Value")); break; case FieldDataType.DateTime: l.Add(rr.GetDateTime("Value")); break; case FieldDataType.Bit: l.Add(rr.GetBoolean("Value")); break; } } rr.Dispose(); return(l); }
//public CmsNode GetNodeById(Guid uniqueId) //{ // CmsNode cmsNode; // var id = SqlHelper.ExecuteScalar<int>("SELECT id FROM umbracoNode WHERE uniqueID = @uniqueId", SqlHelper.CreateParameter("@uniqueId", uniqueId)); // using (IRecordsReader dr = SqlHelper.ExecuteReader(m_SQLSingle, // SqlHelper.CreateParameter("@id", id))) // { // if (dr.Read() || dr.IsNull("uniqueID")) // { // cmsNode = new CmsNode // { // UniqueId = dr.GetGuid("uniqueID"), // NodeObjectType = dr.GetGuid("nodeObjectType"), // ContentTypeId = dr.GetInt("contentTypeId"), // Level = dr.GetShort("level"), // Path = dr.GetString("path"), // ParentId = dr.GetInt("parentId"), // Text = dr.GetString("text"), // SortOrder = dr.GetInt("sortOrder"), // UserId = dr.GetInt("nodeUser"), // CreateDate = dr.GetDateTime("createDate"), // IsTrashed = dr.GetBoolean("trashed") // }; // } // else // { // throw new ArgumentException(string.Format("No node exists with id '{0}' ({1})", id, uniqueId)); // } // } // return cmsNode; //} public IEnumerable <T> GetNodesByIds <T>(Guid[] uniqueIds) where T : CmsNode, new() { var cmsNodes = new List <T>(); // TODO: parameterize this the "right" way to prevent future sql injection var strUIds = string.Format("'{0}'", string.Join("','", uniqueIds)); var ids = new List <int>(); using (IRecordsReader reader = SqlHelper.ExecuteReader(string.Format("SELECT id FROM umbracoNode WHERE uniqueID in ({0})", strUIds))) { while (reader.Read()) { ids.Add(reader.GetInt("id")); } } var strIds = string.Join(",", ids); using (IRecordsReader dr = SqlHelper.ExecuteReader(string.Format(m_SQMultiple, strIds))) { while (dr.Read()) { cmsNodes.Add(new T { UniqueId = dr.GetGuid("uniqueID"), NodeObjectType = dr.GetGuid("nodeObjectType"), ContentTypeId = dr.GetInt("contentTypeId"), Level = dr.GetShort("level"), Path = dr.GetString("path"), ParentId = dr.GetInt("parentId"), Text = dr.GetString("text"), SortOrder = dr.GetInt("sortOrder"), UserId = dr.GetInt("nodeUser"), CreateDate = dr.GetDateTime("createDate"), IsTrashed = dr.GetBoolean("trashed") }); } } if (typeof(T) == typeof(DocType)) { // Fill out property data foreach (var node in cmsNodes) { var docType = node as DocType; if (docType != null) { docType.Properties = GetPropertyTypes(node).ToList(); } } } return(cmsNodes); }
private void PopulateTaskFromReader(IRecordsReader dr) { _id = dr.GetInt("id"); Type = new TaskType((int)dr.GetByte("taskTypeId")); Node = new CMSNode(dr.GetInt("nodeId")); ParentUser = User.GetUser(dr.GetInt("parentUserId")); User = User.GetUser(dr.GetInt("userId")); Date = dr.GetDateTime("DateTime"); Comment = dr.GetString("comment"); Closed = dr.GetBoolean("closed"); }
public static List <LogItem> ConvertIRecordsReader(IRecordsReader reader) { var items = new List <LogItem>(); while (reader.Read()) { items.Add(new LogItem( reader.GetInt("userId"), reader.GetInt("nodeId"), reader.GetDateTime("DateStamp"), ConvertLogHeader(reader.GetString("logHeader")), reader.GetString("logComment"))); } return(items); }
public static Form CreateFromDataReader(IRecordsReader reader) { Form form = Create(); form.Id = reader.GetGuid("id"); form.Pages = new List <Page>(); form.Name = reader.GetString("name"); form.Created = reader.GetDateTime("created"); form.MessageOnSubmit = reader.GetString("MessageOnSubmit"); form.GoToPageOnSubmit = reader.GetInt("GotoPageOnSubmit"); form.ShowValidationSummary = reader.GetBoolean("ShowValidationSummary"); form.HideFieldValidation = reader.GetBoolean("HideFieldValidation"); form.RequiredErrorMessage = reader.GetString("RequiredErrorMessage"); form.InvalidErrorMessage = reader.GetString("InvalidErrorMessage"); form.ManualApproval = reader.GetBoolean("ManualApproval"); form.Archived = reader.GetBoolean("Archived"); form.StoreRecordsLocally = reader.GetBoolean("StoreRecordsLocally"); if (!reader.IsNull("DataSource")) { form.DataSource = reader.GetGuid("DataSource"); } if (!reader.IsNull("FieldIndicationType")) { form.FieldIndicationType = (FormFieldIndication)System.Enum.Parse(typeof(FormFieldIndication), reader.GetInt("FieldIndicationType").ToString()); form.Indicator = reader.GetString("Indicator"); } if (!reader.IsNull("DisableDefaultStylesheet")) { form.DisableDefaultStylesheet = reader.GetBoolean("DisableDefaultStylesheet"); } //check for xpath setting //Umbraco.Forms.Migration.Data.Storage.SettingsStorage ss = new Umbraco.Forms.Migration.Data.Storage.SettingsStorage(); //string set = ss.GetSetting(form.Id, "XPathOnSubmit"); //if (!string.IsNullOrEmpty(set)) // form.XPathOnSubmit = set; //ss.Dispose(); return(form); }
public static List <Subscribtion> Subscribers(int topicId) { List <Subscribtion> l = new List <Subscribtion>(); IRecordsReader rr = Data.SqlHelper.ExecuteReader("SELECT * from forumTopicSubscribers where topicid = @topicId", Data.SqlHelper.CreateParameter("@topicId", topicId)); while (rr.Read()) { Subscribtion s = new Subscribtion(); s.MemberId = rr.GetInt("memberId"); s.TopicId = rr.GetInt("topicId"); s.Date = rr.GetDateTime("date"); l.Add(s); } return(l); }
public Relation(int Id) { using (IRecordsReader dr = SqlHelper.ExecuteReader("select * from umbracoRelation where id = @id", SqlHelper.CreateParameter("@id", Id))) { if (dr.Read()) { this._id = dr.GetInt("id"); this._parentNode = new CMSNode(dr.GetInt("parentId")); this._childNode = new CMSNode(dr.GetInt("childId")); this._relType = RelationType.GetById(dr.GetInt("relType")); this._comment = dr.GetString("comment"); this._datetime = dr.GetDateTime("datetime"); } else { throw new ArgumentException("No relation found for id " + Id.ToString()); } } }
protected void PopulateMediaFromReader(IRecordsReader dr) { var hc = dr.GetInt("children") > 0; SetupMediaForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetString("icon") , hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , null , dr.GetInt("contentTypeId") , dr.GetBoolean("isContainer")); }
private void Initialize(int id) { IRecordsReader dr = SqlHelper.ExecuteReader( "select id, uninstalled, upgradeId, installDate, userId, package, versionMajor, versionMinor, versionPatch from umbracoInstalledPackages where id = @id", SqlHelper.CreateParameter("@id", id)); if (dr.Read()) { Id = id; Uninstalled = dr.GetBoolean("uninstalled"); UpgradeId = dr.GetInt("upgradeId"); InstallDate = dr.GetDateTime("installDate"); User = User.GetUser(dr.GetInt("userId")); PackageId = dr.GetGuid("package"); VersionMajor = dr.GetInt("versionMajor"); VersionMinor = dr.GetInt("versionMinor"); VersionPatch = dr.GetInt("versionPatch"); } dr.Close(); }
protected void PopulateCMSNodeFromReader(IRecordsReader dr) { // testing purposes only > original umbraco data hasn't any unique values ;) // And we need to have a newParent in order to create a new node .. // Should automatically add an unique value if no exists (or throw a decent exception) if (dr.IsNull("uniqueID")) { _uniqueID = Guid.NewGuid(); } else { _uniqueID = dr.GetGuid("uniqueID"); } _nodeObjectType = dr.GetGuid("nodeObjectType"); _level = dr.GetShort("level"); _path = dr.GetString("path"); _parentid = dr.GetInt("parentId"); _text = dr.GetString("text"); _sortOrder = dr.GetInt("sortOrder"); _userId = dr.GetInt("nodeUser"); _createDate = dr.GetDateTime("createDate"); _isTrashed = dr.GetBoolean("trashed"); }
/// <summary> /// This function shows all version history for each current node /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gvCurVer_RowDataBound(object sender, GridViewRowEventArgs e) { // Set Text for no versions to show if (e.Row.RowType.Equals(DataControlRowType.EmptyDataRow)) { Label lblNoVersionsToShow = (Label)e.Row.FindControl("lblNoVersionsToShow"); lblNoVersionsToShow.Text = getDictionaryItem("versions_Label_NoLogsToShow") + " '" + dtpckrDateFrom.DateTime.ToShortDateString() + "'"; } if (e.Row.RowType == DataControlRowType.DataRow) { Label lblNodeId = (Label)e.Row.FindControl("lblNodeId"); Literal ltrlHistVer = (Literal)e.Row.FindControl("ltrlHistVer"); using (IRecordsReader dr = SqlHelper.ExecuteReader(GetSQLHistoryVersions(), SqlHelper.CreateParameter("@nodeId", int.Parse(lblNodeId.Text)))) { while (dr.Read()) { ltrlHistVer.Text += dr.GetString("text") + " <small>(Created: " + dr.GetDateTime("updateDate").ToShortDateString() + " " + dr.GetDateTime("updateDate").ToShortTimeString() + ") "; if (dr.GetBoolean("published")) { ltrlHistVer.Text += "(<span style='color: green;'>published</span>)"; } if (dr.GetBoolean("newest")) { ltrlHistVer.Text += "(<span style='color: navy;'>newest</span>)"; } ltrlHistVer.Text += "</small><br />"; } } } }
protected void PopulateDocumentFromReader(IRecordsReader dr) { bool _hc = false; if (dr.GetInt("children") > 0) _hc = true; int? masterContentType = null; if (!dr.IsNull("masterContentType")) masterContentType = dr.GetInt("masterContentType"); SetupDocumentForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetInt("documentUser") , (dr.GetInt("isPublished") == 1) , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetDateTime("updateDate") , dr.GetDateTime("versionDate") , dr.GetString("icon") , _hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , masterContentType , dr.GetInt("contentTypeId") , dr.GetInt("templateId")); }
/// <summary> /// Get Logs /// </summary> /// <param name="ColumnOrder"></param> protected void GetLogs(string ColumnOrder) { sqlReadLog = "SELECT umbracoLog.userId, umbracoUser.userName, umbracoUser.userLogin, umbracoLog.NodeId, umbracoNode.text AS nodeName, umbracoLog.DateStamp, umbracoLog.logHeader, umbracoLog.logComment "; sqlReadLog += "FROM umbracoLog INNER JOIN umbracoUser ON umbracoLog.userId = umbracoUser.id LEFT OUTER JOIN umbracoNode ON umbracoLog.NodeId = umbracoNode.id "; sqlReadLog += "WHERE ("; if ((dtpckrDateFrom.Text.Equals(string.Empty)) && (dtpckrDateTo.Text.Equals(string.Empty))) { dtpckrDateFrom.DateTime = DateTime.Now.Subtract(new TimeSpan(iLastDays, 0, 0, 0)); dtpckrDateTo.DateTime = DateTime.Now.Subtract(new TimeSpan(0, 0, 0, 0)); sqlReadLog += "umbracoLog.DateStamp >= CONVERT(DATETIME, '" + dtpckrDateFrom.DateTime.ToString("yyyy.MM.dd") + " 00:00:00', 102) AND umbracoLog.DateStamp <= CONVERT(DATETIME, '" + dtpckrDateTo.DateTime.ToString("yyyy.MM.dd") + " 23:59:00', 102) "; } else if ((dtpckrDateFrom.Text.Equals(string.Empty)) && (!dtpckrDateTo.Text.Equals(string.Empty))) { sqlReadLog += "umbracoLog.DateStamp <= CONVERT(DATETIME, '" + dtpckrDateTo.DateTime.ToString("yyyy.MM.dd") + " 23:59:00', 102) "; } else if ((!dtpckrDateFrom.Text.Equals(string.Empty)) && (dtpckrDateTo.Text.Equals(string.Empty))) { sqlReadLog += "umbracoLog.DateStamp >= CONVERT(DATETIME, '" + dtpckrDateFrom.DateTime.ToString("yyyy.MM.dd") + " 00:00:00', 102) "; } else if (dtpckrDateFrom.DateTime <= dtpckrDateTo.DateTime) { sqlReadLog += "umbracoLog.DateStamp >= CONVERT(DATETIME, '" + dtpckrDateFrom.DateTime.ToString("yyyy.MM.dd") + " 00:00:00', 102) AND umbracoLog.DateStamp <= CONVERT(DATETIME, '" + dtpckrDateTo.DateTime.ToString("yyyy.MM.dd") + " 23:59:00', 102) "; } else { string strDateFrom = dtpckrDateFrom.Text; string strDateTo = dtpckrDateTo.Text; dtpckrDateFrom.DateTime = DateTime.Parse(strDateTo); dtpckrDateTo.DateTime = DateTime.Parse(strDateFrom); sqlReadLog += "umbracoLog.DateStamp >= CONVERT(DATETIME, '" + dtpckrDateFrom.DateTime.ToString("yyyy.MM.dd") + " 00:00:00', 102) AND umbracoLog.DateStamp <= CONVERT(DATETIME, '" + dtpckrDateTo.DateTime.ToString("yyyy.MM.dd") + " 23:59:00', 102) "; ltrlLogInfo.Text = getDictionaryItem("logs_StartDateGreaterThanEndDate"); ltrlLogInfo.Visible = true; } if (!txtbNodeID.Text.Equals(string.Empty)) { sqlReadLog += "AND umbracoLog.NodeId = " + int.Parse(txtbNodeID.Text) + " "; } if (ddlLogTypes.SelectedValue.ToString() != "any") { sqlReadLog += "AND logHeader LIKE '" + ddlLogTypes.SelectedValue.ToString() + "' "; } if (ddlUsers.SelectedValue.ToString() != "any") { sqlReadLog += "AND UserId = " + ddlUsers.SelectedValue; } sqlReadLog += ") ORDER BY umbracoLog.DateStamp DESC"; //Set up Cache Object and determine if it exists dgCache = (DataView)Cache.Get("dgCache"); //Assign ColumnOrder to ViewState ViewState["SortOrder"] = ColumnOrder; if (dgCache == null) { //Create DataTable DataTable DataReaderTable = new DataTable(); DataColumn dc1 = new DataColumn("UserName", typeof(string)); DataColumn dc2 = new DataColumn("NodeId", typeof(int)); DataColumn dc3 = new DataColumn("NodeName", typeof(string)); DataColumn dc4 = new DataColumn("DateStamp", typeof(DateTime)); DataColumn dc5 = new DataColumn("logHeader", typeof(string)); DataColumn dc6 = new DataColumn("logComment", typeof(string)); DataReaderTable.Columns.Add(dc1); DataReaderTable.Columns.Add(dc2); DataReaderTable.Columns.Add(dc3); DataReaderTable.Columns.Add(dc4); DataReaderTable.Columns.Add(dc5); DataReaderTable.Columns.Add(dc6); //Loop through DataReader IRecordsReader irLogs = SqlHelper.ExecuteReader(sqlReadLog); while (irLogs.Read()) { //Set up DataRow object DataRow dr = DataReaderTable.NewRow(); dr[0] = irLogs.GetString("userName"); dr[1] = irLogs.GetInt("NodeId"); dr[2] = irLogs.GetString("NodeName"); dr[3] = irLogs.GetDateTime("DateStamp"); dr[4] = irLogs.GetString("logHeader"); dr[5] = irLogs.GetString("logComment"); //Add rows to existing DataTable DataReaderTable.Rows.Add(dr); } //Create DataView to support our column sorting DataView Source = DataReaderTable.DefaultView; //Assign column sort order for DataView Source.Sort = ColumnOrder; //Insert DataTable into Cache object Cache.Insert("dgCache", Source); //Bind DataGrid from DataView gvLogTypesList.DataSource = Source; } else { //Assign Cached DataView new sort order dgCache.Sort = ViewState["SortOrder"].ToString(); //Bind DataGrid from Cached DataView gvLogTypesList.DataSource = dgCache; } gvLogTypesList.Style.Add("width", "100%"); gvLogTypesList.DataBind(); }
public static List<LogItem> ConvertIRecordsReader(IRecordsReader reader) { var items = new List<LogItem>(); while (reader.Read()) { items.Add(new LogItem( reader.GetInt("userId"), reader.GetInt("nodeId"), reader.GetDateTime("DateStamp"), ConvertLogHeader(reader.GetString("logHeader")), reader.GetString("logComment"))); } return items; }
protected void PopulateMemberFromReader(IRecordsReader dr) { SetupNodeForTree(dr.GetGuid("uniqueId"), _objectType, dr.GetShort("level"), dr.GetInt("parentId"), dr.GetInt("nodeUser"), dr.GetString("path"), dr.GetString("text"), dr.GetDateTime("createDate"), false); if (!dr.IsNull("Email")) m_Email = dr.GetString("Email"); m_LoginName = dr.GetString("LoginName"); m_Password = dr.GetString("Password"); }
public static List <UrlTrackerModel> GetUrlTrackerEntries(int?maximumRows, int?startRowIndex, string sortExpression = "", bool _404 = false, bool include410Gone = false, bool showAutoEntries = true, bool showCustomEntries = true, bool showRegexEntries = true, string keyword = "", bool onlyForcedRedirects = false) { List <UrlTrackerModel> urlTrackerEntries = new List <UrlTrackerModel>(); int intKeyword = 0; string query = "SELECT * FROM icUrlTracker WHERE Is404 = @is404 AND RedirectHttpCode != @redirectHttpCode"; if (onlyForcedRedirects) { query = string.Concat(query, " AND ForceRedirect = 1"); } if (!string.IsNullOrEmpty(keyword)) { query = string.Concat(query, " AND (OldUrl LIKE @keyword OR OldUrlQueryString LIKE @keyword OR OldRegex LIKE @keyword OR RedirectUrl LIKE @keyword OR Notes LIKE @keyword"); if (int.TryParse(keyword, out intKeyword)) { query = string.Concat(query, " OR RedirectNodeId = @intKeyword"); } query = string.Concat(query, ")"); } List <IParameter> parameters = new List <IParameter> { _sqlHelper.CreateParameter("is404", _404 ? 1 : 0), _sqlHelper.CreateParameter("redirectHttpCode", include410Gone ? 0 : 410) }; if (!string.IsNullOrEmpty(keyword)) { parameters.Add(_sqlHelper.CreateParameter("keyword", "%" + keyword + "%")); } if (intKeyword != 0) { parameters.Add(_sqlHelper.CreateParameter("intKeyword", intKeyword)); } using (IRecordsReader reader = _sqlHelper.ExecuteReader(query, parameters.ToArray())) { while (reader.Read()) { urlTrackerEntries.Add(new UrlTrackerModel(reader.GetInt("Id"), reader.GetString("OldUrl"), reader.GetString("OldUrlQueryString"), reader.GetString("OldRegex"), reader.GetInt("RedirectRootNodeId"), reader.Get <int?>("RedirectNodeId"), reader.GetString("RedirectUrl"), reader.GetInt("RedirectHttpCode"), reader.GetBoolean("RedirectPassThroughQueryString"), reader.GetBoolean("ForceRedirect"), reader.GetString("Notes"), reader.GetBoolean("Is404"), reader.GetString("Referrer"), reader.GetDateTime("Inserted"))); } } urlTrackerEntries = urlTrackerEntries.Where(x => x.RedirectNodeIsPublished).ToList(); if (!showAutoEntries || !showCustomEntries || !showRegexEntries || !string.IsNullOrEmpty(keyword)) { IEnumerable <UrlTrackerModel> filteredUrlTrackerEntries = urlTrackerEntries; if (!showAutoEntries) { filteredUrlTrackerEntries = filteredUrlTrackerEntries.Where(x => x.ViewType != UrlTrackerViewTypes.Auto); } if (!showCustomEntries) { filteredUrlTrackerEntries = filteredUrlTrackerEntries.Where(x => x.ViewType != UrlTrackerViewTypes.Custom || (showRegexEntries ? string.IsNullOrEmpty(x.OldUrl) : false)); } if (!showRegexEntries) { filteredUrlTrackerEntries = filteredUrlTrackerEntries.Where(x => !string.IsNullOrEmpty(x.OldUrl)); } //if (!string.IsNullOrEmpty(keyword)) //{ // filteredUrlTrackerEntries = filteredUrlTrackerEntries.Where(x => // (x.CalculatedOldUrl != null && x.CalculatedOldUrl.ToLower().Contains(keyword)) || // (x.CalculatedRedirectUrl != null && x.CalculatedRedirectUrl.ToLower().Contains(keyword)) || // (x.OldRegex != null && x.OldRegex.ToLower().Contains(keyword)) || // (x.Notes != null && x.Notes.ToLower().Contains(keyword)) // ); //} urlTrackerEntries = filteredUrlTrackerEntries.ToList(); } if (!string.IsNullOrEmpty(sortExpression)) { string sortBy = sortExpression; bool isDescending = false; if (sortExpression.ToLowerInvariant().EndsWith(" desc")) { sortBy = sortExpression.Substring(0, sortExpression.Length - " desc".Length); isDescending = true; } switch (sortBy) { case "RedirectRootNodeName": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.RedirectRootNodeName) : urlTrackerEntries.OrderBy(x => x.RedirectRootNodeName)).ToList(); break; case "CalculatedOldUrl": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.CalculatedOldUrl) : urlTrackerEntries.OrderBy(x => x.CalculatedOldUrl)).ToList(); break; case "CalculatedRedirectUrl": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.CalculatedRedirectUrl) : urlTrackerEntries.OrderBy(x => x.CalculatedRedirectUrl)).ToList(); break; case "RedirectHttpCode": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.RedirectHttpCode) : urlTrackerEntries.OrderBy(x => x.RedirectHttpCode)).ToList(); break; case "Referrer": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.Referrer) : urlTrackerEntries.OrderBy(x => x.Referrer)).ToList(); break; case "NotFoundCount": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.NotFoundCount) : urlTrackerEntries.OrderBy(x => x.NotFoundCount)).ToList(); break; case "Notes": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.Notes) : urlTrackerEntries.OrderBy(x => x.Notes)).ToList(); break; case "Inserted": urlTrackerEntries = (isDescending ? urlTrackerEntries.OrderByDescending(x => x.Inserted) : urlTrackerEntries.OrderBy(x => x.Inserted)).ToList(); break; } } if (startRowIndex.HasValue) { urlTrackerEntries = urlTrackerEntries.Skip(startRowIndex.Value).ToList(); } if (maximumRows.HasValue) { urlTrackerEntries = urlTrackerEntries.Take(maximumRows.Value).ToList(); } return(urlTrackerEntries); }
public static UrlTrackerModel GetUrlTrackerEntryById(int id) { string query = "SELECT * FROM icUrlTracker WHERE Id = @id"; using (IRecordsReader reader = _sqlHelper.ExecuteReader(query, _sqlHelper.CreateParameter("id", id))) { if (reader.Read()) { return(new UrlTrackerModel(reader.GetInt("Id"), reader.GetString("OldUrl"), reader.GetString("OldUrlQueryString"), reader.GetString("OldRegex"), reader.GetInt("RedirectRootNodeId"), reader.Get <int?>("RedirectNodeId"), reader.GetString("RedirectUrl"), reader.GetInt("RedirectHttpCode"), reader.GetBoolean("RedirectPassThroughQueryString"), reader.GetBoolean("ForceRedirect"), reader.GetString("Notes"), reader.GetBoolean("Is404"), reader.GetString("Referrer"), reader.GetDateTime("Inserted"))); } } return(null); }
protected void PopulateDocumentFromReader(IRecordsReader dr) { var hc = dr.GetInt("children") > 0; SetupDocumentForTree(dr.GetGuid("uniqueId") , dr.GetShort("level") , dr.GetInt("parentId") , dr.GetInt("nodeUser") , dr.GetInt("documentUser") , !dr.GetBoolean("trashed") && (dr.GetInt("isPublished") == 1) //set published... double check trashed property , dr.GetString("path") , dr.GetString("text") , dr.GetDateTime("createDate") , dr.GetDateTime("updateDate") , dr.GetDateTime("versionDate") , dr.GetString("icon") , hc , dr.GetString("alias") , dr.GetString("thumbnail") , dr.GetString("description") , null , dr.GetInt("contentTypeId") , dr.GetInt("templateId") , dr.GetBoolean("isContainer")); if (!dr.IsNull("releaseDate")) _release = dr.GetDateTime("releaseDate"); if (!dr.IsNull("expireDate")) _expire = dr.GetDateTime("expireDate"); }
public static int MigrateData() { if (!GetUrlTrackerTableExists()) { throw new Exception("Url Tracker table not found."); } if (!GetUrlTrackeOldTableExists()) { throw new Exception("Old Url Tracker table not found."); } int newUrlTrackerEntriesCount = 0; List <OldUrlTrackerModel> oldUrlTrackerEntries = new List <OldUrlTrackerModel>(); string query = string.Format("SELECT * FROM {0}", UrlTrackerSettings.OldTableName); IRecordsReader recordsReader = _sqlHelper.ExecuteReader(query); while (recordsReader.Read()) { oldUrlTrackerEntries.Add(new OldUrlTrackerModel() { NodeId = recordsReader.GetInt("NodeID"), OldUrl = recordsReader.GetString("OldUrl"), IsCustom = recordsReader.GetBoolean("IsCustom"), Message = recordsReader.GetString("Message"), Inserted = recordsReader.GetDateTime("Inserted"), IsRegex = recordsReader.GetBoolean("IsRegex") }); } foreach (OldUrlTrackerModel oldUrlTrackerEntry in oldUrlTrackerEntries) { Node node = new Node(oldUrlTrackerEntry.NodeId); if ((node.Id > 0 || true) && !string.IsNullOrEmpty(oldUrlTrackerEntry.OldUrl) && oldUrlTrackerEntry.OldUrl != "#") { string oldUrl = oldUrlTrackerEntry.OldUrl; Uri oldUri = null; if (!oldUrlTrackerEntry.IsRegex) { if (!oldUrl.StartsWith(Uri.UriSchemeHttp)) { oldUri = new Uri(_baseUri, oldUrl); } else { oldUri = new Uri(oldUrl); } oldUrl = UrlTrackerHelper.ResolveShortestUrl(oldUri.AbsolutePath); } else { if (oldUrl.StartsWith("^/")) { oldUrl = string.Concat("^", oldUrl.Substring(2)); } if (oldUrl.StartsWith("/")) { oldUrl = oldUrl.Substring(1); } if (oldUrl.EndsWith("/$")) { oldUrl = string.Concat(oldUrl.Substring(0, oldUrl.Length - 2), "$"); } if (oldUrl.EndsWith("/")) { oldUrl = oldUrl.Substring(0, oldUrl.Length - 1); } } UrlTrackerModel newUrlTrackerEntry = new UrlTrackerModel( !oldUrlTrackerEntry.IsRegex ? oldUrl : string.Empty, oldUri != null ? !string.IsNullOrEmpty(oldUri.Query) && oldUri.Query.StartsWith("?") ? oldUri.Query.Substring(1) : oldUri.Query : string.Empty, oldUrlTrackerEntry.IsRegex ? oldUrl : string.Empty, node.GetDomainRootNode().Id, oldUrlTrackerEntry.NodeId, string.Empty, 301, true, false, oldUrlTrackerEntry.Message); newUrlTrackerEntry.Inserted = oldUrlTrackerEntry.Inserted; AddUrlTrackerEntry(newUrlTrackerEntry); newUrlTrackerEntriesCount++; } } return(newUrlTrackerEntriesCount); }
private static XPathNodeIterator CommentsToXml(IRecordsReader rr) { XmlDocument xd = new XmlDocument(); XmlNode x = umbraco.xmlHelper.addTextNode(xd, "comments", ""); while (rr.Read()) { XmlNode c = xd.CreateElement("comment"); c.Attributes.Append(umbraco.xmlHelper.addAttribute(xd, "id", rr.GetInt("id").ToString())); c.Attributes.Append(umbraco.xmlHelper.addAttribute(xd, "nodeid", rr.GetInt("nodeid").ToString())); c.Attributes.Append(umbraco.xmlHelper.addAttribute(xd, "created", rr.GetDateTime("created").ToString())); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "name", rr.GetString("name"))); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "email", rr.GetString("email"))); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "website", rr.GetString("website"))); c.AppendChild(umbraco.xmlHelper.addCDataNode(xd, "message", rr.GetString("comment"))); x.AppendChild(c); } xd.AppendChild(x); rr.Close(); return xd.CreateNavigator().Select("."); }