public IActionResult Get()
{
var votes = new List <VoteApiModel>();
var votesData = _context.Votes
.Include(x => x.Voter)
.Include(x => x.Type)
.Include(x => x.Style);
foreach (var item in votesData)
{
var vote = new VoteApiModel
{
PickleTypeId = item.Type.Id,
PickleStyleId = item.Style.Id,
FirstName = item.Voter.FirstName,
LastName = item.Voter.LastName,
Email = item.Voter.Email,
Latitude = item.Voter.Latitute,
Longitude = item.Voter.Longitude,
ZipCode = item.Voter.ZipCode
};
votes.Add(vote);
}
return(Ok(votes));
}
public IActionResult Post([FromBody] VoteApiModel vote)
{
// validate pickle type exists
var pickleType = _context.PickleTypes.FirstOrDefault(x => x.Id == vote.PickleTypeId);
if (pickleType == null)
{
return(BadRequest($"{vote.PickleTypeId} is not a valid pickle type."));
}
// validate pickle style exists
var pickleStyle = _context.PickleStyles.FirstOrDefault(x => x.Id == vote.PickleStyleId);
if (pickleStyle == null)
{
return(BadRequest($"{vote.PickleStyleId} is not a valid pickle style."));
}
// check if the voter is already in the systems
var voter = _context.Voters.FirstOrDefault(x => x.Email.Equals(vote.Email, StringComparison.InvariantCultureIgnoreCase));
if (voter != null && !string.IsNullOrEmpty(vote.Email))
{
return(Conflict($"The email address {vote.Email} is already associated with a vote."));
}
var voteDbObj = new Vote
{
PickleTypeId = vote.PickleTypeId,
PickleStyleId = vote.PickleStyleId
};
var voterDbObj = new Voter
{
FirstName = vote.FirstName,
LastName = vote.LastName,
Email = vote.Email,
Latitute = vote.Latitude,
Longitude = vote.Longitude,
ZipCode = vote.ZipCode,
IpAddress = Request.HttpContext.Connection.RemoteIpAddress.ToString()
};
using (var transaction = _context.Database.BeginTransaction())
{
// add the voter
_context.Voters.Add(voterDbObj);
_context.SaveChanges();
// grab the id from the newly saved voter
voteDbObj.VoterId = voterDbObj.Id;
// save the vote
_context.Votes.Add(voteDbObj);
_context.SaveChanges();
transaction.Commit();
}
return(Ok());
}
public object Vote(int roomId, int storyId, [FromBody] VoteApiModel voteModel)
{
var room = this.Rooms.FirstOrDefault(w => w.Identifier == roomId);
if (room == null)
{
return(new NotFoundObjectResult(new { Message = "This session no longer exists" }));
}
var story = room.Stories.FirstOrDefault(w => w.Identifier == storyId);
if (story == null)
{
return(new NotFoundObjectResult(new { Message = "Story not found" }));
}
var member = room.Members.FirstOrDefault(w => w.Identifier == voteModel.MemberId);
if (member == null)
{
return(new NotFoundObjectResult(new { Message = "Member not found" }));
}
if (!story.Votes.Any(w => w.Key == member.Identifier.ToString()))
{
story.Votes.Add(member.Identifier.ToString(), voteModel.Points);
}
else
{
story.Votes[member.Identifier.ToString()] = voteModel.Points;
}
return(member);
}
