protected void FinderTitle() { //-- PageSize = 5; PageNum = _pg; FirstRow = PageNum * PageSize - PageSize; int CurrentRow = 0; //-- Result resultTitle = new Result(); string sTextFinder = _sTextFinder; string findopt1 = Request["findopt1"]; //sSubjSubCateId string findopt2 = Request["findopt2"]; //sTeacSubCateId string findopt3 = Request["findopt3"]; //sGrade string findopt4 = Request["findopt4"]; //sPlatformId string findopt5 = Request["findopt5"]; //sPubId string findopt6 = Request["findopt6"]; //sPubId if (sTextFinder == null) sTextFinder = ""; if (findopt1 != null) findopt1 = (findopt1.Trim() == "" ? null : findopt1); if (findopt2 != null) findopt2 = (findopt2.Trim() == "" ? null : findopt2); if (findopt3 != null) findopt3 = (findopt3.Trim() == "" ? null : findopt3); if (findopt4 != null) findopt4 = (findopt4.Trim() == "" ? null : findopt4); if (findopt5 != null) findopt5 = (findopt5.Trim() == "" ? null : findopt5); if (findopt6 != null) findopt6 = (findopt6.Trim() == "" ? null : findopt6); //For to ShareThisUrl/ string strUrlST = ""; string am = Request["am"]; string asm = Request["asm"]; strUrlST = "?am=" + am + "&asm=" + asm +"&txtadv=" + sTextFinder; if (findopt1 != null) strUrlST = strUrlST + "&findopt1=" + findopt1; if (findopt2 != null) strUrlST = strUrlST + "&findopt2=" + findopt2; if (findopt3 != null) strUrlST = strUrlST + "&findopt3=" + findopt3; if (findopt4 != null) strUrlST = strUrlST + "&findopt4=" + findopt4; if (findopt5 != null) strUrlST = strUrlST + "&findopt5=" + findopt5; if (findopt6 != null) strUrlST = strUrlST + "&findopt6=" + findopt6; Main_MasterPage main = (Main_MasterPage)Page.Master; if (strUrlST != "") { main._site_ShareThisLink = Request.Url.AbsoluteUri + strUrlST; } //END For to ShareThisUrl/ DataSet dsfinder = new DataSet(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); //--- dsfinder.Clear(); dsfinder = resultTitle.Find_FinderTitleCatGroup(sTextFinder, findopt1, findopt2, findopt3, findopt4, findopt5, _sb, findopt6); // Added by Jordan Sherer - Sept 1, 2009 // Need to make sure we don't have a null value; if(dsfinder == null || dsfinder.Tables == null || dsfinder.Tables.Count <= 0) { return; } _ds_nr = dsfinder.Tables[0].Rows.Count; if (_ds_nr == 1) Response.Redirect("product.aspx?p=" + dsfinder.Tables[0].Rows[0].ItemArray[0].ToString()); LoadFinderPagination(_ds_nr, sTextFinder, findopt1, findopt2, findopt3, findopt4, findopt5, findopt6); foreach (DataTable table in dsfinder.Tables) { foreach (DataRow row in table.Rows) { if ((FirstRow <= CurrentRow) && (CurrentRow < (PageNum * PageSize))) { sb.AppendLine("<div class=\"prodSrcRef\">"); 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\" title=\"" + row["pubname"].ToString() +" : " +row["title"].ToString() + "\" style=\"width: 115px;height:115px;\" src=\"" + strFolder + "tn_" + row["ImageTn"].ToString() + "\"></a>"); //sb.AppendLine("<img src=\"" + row["imagetn"].ToString() + "\">"); sb.AppendLine("</div>"); //onload=\"getDim(document.getElementById('boxContImage'),this)\" sb.AppendLine("</div>"); sb.AppendLine("<div class=\"prodSrcDesc\">"); sb.AppendLine("<h2><a href=\"product.aspx?p=" + row["titleid"].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>"); if (Convert.ToDouble(row["yousave"].ToString()) > 0) { sb.AppendLine("<h3> $" + String.Format("{0:#,0.00}", row["Er_price"]) + "</h3>"); sb.AppendLine("<h4>Your DISCOUNTED price</h4>"); sb.AppendLine("<h5>You Save: $" + String.Format("{0:#,0.00}", row["yousave"]) + "</h5>"); } else { if (row["TitleId"].ToString() != Resources.Resource.TorchProductId) { sb.AppendLine("<h6> $" + String.Format("{0:#,0.00}", row["Er_price"]) + "</h6>"); } else { sb.AppendLine("<h6> Configure First</h6>"); } } if (row["TitleId"].ToString() != Resources.Resource.TorchProductId) { sb.AppendLine(Cart.CreateAddToCartLink("<img src=\"" + Global.globalSiteImagesPath + "/addToCart.jpg\" width=\"109\" height=\"26\" />", row["titleid"].ToString(), row["defaultsku"].ToString(), 1, 0)); } 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() == "1")) { sb.AppendLine("<p>Mac / Windows</p>"); } else { sb.AppendLine("<p>" + (row["plat_win_flag"].ToString() == "1" ? "Windows" : "") + "" + (row["plat_mac_flag"].ToString() == "1" ? "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>"); //--Login Validate if ((bool)Session[SiteConstants.UserValidLogin]) { sb.AppendLine("<a href=\"addWish.aspx?p=" + row["TitleId"].ToString() + "&sk=" + row["defaultsku"].ToString() + "&skd=" + row["SKUDesc"] + "\" rel=\"width:560,height:126,ajax:true\" id=\"mb10\" class=\"mb\" title=\"Add Product\"><img src=\"" + Global.globalSiteImagesPath + "/addToWish.jpg\" border=\"0\"></a>"); //duncan working } else { sb.AppendLine("<a href=\"#htmlElement\" id=\"mb15\" class=\"mb\" title=\"\" rel=\"type:element\"><img src=\"" + Global.globalSiteImagesPath + "/addToWish.jpg\" border=\"0\"></a>"); } sb.AppendLine("<a href=\"requestaquote.aspx?title=" + row["title"].ToString() + "\"><img src=\"" + Global.globalSiteImagesPath + "/quote.jpg\" border=\"0\"></a>"); sb.AppendLine("</div>"); sb.AppendLine("<div class=\"clear\"></div>"); sb.AppendLine("</div>"); } if (CurrentRow > (PageNum * PageSize)) break; CurrentRow++; } } sb.AppendLine("<div class=\"prodSrcRef\">"); sb.AppendLine("</div>"); dsfinder.Clear(); dsfinder.Dispose(); dsfinder = null; PlaceHolder_Result.Controls.Add(new LiteralControl(sb.ToString())); }