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("}", ""));
}
