Beispiel #1
0
        public UserForClient GetUser(string Email)
        {
            User userFromDB = new User();

            userFromDB.Email = Email;
            string sql = "SELECT * FROM Users WHERE Email=@Email ";

            DB.PullFromDB(sql,
                          (cmd) => cmd.Parameters.AddWithValueCheckNull("@Email", userFromDB.Email),
                          (dr) => userFromDB = new User(dr));

            UserForClient user = new UserForClient(userFromDB);

            return(user);
        }
Beispiel #2
0
        public bool Delete(string Email)
        {
            UserForClient user           = GetUser(Email);
            string        UserPermission = user.UserPermission;
            bool          delete         = DB.ExecuteCommand("DELETE FROM Users WHERE Email = @Email",
                                                             (cmd) => cmd.Parameters.AddWithValue("@Email", Email)) == 1;

            if (delete)
            {
                UserForClient.DeleteUser(Email, UserPermission);
                return(true);
            }

            return(false);
        }