public static void DeletePoll(int pollID)
{
PollSystemEntities context = new PollSystemEntities();
context.ExecuteStoreCommand("DELETE FROM PollAnswers WHERE PollID={0}", pollID);
context.ExecuteStoreCommand("DELETE FROM Polls WHERE PollID={0}", pollID);
}
public static void ResetPoll(int pollID)
{
PollSystemEntities context = new PollSystemEntities();
context.ExecuteStoreCommand("UPDATE PollAnswers SET Votes=0 WHERE PollID={0}", pollID);
}
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();
}
}