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); }
/// <summary> /// Deprecated Method for adding a new object to the Polls EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPolls(Poll poll) { base.AddObject("Polls", poll); }
/// <summary> /// Create a new Poll object. /// </summary> /// <param name="pollID">Initial value of the PollID property.</param> /// <param name="question">Initial value of the Question property.</param> public static Poll CreatePoll(global::System.Int32 pollID, global::System.String question) { Poll poll = new Poll(); poll.PollID = pollID; poll.Question = question; return poll; }
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(); } }