private void SageSearchBySearchWord()
{
try
{
if (Request.QueryString["searchword"] != null && Request.QueryString["searchword"].ToString() != string.Empty)
{
string searchword = Request.QueryString["searchword"].ToString();
if (!HTMLHelper.IsValidSearchWord(searchword))
{
lblSearchKeyword.Text = "";
gdvList.DataSource = null;
gdvList.DataBind();
}
else
{
lblSearchKeyword.Text = searchword;
SageFrameSearch stb = new SageFrameSearch();
searchword = stb.AddQuotesForSQLSearch(searchword);
GetSearchResultFromDataBase(searchword);
}
}
}
catch
{
}
}
private void BindGrid()
{
try
{
SageFrameSearch SFH = new SageFrameSearch();
DataTable dt = SFH.ListSageSerchProcedures(GetPortalID);
gdvList.DataSource = dt;
gdvList.DataBind();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void EditByID(int ID)
{
SageFrameSearch SFH = new SageFrameSearch();
SageFrameSearchProcedureInfo objInfo = SFH.SageFrameSearchProcedureGet(ID.ToString());
if (objInfo != null)
{
txtSageFrameSearchTitle.Text = objInfo.SageFrameSearchTitle;
txtSageFrameSearchProcedureName.Text = objInfo.SageFrameSearchProcedureName;
txtSageFrameSearchProcedureExecuteAs.Text = objInfo.SageFrameSearchProcedureExecuteAs;
frmWrapper.Visible = true;
gdvWrapper.Visible = false;
actionWrapper.Visible = false;
Session["EditID"] = ID;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
SageFrameSearch con = new SageFrameSearch();
SageFrameSearchSettingInfo objSearchSettingInfo = con.LoadSearchSettings(GetPortalID, GetCurrentCultureName);
string ClientID = string.Empty;
if (objSearchSettingInfo.SearchButtonType == 0)
{
ClientID = ((Button)this.FindControl("btnSageSearch")).ClientID;
}
else if (objSearchSettingInfo.SearchButtonType == 1)
{
ClientID = ((ImageButton)this.FindControl("btnSageSearch")).ClientID;
}
else if (objSearchSettingInfo.SearchButtonType == 2)
{
ClientID = ((LinkButton)this.FindControl("btnSageSearch")).ClientID;
}
((TextBox)this.FindControl(IDOfTxtBox)).Attributes.Add("onkeypress", "return clickButton(event,'" + ClientID + "')");
}
private void LoadSearchSettings()
{
try
{
SageFrameSearch con = new SageFrameSearch();
SageFrameSearchSettingInfo objSearchSettingInfo = con.LoadSearchSettings(GetPortalID, GetCurrentCultureName);
if (objSearchSettingInfo != null)
{
rdblSearchButtonType.SelectedIndex = rdblSearchButtonType.Items.IndexOf(rdblSearchButtonType.Items.FindByValue(objSearchSettingInfo.SearchButtonType.ToString()));
txtSearchButtonText.Text = objSearchSettingInfo.SearchButtonText;
txtSearchButtonImage.Text = objSearchSettingInfo.SearchButtonImage;
txtSearchResultPerPage.Text = objSearchSettingInfo.SearchResultPerPage.ToString();
txtSearchResultPageName.Text = objSearchSettingInfo.SearchResultPageName;
txtMaxSearchChracterAllowedWithSpace.Text = objSearchSettingInfo.MaxSearchChracterAllowedWithSpace.ToString();
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void DelteByID(int ID)
{
SageFrameSearch SFH = new SageFrameSearch();
SFH.SageFrameSearchProcedureDelete(ID, GetUsername);
BindGrid();
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("SageFrameSearch", "SearchExtensionDeltedSuccessfully"), "", SageMessageType.Success);
}
private void SaveExtension()
{
try
{
int SageFrameSearchProcedureID = 0;
if (Session["EditID"] != null)
{
//Update
SageFrameSearchProcedureID = Int32.Parse(Session["EditID"].ToString());
}
SageFrameSearchProcedureInfo objInfo = new SageFrameSearchProcedureInfo();
objInfo.AddedBy = GetUsername;
objInfo.AddedOn = DateTime.Now;
objInfo.DeletedBy = GetUsername;
objInfo.DeletedOn = DateTime.Now;
objInfo.IsActive = true;
objInfo.IsDeleted = false;
objInfo.IsModified = false;
objInfo.PortalID = GetPortalID;
objInfo.SageFrameSearchProcedureExecuteAs = txtSageFrameSearchProcedureExecuteAs.Text.Trim();
objInfo.SageFrameSearchProcedureID = SageFrameSearchProcedureID;
objInfo.SageFrameSearchProcedureName = txtSageFrameSearchProcedureName.Text.Trim();
objInfo.SageFrameSearchTitle = txtSageFrameSearchTitle.Text.Trim();
objInfo.UpdatedBy = GetUsername;
objInfo.UpdatedOn = DateTime.Now;
SageFrameSearch SFH = new SageFrameSearch();
SFH.SageFrameSearchProcedureAddUpdate(objInfo, GetPortalID, GetUsername);
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("SageFrameSearch", "SearchExtensionSavedSuccessfully"), "", SageMessageType.Success);
ClearForm();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void SearchData(string SearchKey)
{
try
{
//Now Send to The Result Page;
string strURL = string.Empty;
SageFrameConfig pagebase = new SageFrameConfig();
bool IsUseFriendlyUrls = pagebase.GetSettingBollByKey(SageFrameSettingKeys.UseFriendlyUrls);
SearchKey = Server.HtmlEncode(SearchKey);
SageFrameSearch objSearch = new SageFrameSearch();
if (objSearch.SearchPageExists(GetPortalID, Path.GetFileNameWithoutExtension(SageSearchResultPage)))
{
if (IsUseFriendlyUrls)
{
if (GetPortalID > 1)
{
strURL = ResolveUrl("~/portal/" + GetPortalSEOName + "/" + SageSearchResultPage + "?searchword=" + SearchKey);
}
else
{
strURL = ResolveUrl("~/" + SageSearchResultPage + "?searchword=" + SearchKey);
}
}
else
{
if (SageSearchResultPage.Contains(SageFrameSettingKeys.PageExtension))
{
SageSearchResultPage = SageSearchResultPage.Replace(SageFrameSettingKeys.PageExtension, "");
}
strURL = ResolveUrl("~/Default.aspx?ptlid=" + GetPortalID + "&ptSEO=" + GetPortalSEOName + "&pgnm=" + SageSearchResultPage + "&searchword=" + SearchKey);
}
}
else
{
if (IsUseFriendlyUrls)
{
if (GetPortalID > 1)
{
strURL = ResolveUrl("~/sf/portal/" + GetPortalSEOName + "/Search-Result" + SageFrameSettingKeys.PageExtension + "?searchword=" + SearchKey);
}
else
{
strURL = ResolveUrl("~/sf/Search-Result" + SageFrameSettingKeys.PageExtension + "?searchword=" + SearchKey);
}
}
else
{
if (SageSearchResultPage.Contains(SageFrameSettingKeys.PageExtension))
{
SageSearchResultPage = SageSearchResultPage.Replace(SageFrameSettingKeys.PageExtension, "");
}
strURL = ResolveUrl("~/Default.aspx?ptlid=" + GetPortalID + "&ptSEO=" + GetPortalSEOName + "&pgnm=Search-Result" + SageFrameSettingKeys.PageExtension + "&searchword=" + SearchKey);
}
}
Session["SageDtv"] = null;
Response.Redirect(strURL, false);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void GetSearchParameter()
{
try
{
string SearchKey = string.Empty;
#region "Get Data From Form Page"
foreach (Control ctl in pnlSearchWord.Controls)
{
if (ctl.HasControls())
{
foreach (Control mctl in ctl.Controls)
{
if (mctl.HasControls())
{
foreach (Control nctl in mctl.Controls)
{
if (nctl.GetType() == typeof(TextBox))
{
TextBox txtSearch = (TextBox)nctl;
if (txtSearch != null)
{
SearchKey = txtSearch.Text.Trim();
break;
}
}
}
}
}
}
}
#endregion
//Remove unwanted html text from the Search text
SearchKey = RemoveUnwantedSearchText(SearchKey);
SageFrameSearch SFS = new SageFrameSearch();
if (SFS.CheckIgnorWords(SearchKey, GetCurrentCultureName))
{
//Call Search function to get result
if (SearchKey != string.Empty)
{
SearchData(SearchKey);
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("SageFrameSearch", "PleaseFillValidTextToSearch"), "", SageMessageType.Alert);
}
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("SageFrameSearch", "PleaseFillValidTextToSearch"), "", SageMessageType.Alert);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void GenrateSageSerchForm()
{
try
{
if (pnlSearchWord.Controls.Count == 1)
{
SageFrameSearch con = new SageFrameSearch();
SageFrameSearchSettingInfo objSearchSettingInfo = con.LoadSearchSettings(GetPortalID, GetCurrentCultureName);
viewPerPage = objSearchSettingInfo.SearchResultPerPage;
HtmlGenericControl sageUl = new HtmlGenericControl("ul");
sageUl.Attributes.Add("class", "sfSearchheader");
HtmlGenericControl sageLi = new HtmlGenericControl("li");
sageUl.Attributes.Add("class", "sfSearchheader");
TextBox txtSageSearch = new TextBox();
txtSageSearch.CssClass = "sfInputbox";
txtSageSearch.MaxLength = objSearchSettingInfo.MaxSearchChracterAllowedWithSpace;
IDOfTxtBox = "txtSage_" + this.Page.Controls.Count.ToString();
txtSageSearch.ID = IDOfTxtBox;
RequiredFieldValidator ReqV = new RequiredFieldValidator();
ReqV.ControlToValidate = IDOfTxtBox;
ReqV.ErrorMessage = "*";
ReqV.CssClass = "sfError";
ReqV.ValidationGroup = "grp_SageSearch";
sageLi.Controls.Add(ReqV);
sageLi.Controls.Add(txtSageSearch);
HtmlGenericControl sageLiButton = new HtmlGenericControl("li");
string SearchReasultPageName = objSearchSettingInfo.SearchResultPageName;
if (!SearchReasultPageName.Contains(SageFrameSettingKeys.PageExtension))
{
SearchReasultPageName += SageFrameSettingKeys.PageExtension;
}
SageSearchResultPage = SearchReasultPageName;
if (objSearchSettingInfo.SearchButtonType == 0)
{
Button btnSageSearch = new Button();
btnSageSearch.ID = "btnSageSearchWord";
btnSageSearch.Text = "Search";
btnSageSearch.CssClass = "sfBtn";
btnSageSearch.Click += new EventHandler(btnSageSearch_Click);
btnSageSearch.ValidationGroup = "grp_SageSearch_" + SageUserModuleID.ToString();
sageLiButton.Controls.Add(btnSageSearch);
}
else if (objSearchSettingInfo.SearchButtonType == 1)
{
ImageButton btnSageSearch = new ImageButton();
btnSageSearch.ID = "btnSageSearchWord";
btnSageSearch.AlternateText = objSearchSettingInfo.SearchButtonText;
string SearchButtonImageUrl = objSearchSettingInfo.SearchButtonImage;
btnSageSearch.ImageUrl = GetTemplateImageUrl(SearchButtonImageUrl, true);
btnSageSearch.CssClass = "sfBtn";
btnSageSearch.ValidationGroup = "grp_SageSearch_" + SageUserModuleID.ToString();
btnSageSearch.Click += new ImageClickEventHandler(btnSageSearch_Click);
sageLiButton.Controls.Add(btnSageSearch);
}
else if (objSearchSettingInfo.SearchButtonType == 2)
{
LinkButton btnSageSearch = new LinkButton();
btnSageSearch.ID = "btnSageSearchWord";
btnSageSearch.Text = "Search";
//btnSageSearch.CssClass = "sfBtn";
btnSageSearch.Click += new EventHandler(btnSageSearch_Click);
btnSageSearch.ValidationGroup = "grp_SageSearch_" + SageUserModuleID.ToString();
sageLiButton.Controls.Add(btnSageSearch);
}
sageUl.Controls.Add(sageLi);
sageUl.Controls.Add(sageLiButton);
pnlSearchWord.Controls.Add(sageUl);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void SaveSearchSettings()
{
try
{
if (txtSearchResultPageName.Text.Trim() != string.Empty && txtSearchResultPerPage.Text.Trim() != string.Empty && txtMaxSearchChracterAllowedWithSpace.Text.Trim() != string.Empty)
{
SageFrameSearchSettingInfo objSearchSettingInfo = new SageFrameSearchSettingInfo();
objSearchSettingInfo.SearchButtonType = Int32.Parse(rdblSearchButtonType.SelectedValue);
objSearchSettingInfo.SearchButtonText = txtSearchButtonText.Text;
objSearchSettingInfo.SearchButtonImage = txtSearchButtonImage.Text.Trim();
objSearchSettingInfo.SearchResultPageName = txtSearchResultPageName.Text.Trim();
objSearchSettingInfo.SearchResultPerPage = Int32.Parse(txtSearchResultPerPage.Text.Trim());
objSearchSettingInfo.MaxSearchChracterAllowedWithSpace = Int32.Parse(txtMaxSearchChracterAllowedWithSpace.Text.Trim());
objSearchSettingInfo.MaxResultChracterAllowedWithSpace = Int32.Parse(txtMaxResultCharacter.Text.Trim());
SageFrameSearch con = new SageFrameSearch();
con.AddUpdateSageFrameSearchSetting(objSearchSettingInfo, GetPortalID, GetCurrentCultureName, GetUsername);
ShowMessage("", GetSageMessage("SageFrameSearch", "SearchSettingSavedSuccessfully"), "", SageMessageType.Success);
}
else
{
ShowMessage("", GetSageMessage("SageFrameSearch", "BlankValueNotAllowed"), "", SageMessageType.Alert);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void GetSearchResultFromDataBase(string searchword)
{
try
{
if (Session["SageDtv"] == null)
{
SageFrameConfig pagebase = new SageFrameConfig();
bool IsUseFriendlyUrls = pagebase.GetSettingBollByKey(SageFrameSettingKeys.UseFriendlyUrls);
SageFrameSearch SFS = new SageFrameSearch();
DataSet ds = SFS.SageSearchBySearchWord(searchword, GetUsername, GetCurrentCultureName, IsUseFriendlyUrls, GetPortalID);
if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
DataTable dt = ds.Tables[0];//Result
DataView dtv = new DataView(dt);
Session["SageDtv"] = ds;
DataTable dtSections = ds.Tables[1];//For Sections
BindOrderingSection();
BindResultSections(dtSections);
DataTable dtTime = ds.Tables[2];//Time of Execution in millisecond
gdvList.DataSource = dtv;
gdvList.DataBind();
}
}
//else
//{
// BindOrderingSection();
// FilterSerchResult();
//}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void SearchData(string SearchKey)
{
try
{
//Now Send to The Result Page;
string strURL = string.Empty;
SearchKey = Server.HtmlEncode(SearchKey);
SageFrameSearch objSearch = new SageFrameSearch();
if (objSearch.SearchPageExists(GetPortalID, Path.GetFileNameWithoutExtension(SageSearchResultPage)))
{
if (!IsParent)
{
strURL = GetParentURL + "/portal/" + GetPortalSEOName + "/" + SageSearchResultPage + "?searchword=" + SearchKey;
}
else
{
strURL = GetParentURL + "/" + SageSearchResultPage + "?searchword=" + SearchKey;
}
}
else
{
if (!IsParent)
{
strURL = GetParentURL + "/sf/portal/" + GetPortalSEOName + "/Search-Result" + SageFrameSettingKeys.PageExtension + "?searchword=" + SearchKey;
}
else
{
strURL = GetParentURL + "/sf/Search-Result" + SageFrameSettingKeys.PageExtension + "?searchword=" + SearchKey;
}
}
Session["SageDtv"] = null;
Response.Redirect(strURL, false);
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void GenrateSageSerchForm()
{
try
{
if (pnlSearch.Controls.Count == 1)
{
SageFrameSearch con = new SageFrameSearch();
SageFrameSearchSettingInfo objSearchSettingInfo = con.LoadSearchSettings(GetPortalID, GetCurrentCultureName);
HtmlGenericControl sageUl = new HtmlGenericControl("ul");
HtmlGenericControl sageLi = new HtmlGenericControl("li");
TextBox txtSageSearch = new TextBox();
txtSageSearch.CssClass = "cssClassSageSearchBox";
txtSageSearch.MaxLength = objSearchSettingInfo.MaxSearchChracterAllowedWithSpace;
IDOfTxtBox = "txt_" + this.Page.Controls.Count.ToString();
txtSageSearch.ID = IDOfTxtBox;
RequiredFieldValidator ReqV = new RequiredFieldValidator();
ReqV.ControlToValidate = IDOfTxtBox;
ReqV.ErrorMessage = "*";
ReqV.CssClass = "cssClasssNormalRed";
ReqV.ValidationGroup = "grp_SageSearch";
sageLi.Controls.Add(ReqV);
sageLi.Controls.Add(txtSageSearch);
HtmlGenericControl sageLiButton = new HtmlGenericControl("li");
string SearchReasultPageName = objSearchSettingInfo.SearchResultPageName;
if (!SearchReasultPageName.Contains(".aspx"))
{
SearchReasultPageName += ".aspx";
}
SageSearchResultPage = SearchReasultPageName;
if (objSearchSettingInfo.SearchButtonType == 0)
{
Button btnSageSearch = new Button();
btnSageSearch.ID = "btnSageSearch";
btnSageSearch.Text = objSearchSettingInfo.SearchButtonText;
btnSageSearch.CssClass = "cssClassSageSearchButton";
btnSageSearch.Click += new EventHandler(btnSageSearch_Click);
btnSageSearch.ValidationGroup = "grp_SageSearch_"+SageUserModuleID.ToString();
sageLiButton.Controls.Add(btnSageSearch);
//txtSageSearch.Attributes.Add("onkeydown", "ClickButtonOnInputBoxEnter('" + btnSageSearch.ClientID + "');");
}
else if (objSearchSettingInfo.SearchButtonType == 1)
{
ImageButton btnSageSearch = new ImageButton();
btnSageSearch.ID = "btnSageSearch";
btnSageSearch.AlternateText = objSearchSettingInfo.SearchButtonText;
string SearchButtonImageUrl = objSearchSettingInfo.SearchButtonImage;
btnSageSearch.ImageUrl = GetTemplateImageUrl(SearchButtonImageUrl, true);
btnSageSearch.CssClass = "cssClassSageSearchImageButton";
btnSageSearch.ValidationGroup = "grp_SageSearch_" + SageUserModuleID.ToString();
btnSageSearch.Click += new ImageClickEventHandler(btnSageSearch_Click);
sageLiButton.Controls.Add(btnSageSearch);
//txtSageSearch.Attributes.Add("onkeydown", "ClickButtonOnInputBoxEnter('" + btnSageSearch.ClientID + "');");
//txtSageSearch.Attributes.Add("onkeypress", "return clickButton(event,'" + btnSageSearch.ClientID + "')");
}
else if (objSearchSettingInfo.SearchButtonType == 2)
{
LinkButton btnSageSearch = new LinkButton();
btnSageSearch.ID = "btnSageSearch";
btnSageSearch.Text = objSearchSettingInfo.SearchButtonText;
btnSageSearch.CssClass = "cssClassSageSearchLinkButton";
btnSageSearch.Click +=new EventHandler(btnSageSearch_Click);
btnSageSearch.ValidationGroup = "grp_SageSearch_" + SageUserModuleID.ToString();
sageLiButton.Controls.Add(btnSageSearch);
//txtSageSearch.Attributes.Add("onkeydown", "ClickButtonOnInputBoxEnter('" + btnSageSearch.ClientID + "');");
}
sageUl.Controls.Add(sageLi);
sageUl.Controls.Add(sageLiButton);
pnlSearch.Controls.Add(sageUl);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
