public bool Save(IEnumerable <Result> resultList, Query query) { using (var db = new SearchEngineDbContext()) { try { foreach (var result in resultList) { result.QueryId = query.Id; result.Query = query; } db.Queries.Add(query); db.Results.AddRange(resultList); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }
public IEnumerable <Result> GetRecordsByQuery(string query) { using (var db = new SearchEngineDbContext()) { var results = db.Results.Where(r => r.Title.Contains(query) || r.Snippet.Contains(query)).ToList(); return(results); } }
public Result GetRecordById(int Id) { using (var db = new SearchEngineDbContext()) { var result = db.Results.Where(r => r.Id == Id).FirstOrDefault(); return(result); } }
public IEnumerable <Result> GetAllResults() { using (var db = new SearchEngineDbContext()) { var results = db.Results.ToList(); return(results); } }
public HomeController() { db = new SearchEngineDbContext(); m_searchService = new CommonSearchService(); m_repository = new SearchEngineRepository(); m_sites = new SearchSites { GoogleUri = "https://www.google.com/search?q=", BingUri = "https://www.bing.com/search?q=", YandexUri = "https://www.yandex.com/search/?text=" }; }
public bool Save(Result result, Query query) { using (var db = new SearchEngineDbContext()) { try { result.QueryId = query.Id; result.Query = query; db.Queries.Add(query); db.Results.Add(result); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }
public SearchService() { _database = new SearchEngineDbContext(); }
public SearchEngineController(SearchEngineDbContext context) { _context = context ?? throw new ArgumentNullException(nameof(context)); }
public SearchRepository(SearchEngineDbContext context) { this.context = context; }