protected string LoadWishList(Guid id) { int TitleId = 0; SiteWish wishList = new SiteWish(); DataSet dswishList = new DataSet(); StringBuilder sb = new StringBuilder(); Boolean entro = false; //dswishList = wishList.Get_All_Wish_By_Session(); dswishList = wishList.Get_All_Wish_By_GUID(id); if (dswishList == null) return ""; foreach (DataTable table in dswishList.Tables) { foreach (DataRow row in table.Rows) { sb.AppendLine("<div class=\"prodwish\">"); sb.AppendLine("<div class=\"prodImg\">"); sb.AppendLine("<div id=\"boxContImage\" style=\"width:115px; height:115px;\">"); sb.AppendLine("<a href=\"product.aspx?p=" + row["titleid"].ToString() + "\"><img id=\"images\" style=\"width: 102px;height:127px;\" title=\"" + row["pubname"].ToString() + " : " + row["title"].ToString() + "\" src=\"" + strFolder + "tn_" + row["imageTN"].ToString() + "\"></a>"); //onload=\"getDim(document.getElementById('boxContImage'),this)\" sb.AppendLine("</div>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"prodSrcDesc\">"); sb.AppendLine("<h2><a href=\"Product.aspx?p=" + row["TitleId"].ToString() + "&s=" + row["SKU"].ToString() + "\">" + row["title"].ToString() + "</a></h2>"); sb.AppendLine("<p><em>by: </em> <a href=\"result.aspx?findopt5=" + row["PubId"].ToString() + "&am=1&asm=" + 3 + "\">" + row["pubname"].ToString() + "</a></p>"); sb.AppendLine("<h3> $" + Convert.ToDouble(row["price"].ToString()) + "</h3>"); if (Convert.ToDouble(row["youShave"].ToString()) > 0) { sb.AppendLine("<h4>Your DISCOUNTED price</h4>"); sb.AppendLine("<h5>You Save: $" + Convert.ToDouble(row["youShave"].ToString()) + "</h5>"); } sb.AppendLine("Date Added: " + row["CreateDate"].ToString() + "<br />"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"prodNumber\">"); sb.AppendLine("<div class=\"prodNumCont\">"); if ((row["Plat_Win_Flag"].ToString() == "1") && (row["Plat_Mac_Flag"].ToString() == "2")) { sb.AppendLine("<p>Mac / Windows</p>"); } else { sb.AppendLine("<p>" + (row["Plat_Win_Flag"].ToString() == "1" ? "Windows" : "") + "" + (row["Plat_Mac_Flag"].ToString() == "2" ? "Mac" : "") + "</p>"); } sb.AppendLine("<div class=\"numBG\">Grades<br /><span>" + row["grades"].ToString() + "</span></div>"); sb.AppendLine("<p>Item #: " + row["SKU"].ToString() + "</p>"); sb.AppendLine("</div>"); //sb.AppendLine("<a href=\"#\" id=\"A2\" class=\"mb\" title=\"\" rel=\"type:element\">" + Cart.CreateAddToCartLink("<img src=\"" + Global.globalSiteImagesPath + "/btnMovetoCart.jpg\"/>", row["titleId"].ToString(), row["SKU"].ToString(), 1, Convert.ToInt32(row["WishListId"].ToString())) + "</a>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); TitleId = Convert.ToInt32(row["TitleId"]); } SiteProduct siteproduct = new SiteProduct(); DataSet dsSitePrice = new DataSet(); dsSitePrice = siteproduct.Get_Title_RelatedProducts(TitleId); foreach (DataTable tableProducts in dsSitePrice.Tables) { foreach (DataRow row in tableProducts.Rows) { if (entro == false){ entro = true; sb.AppendLine("<div id=\"resultControls\">"); sb.AppendLine("<h2>Similar Products</h2>"); sb.AppendLine("<div id=\"SlideItMoo_outer\">"); sb.AppendLine("<div id=\"SlideItMoo_inner\">"); sb.AppendLine("<div id=\"SlideItMoo_items\">"); } sb.AppendLine("<div class=\"SlideItMoo_element\"><a href=\"product.aspx?p=" + row["titleid"].ToString() + "\" style=\"background-color:#FFF;\"><img src=\"" + strFolder + "tn_" + row["imageTN"].ToString() + "\" title=\"" + row["PubName"].ToString() + " : " + row["title"].ToString() + "\" /></a><p>" + row["title"].ToString() + "</p></div>"); } } if (entro == true){ sb.AppendLine("</div>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); sb.AppendLine("</div>"); } } return sb.ToString(); }