WebVote

WebVote is a web application that can provide online referendums or elections. The app has three levels of privileges. Managers register users, admin creates a pool. Then voters vote. Finally admins and managers publish results. Most of the user interface is responsive and looks good on mobile devices. It was developed using ASP.NET Core and Angular.

Table of contents

• About
• Technologies
• Demo
• Users' privileges
• Poll
• User interface
• Analytic queries
• To-do

Technologies

• Back-end
  • ASP.NET Core
  • Entity Framework Core
  • MariaDB
  • AutoMapper
  • CsvHelper
  • FluentValidation
• Front-end
  • Angular
  • NG Bootstrap
  • FileSaver.js
• Docker

Demo

Check it now on webvote.tk (Self-hosted on my 10 y.o. PC using docker).

There are 200 demo voters. Login and password - numbers from 1 to 200.

Users' privileges

The system has three levels of user privileges (voter, manager, administrator). Users with a higher level of privileges have access to all services, as do users with a lower level of privileges.

Ability to	admin	manager	voter
View active polls list	+	+	+
View archived polls list	+	+	+
Vote on active polls	+	+	+
View archived polls	+	+	+
Change password	+	+	+
Register a single voter	+	+
Request analytic queries	+	+
Export analytic queries as CSV	+	+
Register multiple voters via CSV	+
Create polls	+
View pending polls list	+
Edit pending polls	+
Delete pending polls	+
View registration log	+

Poll

A poll has a title, a description and a list of options. Also, admin should specify date-time, when poll will start and date-time when poll will end.

An option has a title and a description.

Poll states

1. Pending - poll that has not yet started. Can be deleted or edited by admin
2. Active - poll that already started and not yet ended. All users can vote
3. Archived - poll that already ended. All users can still view it. Admins and managers can view results

When user votes on active poll, it moves to archive (only for him)

User interface

Toolbars

There are three types of toolbars: admin, manager, voter and unauthorized

Sign In form

Available to unauthorized users.

1. Login field
2. Password field
3. Submit button

Registration form

1. Full name field
2. Birth field
3. Region field
4. Individual tax number field
5. Login field
6. Password field
7. Submit button

Profile

There is account info and ability to change password.

1. Old password field
2. New password field
3. Change password button

Registration multiple voters via csv

If there are any errors in the file, they will appear under file input.

1. File input field
2. Submit button

Pending polls list

Admin can delete or edit pending poll

1. Edit poll button. Opens edit form
2. Delete poll button. Deletes poll

Active polls list

1. Vote button. Opens vote form

Archived pools list

1. View button. Opens read only vote form

Create-edit poll form

The similar form is used for editing polls.

1. Poll title field
2. Poll description field
3. Start datetime. Should be within one hour of the present
4. End datetime. Should be greater than start datetime
5. List of options. Number of options must be greater than 0
6. Option title field
7. Option description field
8. Delete option button
9. Submit button
10. Add option button

Vote-view poll form

In the similar form for viewing poll, check marks and submit button are disabled.

1. Check mark. Selects an option
2. Highlighted check mark. Indicates that the option is selected
3. Submit vote button

Registration log

Admin can view who was registered by whom and when

Analytic queries

Votes per option

Returns the number of votes per each option of the selected poll

• Option name
• Votes count
• Votes percent = votesCount / totalVotes * 100%

1. Request result button
2. Download CSV button. Starts downloading results as CSV file

Id,Title,Count,Percent
14,SpongeBob SquarePants,47,0.235
13,Patrick Star,43,0.215
8,Squidward Tentacles,40,0.2
11,Plankton and Karen,39,0.195
12,Mr. Krabs,31,0.155

Votes per region

Returns the number of votes from each region of the selected poll. Can help you to see voters activity

• Region name
• Votes count
• Citizens count
• Voters activity = votesCount / citizensCount * 100%
• Votes percent = votesCount / totalVotes * 100%

There is a bug in this query: the citizen count should be fixed at the moment the poll is completed, but it represents actual number of citizens

1. Request result button
2. Download CSV button. Starts downloading results as CSV file

Id,Name,VotesCount,CitizensCount,VotersActivityPercent,VotesPercent
5,Vinnytsia Oblast,15,24,0.625,0.075
16,Kherson Oblast,12,20,0.6,0.06
11,Mykolaiv Oblast,13,22,0.5909090909090909090909090909,0.065
12,Luhansk Oblast,13,22,0.5909090909090909090909090909,0.065
24,Cherkasy Oblast,12,21,0.5714285714285714285714285714,0.06
ETC...

To-do

There are a couple things that I want to implement to make the system more consistent

1. Ability to change user privileges. Admin will be able to change other users' privileges
2. Ability to reset a password if user forgets it. Admin will be able to reset user's password
3. Ability to change user's personal information, for example region if user moves to another
4. Ability to link Google account to sign in with it
5. Ability to link email. To reset password with it and receive email notifications about new polls
6. Ability to attach files to polls, for example, some documents
7. Ability to attach photos to options. For example, photos of candidates in elections
8. Add more analytic queries
9. Cover all code with unit tests 😉
10. CI / CD with GitHub Actions