Example #1
0
        /// <summary>
        /// Fetch data from the db based on the current filter.
        /// </summary>
        public void FetchData()
        {
            pDAO = new PollingStationDAO(DigitalVoterList.GetDefaultInstance());
            mDAO = new MunicipalityDAO(DigitalVoterList.GetDefaultInstance());
            vDAO = new VoterDAO(DigitalVoterList.GetDefaultInstance());

            VoterFilter f = this.Filter;

            if (f.CPRNO != 0)
            {
                this.Voters = vDAO.Read(v => v.PrimaryKey == f.CPRNO);
                VoterDO voter = this.Voters.First();
                this.PollingStations = pDAO.Read(ps => ps.PrimaryKey == voter.PollingStationId);
                PollingStationDO pollingStation = this.PollingStations.First();
                this.Municipalities = mDAO.Read(m => m.PrimaryKey == pollingStation.MunicipalityId);
            }
            else if (f.PollingStation != null)
            {
                this.PollingStations = pDAO.Read(ps => ps.PrimaryKey == f.PollingStation.PrimaryKey);
                this.Voters = vDAO.Read(v => v.PollingStationId == f.PollingStation.PrimaryKey);
                this.Municipalities = mDAO.Read(m => m.PrimaryKey == f.PollingStation.MunicipalityId);
            }
            else if (f.Municipality != null)
            {
                this.Municipalities = mDAO.Read(m => m.PrimaryKey == f.Municipality.PrimaryKey);
                this.PollingStations = pDAO.Read(p => p.MunicipalityId == f.Municipality.PrimaryKey);

                this.Voters = Enumerable.Empty<VoterDO>();
                foreach (var ps in this.PollingStations)
                {
                    PollingStationDO ps1 = ps;
                    this.Voters = this.Voters.Concat(vDAO.Read(v => v.PollingStationId == ps1.PrimaryKey));
                }
            }
        }
Example #2
0
        /// <summary>
        /// Insert the data that was fected onto the remote server.
        /// </summary>
        /// <param name="server">The address of the server.</param>
        /// <param name="port">The port of the server.</param>
        /// <param name="user">The username.</param>
        /// <param name="password">The password.</param>
        public void InsertData(string server, string port, string user, string password)
        {
            foreach (var municipality in this.Municipalities)
            {
                municipality.ResetAssociations();
            }
            foreach (var pollingStation in this.PollingStations)
            {
                pollingStation.ResetAssociations();
            }
            foreach (var voter in this.Voters)
            {
                voter.ResetAssociations();
            }

            var context = DigitalVoterList.GetInstance(user, password, server, port);

            mDAO = new MunicipalityDAO(context);
            pDAO = new PollingStationDAO(context);
            vDAO = new VoterDAO(context);

            mDAO.Create(this.Municipalities);
            pDAO.Create(this.PollingStations);
            vDAO.Create(this.Voters);
        }
        /// <summary>
        /// Fetch data from the db based on the current filter.
        /// </summary>
        public void FetchData()
        {
            pDAO = new PollingStationDAO(DigitalVoterList.GetDefaultInstance());
            mDAO = new MunicipalityDAO(DigitalVoterList.GetDefaultInstance());
            vDAO = new VoterDAO(DigitalVoterList.GetDefaultInstance());

            VoterFilter f = this.Filter;

            if (f.CPRNO != 0)
            {
                this.Voters = vDAO.Read(v => v.PrimaryKey == f.CPRNO);
                VoterDO voter = this.Voters.First();
                this.PollingStations = pDAO.Read(ps => ps.PrimaryKey == voter.PollingStationId);
                PollingStationDO pollingStation = this.PollingStations.First();
                this.Municipalities = mDAO.Read(m => m.PrimaryKey == pollingStation.MunicipalityId);
            }
            else if (f.PollingStation != null)
            {
                this.PollingStations = pDAO.Read(ps => ps.PrimaryKey == f.PollingStation.PrimaryKey);
                this.Voters = vDAO.Read(v => v.PollingStationId == f.PollingStation.PrimaryKey);
                this.Municipalities = mDAO.Read(m => m.PrimaryKey == f.PollingStation.MunicipalityId);
            }
            else if (f.Municipality != null)
            {
                this.Municipalities = mDAO.Read(m => m.PrimaryKey == f.Municipality.PrimaryKey);
                this.PollingStations = pDAO.Read(p => p.MunicipalityId == f.Municipality.PrimaryKey);

                this.Voters = Enumerable.Empty<VoterDO>();
                foreach (var ps in this.PollingStations)
                {
                    PollingStationDO ps1 = ps;
                    this.Voters = this.Voters.Concat(vDAO.Read(v => v.PollingStationId == ps1.PrimaryKey));
                }
            }
        }
Example #4
0
        public void SetUp()
        {
            if (!Directory.Exists(destination))
            {
                Directory.CreateDirectory(destination);
            }

            // Create a municipality
            var mDAO = new MunicipalityDAO();

            mDAO.Create(new MunicipalityDO(9998, "Teststreet 42", "4242 Testcity", "Municipality of Test"));
            IEnumerator <MunicipalityDO> muns =
                mDAO.Read(m => m.Name.StartsWith("Municipality of Test")).GetEnumerator();

            muns.MoveNext();
            this.mun = muns.Current;

            // Create 3 polling stations.
            var pDAO = new PollingStationDAO();

            pDAO.Create(new PollingStationDO(this.mun.PrimaryKey, 10000, "Test Polling Station 1", "Teststreet 44"));
            pDAO.Create(new PollingStationDO(this.mun.PrimaryKey, 10001, "Test Polling Station 2", "Teststreet 45"));
            pDAO.Create(new PollingStationDO(this.mun.PrimaryKey, 10002, "Test Polling Station 3", "Teststreet 46"));
            IEnumerator <PollingStationDO> pss =
                pDAO.Read(po => po.Name.StartsWith("Test Polling Station")).GetEnumerator();
            int pi = 0;

            while (pss.MoveNext())
            {
                this.ps[pi++] = pss.Current;
            }

            // Create 10 voters.
            var vDAO = new VoterDAO();

            vDAO.Create(new VoterDO(this.ps[0].PrimaryKey, 101264242, "Test Testson 1", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[1].PrimaryKey, 101264243, "Test Testson 2", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[2].PrimaryKey, 101264244, "Test Testson 3", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[0].PrimaryKey, 101264245, "Test Testson 4", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[0].PrimaryKey, 101264246, "Test Testson 5", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[1].PrimaryKey, 101264247, "Test Testson 6", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[1].PrimaryKey, 101264248, "Test Testson 7", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[2].PrimaryKey, 101264249, "Test Testson 8", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[2].PrimaryKey, 101264250, "Test Testson 9", "Teststreet 47", "4242 Testcity", false, false));
            vDAO.Create(new VoterDO(this.ps[2].PrimaryKey, 101264251, "Test Testson 10", "Teststreet 47", "4242 Testcity", false, false));
            IEnumerator <VoterDO> voters = vDAO.Read(vo => vo.Name.StartsWith("Test Testson")).GetEnumerator();
            int vi = 0;

            while (voters.MoveNext())
            {
                this.v[vi++] = voters.Current;
            }

            // Setup Voter Card Generator sub-system.
            this.filter        = new VoterFilter(mun);
            this.vcg           = new VoterCardGenerator(filter);
            this.vcgView       = new VoterCardGeneratorWindow(this.vcg);
            this.vcgController = new VoterCardGeneratorController(this.vcg, this.vcgView);
        }
Example #5
0
        public void TearDown()
        {
            var vDAO = new VoterDAO();

            vDAO.Delete(vo => vo.Name.StartsWith("Test Testson"));
            var pDAO = new PollingStationDAO();

            pDAO.Delete(po => po.Name.StartsWith("Test Polling Station"));
            var mDAO = new MunicipalityDAO();

            mDAO.Delete(m => m.Name.StartsWith("Municipality of T"));
        }
Example #6
0
        public void GenerateMunicipalities(int municipalities)
        {
            var m = new HashSet<MunicipalityDO>();

            for (uint i = 0; i < municipalities; i++)
            {
                var municipality = new MunicipalityDO(i, this.data.GetRoadname() + " " + this.r.Next(1000), this.data.GetCityname(), this.data.GetMunicipalityname());
                m.Add(municipality);
            }

            var dao = new MunicipalityDAO(dvl);
            dao.Create(m);
        }
Example #7
0
        public void GenerateMunicipalities(int municipalities)
        {
            var m = new HashSet <MunicipalityDO>();

            for (uint i = 0; i < municipalities; i++)
            {
                var municipality = new MunicipalityDO(i, this.data.GetRoadname() + " " + this.r.Next(1000), this.data.GetCityname(), this.data.GetMunicipalityname());
                m.Add(municipality);
            }

            var dao = new MunicipalityDAO(dvl);

            dao.Create(m);
        }
Example #8
0
        /// <summary> Initializes a new instance of the <see cref="VoterSelection"/> class with proper values for the default selection. </summary>
        public VoterSelection()
        {
            pDAO = new PollingStationDAO(DigitalVoterList.GetDefaultInstance());
            mDAO = new MunicipalityDAO(DigitalVoterList.GetDefaultInstance());
            vDAO = new VoterDAO(DigitalVoterList.GetDefaultInstance());

            // Call database to get initial values (no selection, ie. entire DB)
            try
            {
                Municipalities  = mDAO.Read(o => true);
                PollingStations = pDAO.Read(o => true);
                voterCount      = vDAO.Read(o => true).Count();
                currentFilter   = null;
            }
            catch (Exception e)
            {
                System.Windows.Forms.MessageBox.Show(
                    string.Format("The system was not able to connect to the server. The system said: {0}", e.Message));
                Environment.Exit(-1);
            }
        }
Example #9
0
        /// <summary> Initializes a new instance of the <see cref="VoterSelection"/> class with proper values for the default selection. </summary>
        public VoterSelection()
        {
            pDAO = new PollingStationDAO(DigitalVoterList.GetDefaultInstance());
            mDAO = new MunicipalityDAO(DigitalVoterList.GetDefaultInstance());
            vDAO = new VoterDAO(DigitalVoterList.GetDefaultInstance());

            // Call database to get initial values (no selection, ie. entire DB)
            try
            {
                Municipalities = mDAO.Read(o => true);
                PollingStations = pDAO.Read(o => true);
                voterCount = vDAO.Read(o => true).Count();
                currentFilter = null;
            }
            catch (Exception e)
            {
                System.Windows.Forms.MessageBox.Show(
                    string.Format("The system was not able to connect to the server. The system said: {0}", e.Message));
                Environment.Exit(-1);
            }
        }
Example #10
0
        /// <summary>
        /// Insert the data that was fected onto the remote server.
        /// </summary>
        /// <param name="server">The address of the server.</param>
        /// <param name="port">The port of the server.</param>
        /// <param name="user">The username.</param>
        /// <param name="password">The password.</param>
        public void InsertData(string server, string port, string user, string password)
        {
            foreach (var municipality in this.Municipalities)
            {
                municipality.ResetAssociations();
            }
            foreach (var pollingStation in this.PollingStations)
            {
                pollingStation.ResetAssociations();
            }
            foreach (var voter in this.Voters)
            {
                voter.ResetAssociations();
            }

            var context = DigitalVoterList.GetInstance(user, password, server, port);

            mDAO = new MunicipalityDAO(context);
            pDAO = new PollingStationDAO(context);
            vDAO = new VoterDAO(context);

            mDAO.Create(this.Municipalities);
            pDAO.Create(this.PollingStations);
            vDAO.Create(this.Voters);
        }