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);
}
}
}
