コード例 #1
0
ファイル: wts.aspx.cs プロジェクト: bashtech/ivote-teama
    protected void Page_Load(object sender, EventArgs e)
    {
        string position = Request.QueryString["position"];
        int positionID;

        if (position != null && int.TryParse(position, out positionID))
        {
            positionTitle = dbLogic.selectPositionFromID(positionID.ToString());

            LabelHeader.Text = positionTitle;
            HiddenFieldPosition.Value = positionTitle;

            ISession session = DatabaseEntities.NHibernateHelper.CreateSessionFactory().OpenSession();
            userObject = DatabaseEntities.User.FindUser(session, Page.User.Identity.Name.ToString());
            id = userObject.ID.ToString();

            if(dbLogic.isUserWTS(int.Parse(id), HiddenFieldPosition.Value)) {
                Fieldset2.Visible = false;
                Confirm.Visible = true;
                return;
            }

            //ds = dbLogic.getResults();
            info = new string[3] { id, id, HiddenFieldPosition.Value };

            if (!String.IsNullOrEmpty(positionTitle))
                Submit.Enabled = true;
        } else
            throw new HttpException(400, "Invalid position ID");
    }
コード例 #2
0
ファイル: Default.aspx.cs プロジェクト: bashtech/ivote-teama
    protected void createUser_Click(object sender, EventArgs e)
    {
        if (!Page.IsValid)
            return;
        ISession session = DatabaseEntities.NHibernateHelper.CreateSessionFactory().OpenSession();
        ITransaction transaction = session.BeginTransaction();

        DatabaseEntities.User user = new DatabaseEntities.User();
        user.FirstName = "Default";
        user.LastName = "Admin";
        user.Email = email.Text;
        user.Password = DatabaseEntities.User.Hash(password.Text);
        user.PasswordHint = "";
        user.CanVote = false;
        user.CurrentCommittee = -1;
        user.Department = DepartmentType.Staff;
        user.IsAdmin = true;
        user.IsBargainingUnit = false;
        user.IsNEC = false;
        user.IsTenured = false;
        user.IsUnion = false;
        user.LastLogin = DateTime.Now;
        user.CanVote = false;

        DatabaseEntities.NHibernateHelper.UpdateDatabase(session, user);

        DatabaseEntities.NHibernateHelper.Finished(transaction);

        createUserStatus.Visible = true;
        createUser.Enabled = false;
    }
コード例 #3
0
    protected void Certify_Click(Object sender, EventArgs e)
    {
        ITransaction transaction = session.BeginTransaction();
        user = DatabaseEntities.User.FindUser(session, User.Identity.Name);
        // If the confirmation box is ticked, submit the certification
        if (CertifyCheckBox.Checked == true)
        {
            Certification certification = new Certification();
            certification.Election = election.ID;
            certification.User = user.ID;
            session.SaveOrUpdate(certification);
            session.Flush();
            CertifyCheckBox.Visible = false;
            CertifyButton.Visible = false;
            CertifyWarning.Visible = false;
            NECCertifyAgreement.Visible = false;
            NECCertificationComplete.Visible = true;
        }
        else // otherwise display the error label
            CertifyWarning.Visible = true;

        NHibernateHelper.Finished(transaction);
    }
コード例 #4
0
ファイル: Register.aspx.cs プロジェクト: bashtech/ivote-teama
    private User CreateUser(String email, String firstName, String lastName, String department)
    {
        DatabaseEntities.User user = new DatabaseEntities.User();
        user.FirstName = firstName;
        user.LastName = lastName;
        user.Email = email;
        user.Password = DatabaseEntities.User.Hash("");
        user.PasswordHint = "";

        user.LastLogin = DateTime.Now;

        user.CurrentCommittee = Convert.ToInt32(CurrentCommittee.SelectedValue);
        user.Department = (DepartmentType)Enum.Parse(typeof(DepartmentType), department);

        return user;
    }
コード例 #5
0
ファイル: Committee.cs プロジェクト: bashtech/ivote-teama
 /// <summary>
 /// This function takes the specified user off the committee with the
 /// specified ID.
 /// </summary>
 /// <param name="session">A valid session.</param>
 /// <param name="user">The user to remove</param>
 /// <param name="id">The ID of the committee the user is being removed from.</param>
 public static void RemoveMember(ISession session, User user, int id)
 {
     user.CurrentCommittee = User.NoCommittee;
     session.SaveOrUpdate(user);
     session.Flush();
 }
コード例 #6
0
        public static void AddMembersToSingleCommitteeOnly()
        {
            Console.Write("Add Members to Single Committee Only:\n");
            ISessionFactory factory = NHibernateHelper.CreateSessionFactory();
            // Clear out database
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    Clear(session, transaction);
                }
            }
            // Pre-requisites
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    // create 1st committee
                    Console.Write("Create committee with 2 positions.\n");
                    Committee com = new Committee();
                    com.Name = "Acommittee";
                    com.PositionCount = 2;
                    session.SaveOrUpdate(com);

                    // add 2 users who are tenured and union members who are on
                    // the committee
                    Console.Write("Create 2 users and add them to the first committee.\n");
                    User[] users = new User[2];
                    for (int i = 0; i < 2; i++)
                    {
                        users[i] = User.CreateUser("e", i.ToString() + "F",
                            i.ToString() + "L", "p", "h", false, false, true, true,
                            false, DepartmentType.CSC, OfficerPositionType.None, true,
                            User.NoCommittee);
                        session.SaveOrUpdate(users[i]);
                        users[i].AddToCommittee(session, "Acommittee");
                    }

                    // create 2nd committee
                    Console.Write("Create another committee with 2 positions.\n");
                    Committee bcom = new Committee();
                    bcom.Name = "Bcommittee";
                    bcom.PositionCount = 2;
                    session.SaveOrUpdate(bcom);

                    transaction.Commit();
                }
            }
            // More pre-requisites
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    Console.Write("Try to add one of the users to the second committee.\n");
                    List<User> users = User.GetAllUsers(session);
                    User toAdd = users[0];
                    toAdd.AddToCommittee(session, "Bcommittee");
                    transaction.Commit();
                }
            }
            // Assertions
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    // assert that both users' committee fields reference the
                    // original committee
                    List<User> users = User.GetAllUsers(session);
                    Committee a = Committee.FindCommittee(session, "Acommittee"),
                        b = Committee.FindCommittee(session, "Bcommittee");

                    Assert.AreEqual(a.ID, users[0].CurrentCommittee);
                    Assert.AreEqual(a.ID, users[1].CurrentCommittee);

                    Assert.AreEqual(0, a.NumberOfVacancies(session));
                    Assert.AreEqual(2, b.NumberOfVacancies(session));

                    Assert.AreEqual(2, a.NumberOfPositions(session));
                    Assert.AreEqual(0, b.NumberOfPositions(session));
                }
            }
        }
コード例 #7
0
        public static void TestCommitteeCreationFailure()
        {
            Console.Write("Test Committee Election Failure:\n");
            ISessionFactory factory = NHibernateHelper.CreateSessionFactory();
            // Clear out database
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    Clear(session, transaction);
                }
            }

            // Pre-requisites
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    // create a committee: 3 positions, 3 filled
                    Console.Write("Create committee with 3 positions.\n");
                    Committee com = new Committee();
                    com.Name = "Acommittee";
                    com.PositionCount = 3;
                    session.SaveOrUpdate(com);
                    // add 3 users who are tenured and union members who are on
                    // the committee
                    Console.Write("Create 3 users and give them positions in the committee.\n");
                    User[] users = new User[3];
                    for (int i = 0; i < 3; i++)
                    {
                        users[i] = User.CreateUser("e", i.ToString() + "F",
                            i.ToString() + "L", "p", "h", false, false, true, true,
                            false, DepartmentType.CSC, OfficerPositionType.None, true,
                            com.ID);
                        session.SaveOrUpdate(users[i]);
                    }
                    transaction.Commit();
                }
                // Assertions
                using (ITransaction transaction = session.BeginTransaction())
                {
                    Console.Write("Attempting to create an election based off the committee.\n");
                    Committee com = Committee.FindCommittee(session, "Acommittee");
                    CommitteeElection election =
                        CommitteeElection.CreateElection(session, com);
                    Console.Write("CommitteeElection value (should be null): ");
                    Assert.AreEqual(null, election);
                }
            }
        }
コード例 #8
0
        public static void InitiateCommitteeElection()
        {
            Console.Write("Initial Committee Election:\n");
            // Set up pre-conditions
            ISessionFactory factory = NHibernateHelper.CreateSessionFactory();
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    // clear the databse first
                    Clear(session, transaction);
                }
                using (ITransaction transaction = session.BeginTransaction())
                {
                    // add an admin user
                    Console.Write("Create admin user.\n");
                    User user = User.CreateUser("e", "f", "l", "p", "h", true, false,
                        false, false, false, DepartmentType.CSC,
                        OfficerPositionType.None, false, -1);
                    session.SaveOrUpdate(user);

                    // create a committee: 4 positions, 3 filled
                    Console.Write("Create committee with 4 positions.\n");
                    Committee com = new Committee();
                    com.Name = "Acommittee";
                    com.PositionCount = 4;
                    session.SaveOrUpdate(com);

                    // add 3 users who are tenured and union members who are on
                    // the committee
                    Console.Write("Create 3 users and give them positions in the committee.\n");
                    User[] users = new User[3];
                    for (int i = 0; i < 3; i++)
                    {
                        users[i] = User.CreateUser("e", i.ToString() + "F",
                            i.ToString() + "L", "p", "h", false, false, true, true,
                            false, DepartmentType.CSC, OfficerPositionType.None, true,
                            com.ID);
                        session.SaveOrUpdate(users[i]);
                    }
                    transaction.Commit();
                }
                using (ITransaction transaction = session.BeginTransaction())
                {
                    Console.Write("Create an election based off the committee.\n");
                    Committee com = Committee.FindCommittee(session, "Acommittee");
                    CommitteeElection election =
                        CommitteeElection.CreateElection(session, com);
                    session.SaveOrUpdate(election);
                    transaction.Commit();
                }
            }
            // Assertions
            using (ISession session = factory.OpenSession())
            {
                using (ITransaction transaction = session.BeginTransaction())
                {
                    Console.Write("Election object's phase is WTSPhase: ");
                    Assert.AreEqual(ElectionPhase.WTSPhase, CommitteeElection.FindElection(session, "Acommittee").Phase);

                    int vacancies = CommitteeElection.FindElection(session, "Acommittee").VacanciesToFill;
                    Assert.AreEqual(1, vacancies);

                    // Put email stuff here
                }
            }
        }
コード例 #9
0
 protected void Page_Load(object sender, EventArgs e)
 {
     ISession session = DatabaseEntities.NHibernateHelper.CreateSessionFactory().OpenSession();
     user = GetUser(session);
     is_admin = user.IsAdmin;
 }
コード例 #10
0
ファイル: User.cs プロジェクト: bashtech/ivote-teama
 /// <summary>
 /// Hashes and then updates a user's password.
 /// </summary>
 /// <param name="session">A valid session.</param>
 /// <param name="ID">The ID of the user whose password is to be set.</param>
 /// <param name="password">The new password.</param>
 /// <param name="passwordHint">The new password hint.</param>
 public static void UpdatePassword(ISession session, User user,
     string password, string passwordHint)
 {
     user.Password = Hash(password);
     user.PasswordHint = passwordHint;
     session.SaveOrUpdate(user);
     session.Flush();
 }
コード例 #11
0
ファイル: User.cs プロジェクト: bashtech/ivote-teama
        /// <summary>
        /// This function imports all the the users in a .accdb file which is
        /// formatted like the example file Karen gave to us.  The .accdb
        /// will just be on the server.
        /// </summary>
        /// <param name="session">A valid session.</param>
        /// <param name="filePath"></param>
        /// <returns>True if the import was successful, false otherwise.</returns>
        public static bool ImportUsers(ISession session, string filePath)
        {
            DataSet data = new DataSet();
            using (OleDbConnection connection =
                new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Persist Security Info=False;"))
            {
                OleDbCommand command = new OleDbCommand("SELECT * FROM Faculty",connection);
                OleDbDataAdapter adapter = new OleDbDataAdapter(command);

                try
                {
                    connection.Open();
                    adapter.Fill(data, "Faculty");
                }
                catch(Exception e)
                {
                    return false;
                }
                connection.Close();
            }
            DataRowCollection rows = data.Tables["Faculty"].Rows;
            foreach (DataRow row in rows)
            {
                User user = new User();
                user.LastName = row.Field<string>("Last");
                user.FirstName = row.Field<string>("First");

                user.Department = User.GetDepartment(row.Field<string>("Department"));
                if (user.Department == DepartmentType.None)
                    return false;

                // Im assuming N = not tenured
                // T = tenured
                // O = I don't know but im marking it in as not tenured for now.
                string tenured = row.Field<string>("Tenure");
                user.IsTenured = (tenured == "T") ? true : false;
                // this field is either 1 or 2.  Im assuming 2 means they aren't tenured
                user.IsUnion = (row.Field<Int16?>("Union") == 1) ? true : false;

                user.Email = row.Field<string>("Email");
                if(string.IsNullOrEmpty(user.Email))
                    user.Email = "Please retrieve the email for this user.";

                user.Password = User.Hash(User.DefaultPassword);
                user.PasswordHint = "Please see the email you recieved in regards to signing up on the iVote system.";
                user.LastLogin = DateTime.Now;
                user.OfficerPosition = OfficerPositionType.None;
                user.IsFaculty = true;
                user.IsAdmin = false;
                user.IsBargainingUnit = false;
                user.IsNEC = false;
                user.CanVote = true;
                user.CurrentCommittee = User.NoCommittee;

                session.SaveOrUpdate(user);
            }
            session.Flush();
            return true;
        }
コード例 #12
0
ファイル: User.cs プロジェクト: bashtech/ivote-teama
 // Helper functions
 /// <summary>
 /// Creates a new user object with the specified values
 /// </summary>
 /// <param name="email">The user's email</param>
 /// <param name="first">The user's first name</param>
 /// <param name="last">The user's last name</param>
 /// <param name="password">The user's password to be hashed</param>
 /// <param name="passwordHint">The user's password hint</param>
 /// <param name="isAdmin">Whether ot not the user is an admin</param>
 /// <param name="isNEC">Whether or not the user is an NEC member</param>
 /// <param name="isFaculty">Whether or not the user is an faculty member</param>
 /// <param name="isTenured">Whether or not the user is tenured</param>
 /// <param name="isUnion">Whether or not the user is in APSCUF</param>
 /// <param name="isBargainingUnit">Whether or not the user is in a bargainingunit committee</param>
 /// <param name="department">The department the faculty member is in</param>
 /// <param name="officerPosition">The officer position of the user</param>
 /// <param name="canVote">Whether or not the user can vote</param>
 /// <param name="currentCommittee">The committee this user serves on</param>
 /// <returns>Returns a user object with the specified officer position</returns>
 public static User CreateUser(string email, string first, string last, string password,
     string passwordHint, bool isAdmin, bool isNEC, bool isFaculty,bool isTenured, bool isUnion,
     bool isBargainingUnit, DepartmentType department,
     OfficerPositionType officerPosition, bool canVote, int currentCommittee)
 {
     User ret = new User();
     ret.Email = email;
     ret.FirstName = first;
     ret.LastName = last;
     ret.Password = Hash(password);
     ret.PasswordHint = passwordHint;
     ret.IsAdmin = isAdmin;
     ret.IsNEC = isNEC;
     ret.IsFaculty = isFaculty;
     ret.IsTenured = isTenured;
     ret.IsUnion = isUnion;
     ret.IsBargainingUnit = isBargainingUnit;
     ret.Department = department;
     ret.OfficerPosition = officerPosition;
     ret.CanVote = canVote;
     ret.CurrentCommittee = currentCommittee;
     return ret;
 }
コード例 #13
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["id"] == null ||
            Request.QueryString["id"] == "")
            throw new HttpException(400, "Invalid election ID");

        ElectionID = int.Parse(Request.QueryString["id"]);

        session = NHibernateHelper.CreateSessionFactory().OpenSession();

        // grab the objects based off the committee ID
        election = CommitteeElection.FindElection(session, ElectionID);
        if (election == null)
            Response.Redirect("home.aspx#election_not_found");
        committee = Committee.FindCommittee(session, election.PertinentCommittee);
        if (committee == null)
            Response.Redirect("home.aspx#committee_not_found");

        VacancyCount.Text = election.VacanciesToFill.ToString();
        CommitteeNameLiteral.Text = committee.Name;
        CommitteeNameLiteral2.Text = committee.Name;
        CommitteeDescription.Text = committee.Description;
        must_be_tenured.Visible = committee.TenureRequired;

        user = DatabaseEntities.User.FindUser(session, User.Identity.Name);

        MakeElectionSpecial.Visible = user.IsAdmin;

        // expose the pertinent panel based on the state of the election.
        switch (election.Phase)
        {
            case ElectionPhase.WTSPhase:
                //*******************************
                //****** Faculty WTS Load *******
                //*******************************
                //Check if WTS already exists
                List<DatabaseEntities.CommitteeWTS> wtsList = DatabaseEntities.CommitteeWTS.FindCommitteeWTS(session, election.ID);
                bool wtsAlreadySubmitted = false;
                foreach (DatabaseEntities.CommitteeWTS wts in wtsList)
                {
                    if (wts.Election == election.ID && wts.User == user.ID &&
                        (!committee.TenureRequired || user.IsTenured) &&
                        (!committee.BargainingUnitRequired || user.IsBargainingUnit))
                        wtsAlreadySubmitted = true;
                }

                if(user.CurrentCommittee == committee.ID) {
                    wtsPanelServing.Visible = true;
                    wtsPanelNew.Visible = false;
                } else if (wtsAlreadySubmitted &&
                   (!committee.TenureRequired || user.IsTenured) &&
                   (!committee.BargainingUnitRequired || user.IsBargainingUnit))
                {
                    wtsPanelExisting.Visible = true;
                    wtsPanelNew.Visible = false;
                }
                if ((!committee.TenureRequired || user.IsTenured) &&
                    (!committee.BargainingUnitRequired || user.IsBargainingUnit))
                    FacultyWTS.Visible = true;
                //Prevent a user from submitting a WTS if a member from their department is on the committee
                if(DatabaseEntities.Committee.DepartmentRepresented(session, committee, user.Department))
                    FacultyWTS.Visible = false;

                break;
            case ElectionPhase.NominationPhase:
                if(!user.CanVote)
                    break;

                if (CommitteeWTSNomination.FindCommitteeWTSNomination(session,
                    election.ID, user.ID).Count == 0)
                {
                    FacultyNomination.Visible = true;
                    BuildUserNominationOptions();
                }
                else
                    FacultyNominationComplete.Visible = true;
                break;
            case ElectionPhase.VotePhase:
                if(!user.CanVote)
                    break;

                if (BallotFlag.FindBallotFlag(session, election.ID, user.ID) ==
                    null)
                {
                    FacultyVote.Visible = true;
                    BuildUserVoteOptions();
                }
                else
                    FacultyVoteComplete.Visible = true;
                break;
            case ElectionPhase.ClosedPhase:
                if (!user.IsNEC && !user.IsAdmin)
                    FacultyClosed.Visible = true;
                break;
        }

        JulioButtonHider.Visible = user.IsAdmin;
        CancelElection.Visible = user.IsAdmin;

        if (user.IsNEC && election.Phase == ElectionPhase.CertificationPhase)
        {
            ActivateTab("CertificationPhase");
            NECCertificationPanel.Visible = true;
            BuildNECVoteTable();
            if(Certification.FindCertification(session, election.ID, user.ID) != null)
            {
                NECCertifyAgreement.Visible = false;
                CertifyCheckBox.Visible = false;
                CertifyButton.Visible = false;
                CertifyWarning.Visible = false;
                NECCertificationComplete.Visible = true;
            }
        }

        DaysLeftInPhase();
        JulioButton.Text = "Switch to Next Phase";
        switch(election.Phase) {
            case ElectionPhase.WTSPhase:
                PhaseLiteral.Text = "WTS Phase";
                break;
            case ElectionPhase.NominationPhase:
                PhaseLiteral.Text = "Nomination Phase";
                break;
            case ElectionPhase.VotePhase:
                PhaseLiteral.Text = "Voting Phase";
                break;
            case ElectionPhase.CertificationPhase:
                PhaseLiteral.Text = "Certification Phase";
                if(ElectionConflict.FindElectionConflicts(session, election.ID).Count == 0)
                    JulioButton.Text = "Close Election";
                break;
            case ElectionPhase.ConflictPhase:
                PhaseLiteral.Text = "Conflict Resolution Phase";
                JulioButton.Text = "Close Election";
                break;
            case ElectionPhase.ClosedPhase:
                PhaseLiteral.Text = "Closed";
                CancelElection.Visible = false;
                JulioButtonHider.Visible = false;
                break;
        }

        if(user.IsAdmin) {

            ActivateTab(election.Phase.ToString());

            JulioButton.Visible = true;
            JulioButtonSpacerText.Visible = true;
            if(election.Phase >= ElectionPhase.ClosedPhase)
                closed_tab.Visible = true;
            if (election.Phase == ElectionPhase.ConflictPhase)
            {
                List<ElectionConflict> conflicts = ElectionConflict.FindElectionConflicts(session, election.ID);
                foreach (ElectionConflict conflict in conflicts)
                {
                    DatabaseEntities.User conflictUser1 =
                        DatabaseEntities.User.FindUser(session, conflict.FirstUser);
                    if (conflict.Type == ConflictType.ElectedToMultipleCommittees)
                        BuildMultipleCommitteesConflictPanel(conflictUser1, conflict.ID);
                    if (conflict.Type == ConflictType.TooManyDeptMembers)
                    {
                        DatabaseEntities.User conflictUser2 =
                        DatabaseEntities.User.FindUser(session, conflict.SecUser);
                        BuildTooManyDeptConflictPanel(conflictUser1,
                            conflictUser2, conflictUser2.Department, conflict.ID);
                    }
                }
                JulioButton.Visible = conflicts.Count == 0;
                JulioButtonSpacerText.Visible = conflicts.Count == 0;
                if (conflicts.Count == 0)
                    AdminNoConflicts.Visible = true;
                else
                    DaysRemaining.Text = "The election cannot be closed while conflicts are present.";

                conflicts_tab.Visible = true;
            }

            if (election.Phase >= ElectionPhase.CertificationPhase)
            {
                int numberCertifications = Certification.FindCertifications(session, election.ID).Count;
                string req_certs = System.Configuration.ConfigurationManager.AppSettings["required_nec_certs"];
                int nec_certs = req_certs != null ? int.Parse(req_certs) : 3;

                AdminCertCount.Text = "There are currently " + numberCertifications.ToString();
                if (numberCertifications >= nec_certs) // TODO: Add a button to advance to the next phase.
                    AdminCertCount.Text += " certifications, which is enough to proceed to the next stage.";
                else
                    AdminCertCount.Text += " certification(s).  More NEC members must certify the results before proceeding.";
                certifications_tab.Visible = true;
                necprogressbar.Attributes.Add("style", "width: " + Math.Min(100, numberCertifications * (100 / nec_certs)).ToString() + "%");

                if(numberCertifications < nec_certs) {
                    HtmlGenericControl pretext = new HtmlGenericControl("span");
                    pretext.InnerText = certifications_tab_link.Text;
                    certifications_tab_link.Controls.Add(pretext);

                    HtmlGenericControl badge = new HtmlGenericControl("span");
                    badge.Attributes["class"] = "badge badge-info";
                    badge.Attributes["style"] = "margin-left: 0.5em;";
                    badge.InnerText = numberCertifications.ToString();
                    certifications_tab_link.Controls.Add(badge);
                }

            }
            if (election.Phase >= ElectionPhase.VotePhase)
            {
                votes_tab.Visible = true;
                BuildAdminVoteTable();
            }
            if (election.Phase >= ElectionPhase.NominationPhase)
            {
                nominations_tab.Visible = true;
                BuildAdminNominationTable();
            }
            if(election.Phase >= ElectionPhase.WTSPhase &&
               election.Phase < ElectionPhase.ClosedPhase)
                wts_tab.Visible = true;

            //*******************************
            //******** Admin WTS Load *******
            //*******************************

            List<DatabaseEntities.CommitteeWTS> wtsList = DatabaseEntities.CommitteeWTS.FindCommitteeWTS(session, election.ID);

            foreach (DatabaseEntities.CommitteeWTS wts in wtsList)
            {
                DatabaseEntities.User wtsUser = DatabaseEntities.User.FindUser(session, wts.User);
                if(wtsUser == null)
                    continue;

                TableRow tr = new TableRow();

                Label revokeNameLabel = new Label();
                revokeNameLabel.Text = wtsUser.FirstName + " " + wtsUser.LastName;
                TableCell td1 = new TableCell();
                td1.Controls.Add(revokeNameLabel);

                Label revokeDeptLabel = new Label();
                revokeDeptLabel.Text = wtsUser.Department.ToString();
                TableCell td2 = new TableCell();
                td2.Controls.Add(revokeDeptLabel);

                Button revokeButton = new Button();
                revokeButton.Text = "Revoke";
                revokeButton.CssClass = "btn btn-danger btn-small";
                revokeButton.CommandArgument = wts.User.ToString();
                revokeButton.Click += new System.EventHandler(this.wtsRevoke_Click);
                TableCell td3 = new TableCell();
                td3.Controls.Add(revokeButton);

                tr.Cells.Add(td1);
                tr.Cells.Add(td2);
                tr.Cells.Add(td3);

                wtsAdminTable.Rows.Add(tr);

            }
            if(wtsList.Count == 0) {
                TableRow tr = new TableRow();

                TableCell td1 = new TableCell();
                td1.Controls.Add(new LiteralControl("No WTS forms have been submitted yet."));
                td1.ColumnSpan = 3;
                tr.Controls.Add(td1);

                wtsAdminTable.Rows.Add(tr);
            }
        }
    }