Пример #1
0
 private void lbSearchResults_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (lbSearchResults.SelectedIndex > -1 && lbSearchResults.SelectedIndex < lbSearchResults.Items.Count)
     {
         SongSearchResult ssr = (SongSearchResult)lbSearchResults.Items[lbSearchResults.SelectedIndex];
         UpdateSearchDisplayer(ssr.autoNumber, ssr.songNumber);
     }
 }
Пример #2
0
        public static List <SongSearchResult> Search(List <string> searchTerms)
        {
            if (searchTerms.Count < 1)
            {
                throw (new ApplicationException("No search terms"));
            }

            // Double check sql
            string p = ",./<>?[]\\{}|!@#$%^&*()-=_+:;'\"";

            foreach (string str in searchTerms)
            {
                if (str.IndexOfAny(p.ToCharArray()) != -1)
                {
                    throw (new ApplicationException("Malformed sql passed to Search"));
                }
            }

            // Build the query
            string query = "SELECT \"SongVerses\".\"AutoNumber\", \"Songs\".\"Number\", \"SongVerses\".\"Verse\", \"SongVerses\".\"OrderNum\", \"SongVerses\".\"IsChorus\" " +
                           "FROM \"SongVerses\" INNER JOIN \"Songs\" ON \"SongVerses\".\"AutoNumber\" = \"Songs\".\"AutoNumber\" WHERE ";

            foreach (string s in searchTerms)
            {
                query += "(\"Verse\" LIKE '%" + s + "%') AND ";
            }
            query  = query.Remove(query.Length - 4);
            query += "ORDER BY \"Number\"";

            // Query the database
            List <SongSearchResult> lResult = new List <SongSearchResult>();

            using (FBirdTask t = new FBirdTask())
            {
                t.CommandText = query;
                t.ExecuteReader();
                int cutoff = 100;
                while (t.DR.Read() && cutoff > 0)
                {
                    cutoff--;
                    SongSearchResult ssr = new SongSearchResult();
                    ssr.autoNumber   = t.GetInt32(0);
                    ssr.songNumber   = t.GetInt32(1);
                    ssr.verseData    = t.GetString(2);
                    ssr.isAtStart    = t.GetInt32(3) == 0;
                    ssr.isChorus     = t.GetBoolean(4);
                    ssr.verseData    = SongProject.RemoveVerseFormatting(ssr.verseData);
                    ssr.searchResult = ssr.verseData;
                    lResult.Add(ssr);
                }
            }

            return(lResult);
        }
Пример #3
0
        private void lbSearchResults_DrawItem(object sender, DrawItemEventArgs e)
        {
            if (e.Index > -1 && e.Index < lbSearchResults.Items.Count)
            {
                // Init brushes
                int        padding       = 3;
                SolidBrush brushNormal   = new SolidBrush(Color.FromArgb(223, 223, 223));
                SolidBrush brushSelected = new SolidBrush(Color.FromArgb(255, 204, 91));
                Rectangle  textr         = new Rectangle(padding + e.Bounds.X, padding + e.Bounds.Y, e.Bounds.Width - padding * 2, e.Bounds.Height - padding * 2);

                // Background
                if ((e.State & DrawItemState.Selected) == DrawItemState.Selected)
                {
                    e.Graphics.FillRectangle(brushSelected, e.Bounds.X + 1, e.Bounds.Y + 1, e.Bounds.Width - 2, e.Bounds.Height - 2);
                }
                else
                {
                    e.Graphics.FillRectangle(brushNormal, e.Bounds.X + 1, e.Bounds.Y + 1, e.Bounds.Width - 2, e.Bounds.Height - 2);
                }

                // Build the display string
                SongSearchResult ssr = (SongSearchResult)lbSearchResults.Items[e.Index];
                string           s   = ssr.songNumber + ". ";
                if (!ssr.isAtStart)
                {
                    s += "...";
                }
                s += ssr.verseData;

                // Measure and paint highlights
                StringFormat sf = new StringFormat();
                sf.SetMeasurableCharacterRanges(SearchHelper.FindCharacterRanges(s, SearchHelper.BreakSearchTerms(txtFulltextSearch.Text)));
                foreach (Region rg in e.Graphics.MeasureCharacterRanges(s, lbSearchResults.Font, textr, sf))
                {
                    e.Graphics.FillRegion(new SolidBrush(Color.FromArgb(100, Color.Yellow)), rg);
                }

                // Text
                if (ssr.score > 600)
                {
                    e.Graphics.DrawString(s, lbSearchResults.Font, new SolidBrush(Color.FromArgb(80, 80, 80)), textr, sf);
                }
                else
                {
                    e.Graphics.DrawString(s, lbSearchResults.Font, Brushes.Black, textr, sf);
                }
            }
        }
Пример #4
0
        private void lbSearchResults_MeasureItem(object sender, MeasureItemEventArgs e)
        {
            if (e.Index > -1 && e.Index < lbSearchResults.Items.Count)
            {
                // Build the display string
                SongSearchResult ssr = (SongSearchResult)lbSearchResults.Items[e.Index];
                string           s   = ssr.songNumber + ". ";
                if (!ssr.isAtStart)
                {
                    s += "...";
                }
                s += ssr.verseData;

                int padding = 3;
                int h       = (int)e.Graphics.MeasureString(s, lbSearchResults.Font, lbSearchResults.Width - padding * 2).Height;
                e.ItemHeight = h + padding * 2;
            }
        }
Пример #5
0
        private void lbSearchResults_DoubleClick(object sender, EventArgs e)
        {
            if (lbSearchResults.SelectedIndex == -1)
            {
                return;
            }

            // Start the song
            SongSearchResult ssr = (SongSearchResult)lbSearchResults.SelectedItem;
            int autoNumber       = ssr.autoNumber;

            dvSongs.RowFilter = "AutoNumber = " + autoNumber;
            if (dvSongs.Count > 0)
            {
                currentSong = (PresenterDataset.SongsRow)dvSongs[0].Row;
                StartProject(true);
            }
        }