//Add public static PreSearches AddPreSerch(PreSearches preSearch) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { PreSearches isExist = db.PreSearches.FirstOrDefault(x => x.Id == preSearch.Id); if (isExist == null) { isExist = db.PreSearches.Add(preSearch); db.SaveChanges(); } return(isExist); } }
//Delete public static void DeletePreSerch(PreSearches preSearch) { if (preSearch != null) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { db.Entry(preSearch).State = EntityState.Modified; db.PreSearches.Remove(preSearch); db.SaveChanges(); } catch (Exception ex) { } } } }
//Update public static void UpdatePreSerches(PreSearches preSearches) { using (RatzhKatzviEntities1 db = new RatzhKatzviEntities1()) { try { PreSearches isExist = db.PreSearches.FirstOrDefault(x => x.Id == preSearches.Id); if (isExist != null) { db.Entry(preSearches).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { } } }
public static List <WordLocation> SearchInBooks(string text) { if (text.Length > 0) { string[] searchWords = text.Split(' '); string newRgxText = ".*"; foreach (var word in searchWords) { newRgxText += word + "(.*)"; } var rgx = new Regex(newRgxText); List <Items> items = ItemsDL.GetAllItems().Where(item => true == item.EnableSearch).ToList(); List <BookPages> bookPages = new List <BookPages>(); List <WordLocation> searchResultWordLocations = new List <WordLocation>(); bool flag = false; PreSearches newPreSearch = new PreSearches(); foreach (var item in items) { bookPages = BookPagesDL.GetBookByItemId(item.ItemId); bookPages = BookPagesDL.SearchText(bookPages, rgx); if (bookPages.Count > 0) { if (!flag) { flag = true; newPreSearch = PreSearchesDL.AddPreSerch(new PreSearches { PreSearch = text, SearchedCounter = 1 }); } if (newPreSearch != default(PreSearches)) { searchResultWordLocations.AddRange(WordLocationDL.Create_List_WordLocationFromBooPage(bookPages, newPreSearch.Id)); } } } if (searchResultWordLocations != default(List <WordLocation>)) { WordLocationDL.AddList(searchResultWordLocations); } return(searchResultWordLocations); } return(new List <WordLocation>()); }