/// <summary> /// Used for rolling back documents to a previous version /// </summary> /// <returns> Previous published versions of the document</returns> public DocumentVersionList[] GetVersions() { ArrayList versions = new ArrayList(); using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select documentUser, versionId, updateDate, text from cmsDocument where nodeId = @nodeId order by updateDate", new SqlParameter("@nodeId", Id))) { while (dr.Read()) { DocumentVersionList dv = new DocumentVersionList(new Guid(dr["versionId"].ToString()), DateTime.Parse(dr["updateDate"].ToString()), dr["text"].ToString(), Umbraco.BusinessLogic.User.GetUser(int.Parse(dr["documentUser"].ToString()))); versions.Add(dv); } } DocumentVersionList[] retVal = new DocumentVersionList[versions.Count]; int i = 0; foreach (DocumentVersionList dv in versions) { retVal[i] = dv; i++; } return(retVal); }
/// <summary> /// Used for rolling back documents to a previous version /// </summary> /// <returns> Previous published versions of the document</returns> public DocumentVersionList[] GetVersions() { ArrayList versions = new ArrayList(); using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select documentUser, versionId, updateDate, text from cmsDocument where nodeId = @nodeId order by updateDate", new SqlParameter("@nodeId", Id))) { while (dr.Read()) { DocumentVersionList dv = new DocumentVersionList(new Guid(dr["versionId"].ToString()), DateTime.Parse(dr["updateDate"].ToString()), dr["text"].ToString(), Umbraco.BusinessLogic.User.GetUser(int.Parse(dr["documentUser"].ToString()))); versions.Add(dv); } } DocumentVersionList[] retVal = new DocumentVersionList[versions.Count]; int i = 0; foreach (DocumentVersionList dv in versions) { retVal[i] = dv; i++; } return retVal; }