public async Task CastVotesAsync(int ballotId, IEnumerable <VoteModel> votes, DateTime castedAt) { await Task.CompletedTask; using (var dataSet = new StudentElectionDataSet()) { using (var manager = new TableAdapterManager()) { manager.VoteTableAdapter = new VoteTableAdapter(); manager.BallotTableAdapter = new BallotTableAdapter(); foreach (var vote in votes) { var newRow = dataSet.Vote.NewVoteRow(); newRow.BallotId = ballotId; newRow.CandidateId = vote.CandidateId; dataSet.Vote.AddVoteRow(newRow); } manager.BallotTableAdapter.FillBallotsById(dataSet.Ballot, ballotId); var ballot = dataSet.Ballot.FindByID(ballotId); ballot.CastedAt = castedAt; manager.UpdateAll(dataSet); } } }
public async Task InsertVotersAsync(IEnumerable <VoterModel> voters) { await Task.CompletedTask; using (var dataSet = new StudentElectionDataSet()) { using (var manager = new TableAdapterManager()) { manager.VoterTableAdapter = new VoterTableAdapter(); var id = -1; foreach (var voter in voters) { var newRow = dataSet.Voter.NewVoterRow(); _mapper.Map(voter, newRow); newRow.ID = id; if (voter.Birthdate == null) { newRow.SetBirthdateNull(); } dataSet.Voter.AddVoterRow(newRow); id--; } manager.UpdateAll(dataSet); } } }
public async Task InsertCandidatesAsync(IEnumerable <CandidateModel> candidates) { await Task.CompletedTask; using (var dataSet = new StudentElectionDataSet()) { using (var manager = new TableAdapterManager()) { manager.CandidateTableAdapter = new CandidateTableAdapter(); var id = -1; foreach (var candidate in candidates) { var newRow = dataSet.Candidate.NewCandidateRow(); _mapper.Map(candidate, newRow); newRow.ID = id; if (candidate.Birthdate == null) { newRow.SetBirthdateNull(); } dataSet.Candidate.AddCandidateRow(newRow); id--; } manager.UpdateAll(dataSet); } } }
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); } } }