Example #1
0
        /*
         * Navigation links and keeps window size consistent among windows
         */
        private void ListViewMenu_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            switch (((ListViewItem)((ListView)sender).SelectedItem).Name)
            {
            case "Home":
                MainWindow main = new MainWindow(username);
                main.Height = this.ActualHeight;
                main.Width  = this.ActualWidth;
                main.Top    = this.Top;
                main.Left   = this.Left;
                main.WindowStartupLocation = this.WindowStartupLocation;
                if (this.WindowState == System.Windows.WindowState.Maximized)
                {
                    main.WindowState = System.Windows.WindowState.Maximized;
                }
                main.Show();
                this.Close();
                break;

            case "Events":
                EventScreen events = new EventScreen(username);
                events.Height = this.ActualHeight;
                events.Width  = this.ActualWidth;
                events.Top    = this.Top;
                events.Left   = this.Left;
                events.WindowStartupLocation = this.WindowStartupLocation;
                if (this.WindowState == System.Windows.WindowState.Maximized)
                {
                    events.WindowState = System.Windows.WindowState.Maximized;
                }
                events.Show();
                this.Close();
                break;

            case "Friends":
                FriendScreen friend = new FriendScreen(username);
                friend.Height = this.ActualHeight;
                friend.Width  = this.ActualWidth;
                friend.Top    = this.Top;
                friend.Left   = this.Left;
                friend.WindowStartupLocation = this.WindowStartupLocation;
                if (this.WindowState == System.Windows.WindowState.Maximized)
                {
                    friend.WindowState = System.Windows.WindowState.Maximized;
                }
                friend.Show();
                this.Close();
                break;

            case "Memories":
                MemoriesScreen memories = new MemoriesScreen(username);
                memories.Height = this.ActualHeight;
                memories.Width  = this.ActualWidth;
                memories.Top    = this.Top;
                memories.Left   = this.Left;
                memories.WindowStartupLocation = this.WindowStartupLocation;
                if (this.WindowState == System.Windows.WindowState.Maximized)
                {
                    memories.WindowState = System.Windows.WindowState.Maximized;
                }
                memories.Show();
                this.Close();
                break;

            case "Discover":
                DiscoverScreen discover = new DiscoverScreen(username);
                discover.Height = this.ActualHeight;
                discover.Width  = this.ActualWidth;
                discover.Top    = this.Top;
                discover.Left   = this.Left;
                discover.WindowStartupLocation = this.WindowStartupLocation;
                if (this.WindowState == System.Windows.WindowState.Maximized)
                {
                    discover.WindowState = System.Windows.WindowState.Maximized;
                }
                discover.Show();
                this.Close();
                break;

            case "Settings":
                SettingsScreen settings = new SettingsScreen(username);
                settings.Height = this.ActualHeight;
                settings.Width  = this.ActualWidth;
                settings.Top    = this.Top;
                settings.Left   = this.Left;
                settings.WindowStartupLocation = this.WindowStartupLocation;
                if (this.WindowState == System.Windows.WindowState.Maximized)
                {
                    settings.WindowState = System.Windows.WindowState.Maximized;
                }
                settings.Show();
                this.Close();
                break;

            case "Logout":
                LoginScreen login = new LoginScreen();
                login.Show();
                this.Close();
                break;

            default:
                break;
            }
        }
        /*
         * deletes account and all everything associated with it
         */
        private void deleteAccount(object sender, RoutedEventArgs e)
        {
            if (currentPassword.Equals(confirmPassword.Password) && username.Equals(confirmUsername.Text))
            {
                String CmdString = string.Empty;
                using (SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB; Initial Catalog=LoginDB; Integrated Security=True;"))
                {
                    cnn.Open();
                    CmdString = "DELETE FROM Users WHERE UserName = @username";

                    SqlCommand cmd = new SqlCommand(CmdString, cnn);
                    // values are retrieve from variables defined in program
                    cmd.Parameters.AddWithValue("@username", username);
                    cmd.ExecuteNonQuery();
                }

                CmdString = string.Empty;
                using (SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB; Initial Catalog=LoginDB; Integrated Security=True;"))
                {
                    cnn.Open();
                    CmdString = "DELETE FROM BucketList WHERE UserName = @username";

                    SqlCommand cmd = new SqlCommand(CmdString, cnn);
                    // values are retrieve from variables defined in program
                    cmd.Parameters.AddWithValue("@username", username);
                    cmd.ExecuteNonQuery();
                }

                CmdString = string.Empty;
                using (SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB; Initial Catalog=LoginDB; Integrated Security=True;"))
                {
                    cnn.Open();
                    CmdString = "DELETE FROM Friends WHERE UserName = @username";

                    SqlCommand cmd = new SqlCommand(CmdString, cnn);
                    // values are retrieve from variables defined in program
                    cmd.Parameters.AddWithValue("@username", username);
                    cmd.ExecuteNonQuery();
                }

                CmdString = string.Empty;
                using (SqlConnection cnn = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB; Initial Catalog=LoginDB; Integrated Security=True;"))
                {
                    cnn.Open();
                    CmdString = "DELETE FROM Image WHERE UserName = @username";

                    SqlCommand cmd = new SqlCommand(CmdString, cnn);
                    // values are retrieve from variables defined in program
                    cmd.Parameters.AddWithValue("@username", username);
                    cmd.ExecuteNonQuery();
                }

                LoginScreen login = new LoginScreen();
                login.Show();
                this.Close();
            }
            else
            {
                MessageBox.Show("Credentials Incorrect");
            }
        }