private Item GetThisItemFromRight(Sitecore.Data.ID theItemID)
{
Item itm = null;
Item retVal = null;
try
{
Database RightDB = Sitecore.Configuration.Factory.GetDatabase(strRightDB);
if (RightDB != null)
{
itm = RightDB.GetItem(theItemID);
}
if (itm != null)
{
Sitecore.Data.Fields.TextField tf = null;
if (itm.TemplateName.ToString().ToLower() == "product")
{
tf = itm.Fields["_NDC"];
}
else if (itm.TemplateName.ToString().ToLower() == "productgroup")
{
tf = itm.Fields["Product Group Name"];
}
if ((tf != null) && (!String.IsNullOrWhiteSpace(tf.Value)))
{
retVal = itm;
}
}
}
catch (Exception ex)
{
}
return(retVal);
}
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();
}
}
}
