public List <ElectionModel> listMember()
{
List <ElectionModel> mod = new List <ElectionModel>();
string query = "SELECT * FROM public.election";
try
{
con.Open();
cmd = new NpgsqlCommand(query, con);
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ElectionModel model = new ElectionModel();
model.e_id = Convert.ToInt32(dr["e_id"]);
model.e_name = dr["e_name"].ToString();
model.e_village = dr["e_village"].ToString();
model.e_dist = dr["e_dist"].ToString();
model.e_postcode = Convert.ToInt32(dr["e_postcode"]);
mod.Add(model);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(mod);
}
public List <ElectionModel> ReadData()
{
var listData = new List <ElectionModel>();
using (var reader = new StreamReader(FilePath))
{
while (!reader.EndOfStream)
{
var dataFromReader = reader.ReadLine();
var listDataFromFile = dataFromReader.Split(',');
int.TryParse(listDataFromFile[5], out int score);
var data = new ElectionModel
{
Id = Guid.NewGuid().ToString(),
Name = listDataFromFile[2],
NameParty = listDataFromFile[4],
No = listDataFromFile[3],
NameArea = $"{listDataFromFile[0]}{listDataFromFile[1]}",
Score = score
};
listData.Add(data);
System.Console.WriteLine(dataFromReader);
}
}
return(listData);
}
public int update(ElectionModel model)
{
string query = "UPDATE public.election SET e_name=@e_name,e_village=@e_village,e_dist=@e_dist,e_postcode=@e_postcode where e_id=@e_id";
int i = 0;
try
{
con.Open();
cmd = new NpgsqlCommand(query, con);
cmd.Parameters.AddWithValue("@e_name", model.e_name);
cmd.Parameters.AddWithValue("@e_village", model.e_village);
cmd.Parameters.AddWithValue("@e_dist", model.e_dist);
cmd.Parameters.AddWithValue("@e_postcode", model.e_postcode);
cmd.Parameters.AddWithValue("@e_id", model.e_id);
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
return(i);
}
private async void Window_Loaded(object sender, RoutedEventArgs e)
{
try
{
grdBallot.Visibility = Visibility.Hidden;
btnReset.Visibility = Visibility.Collapsed;
btnNext.Visibility = Visibility.Collapsed;
bdrLoadingMaintenance.Visibility = Visibility.Visible;
_currentElection = await _electionService.GetCurrentElectionAsync();
await SetBallotAsync(_voter);
grdBallot.Visibility = Visibility.Visible;
btnReset.Visibility = Visibility.Visible;
btnNext.Visibility = Visibility.Visible;
bdrLoadingMaintenance.Visibility = Visibility.Collapsed;
}
catch (Exception ex)
{
Logger.LogError(ex);
MessageBox.Show(ex.GetBaseException().Message, "PROGRAM ERROR: " + ex.Source, MessageBoxButton.OK, MessageBoxImage.Stop);
}
}
//private void lblVoterID_Click(object sender, EventArgs e)
//{
// G.WaitLang(this);
// var window = new VotersListWindow();
// var helper = new WindowInteropHelper(window);
// helper.Owner = Handle;
// G.EndWait(this);
// window.ShowDialog();
// G.WaitLang(this);
// var voter = window.GetNewData();
// G.EndWait(this);
// if (voter == null) return;
// lblName.Visible = true;
// lblStrand.Visible = true;
// lblVoterID.Text = voter.VoterID;
// lblVoterID.Tag = voter.ID;
// lblName.Text = voter.FullName;
// lblStrand.Text = voter.GradeStrand;
// if (lblName.Width > 255)
// {
// lblName.Width = 255;
// lblName.AutoSize = false;
// ttpCandidate.SetToolTip(lblName, voter.FullName);
// }
// else
// {
// ttpCandidate.SetToolTip(lblName, null);
// }
// txtAlias.Text = voter.FirstName;
// txtAlias.Focus();
// txtAlias.SelectAll();
//}
private async void CandidateForm_Load(object sender, EventArgs e)
{
_currentElection = await _electionService.GetCurrentElectionAsync();
dtBirthdate.MaxDate = DateTime.Today;
if (EditingCandidate == null)
{
lblTitle.Text = "Add Candidate";
btnAdd.Text = "ADD";
await LoadPositionsAsync();
cmbPosition.SelectedIndex = -1;
}
else
{
var party = await _partyService.GetPartyAsync(EditingCandidate.PartyId);
SetParty(party);
lblTitle.Text = "Edit Candidate";
txtFirstName.Text = EditingCandidate.FirstName;
txtMiddleName.Text = EditingCandidate.MiddleName;
txtLastName.Text = EditingCandidate.LastName;
txtSuffix.Text = EditingCandidate.Suffix;
dtBirthdate.Checked = EditingCandidate.Birthdate.HasValue;
if (dtBirthdate.Checked)
{
dtBirthdate.Value = EditingCandidate.Birthdate.Value;
}
cmbSex.SelectedIndex = (int)EditingCandidate.Sex - 1;
cmbYearLevel.SelectedItem = EditingCandidate.YearLevel.ToString();
txtSection.Text = EditingCandidate.Section;
txtAlias.Text = EditingCandidate.Alias;
pbImage.Image = Properties.Resources.default_candidate;
if (!string.IsNullOrWhiteSpace(EditingCandidate.PictureFileName))
{
var filePath = Path.Combine(App.ImageFolderPath, EditingCandidate.PictureFileName);
if (File.Exists(filePath))
{
using (var bmpTemp = new Bitmap(filePath))
{
pbImage.Image = new Bitmap(bmpTemp);
}
}
}
btnAdd.Text = "UPDATE";
}
Microsoft.Win32.SystemEvents.DisplaySettingsChanged += (s, ev) =>
{
G.PlaceWindowOnCenter(this);
};
Text = lblTitle.Text;
}
private void LoadPeople()
{
var peopleXml = _xmlRoot.SelectNodes("t:person", _nsm);
var numToLoad = peopleXml.Count;
if (peopleXml == null || numToLoad == 0)
{
throw new LoaderException("No people in the file");
}
_peopleModel = new PeopleModel(_election);
var defaultReason = ElectionModel.GetDefaultIneligibleReason(_election);
_people = new List <Person>();
var rowsProcessed = 0;
foreach (XmlElement personXml in peopleXml)
{
LoadPerson(personXml, _people, defaultReason);
rowsProcessed++;
if (rowsProcessed % 100 == 0)
{
_hub.StatusUpdate("Processing {0:n0} people".FilledWith(rowsProcessed, numToLoad), true);
}
}
Db.BulkInsert(_people);
_hub.StatusUpdate("Loaded {0:n0} people.".FilledWith(rowsProcessed));
}
public int Add(ElectionModel model)
{
string query = "INSERT INTO public.election(e_name,e_village,e_dist,e_postcode) VALUES(@e_name,@e_village,@e_dist,@e_postcode)";
int i = 0;
try
{
con.Open();
cmd = new NpgsqlCommand(query, con);
cmd.Parameters.AddWithValue("@e_name", model.e_name);
cmd.Parameters.AddWithValue("@e_village", model.e_village);
cmd.Parameters.AddWithValue("@e_dist", model.e_dist);
cmd.Parameters.AddWithValue("@e_postcode", model.e_postcode);
i = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
return(i);
}
private async void Window_Loaded(object sender, RoutedEventArgs e)
{
_currentElection = await _electionService.GetCurrentElectionAsync();
if (Voter == null)
{
lblTitle.Content = "Add Voter";
btnAdd.Content = "ADD";
}
else
{
lblTitle.Content = "Edit Voter";
txtVoterID.Text = Voter.Vin;
txtLastName.Text = Voter.LastName;
txtFirstName.Text = Voter.FirstName;
txtMiddleName.Text = Voter.MiddleName;
cmbGradeLevel.Text = Voter.YearLevel.ToString();
txtStrandSection.Text = Voter.Section;
cmbSex.Text = Voter.Sex.ToString();
dpBirthdate.SelectedDate = Voter.Birthdate;
btnAdd.Content = "UPDATE";
}
}
private async void PartyForm_Load(object sender, EventArgs e)
{
_currentElection = await _electionService.GetCurrentElectionAsync();
if (Party == null)
{
lblTitle.Text = "Create Party";
btnAdd.Text = "ADD";
btnDelete.Visible = false;
var random = new Random();
_argb = (int)(0xFF000000 + (random.Next(0xFFFFFF) & 0x7F7F7F));
pbColor.BackColor = Color.FromArgb(_argb);
}
else
{
lblTitle.Text = "Edit Party";
btnAdd.Text = "UPDATE";
txtName.Text = Party.Title;
txtName.SelectionStart = txtName.TextLength;
txtShortName.Text = Party.ShortName;
pbColor.BackColor = Party.Color;
_argb = Party.Argb;
btnDelete.Visible = true;
}
Text = lblTitle.Text;
}
public List <ElectionModel> ReadData2()
{
var listData = new List <ElectionModel>();
using (var reader = new StreamReader(FilePath))
{
var dataFromRead = reader.ReadToEnd();
var dataFromSplitLine = dataFromRead.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries).ToList();
foreach (var item in dataFromSplitLine)
{
var listDataFromFile = item.Split(',');
int.TryParse(listDataFromFile[5], out int score);
var data = new ElectionModel
{
Id = Guid.NewGuid().ToString(),
Name = listDataFromFile[2],
NameParty = listDataFromFile[4],
No = listDataFromFile[3],
NameArea = $"{listDataFromFile[0]}{listDataFromFile[1]}",
Score = score
};
listData.Add(data);
}
}
return(listData);
}
protected override bool AuthorizeCore(System.Web.HttpContextBase httpContext)
{
var authorized = base.AuthorizeCore(httpContext) && (UserSession.IsGuestTeller || UserSession.IsKnownTeller);
if (!authorized)
{
// The user is not authenticated
return(false);
}
var electionModel = new ElectionModel();
if (UserSession.IsGuestTeller)
{
if (!electionModel.GuestsAllowed())
{
UserSession.ProcessLogout();
return(false);
}
return(true);
}
// only update visit every 5 minutes. Lasts for 1 hour, so could be only 45 minutes.
var currentElection = UserSession.CurrentElection;
var delayTime = TimeSpan.FromMinutes(5);
if (currentElection != null && currentElection.ListForPublic.AsBoolean())
{
LogTime("init");
var db = UnityInstance.Resolve <IDbContextFactory>().GetNewDbContext;
LogTime("resolve");
db.Election.Attach(currentElection);
LogTime("attach");
currentElection.ListedForPublicAsOf = DateTime.Now;
LogTime("listed");
var electionCacher = new ElectionCacher(db);
LogTime("cacher");
electionCacher.UpdateItemAndSaveCache(currentElection);
LogTime("update cache");
if (currentElection.ListForPublic.AsBoolean() &&
(DateTime.Now - currentElection.ListedForPublicAsOf.GetValueOrDefault(DateTime.Now.AddMinutes(-60))).TotalMinutes > delayTime.TotalMinutes)
{
db.SaveChanges();
LogTime("db save");
}
new PublicHub().TellPublicAboutVisibleElections();
LogTime("notify");
}
return(true);
}
public async Task UpdateElectionAsync(ElectionModel model)
{
using (var context = new StudentElectionContext())
{
var election = await context.Elections.SingleOrDefaultAsync(c => c.Id == model.Id);
_mapper.Map(model, election);
await context.SaveChangesAsync();
}
}
public async Task <int> AddElectionAsync(ElectionModel model)
{
using (var context = new StudentElectionContext())
{
var election = new Election();
_mapper.Map(model, election);
context.Elections.Add(election);
return(await context.SaveChangesAsync());
}
}
private async void PositionForm_Load(object sender, EventArgs e)
{
_currentElection = await _electionService.GetCurrentElectionAsync();
_window = (Tag as MaintenanceWindow);
await LoadPositionsAsync();
nudNumberOfWinners.Value = Math.Min(2, nudNumberOfWinners.Maximum);
nudNumberOfWinners.Value = 1;
cmbWhoCanVote.SelectedIndex = 0;
}
public async Task InsertElectionAsync(ElectionModel model)
{
var election = new Election();
_mapper.Map(model, election);
using (var context = new StudentElectionContext())
{
context.Elections.Add(election);
await context.SaveChangesAsync();
}
}
public async Task <BallotModel> GetBallotAsync(ElectionModel election, VoterModel voter)
{
var existingBallot = await _ballotRepository.GetBallotByVinAsync(election.Id, voter.Vin);
if (existingBallot == null)
{
var enteredAt = DateTime.Now;
existingBallot = await _ballotRepository.InsertBallotAsync(voter, enteredAt);
existingBallot.Code = GetBallotCode(election.ServerTag, existingBallot);
await _ballotRepository.SetBallotCodeAsync(existingBallot);
}
return(existingBallot);
}
public async Task UpdateElectionAsync(ElectionModel election)
{
await Task.CompletedTask;
using (var tableAdapter = new ElectionTableAdapter())
{
tableAdapter.Update(
election.Title,
election.Description,
election.TookPlaceOn,
election.CandidatesFinalizedAt,
election.ClosedAt,
election.ServerTag,
election.Id
);
}
}
private async Task SetCurrentElectionAsync()
{
_currentElection = await _electionService.GetCurrentElectionAsync();
if (_currentElection != null)
{
if (_currentElection.ClosedAt.HasValue)
{
grdFinalizeCandidates.Visibility = Visibility.Collapsed;
grdVoting.Visibility = Visibility.Collapsed;
grdVoteEnded.Visibility = Visibility.Visible;
}
else
{
if (_currentElection.CandidatesFinalizedAt.HasValue)
{
grdFinalizeCandidates.Visibility = Visibility.Collapsed;
grdVoting.Visibility = Visibility.Visible;
grdVoteEnded.Visibility = Visibility.Collapsed;
}
else
{
grdFinalizeCandidates.Visibility = Visibility.Visible;
grdVoting.Visibility = Visibility.Collapsed;
grdVoteEnded.Visibility = Visibility.Collapsed;
}
}
this.Title = $"{ _currentElection.Title } • { (string.IsNullOrWhiteSpace(_currentElection.ServerTag) ? "(No tag)" : _currentElection.ServerTag) }";
}
else
{
this.Title = "Student Election System";
grdNoElection.Visibility = Visibility.Visible;
}
//var fileName = "D:/Videos/New Text Document.txt";
//FileSecurity fSecurity = File.GetAccessControl(fileName);
//fSecurity.AddAccessRule(new FileSystemAccessRule("Everyone", FileSystemRights.ReadData, AccessControlType.Allow));
//File.SetAccessControl(fileName, fSecurity);
//DB.LoadData();
}
public async Task <ElectionModel> GetElectionByServerTagAsync(string tag)
{
await Task.CompletedTask;
using (var tableAdapter = new ElectionTableAdapter())
{
var row = tableAdapter.GetElectionsByServerTag(tag).SingleOrDefault();
if (row == null)
{
return(null);
}
var model = new ElectionModel();
_mapper.Map(row, model);
return(model);
}
}
public async Task <ElectionModel> GetCurrentElectionAsync()
{
await Task.CompletedTask;
using (var tableAdapter = new ElectionTableAdapter())
{
var row = tableAdapter.GetCurrentElections().SingleOrDefault();
if (row == null)
{
return(null);
}
var model = new ElectionModel();
_mapper.Map(row, model);
return(model);
}
}
public JsonResult SelectElection(Guid guid, Guid?oldComputerGuid)
{
var electionModel = new ElectionModel();
if (electionModel.JoinIntoElection(guid, oldComputerGuid.AsGuid()))
{
return(new
{
Locations = ContextItems.LocationModel.GetLocations_Physical().OrderBy(l => l.SortOrder).Select(l => new { l.Name, l.C_RowId }),
Selected = true,
ElectionName = UserSession.CurrentElectionName,
ElectionGuid = UserSession.CurrentElectionGuid,
CompGuid = UserSession.CurrentComputer.ComputerGuid,
// Pulse = new PulseModel(this).Pulse()
}.AsJsonResult());
}
return(new { Selected = false }.AsJsonResult());
}
public async Task <ElectionModel> GetElectionByServerTagAsync(string tag)
{
using (var context = new StudentElectionContext())
{
var election = await context.Elections
.SingleOrDefaultAsync(e => e.ServerTag.ToLower() == tag.ToLower());
if (election == null)
{
return(null);
}
var model = new ElectionModel();
_mapper.Map(election, model);
return(model);
}
}
public async Task <ElectionModel> GetCurrentElectionAsync()
{
using (var context = new StudentElectionContext())
{
var election = await context.Elections
.OrderByDescending(e => e.TookPlaceOn)
.ThenByDescending(e => e.Id).FirstOrDefaultAsync();
if (election == null)
{
return(null);
}
var model = new ElectionModel();
_mapper.Map(election, model);
return(model);
}
}
private async void CandidateViewerForm_Load(object sender, EventArgs e)
{
_window = (Tag as MaintenanceWindow);
_currentElection = await _electionService.GetCurrentElectionAsync();
btnEdit.Visible = !_currentElection.CandidatesFinalizedAt.HasValue;
btnDelete.Visible = !_currentElection.CandidatesFinalizedAt.HasValue;
_candidateParty = (await _candidateService.GetCandidateDetailsListByPartyAsync(CurrentCandidate.PartyId)).ToList();
_index = _candidateParty.Select(x => x.Id).ToList().IndexOf(CurrentCandidate.Id);
btnNext.Enabled = _index != _candidateParty.Count - 1;
btnPrev.Enabled = _index != 0;
lblCandidatePage.Text = (_index + 1) + " of " + (_candidateParty.Count);
SetCandidate();
}
public IHttpActionResult UpdateRecord(JObject model)
{
ElectionModel mod = new ElectionModel();
var s = JsonConvert.DeserializeObject <List <ElectionModel> >(model["models"].ToString());
mod.e_id = s[0].e_id;
mod.e_name = s[0].e_name;
mod.e_village = s[0].e_village;
mod.e_dist = s[0].e_dist;
mod.e_postcode = s[0].e_postcode;
int i = repo.update(mod);
if (i >= 1)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public Election()
{
Convenor = "[Convener]"; // correct spelling is Convener. DB field name is wrong.
ElectionGuid = Guid.NewGuid();
Name = "[New Election]";
ElectionType = "LSA";
ElectionMode = ElectionModeEnum.Normal;
TallyStatus = ElectionTallyStatusEnum.NotStarted;
NumberToElect = 9;
NumberExtra = 0;
VotingMethods = "PDM";
var rules = new ElectionModel().GetRules(ElectionType, ElectionMode);
// No longer used as rules. Each person has own status.
// CanVote = rules.CanVote;
// CanReceive = rules.CanReceive;
NumberToElect = rules.Num;
NumberExtra = rules.Extra;
}
public async Task InsertElectionAsync(ElectionModel model)
{
await Task.CompletedTask;
using (var dataSet = new StudentElectionDataSet())
{
using (var manager = new TableAdapterManager())
{
manager.ElectionTableAdapter = new ElectionTableAdapter();
var newRow = dataSet.Election.NewElectionRow();
_mapper.Map(model, newRow);
newRow.ID = -1;
newRow.SetCandidatesFinalizedAtNull();
newRow.SetClosedAtNull();
dataSet.Election.AddElectionRow(newRow);
manager.UpdateAll(dataSet);
}
}
}
public List <ElectionModel> ReadDataFromCSVFile()
{
var electionDataList = new List <ElectionModel>();
using (var reader = new StreamReader(csvFile))
{
while (!reader.EndOfStream)
{
var dataFromFile = reader.ReadLine();
var splitData = dataFromFile.Split(",");
var electionData = new ElectionModel()
{
Id = Guid.NewGuid().ToString(),
Name = splitData[2],
NameParty = splitData[4],
No = splitData[3],
NameArea = $"{splitData[0]}{splitData[1]}",
Score = Int32.Parse(splitData[5])
};
electionDataList.Add(electionData);
}
}
return(electionDataList);
}
private async Task LoadElectionAsync()
{
_currentElection = await _electionService.GetCurrentElectionAsync();
_canOpenNewElection = _currentElection == null || _currentElection.ClosedAt.HasValue;
btnEdit.Visible = _currentElection.CandidatesFinalizedAt == null;
if (_canOpenNewElection)
{
btnOpenOrCloseElection.Text = "OPEN NEW ELECTION";
}
else
{
btnOpenOrCloseElection.Text = "CLOSE ELECTION";
}
if (_currentElection != null)
{
lblCurrentElectionTitle.Text = _currentElection.Title;
if (string.IsNullOrEmpty(_currentElection.Description))
{
lblDescription.Text = "(no description)";
lblDescription.Font = new Font(lblDescription.Font, FontStyle.Italic);
}
else
{
lblDescription.Text = _currentElection.Description;
lblDescription.Font = new Font(lblDescription.Font, FontStyle.Regular);
}
if (_currentElection.TookPlaceOn > DateTime.Today)
{
lblTookPlaceOnLabel.Text = $"Will be conducted on { _currentElection.TookPlaceOn.ToString("MMMM d, yyyy") }";
}
else if (_currentElection.TookPlaceOn < DateTime.Today || _currentElection.ClosedAt.HasValue)
{
lblTookPlaceOnLabel.Text = $"Took place on { _currentElection.TookPlaceOn.ToString("MMMM d, yyyy") }";
}
else
{
lblTookPlaceOnLabel.Text = $"Conducting today, { _currentElection.TookPlaceOn.ToString("MMMM d, yyyy") }";
}
lblTookPlaceOn.Text = _currentElection.TookPlaceOn.Date.Humanize(dateToCompareAgainst: DateTime.Today);
if (_currentElection.CandidatesFinalizedAt == null)
{
lblCandidatesFinalizedAt.Text = "(not finalized yet)";
lblCandidatesFinalizedAt.Font = new Font(lblCandidatesFinalizedAt.Font, FontStyle.Regular);
}
else
{
lblCandidatesFinalizedAt.Text = _currentElection.CandidatesFinalizedAt.Value.ToString("yyyy-MM-dd hh:mm:ss tt");
lblCandidatesFinalizedAt.Font = new Font(lblCandidatesFinalizedAt.Font, FontStyle.Bold);
}
if (_currentElection.ClosedAt == null)
{
lblClosedAt.Text = "(not closed yet)";
lblClosedAt.Font = new Font(lblCandidatesFinalizedAt.Font, FontStyle.Regular);
}
else
{
lblClosedAt.Text = _currentElection.ClosedAt.Value.ToString("yyyy-MM-dd hh:mm:ss tt");
lblClosedAt.Font = new Font(lblCandidatesFinalizedAt.Font, FontStyle.Bold);
}
}
}
public async Task <BallotModel> GetBallotByVinAsync(ElectionModel election, VoterModel voter)
{
return(await _ballotRepository.GetBallotByVinAsync(election.Id, voter.Vin));
}
