Esempio n. 1
0
        public static List <Contact> FindUsers(string searchFor, string except) // nie odnajdujemy loginu dla użytkownika który jest wyszukującym
        {
            List <Contact>   usersFound  = new List <Contact>();
            string           commandText = "SELECT Login, Name FROM Users";
            SQLiteDataReader reader      = ExecuteReader(commandText);

            while (reader.Read())
            {
                string login = reader["Login"].ToString();
                if (login != except)
                {
                    string name = reader["Name"].ToString();
                    if (LevenshteinDistance.AreSimilar(searchFor, login) || LevenshteinDistance.AreSimilar(searchFor, name))
                    {
                        usersFound.Add(new Contact(login, name));
                    }
                }
            }
            reader.Close();
            return(usersFound);
        }