public List<SageFrameSearchInfo> SageSearchBySearchWord(int offset, int limit, string Searchword, string SearchBy, string CultureName, bool IsUseFriendlyUrls, int PortalID) { try { List<SageFrameSearchInfo> searchList = new List<SageFrameSearchInfo>(); SQLHandler sagesql = new SQLHandler(); DataSet ds = new DataSet(); ds = sagesql.ExecuteScriptAsDataSet("[dbo].[sp_SageSearchBySearchKey] N'" + Searchword + "','" + SearchBy + "','" + IsUseFriendlyUrls + "','" + CultureName + "','" + PortalID + "','" + offset + "'," + limit); foreach (DataRow row in ds.Tables[0].Rows) { SageFrameSearchInfo obj = new SageFrameSearchInfo(); obj.RowTotal = Convert.ToInt32(row["RowTotal"]); obj.PageName = row["PageName"].ToString(); obj.HTMLContent = row["HTMLContent"].ToString(); obj.URL = row["URL"].ToString(); obj.UpdatedContentOn = row["UpdatedContentOn"].ToString(); obj.SearchWord = row["SearchWord"].ToString(); searchList.Add(obj); } return searchList; } catch (Exception e) { throw e; } }
public List<SageFrameSearchInfo> GetSageSearchResultBySearchWord(int offset, int limit, string Searchword, string SearchBy, string CultureName, bool IsUseFriendlyUrls, int PortalID) { SqlDataReader reader=null; try { List<KeyValuePair<string, object>> ParaMeterCollection = new List<KeyValuePair<string, object>>(); ParaMeterCollection.Add(new KeyValuePair<string, object>("@Searchword", Searchword)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@CultureName", CultureName)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@IsUseFriendlyUrls", IsUseFriendlyUrls)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@SearchBy", SearchBy)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@PortalID", PortalID)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@offset", offset)); ParaMeterCollection.Add(new KeyValuePair<string, object>("@limit", limit)); SQLHandler Objsql = new SQLHandler(); reader = Objsql.ExecuteAsDataReader("[dbo].[sp_HtmlContentSearch]", ParaMeterCollection); List<SageFrameSearchInfo> searchList = new List<SageFrameSearchInfo>(); while (reader.Read()) { SageFrameSearchInfo obj = new SageFrameSearchInfo(); obj.RowTotal = Convert.ToInt32(reader["RowTotal"]); obj.PageName = reader["PageName"].ToString(); obj.HTMLContent = reader["HTMLContent"].ToString(); obj.URL = reader["URL"].ToString(); obj.UpdatedContentOn = reader["UpdatedContentOn"].ToString(); searchList.Add(obj); } return searchList; } catch (Exception e) { throw e; } finally { if (reader != null) { reader.Close(); } } }