示例#1
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            User user = new User();

            var query = (from c in db.Competitions
                         join m in db.Members on c.airc_id equals m.airc_id
                         join rc in db.Clubs on c.club_id equals rc.club_id
                         where c.competition_status == "S" && c.competition_date >= currentDate &&
                         c.competition_date.Year == currentyear
                         orderby c.competition_date ascending
                         select new
            {
                next_competition_date = c.competition_date,
                c.competition_id,
                c.competition_name,
                c.competition_type,
                competition_venue = c.venue,
                Secretary = c.Member.first_name + " " + c.Member.last_name,
                hosting_club = c.Club.clubname,
                c.club_id,
                secretary_airc_id = m.airc_id
            }).Take(1);

            foreach (var record in query)
            {
                tbxCompetitionDate.Text      = record.next_competition_date.ToString();
                tbxCompetitionName.Text      = record.competition_name;
                tbxCompetitionVenue.Text     = record.competition_venue;
                tbxCompetitionSecretary.Text = record.Secretary;
                tbxHostingClub.Text          = record.hosting_club;
                club_id           = record.club_id;
                competition_id    = record.competition_id;
                competition_type  = record.competition_type;
                secretary_airc_id = record.secretary_airc_id;
            }


            if (member_role == "M")
            {
                btnAddClub.Visibility                   = Visibility.Collapsed;
                btnAddCompetition.Visibility            = Visibility.Collapsed;
                btnListNewMembers.Visibility            = Visibility.Collapsed;
                btnModifyMemberDetails.Visibility       = Visibility.Collapsed;
                btnModifyMyDetails.Visibility           = Visibility.Visible;
                btnOpenCompetition.Visibility           = Visibility.Collapsed;
                btnViewLeaderboard.Visibility           = Visibility.Visible;
                btnViewReports.Visibility               = Visibility.Visible;
                btnViewScheduledCompetitions.Visibility = Visibility.Visible;
                btnOpenCompetition.Visibility           = Visibility.Collapsed;
            }

            if (member_role == "S")
            {
                btnAddClub.Visibility                   = Visibility.Collapsed;
                btnAddCompetition.Visibility            = Visibility.Visible;
                btnListNewMembers.Visibility            = Visibility.Visible;
                btnModifyMemberDetails.Visibility       = Visibility.Visible;
                btnModifyMyDetails.Visibility           = Visibility.Visible;
                btnOpenCompetition.Visibility           = Visibility.Collapsed;
                btnViewLeaderboard.Visibility           = Visibility.Visible;
                btnViewReports.Visibility               = Visibility.Visible;
                btnViewScheduledCompetitions.Visibility = Visibility.Visible;
                btnOpenCompetition.Visibility           = Visibility.Collapsed;
            }

            if (member_role == "A")
            {
                btnAddClub.Visibility                   = Visibility.Visible;
                btnAddCompetition.Visibility            = Visibility.Visible;
                btnListNewMembers.Visibility            = Visibility.Visible;
                btnModifyMemberDetails.Visibility       = Visibility.Visible;
                btnModifyMyDetails.Visibility           = Visibility.Visible;
                btnViewLeaderboard.Visibility           = Visibility.Visible;
                btnViewReports.Visibility               = Visibility.Visible;
                btnViewScheduledCompetitions.Visibility = Visibility.Visible;
                btnOpenCompetition.Visibility           = Visibility.Collapsed;
            }

            //if (tbxCompetitionDate.Text.ToString() == currentDate.ToString() )
            //{
            if (secretary_airc_id == airc_id)
            {
                btnOpenCompetition.Visibility = Visibility.Visible;
            }
            //}



            MainDashboard maindashboard = new MainDashboard();
        }
示例#2
0
        private void BtnSubmit_Click(object sender, RoutedEventArgs e)
        {
            string currentUser     = tbxUsername.Text;
            string currentPassword = tbxPassword.Password;

            if (activeTab == "Logon")
            {
                //var query = (from c in db.Competitions
                //             join m in db.Members on c.airc_id equals m.airc_id
                //             join rc in db.Clubs on c.club_id equals rc.club_id
                //             where c.competition_status == "S" && c.competition_date >= currentDate
                //             && c.competition_date.Year == currentyear
                //             orderby c.competition_date ascending
                //             select new
                //             {
                //                 next_competition_date = c.competition_date,
                //                 c.competition_id,
                //                 c.competition_name,
                //                 c.competition_type,
                //                 competition_venue = c.venue,
                //                 Secretary = c.Member.first_name + " " + c.Member.last_name,
                //                 hosting_club = c.Club.clubname
                //             }).Take(1);

                var query = (from u in db.Users
                             join m in db.Members on u.airc_id equals m.airc_id
                             where u.username == tbxUsername.Text &&
                             u.userpassword == tbxPassword.Password
                             select new
                {
                    m.role,
                    u.username,
                    u.userpassword,
                    u.airc_id
                });

                foreach (var record in query)
                {
                    //LoggedInUser = User.airc_id;
                    MainDashboard maindashboard = new MainDashboard();
                    this.Hide();
                    close = true;
                    maindashboard.tbxUsername.Text = record.username;
                    maindashboard.airc_id          = record.airc_id;
                    maindashboard.member_role      = record.role;
                    maindashboard.ShowDialog();
                }
                // By Default if we reach here that means we have an invalid username and/or password entered
                if (close == false)
                {
                    MessageBox.Show($"Incorrect username or Password");
                }
            }
            else if (activeTab == "Register")
            {
                // call Register user Class
                airc_id = Convert.ToInt16(tbxAIRC_ID.Text.Trim());
                string role         = "M"; //Role is Member
                string memberStatus = "N"; //Member status is "N" for new Membe


                RegisterUser(
                    airc_id,
                    currentUser,
                    currentPassword);

                SaveRegistration();

                RegisterMember(
                    airc_id,
                    club_id,
                    memberStatus,
                    role,
                    tbxFirstname.Text.Trim(),
                    tbxLastName.Text.Trim(),
                    DRgrade.Trim(),
                    SJgrade.Trim(),
                    XCgrade.Trim(),
                    tbxPhone.Text,
                    tbxEmail.Text);

                //     SaveRegistration();

                MessageBox.Show($"Your user {currentUser} has been saved. Please login again with your username and password");
                this.Close();
            }
        }