private void BuildUIFromCustom2()
{
SqlDataReader dr = GetDatabase();
sb = new StringBuilder();
sb.Append("<table border=\"1\" cellpadding=\"1\" cellspacing=\"5\">");
sb.Append("<tr>");
sb.AppendFormat("<th>Row Number</th><th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th>", "DB NDC", "Item Path", "Current PI", "Modified To");
sb.Append("</tr>");
while (dr.Read())
{
String RowID = dr[0].ToString();
String NDC = dr[1].ToString();
String NewPI = dr[3].ToString();
String CurrentPI = String.Empty;
Item product = null;
Item itm = null;
String query = "/sitecore/content/MylanInstitutionalProducts/Products//*[@@templateid='{692169E2-B461-41B4-95F9-235D652319A8}' and @ _NDC='" + NDC + "']";
itm = masterDB.SelectSingleItem(query);
try
{
if (itm != null)
{
product = null;
product = getProductforNDC(itm);
if (product != null)
{
TextField tf = product.Fields["PrescribingInformationLink"];
if ((tf != null) && (!string.IsNullOrWhiteSpace(tf.Value)))
{
CurrentPI = tf.Value.ToString();
}
}
}
}
catch (Exception ex)
{
product = null;
}
sb.Append(BuildDisplayStringCustom(RowID, NDC, itm, product, CurrentPI, NewPI));
}
sb.Append("</table>");
lblRenamedItems.Text = sb.ToString();
}
public List <Item> GetCampaignItems(string path)
{
Sitecore.Data.Database context = Sitecore.Configuration.Factory.GetDatabase("master");
Item item = context.SelectSingleItem(path);
List <Item> items = item.Axes.GetDescendants().Where(x => x.TemplateID.ToString() == "{94FD1606-139E-46EE-86FF-BC5BF3C79804}").ToList();
return(items);
}
public static Stream GetFileByPath(string Path, Sitecore.Data.Database database)
{
return(GetFileStream(database.SelectSingleItem(Path)));
}
public static List <KeyValuePair <string, string> > GetItemValuesByPath(string Path, Sitecore.Data.Database database)
{
return(GetItemFieldValuesFromTemplate(database.SelectSingleItem(Path), database));
}
public static Item GetItemByPath(string Path, Sitecore.Data.Database database)
{
return(database.SelectSingleItem(Path));
}
private DataTable DisplayCookieData()
{
string[] CookieArray = getValuesFromCookies(Request.Cookies["ProductCatalog"].Value.ToString());
DataTable dt = new DataTable();
dt.Columns.Add("ProductID");
dt.Columns.Add("ProductName");
dt.Columns.Add("InfoPrescribingInformationLink");
dt.Columns.Add("AttrWarnings");
dt.Columns.Add("RowCount");
int productCount = 0;
HashSet <string> prodNames = new HashSet <string>();
foreach (string a in CookieArray)
{
string[] ProdArray = a.Split(new Char[] { '_' });
if (ProdArray[0] == "ndc")
{
Item[] productNDC = masterDB.SelectItems(String.Format("fast://*[@@name='{0}']", ProdArray[1]));
foreach (Item ndc in productNDC)
{
prodNames.Add(ndc.Parent.ID.ToString());
}
}
}
foreach (string prod in prodNames)
{
DataRow dr = dt.NewRow();
productCount++;
bool itemInTable = false;
Item fullProduct = masterDB.SelectSingleItem(String.Format("fast://*[@@id='{0}']", prod));
if (fullProduct != null)
{
dr["ProductID"] = fullProduct.ID;
if (fullProduct.Fields["PrescribingInformationLink"] != null)
{
dr["ProductName"] = fullProduct.Fields["Product Group Name"].Value.ToString();
}
if (fullProduct.Fields["PrescribingInformationLink"] != null)
{
dr["InfoPrescribingInformationLink"] = fullProduct.Fields["PrescribingInformationLink"].Value.ToString();
}
foreach (Item child in fullProduct.Children)
{
if (child.Fields["_xAttrWarnings"] != null)
{
dr["AttrWarnings"] = createWarningImages(child.Fields["_xAttrWarnings"].Value.ToString());
}
}
dr["RowCount"] = productCount;
for (int q = 0; q < dt.Rows.Count; q++)
{
if (dt.Rows[q]["ProductName"] == dr["ProductName"])
{
itemInTable = true;
}
}
if (!itemInTable)
{
dt.Rows.Add(dr);
}
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["RowCount"] = productCount;
}
return(dt);
}