. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
| Server IP : 87.98.249.37 / Your IP : 216.73.216.208 [ Web Server : Microsoft-IIS/10.0 System : Windows NT NS3076740 10.0 build 17763 (Windows Server 2019) AMD64 User : IWPD_292(growel19p) ( 0) PHP Version : 8.3.12 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Inetpub/vhosts/growel.com/httpdocs/ |
Upload File : |
using GrowelBLL.Services;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace GrowelWeb
{
public partial class GetSearchResult : System.Web.UI.Page
{
public string pg_title;
public string siteurl;
protected void Page_Load(object sender, EventArgs e)
{
pg_title = Convert.ToString(Request.QueryString["term"]);
siteurl = clsComman.value("SiteUrl");
ShowSearchResult();
}
private void ShowSearchResult()
{
StringBuilder sb = new StringBuilder();
AdminService adminService = new AdminService();
DataSet ds = adminService.GetSearchResult(pg_title);
if (ds.Tables[0].Rows.Count == 0)
{
return;
}
adminService.InsertSearchLog(pg_title);
if (ds.Tables[0].Rows.Count == 1) // Single Prodicy the go to direct product Page
{
if (ds.Tables[0].Rows[0]["IsFinalProduct"].ToString() == "1")
{
Response.Redirect(siteurl + "Product/" + ds.Tables[0].Rows[0]["product"].ToString().ToLower());
}
}
sb.Append(" <div class='range range-50'>");
string img = "";
string bunit = "";
foreach (DataRow drow in ds.Tables[0].Rows)
{
if (Convert.ToString(drow["ProductImage"]) != "")
img = siteurl + "images/products/" + Convert.ToString(drow["ProductImage"]);
else
img = siteurl + "Includes/images/noimg.jpg";
if (drow["searchtype"].ToString().ToLower() == "product_types")
{
sb.Append(" <div class='cell-sm-6 cell-md-3 wow fadeInRightSmall'>");
sb.Append(" <article class='post-minimal'>");
sb.Append(" <div style='min-height: 50px;'>");
sb.Append(" <time class='post-minimal__time'>" + drow["product_displayname"].ToString() + "</time>");
sb.Append(" </div>");
sb.Append(" <div class='post-minimal__divider'></div><br>");
sb.Append(" <div style='min-height: 150px;'>");
sb.Append(" <img src='" + img + "' alt='" + drow["product_displayname"].ToString() + "' style='max-height:150px;border-radius:20px;' />"); //min-height: 150px; width='250' height='150'
//sb.Append(" <h6 class='post-minimal__title'><a href='single-post.html'>The Fourth Industrial Revolution: What's in Store for Manufacturers?</a></h6>");
sb.Append(" </div>");
sb.Append(" <a class='button button-primary' href='" + siteurl + "Business/" + drow["Product_type"].ToString().ToLower() + "/" + drow["Product"].ToString().ToLower() + "'>More Details</a>");
sb.Append(" </article>");
sb.Append(" </div>");
}
else if (drow["searchtype"].ToString().ToLower() == "products")
{
sb.Append(" <div class='cell-sm-6 cell-md-3 wow fadeInRightSmall'>");
sb.Append(" <article class='post-minimal'>");
sb.Append(" <div style='min-height: 50px;'>");
sb.Append(" <time class='post-minimal__time'>" + drow["product_displayname"].ToString() + "</time>");
sb.Append(" </div>>");
sb.Append(" <div class='post-minimal__divider'></div><br>");
sb.Append(" <div style='min-height: 150px;'>");
sb.Append(" <img src='" + img + "' alt='" + drow["product_displayname"].ToString() + "' style='max-height:150px;border-radius:20px;' />"); //min-height: 150px; width='250' height='150'
sb.Append(" </div>");
if (drow["IsFinalProduct"].ToString() == "0")
{
sb.Append(" <a class='button button-primary' href='" + siteurl + "Business/" + drow["Business_Unit"].ToString().ToLower() + "/" + drow["product"].ToString().ToLower() + "'>More Details</a>");
}
else
{
sb.Append(" <a class='button button-primary' href='" + siteurl + "Product/" + drow["product"].ToString().ToLower() + "'>More Details</a>");
}
sb.Append(" </article>");
sb.Append(" </div>");
}
else if (drow["searchtype"].ToString().ToLower() == "subproducts")
{
sb.Append(" <div class='cell-sm-6 cell-md-3 wow fadeInRightSmall'>");
sb.Append(" <article class='post-minimal'>");
sb.Append(" <div style='min-height: 50px;'>");
sb.Append(" <time class='post-minimal__time'>" + drow["product_displayname"].ToString() + "</time>");
sb.Append(" </div>");
sb.Append(" <div class='post-minimal__divider'></div><br>");
sb.Append(" <div style='min-height: 150px;'>");
sb.Append(" <img src='" + img + "' alt='" + drow["product_displayname"].ToString() + "' style='max-height:150px;border-radius:20px;' />"); //min-height: 150px; width='250' height='150'
//sb.Append(" <h6 class='post-minimal__title'><a href='single-post.html'>The Fourth Industrial Revolution: What's in Store for Manufacturers?</a></h6>");
sb.Append(" </div>");
if (drow["IsFinalProduct"].ToString() == "0")
{
sb.Append(" <a class='button button-primary' href='" + siteurl + "Business/" + bunit + "/" + drow["product"].ToString().ToLower() + "'>More Details</a>");
}
else
{
sb.Append(" <a class='button button-primary' href='" + siteurl + "Product/" + drow["product"].ToString().ToLower() + "'>More Details</a>");
}
sb.Append(" </article>");
sb.Append(" </div>");
}
}
sb.Append(" </div>");
if (ds.Tables[1].Rows.Count > 0)
{
sb.Append(" <div class='range'>");
sb.Append(" <div class='cell-sm-12 cell-md-12 cell-lg-12'>");
sb.Append(" <h4>Pages</h4>");
sb.Append(" <hr style='height: 1px; border-width:0; color: gray; background-color:gray'> ");
sb.Append(" </div>");
foreach (DataRow dr in ds.Tables[1].Rows)
{
sb.Append(" <div class='cell-sm-12 cell-md-12 wow fadeInRightSmall'>");
sb.Append(" <a href='" + siteurl + dr["searchtype"].ToString().ToLower() + "/" + dr["page"].ToString().ToLower() + "'>" +
" <h5> > " + dr["Page_DisplayTitle"].ToString() + "</h5>" +
"</a>");
sb.Append(" </div>");
}
sb.Append(" </div>");
}
litpro.Text = sb.ToString();
}
}
}