public static void ClearSitecoreCacheofItem(string database, Sitecore.Data.ID itemID) { try { Database db = GetDatabase(database); //clear data cache db.Caches.DataCache.RemoveItemInformation(itemID); //clear item cache db.Caches.ItemCache.RemoveItem(itemID); //clear standard values cache db.Caches.StandardValuesCache.RemoveKeysContaining(itemID.ToString()); //remove path cache db.Caches.PathCache.RemoveKeysContaining(itemID.ToString()); Sitecore.Caching.Cache prefetchCache = GetPrefetchCache(db); if (prefetchCache != null) { prefetchCache.RemoveKeysContaining(itemID.ToString()); } } catch { } }
protected void rptCategories_ItemDataBound(object sender, RepeaterItemEventArgs e) { if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { DataRowView dr = (DataRowView)e.Item.DataItem; Sitecore.Data.ID itmID = (Sitecore.Data.ID.Parse(dr["ProductCategoryItemID"].ToString())); if (itmID != Sitecore.Data.ID.Null) { Sitecore.Data.Items.Item itm = webDB.GetItem(itmID); if (itm != null) { Sitecore.Data.Fields.TextField catField = itm.Fields["Category"]; if ((catField != null) && (!String.IsNullOrWhiteSpace(catField.Value.ToString()))) { String category = catField.Value.ToString(); HtmlGenericControl lblName = (HtmlGenericControl)e.Item.FindControl("lblCategory"); if (lblName != null) { lblName.InnerHtml = itm.Fields["Category"].Value.ToString(); } HtmlAnchor anchr = (HtmlAnchor)e.Item.FindControl("CatAnch"); if (anchr != null) { anchr.Attributes.Add("href", String.Format("#{0}", category.ToLower().Replace(" ", ""))); } } } } DataView dv = dt.DefaultView; dv.RowFilter = String.Format("ProductCategoryItemID = '{0}'", itmID.ToString()); String[] ColumnsToFilter = { "ProductCategoryItemID", "ProductGroupItemID", "ItemID" }; DataTable distinctGroups = dv.ToTable(true, ColumnsToFilter); Repeater Groups = (Repeater)e.Item.FindControl("rptGroups"); if (Groups != null) { DataTable dtNew = distinctGroups; distinctGroups.Columns.Add("AttrWarnings"); foreach (DataRow drNew in dtNew.Rows) { ID ndcItemID = Sitecore.Data.ID.Parse(drNew["ItemID"]); if (ndcItemID != Sitecore.Data.ID.Null) { Item NDC = webDB.GetItem(ndcItemID); if (NDC != null) { drNew["AttrWarnings"] += NDC.Fields["_xAttrWarnings"].Value.ToString(); } } } Groups.DataSource = dtNew; Groups.DataBind(); } } }
public static void ShowItemBrowser(string header, string text, string icon, string button, Sitecore.Data.ID root, Sitecore.Data.ID selected, string database) { ShowItemBrowser( header, text, icon, button, root.ToString(), selected.ToString(), database); }
// Sort items public HtmlString sortingItems(Sitecore.Data.ID itemId, string text) { return(new HtmlString("<span style='float: right; padding-right: 15px;'><a href='#' class='pe-button pe-gray1 fa-input' onclick='javascript:Sitecore.PageModes.PageEditor.postRequest(\"webedit:sortcontent(id=" + itemId.ToString() + ")\");'> " + text + "</a></span>")); }
// delete item public HtmlString deleteItem(Sitecore.Data.ID itemId) { return(new HtmlString("<span style='float: right; padding-right: 15px;'><a name='edit_" + itemId + "' href='#delete' class='pe-button pe-red' onclick='Sitecore.PageModes.PageEditor.postRequest(\"webedit:delete(id=" + itemId.ToString() + ")\"); alert(\"Once you confirm item deletion, please refresh the page.\");' id='edit_" + itemId + "'>x</a></span>")); }
protected void rptGroups_ItemDataBound(object sender, RepeaterItemEventArgs e) { if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) { DataRowView dr = (DataRowView)e.Item.DataItem; Sitecore.Data.ID itmID = (Sitecore.Data.ID.Parse(dr["ProductGroupItemID"].ToString())); if (itmID != Sitecore.Data.ID.Null) { Sitecore.Data.Items.Item itm = webDB.GetItem(itmID); if (itm != null) { Label lblName = (Label)e.Item.FindControl("lblGroup"); if (lblName != null) { lblName.Text = itm.Fields["Product Group Name"].Value.ToString(); } } } DataTable dtNew = new DataTable(); dtNew.Columns.Add("ID"); dtNew.Columns.Add("ItemID"); dtNew.Columns.Add("NDC"); dtNew.Columns.Add("ProductDescription"); dtNew.Columns.Add("AttrStrength"); dtNew.Columns.Add("PkgPackage"); dtNew.Columns.Add("PkgPackageDetails"); dtNew.Columns.Add("WholeSaler"); if (itmID != Sitecore.Data.ID.Null) { DataView dv = dt.DefaultView; String[] ColumnsToFilter = { "ProductCategoryItemID", "ProductGroupItemID", "ItemID" }; DataTable distinctGroups = dv.ToTable(true, ColumnsToFilter); foreach (DataRow dRow in distinctGroups.Rows) { if (dRow["ProductGroupItemID"].ToString() == itmID.ToString()) { Sitecore.Data.ID ndcID = (Sitecore.Data.ID.Parse(dRow["ItemID"].ToString())); DataRow detailRow = dtNew.NewRow(); Item ndc = webDB.GetItem(ndcID); //detailRow["ID"] = dRow["ID"].ToString(); detailRow["ItemID"] = ndcID.ToString(); detailRow["NDC"] = ndc.Fields["_NDC"].Value.ToString(); detailRow["ProductDescription"] = ndc.Fields["_ProductDescription"].Value.ToString(); detailRow["AttrStrength"] = ndc.Fields["_xAttrStrength"].Value.ToString(); detailRow["PkgPackage"] = ndc.Fields["_xPkgPackage"].Value.ToString(); detailRow["PkgPackageDetails"] = ndc.Fields["_xPkgPackageDetails"].Value.ToString(); detailRow["WholeSaler"] = ""; dtNew.Rows.Add(detailRow); } } Repeater rptDetails = (Repeater)e.Item.FindControl("rptDailyDetails"); if (rptDetails != null) { rptDetails.DataSource = dtNew; rptDetails.DataBind(); } } } }
public static string ConvertSitecoreIdToLowerString(Sitecore.Data.ID itemId) { return(itemId.ToString().ToLower().Replace("{", "").Replace("}", "")); }