// Menu clipContextMenu = new Menu(); /// <summary> /// Ensures that the catalogs are loaded. /// </summary> private void EnsureCatalogs() { if (catalogs == null) { DbContentCatalogManager m = new DbContentCatalogManager(); catalogs = m.GetCollection(string.Empty, string.Empty, null); catalogs.Sort(ContentCompareKey.MenuOrder); } }
/// <summary> /// Duplicates DbContentCatalog object into a database; may or may not be the same database /// as the parent object. /// </summary> /// <returns> A new DbContentCatalog object reflecting the replicated DbContentCatalog object.</returns> public DbContentCatalog Duplicate() { DbContentCatalog clonedDbContentCatalog = this.Clone(); // Insert must be called after children are replicated! clonedDbContentCatalog.iD = DbContentCatalogManager._insert(clonedDbContentCatalog); clonedDbContentCatalog.isSynced = true; return(clonedDbContentCatalog); }
/// <summary> /// Ensures that the object's fields and children are /// pre-loaded before any updates or reads. /// </summary> public void EnsurePreLoad() { if (!isPlaceHolder) { return; } DbContentCatalogManager._fill(this); isPlaceHolder = false; }
private void bind() { #region Bind General Child Data DbContentCatalogManager parentCatalogManager = new DbContentCatalogManager(); DbContentCatalogCollection parentCatalogCollection = parentCatalogManager.GetCollection(string.Empty, string.Empty, null); foreach (DbContentCatalog parentCatalog in parentCatalogCollection) { ListItem i = new ListItem(parentCatalog.ToString(), parentCatalog.ID.ToString()); msParentCatalog.Items.Add(i); } DbContentRatingManager ratingManager = new DbContentRatingManager(); DbContentRatingCollection ratingCollection = ratingManager.GetCollection(string.Empty, string.Empty, null); foreach (DbContentRating rating in ratingCollection) { ComboBoxItem i = new ComboBoxItem(); i.Text = rating.Name; i.Value = rating.ID.ToString(); ratingComboBox.Items.Add(i); } DbContentStatusManager statusManager = new DbContentStatusManager(); DbContentStatusCollection statusCollection = statusManager.GetCollection(string.Empty, string.Empty); foreach (DbContentStatus status in statusCollection) { ListItem i = new ListItem(status.ToString(), status.ID.ToString()); msStatus.Items.Add(i); } DbContentClipManager clipManager = new DbContentClipManager(); DbContentClipCollection clips = clipManager.GetCollection(string.Empty, "Title", null); foreach (DbContentClip clip in clips) { referenceComboBox.Items.Add( new ComboBoxItem( Regex.Replace(clip.Title, "<[^>]*>", ""))); } #endregion }
/// <summary> /// Saves the DbContentCatalog object state to the database. /// </summary> public int Save() { if (isSynced) { return(iD); } if (iD == -1) { throw (new Exception("Invalid record; cannot be saved.")); } if (iD == 0) { iD = DbContentCatalogManager._insert(this); } else { DbContentCatalogManager._update(this); } isSynced = iD != -1; return(iD); }
/// <summary> /// Render this control to the output parameter specified. /// </summary> /// <param name="output"> The HTML writer to write out to </param> protected override void RenderContent(HtmlTextWriter output) { DbContentCatalogManager m = new DbContentCatalogManager(); DbContentCatalogCollection dbContentCatalogCollection = m.GetCollection(string.Empty, string.Empty, null); // Render Header Row this.headerLockEnabled = true; RenderRow(this.HeaderRowCssClass, ); bool rowflag = false; string rowCssClass; // // Render Records // foreach (DbContentCatalog dbContentCatalog in dbContentCatalogCollection) { if (rowflag) { rowCssClass = defaultRowCssClass; } else { rowCssClass = alternateRowCssClass; } rowflag = !rowflag; output.WriteBeginTag("tr"); output.WriteAttribute("i", dbContentCatalog.ID.ToString()); output.WriteLine(HtmlTextWriter.TagRightChar); output.Indent++; output.Indent--; output.WriteEndTag("tr"); output.WriteLine(); } }
/// <summary> /// Overwrites and existing DbContentCatalog object in the database. /// </summary> public void Overwrite(int id) { iD = id; DbContentCatalogManager._update(this); isSynced = true; }
public void Delete() { DbContentCatalogManager._delete(this.iD); }
public DbContentCatalog(int id) { this.iD = id; isSynced = DbContentCatalogManager._fill(this); }
protected override void itemCommand(object sender, ToolBarItemEventArgs e) { base.itemCommand(sender, e); switch (e.Item.Value) { case "Up": if (IsCatalogSelected) { DbContentCatalogManager.PeerMove(new DbContentCatalog(this.SelectedID), -1, true, false); } else { DbContentClipManager.PeerMove(new DbContentClip(this.SelectedClipID), -1, true, false); } break; case "Down": if (IsCatalogSelected) { DbContentCatalogManager.PeerMove(new DbContentCatalog(this.SelectedID), -1, true, false); } else { DbContentClipManager.PeerMove(new DbContentClip(this.SelectedClipID), 1, true, false); } break; case "Copy": if (isCatalogSelected) { copyCatalogID = selectedID; copyClipID = -1; } else { copyCatalogID = -1; copyClipID = selectedClipID; } break; case "Paste": if (copyCatalogID != -1) { DbContentCatalog srcCatalog; DbContentCatalog destCatalog; srcCatalog = new DbContentCatalog(copyCatalogID); if (isCatalogSelected) { destCatalog = DbContentCatalog.NewPlaceHolder(selectedID); } else { destCatalog = new DbContentClip(selectedClipID).ParentCatalog; } pasteCatalog(srcCatalog, destCatalog, false, false); } else if (copyClipID != -1) { DbContentClip copyClip = new DbContentClip(selectedClipID); DbContentClip newClip = new DbContentClip(); newClip.ArchiveDate = copyClip.ArchiveDate; newClip.Authors = copyClip.Authors; newClip.Body = copyClip.Body; newClip.CommentsEnabled = copyClip.CommentsEnabled; newClip.CreateDate = DateTime.Now; newClip.Description = copyClip.Description; newClip.Editors = copyClip.Editors; newClip.ExpirationDate = copyClip.ExpirationDate; newClip.Icon = copyClip.Icon; newClip.Keywords = copyClip.Keywords; newClip.MenuBreak = copyClip.MenuBreak; newClip.MenuEnabled = copyClip.MenuEnabled; newClip.MenuLabel = copyClip.MenuLabel; newClip.MenuLeftIcon = copyClip.MenuLeftIcon; newClip.MenuLeftIconOver = copyClip.MenuLeftIconOver; newClip.MenuRightIcon = copyClip.MenuRightIcon; newClip.MenuRightIconOver = copyClip.MenuRightIconOver; newClip.MenuTooltip = copyClip.MenuTooltip; newClip.ModifyDate = DateTime.Now; newClip.NotifyOnComments = copyClip.NotifyOnComments; newClip.OverrideUrl = copyClip.OverrideUrl; if (isCatalogSelected) { newClip.ParentCatalog = DbContentCatalog.NewPlaceHolder(selectedID); } else { newClip.ParentCatalog = new DbContentClip(selectedClipID).ParentCatalog; } newClip.Priority = copyClip.Priority; newClip.PublishDate = copyClip.PublishDate; newClip.Rating = copyClip.Rating; newClip.References = copyClip.References; newClip.SortOrder = copyClip.SortOrder; newClip.Status = copyClip.Status; newClip.Title = copyClip.Title; newClip.WorkingDraft = copyClip.WorkingDraft; newClip.Save(); } break; case "rPaste": if (copyCatalogID != -1) { DbContentCatalog srcCatalog; DbContentCatalog destCatalog; srcCatalog = new DbContentCatalog(copyCatalogID); if (isCatalogSelected) { destCatalog = DbContentCatalog.NewPlaceHolder(selectedID); } else { destCatalog = new DbContentClip(selectedClipID).ParentCatalog; } pasteCatalog(srcCatalog, destCatalog, true, true); } break; } }
public DbContentHitCollection GetCollection(int topCount, string whereClause, string sortClause, params DbContentHitFlags[] optionFlags) { StringBuilder query; Database database; DbCommand dbCommand; IDataReader r; DbContentHitCollection dbContentHitCollection; int innerJoinOffset; query = new StringBuilder("SELECT "); if (topCount > 0) { query.Append("TOP "); query.Append(topCount); query.Append(" "); } foreach (string columnName in InnerJoinFields) { query.Append("DbContentHit."); query.Append(columnName); query.Append(","); } innerJoinOffset = InnerJoinFields.GetUpperBound(0) + 1; int userOffset = -1; int userContactOffset = -1; int requestContentOffset = -1; int requestContentStatusOffset = -1; int requestContentParentCatalogOffset = -1; int requestContentRatingOffset = -1; int requestContentWorkingDraftOffset = -1; // // Append Option Flag Fields // if (optionFlags != null) { for (int x = 0; x < optionFlags.Length; x++) { switch (optionFlags[x]) { case DbContentHitFlags.User: for (int i = 0; i <= GreyFoxUserManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("User."); query.Append(GreyFoxUserManager.InnerJoinFields[i]); query.Append(","); } userOffset = innerJoinOffset; innerJoinOffset = userOffset + GreyFoxUserManager.InnerJoinFields.GetUpperBound(0) + 1; break; case DbContentHitFlags.UserContact: for (int i = 0; i <= GreyFoxContactManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("User_Contact."); query.Append(GreyFoxContactManager.InnerJoinFields[i]); query.Append(","); } userContactOffset = innerJoinOffset; innerJoinOffset = userContactOffset + GreyFoxContactManager.InnerJoinFields.GetUpperBound(0) + 1; break; case DbContentHitFlags.RequestContent: for (int i = 0; i <= DbContentClipManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("RequestContent."); query.Append(DbContentClipManager.InnerJoinFields[i]); query.Append(","); } requestContentOffset = innerJoinOffset; innerJoinOffset = requestContentOffset + DbContentClipManager.InnerJoinFields.GetUpperBound(0) + 1; break; case DbContentHitFlags.RequestContentStatus: for (int i = 0; i <= DbContentStatusManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("RequestContent_Status."); query.Append(DbContentStatusManager.InnerJoinFields[i]); query.Append(","); } requestContentStatusOffset = innerJoinOffset; innerJoinOffset = requestContentStatusOffset + DbContentStatusManager.InnerJoinFields.GetUpperBound(0) + 1; break; case DbContentHitFlags.RequestContentParentCatalog: for (int i = 0; i <= DbContentCatalogManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("RequestContent_ParentCatalog."); query.Append(DbContentCatalogManager.InnerJoinFields[i]); query.Append(","); } requestContentParentCatalogOffset = innerJoinOffset; innerJoinOffset = requestContentParentCatalogOffset + DbContentCatalogManager.InnerJoinFields.GetUpperBound(0) + 1; break; case DbContentHitFlags.RequestContentRating: for (int i = 0; i <= DbContentRatingManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("RequestContent_Rating."); query.Append(DbContentRatingManager.InnerJoinFields[i]); query.Append(","); } requestContentRatingOffset = innerJoinOffset; innerJoinOffset = requestContentRatingOffset + DbContentRatingManager.InnerJoinFields.GetUpperBound(0) + 1; break; case DbContentHitFlags.RequestContentWorkingDraft: for (int i = 0; i <= DbContentClipManager.InnerJoinFields.GetUpperBound(0); i++) { query.Append("RequestContent_WorkingDraft."); query.Append(DbContentClipManager.InnerJoinFields[i]); query.Append(","); } requestContentWorkingDraftOffset = innerJoinOffset; innerJoinOffset = requestContentWorkingDraftOffset + DbContentClipManager.InnerJoinFields.GetUpperBound(0) + 1; break; } } } // // Remove trailing comma // query.Length--; if (optionFlags != null) { query.Append(" FROM "); // // Start INNER JOIN expressions // for (int x = 0; x < optionFlags.Length; x++) { query.Append("("); } query.Append("kitCms_Hits AS DbContentHit"); } else { query.Append(" FROM kitCms_Hits AS DbContentHit"); } // // Finish INNER JOIN expressions // if (optionFlags != null) { for (int x = 0; x < optionFlags.Length; x++) { switch (optionFlags[x]) { case DbContentHitFlags.User: query.Append(" LEFT JOIN sysGlobal_Users AS User ON DbContentHit.UserID = User.GreyFoxUserID)"); break; case DbContentHitFlags.UserContact: query.Append(" LEFT JOIN sysGlobal_Contacts AS User_Contact ON User.ContactID = User_Contact.GreyFoxContactID)"); break; case DbContentHitFlags.RequestContent: query.Append(" LEFT JOIN kitCms_Clips AS RequestContent ON DbContentHit.RequestContentID = RequestContent.DbContentClipID)"); break; case DbContentHitFlags.RequestContentStatus: query.Append(" LEFT JOIN kitCms_Statuses AS RequestContent_Status ON RequestContent.StatusID = RequestContent_Status.DbContentStatusID)"); break; case DbContentHitFlags.RequestContentParentCatalog: query.Append(" LEFT JOIN kitCms_Catalogs AS RequestContent_ParentCatalog ON RequestContent.ParentCatalogID = RequestContent_ParentCatalog.DbContentCatalogID)"); break; case DbContentHitFlags.RequestContentRating: query.Append(" LEFT JOIN kitCms_Ratings AS RequestContent_Rating ON RequestContent.RatingID = RequestContent_Rating.DbContentRatingID)"); break; case DbContentHitFlags.RequestContentWorkingDraft: query.Append(" LEFT JOIN kitCms_Clips AS RequestContent_WorkingDraft ON RequestContent.WorkingDraftID = RequestContent_WorkingDraft.DbContentClipID)"); break; } } } // // Render where clause // if (whereClause != string.Empty) { query.Append(" WHERE "); query.Append(whereClause); } // // Render sort clause // if (sortClause != string.Empty) { query.Append(" ORDER BY "); query.Append(sortClause); } // // Render final semicolon // query.Append(";"); database = DatabaseFactory.CreateDatabase(); dbCommand = database.GetSqlStringCommand(query.ToString()); #if DEBUG try { r = database.ExecuteReader(dbCommand); } catch (Exception e) { string msg = e.Message; throw(new Exception(msg + " --- Query: " + query.ToString())); } #else r = database.ExecuteReader(dbCommand); #endif dbContentHitCollection = new DbContentHitCollection(); while (r.Read()) { DbContentHit dbContentHit = ParseFromReader(r, 0, 1); // Fill User if (userOffset != -1 && !r.IsDBNull(userOffset)) { GreyFoxUserManager.FillFromReader(dbContentHit.user, r, userOffset, userOffset + 1); // Fill if (userContactOffset != -1 && !r.IsDBNull(userContactOffset)) { GreyFoxContactManager.FillFromReader(dbContentHit.user.Contact, "sysGlobal_Contacts", r, userContactOffset, userContactOffset + 1); } } // Fill RequestContent if (requestContentOffset != -1 && !r.IsDBNull(requestContentOffset)) { DbContentClipManager.FillFromReader(dbContentHit.requestContent, r, requestContentOffset, requestContentOffset + 1); // Fill if (requestContentStatusOffset != -1 && !r.IsDBNull(requestContentStatusOffset)) { DbContentStatusManager.FillFromReader(dbContentHit.requestContent.Status, r, requestContentStatusOffset, requestContentStatusOffset + 1); } // Fill Parent Catalog if (requestContentParentCatalogOffset != -1 && !r.IsDBNull(requestContentParentCatalogOffset)) { DbContentCatalogManager.FillFromReader(dbContentHit.requestContent.ParentCatalog, r, requestContentParentCatalogOffset, requestContentParentCatalogOffset + 1); } // Fill if (requestContentRatingOffset != -1 && !r.IsDBNull(requestContentRatingOffset)) { DbContentRatingManager.FillFromReader(dbContentHit.requestContent.Rating, r, requestContentRatingOffset, requestContentRatingOffset + 1); } // Fill if (requestContentWorkingDraftOffset != -1 && !r.IsDBNull(requestContentWorkingDraftOffset)) { DbContentClipManager.FillFromReader(dbContentHit.requestContent.WorkingDraft, r, requestContentWorkingDraftOffset, requestContentWorkingDraftOffset + 1); } } dbContentHitCollection.Add(dbContentHit); } return(dbContentHitCollection); }
private void bindDropDownLists() { #region Bind General Child Data msStatus.Items.Add(new ListItem("Null", "Null")); DbContentStatusManager statusManager = new DbContentStatusManager(); DbContentStatusCollection statusCollection = statusManager.GetCollection(string.Empty, string.Empty); foreach (DbContentStatus status in statusCollection) { ListItem i = new ListItem(status.ToString(), status.ID.ToString()); msStatus.Items.Add(i); } #endregion #region Bind Publishing Child Data msParentCatalog.Items.Add(new ListItem("Null", "Null")); DbContentCatalogManager parentCatalogManager = new DbContentCatalogManager(); DbContentCatalogCollection parentCatalogCollection = parentCatalogManager.GetCollection(string.Empty, string.Empty, null); foreach (DbContentCatalog parentCatalog in parentCatalogCollection) { ListItem i = new ListItem(parentCatalog.ToString(), parentCatalog.ID.ToString()); msParentCatalog.Items.Add(i); } msRating.Items.Add(new ListItem("Null", "Null")); DbContentRatingManager ratingManager = new DbContentRatingManager(); DbContentRatingCollection ratingCollection = ratingManager.GetCollection(string.Empty, string.Empty, null); foreach (DbContentRating rating in ratingCollection) { ListItem i = new ListItem(rating.ToString(), rating.ID.ToString()); msRating.Items.Add(i); } msReferences.Items.Add(new ListItem("Null", "Null")); DbContentClipManager referencesManager = new DbContentClipManager(); DbContentClipCollection referencesCollection = referencesManager.GetCollection(string.Empty, string.Empty, null); foreach (DbContentClip references in referencesCollection) { ListItem i = new ListItem(references.ToString(), references.ID.ToString()); msReferences.Items.Add(i); } #endregion #region Bind Contributors Child Data msAuthors.Items.Add(new ListItem("Null", "Null")); GreyFoxUserManager authorsManager = new GreyFoxUserManager(); GreyFoxUserCollection authorsCollection = authorsManager.GetCollection(string.Empty, string.Empty, null); foreach (GreyFoxUser authors in authorsCollection) { ListItem i = new ListItem(authors.ToString(), authors.ID.ToString()); msAuthors.Items.Add(i); } msEditors.Items.Add(new ListItem("Null", "Null")); GreyFoxUserManager editorsManager = new GreyFoxUserManager(); GreyFoxUserCollection editorsCollection = editorsManager.GetCollection(string.Empty, string.Empty, null); foreach (GreyFoxUser editors in editorsCollection) { ListItem i = new ListItem(editors.ToString(), editors.ID.ToString()); msEditors.Items.Add(i); } #endregion }