Пример #1
0
        public bool ValidareUser(string user, out string ErrorMessage)
        {
            //TO DO: Verficarea existaentei aceluiasi user in momentul inregistrarii
            var input = user;

            ErrorMessage = string.Empty;
            OleDbCommand    cmdSelect;
            OleDbDataReader reader;
            ConectareBD     conectare = new ConectareBD();
            OleDbConnection conn      = conectare.ConectareBazDate();

            if (string.IsNullOrWhiteSpace(input))
            {
                ErrorMessage = "Trebuie sa adaugi un nume de utilizator";
                return(false);
            }
            else
            {
                conn.Open();
                cmdSelect = new OleDbCommand("SELECT User, Parola FROM Conturi where Conturi.User = '******'", conn);

                reader = cmdSelect.ExecuteReader();

                if (reader.HasRows)
                {
                    ErrorMessage = "User-ul este deja folosit";
                    return(false);
                }
            }

            return(true);
        }