protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack || isFirstLoaded)
{
string userQuery = HttpContext.Current.Request.QueryString.Get("searchQuery");
searchArea.Text = userQuery;
if (!string.IsNullOrWhiteSpace(userQuery))
{
var index = new Lucene.Linq.DatabaseIndexSet<BubbleBaseDataContext>(
@"C:\Index",
new BubbleBaseDataContext());
index.Write();
List<BubbleSearchDataContext.Page> pageList = new List<BubbleSearchDataContext.Page>();
List<BubbleSearchDataContext.Word> queryWord = (from w in index.DataContext.Words
where w.txt_word.Contains(userQuery) || w.txt_word.Equals(userQuery)
join o in index.DataContext.Occurrences
on w.id_word equals o.id_word
orderby o.nb_occur descending
select w).ToList();
foreach (BubbleSearchDataContext.Word item in queryWord)
{
BubbleSearchDataContext.Occurrence occur = (from o in index.DataContext.Occurrences
where o.id_word.Equals(item.id_word)
select o).FirstOrDefault();
BubbleSearchDataContext.Page page = (from p in index.DataContext.Pages
where p.id_page.Equals(occur.id_page)
select p).FirstOrDefault();
if (!pageList.Contains(page))
pageList.Add(page);
}
DataTable dt = new DataTable();
dt.Columns.Add();
foreach (BubbleSearchDataContext.Page item in pageList)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
HyperLink link = new HyperLink();
link.NavigateUrl = item.url_page;
link.Text = item.title_page;
cell.Controls.Add(link);
row.Controls.Add(cell);
TableRow row2 = new TableRow();
TableCell cell2 = new TableCell();
cell2.Text = item.description_page;
row2.Controls.Add(cell2);
TableRow row3 = new TableRow();
TableCell cell3 = new TableCell();
cell3.Text = item.url_page;
row3.Controls.Add(cell3);
TableRow row4 = new TableRow();
TableCell cell4 = new TableCell();
row4.Height = 1;
row4.CssClass = "resultSeparator";
cell4.BackColor = System.Drawing.Color.White;
cell4.CssClass = "resultSeparator";
row4.Controls.Add(cell4);
resultsView.Controls.Add(row);
resultsView.Controls.Add(row2);
resultsView.Controls.Add(row3);
resultsView.Controls.Add(row4);
}
isFirstLoaded = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (firstTime)
{
string userQuery = HttpContext.Current.Request.QueryString.Get("searchQuery");
if (!string.IsNullOrWhiteSpace(userQuery))
{
SearchBox.Text = userQuery;
Google_CheckBox.Checked = googleCheck;
Bing_CheckBox.Checked = bingCheck;
var index = new Lucene.Linq.DatabaseIndexSet<dotBaseDataContext>(
@"C:\Index",
new dotBaseDataContext());
index.Write();
#region Split de la requete de l'utilisateur
List<string> queryList = dotHelper.splitQuery(userQuery);
#endregion
if (queryList.Count > 0)
{
#region Recherche d'elements
int priorite = 0;
long begin = DateTime.Now.Ticks;
//On recupere toutes les pages contenant le premier mot de la query
List<dotSearchResult> resultList = (from p in index.DataContext.Pages
join o in index.DataContext.Occurrences
on p.id_page equals o.id_page
join w in index.DataContext.Words
on o.id_word equals w.id_word
where w.txt_word.Contains(queryList[0]) || w.txt_word.Equals(queryList[0])
orderby o.nb_occur ascending
select new dotSearchResult
{
pageTitle = p.title_page,
pageUrl = p.url_page,
pageDescription = p.description_page,
pageID = p.id_page,
engine = dotSearchEngine.dotSearch
}).ToList();
//On affecte la priorite a chaque page
resultList = resultList.AsEnumerable().Select(p => new dotSearchResult()
{
pageTitle = p.pageTitle,
pageUrl = p.pageUrl,
pageDescription = p.pageDescription,
pageID = p.pageID,
engine = p.engine,
dotPriority = priorite++
}).ToList();
if (queryList.Count > 1)
{
//Pour les pages trouvees dans resultList on cherche les pages contenant les autres mots de la query
for (int j = 1; j < queryList.Count; j++)
{
List<dotSearchResult> tempList = (from p in resultList
join o in index.DataContext.Occurrences
on p.pageID equals o.id_page
join w in index.DataContext.Words
on o.id_word equals w.id_word
where w.txt_word.Contains(queryList[j]) || w.txt_word.Equals(queryList[j])
orderby o.nb_occur ascending
select p).ToList();
if (tempList != null)
{
//On affecte la priorite a chaque page
tempList = tempList.AsEnumerable().Select(p => new dotSearchResult()
{
pageTitle = p.pageTitle,
pageUrl = p.pageUrl,
pageDescription = p.pageDescription,
pageID = p.pageID,
engine = p.engine,
dotPriority = priorite++
}).ToList();
//On ajoute les nouveaux resultats aux resultats initiaux
resultList.AddRange(tempList);
}
}
}
//Calcul du temps d'execution de requete
long end = DateTime.Now.Ticks;
long totalTime = end - begin;
TimeSpan ts = TimeSpan.FromTicks(totalTime);
double seconds = ts.TotalSeconds;
//On etablit la liste finale de resultats sans doublons et triee
List<dotSearchResult> finalResult = new List<dotSearchResult>();
foreach (dotSearchResult pageResult in resultList)
{
if (!finalResult.Exists(delegate(dotSearchResult p) { return p.pageID == pageResult.pageID;} ))
{
try
{
dotSearchResult match = (from p in resultList
where p.pageID.Equals(pageResult.pageID)
orderby p.dotPriority descending
select p).First();
finalResult.Add(match);
}
catch
{
continue;
}
}
}
#endregion
#region Binding a la ListView
DataTable dt = new DataTable();
dt.Columns.Add();
DataTable dtt = new DataTable();
dtt.Columns.Add("Title");
dtt.Columns.Add("URL");
dtt.Columns.Add("Description");
dtt.Columns.Add("URLcourte");
dtt.Columns.Add("Engine");
if (googleCheck)
finalResult.AddRange(dotHelper.GoogleSearch(userQuery));
if(bingCheck)
finalResult.AddRange(dotHelper.BingSearch(userQuery));
finalResult = finalResult.OrderByDescending(p => p.dotPriority).ToList();
if (finalResult.Count == 0)
resultsNbr.Text = "Aucun résultat trouvé";
else
resultsNbr.Text = finalResult.Count + " résultat(s) trouvé(s) en " + Math.Round(seconds, 3) + "s";
foreach (dotSearchResult item in finalResult)
{
string url = string.Empty;
if(!string.IsNullOrWhiteSpace(item.pageUrl))
url = item.pageUrl;
string shorturl = string.Empty;
if(!string.IsNullOrWhiteSpace(item.pageUrl))
shorturl = url.Length > 65 ? url.Substring(0, 65) + " ..." : url;
string title = string.Empty;
if (!string.IsNullOrWhiteSpace(item.pageTitle))
{
title = item.pageTitle.Length > 70 ? item.pageTitle.Substring(0, 70) + " ..." : item.pageTitle;
foreach (string keyword in queryList)
{
title = dotHelper.makeBold(title, keyword);
}
}
string description = string.Empty;
if (!string.IsNullOrWhiteSpace(item.pageDescription))
{
description = item.pageDescription.Length > 430 ? item.pageDescription.Substring(0, 430) + " ..." : item.pageDescription;
foreach (string keyword in queryList)
{
description = dotHelper.makeBold(description, keyword);
}
}
string engine = string.Empty;
if (googleCheck && bingCheck)
engine = "Boogle";
else
engine = item.engine.ToString();
string[] infoArray = { title, url, description, shorturl, engine };
dtt.LoadDataRow(infoArray, LoadOption.OverwriteChanges);
}
resultsList.DataSource = dtt;
resultsList.DataBind();
dtt.Dispose();
firstTime = false;
#endregion
}
}
}
#endregion Methods
}