protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
HVE.Files.dbConnection conn = new HVE.Files.dbConnection();
string sclearsql = string.Concat("SELECT top 5 DocName, DocLocation, DownloadCount FROM [AAES Home].[dbo].[TopViewedDocsTable11] order by DownloadCount desc");
tempTabale = conn.executeSelectNoParameter(sclearsql);
webApp = SPContext.Current.Site.WebApplication.GetResponseUri(Microsoft.SharePoint.Administration.SPUrlZone.Default).ToString();
for (int i = 0; i < tempTabale.Rows.Count; i++)
{
hrefLink = "/" + tempTabale.Rows[i][1].ToString();
htmlString.Append("<br>");
htmlString.Append(@"<span>" +
"<a href='" + hrefLink + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a>" +
" (" + tempTabale.Rows[i][2] + ")" +
"</span>");
htmlString.Append(" ");
}
Literal1.Text = htmlString.ToString();
}
}
catch (System.Exception excep)
{
throw excep;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Button1.Visible = false;
try
{
if (!Page.IsPostBack)
{
//HVEStage_Search_Service_Application_LinksStoreDB_ac061569c0804ca68d18ac6f23bb2758
//HVEDev_Search_Service_Application_LinksStoreDB_151f333c38ce4fd3a6527d79d5532774
string quer = @"Select top 10
querystring, COUNT(queryString) as CountValue
from [HVEDev_Search_Service_Application_LinksStoreDB_151f333c38ce4fd3a6527d79d5532774].[dbo].[MSSQLogPageImpressionQuery]
where queryString !=''
and queryString IS NOT NULL
and queryString not like 'path:%'
and queryString not like 'siteid:%'
group by queryString
order by CountValue desc";
//HVE.Files.dbConnection conn = new HVE.Files.dbConnection("TopSearchedItems");
HVE.Files.dbConnection conn = new HVE.Files.dbConnection();
DataTable tempTabale = null;
tempTabale = conn.executeSelectNoParameter(quer);
Repeater1.DataSource = tempTabale;
Repeater1.DataBind();
#region GridView Bound Columns
//////DataTable dt = new DataTable();
//////for (int i = 0; i < tempTabale.Rows.Count; i++)
//////{
////// DataColumn dcol = new DataColumn("Col" + (i + 1), typeof(System.String));
////// dcol.AutoIncrement = true;
////// dt.Columns.Add(dcol);
//////}
//////DataRow drow = dt.NewRow();
////////drow["Col1"] = 1;// "Row-";
//////dt.Rows.Add(drow);
////////GridView1.DataSource = dt;
////////GridView1.DataBind();
#endregion
#region LiteralControl
StringBuilder htmlStr = new StringBuilder("");
//string hrefLinks = "http://win-njfp7te48bn/sites/HVEDev3Search/Pages/search.aspx?k=";
string hrefLinks = this.Page.Request.Url.ToString().Substring(0, this.Page.Request.Url.ToString().IndexOf(".aspx?k=")) + ".aspx?k=";
string str = SPContext.Current.Site.Url;
string str1 = this.Page.Request.Url.ToString();
string var1 = str1.Substring(0, str1.IndexOf(".aspx?k="));
//string var1 = str1.Substring(str1.LastIndexOf(".aspx?k="));
/*
* var1 = entry.DocLocation.Substring(entry.DocLocation.LastIndexOf("/"));
* var2 = var1.Substring(var1.LastIndexOf("/"));
* var3 = var2.Substring(1);
* var4 = var3.Substring(var3.LastIndexOf('.') + 1);
*/
for (int i = 0; i < tempTabale.Rows.Count; i++)
{
//htmlStr.Append("<table><tr></tr></table>");
switch (i)
{
case 0:
string hyperLink1 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:xx-large; '><a href='" + hyperLink1 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 1:
string hyperLink2 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:x-large; '><a href='" + hyperLink2 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 2:
string hyperLink3 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:large; '><a href='" + hyperLink3 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 3:
string hyperLink4 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:large; '><a href='" + hyperLink4 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 4:
string hyperLink5 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:larger; '><a href='" + hyperLink5 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 5:
string hyperLink6 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:medium; '><a href='" + hyperLink6 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 6:
string hyperLink7 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:small; '><a href='" + hyperLink7 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 7:
string hyperLink8 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:small; '><a href='" + hyperLink8 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 8:
string hyperLink9 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:smaller; '><a href='" + hyperLink9 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 9:
string hyperLink10 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:smaller; '><a href='" + hyperLink10 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" ");
break;
default:
Console.WriteLine("Default case");
break;
}
}
LiteralText.Text = htmlStr.ToString();
}
#endregion
}
catch (System.Exception excep)
{
Label1.Text += excep.Message;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
string quer = @"Select top 10
querystring, COUNT(queryString) as CountValue
from [Search_Service_Application_1_LinksStoreDB_85b9e99e32794b6c9785675b4fb6757f].[dbo].[MSSQLogPageImpressionQuery]
where queryString !=''
and queryString IS NOT NULL
and queryString not like 'path:\""http://%'
and queryString not like 'path:\""https://%'
and queryString not like 'siteid:%'
group by queryString
order by CountValue desc";
HVE.Files.dbConnection conn = new HVE.Files.dbConnection();
DataTable tempTabale = null;
tempTabale = conn.executeSelectNoParameter(quer);
//GridView1.DataSource = tempTabale;
//GridView1.DataBind();
//foreach (DataRow row in tempTabale.Rows) {}
string linkVal = @"http://aespaspsas/sites/HVEDevSite/_layouts/15/osssearchresults.aspx?u=http%3A%2F%2Faespaspsas%2Fsites%2FHVEDevSite&k=";
StringBuilder htmlStr = new StringBuilder("This is string builder");
for (int i = 0; i < tempTabale.Rows.Count; i++)
{
switch (i)
{
case 0:
htmlStr.Append("<p><font size='7'>" + tempTabale.Rows[i][0] + "</font>");
//htmlStr.Append(@"<a href='<%#Eval(\""tempTabale.Rows[i][0]\"")%>' target='_blank'>Visit W3Schools</a>");
//htmlStr.Append("<p><font size='7'>" + tempTabale.Rows[i][0] + "</font></p>");
htmlStr.Append(" ");
break;
case 1:
htmlStr.Append("<font size='7'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 2:
htmlStr.Append("<font size='6'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 3:
htmlStr.Append("<font size='6'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 4:
htmlStr.Append("<font size='6'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 5:
htmlStr.Append("<font size='5'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 6:
htmlStr.Append("<font size='5'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 7:
htmlStr.Append("<font size='5'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 8:
htmlStr.Append("<font size='4'>" + tempTabale.Rows[i][0] + "</font>");
htmlStr.Append(" ");
break;
case 9:
htmlStr.Append("<font size='4'>" + tempTabale.Rows[i][0] + "</font></p>");
htmlStr.Append(" ");
break;
// case 10:
// htmlStr.Append("<p><font size='4'>" + tempTabale.Rows[i][0] + "</font></p>");
//// htmlStr.Append(" ");
// break;
default:
Console.WriteLine("Default case");
break;
}
}
LiteralText.Text = htmlStr.ToString();
Repeater1.DataSource = tempTabale;
Repeater1.DataBind();
}
}
catch (System.Exception excep)
{
Label1.Text += excep.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Button1.Visible = false;
try
{
if (!Page.IsPostBack)
{ //AES_Search_Service_Application_LinksStoreDB_07d1b3d709b844288e1c87626eb41904 //HVEDev_Search_Service_Application_LinksStoreDB_151f333c38ce4fd3a6527d79d5532774
////////////// string quer = @"Select top 10
////////////// querystring, COUNT(queryString) as CountValue
////////////// from [HVEDev_Search_Service_Application_LinksStoreDB_151f333c38ce4fd3a6527d79d5532774].[dbo].[MSSQLogPageImpressionQuery]
////////////// where queryString !=''
////////////// and queryString IS NOT NULL
////////////// and queryString not like 'path:%'
////////////// and queryString not like 'siteid:%'
////////////// group by queryString
////////////// order by CountValue desc";
string quer = @"Select top 10
querystring, COUNT(queryString) as CountValue
from [HVEStage_Search_Service_Application_LinksStoreDB_ac061569c0804ca68d18ac6f23bb2758].[dbo].[MSSQLogPageImpressionQuery]
where queryString !=''
and queryString IS NOT NULL
and queryString not like 'path:%'
and queryString not like 'siteid:%'
group by queryString
order by CountValue desc";
HVE.Files.dbConnection conn = new HVE.Files.dbConnection();
DataTable tempTabale = null;
tempTabale = conn.executeSelectNoParameter(quer);
#region GridView Bound Columns
DataTable dt = new DataTable();
for (int i = 0; i < tempTabale.Rows.Count; i++)
{
DataColumn dcol = new DataColumn("Col" + (i + 1), typeof(System.String));
dcol.AutoIncrement = true;
dt.Columns.Add(dcol);
}
DataRow drow = dt.NewRow();
//drow["Col1"] = 1;// "Row-";
dt.Rows.Add(drow);
GridView1.DataSource = dt;
GridView1.DataBind();
#endregion
#region LiteralControl
StringBuilder htmlStr = new StringBuilder("");
string hrefLinks = "http://win-njfp7te48bn/sites/HVEDev3Search/Pages/search.aspx?k=";
for (int i = 0; i < tempTabale.Rows.Count; i++)
{
//htmlStr.Append("<table><tr></tr></table>");
switch (i)
{
case 0:
string hyperLink1 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:xx-large; '><a href='" + hyperLink1 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 1:
string hyperLink2 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:x-large; '><a href='" + hyperLink2 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 2:
string hyperLink3 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:large; '><a href='" + hyperLink3 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 3:
string hyperLink4 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:large; '><a href='" + hyperLink4 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 4:
string hyperLink5 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:larger; '><a href='" + hyperLink5 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 5:
string hyperLink6 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:medium; '><a href='" + hyperLink6 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 6:
string hyperLink7 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:small; '><a href='" + hyperLink7 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 7:
string hyperLink8 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:small; '><a href='" + hyperLink8 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 8:
string hyperLink9 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:smaller; '><a href='" + hyperLink9 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" | ");
htmlStr.Append(" ");
break;
case 9:
string hyperLink10 = hrefLinks + tempTabale.Rows[i][0];
htmlStr.Append("<span style='font-size:smaller; '><a href='" + hyperLink10 + "' title='" + tempTabale.Rows[i][0] + "' >" + tempTabale.Rows[i][0] + "</a></span>");
htmlStr.Append(" ");
break;
default:
Console.WriteLine("Default case");
break;
}
}
LiteralText.Text = htmlStr.ToString();
}
#endregion
}
catch (System.Exception excep)
{
//Label1.Text += excep.Message;
}
}
