public static void CreateNewPoll(string question, string answer1, string answer2, string answer3, string answer4, string answer5, string answer6) { Poll newPoll = new Poll(); newPoll.Question = question; PollSystemEntities context = new PollSystemEntities(); context.Polls.AddObject(newPoll); context.SaveChanges(); if (!string.IsNullOrWhiteSpace(answer1)) CreateAnswer(answer1, newPoll); if (!string.IsNullOrWhiteSpace(answer2)) CreateAnswer(answer2, newPoll); if (!string.IsNullOrWhiteSpace(answer3)) CreateAnswer(answer3, newPoll); if (!string.IsNullOrWhiteSpace(answer4)) CreateAnswer(answer4, newPoll); if (!string.IsNullOrWhiteSpace(answer5)) CreateAnswer(answer5, newPoll); if (!string.IsNullOrWhiteSpace(answer6)) CreateAnswer(answer6, newPoll); }
private static void CreateAnswer(string answerText, Poll newPoll) { using (PollSystemEntities context = new PollSystemEntities()) { if (answerText.Length > 255) { // Special case: long text should be inserted directly string cmd = String.Format("INSERT INTO PollAnswers(Answer, Votes, PollID) VALUES ('{0}', {1}, {2})", answerText, 0, newPoll.PollID); context.ExecuteStoreCommand(cmd); } else { PollAnswer answer = new PollAnswer(); answer.Answer = answerText; answer.PollID = newPoll.PollID; answer.Votes = 0; context.PollAnswers.AddObject(answer); } context.SaveChanges(); } }
public static void VoteForPoll(int answerID) { using (PollSystemEntities context = new PollSystemEntities()) { PollAnswer answer = context.PollAnswers.First(a => a.AnswerID == answerID); int votes = answer.Votes; answer.Votes = votes + 1; context.SaveChanges(); } }