protected void OnLinkButtonDeleteAnswer_Command(object sender, CommandEventArgs e)
{
var dbContext = new PollSystemEntities();
int answerId = Convert.ToInt32(e.CommandArgument);
var answer = dbContext.Answers.Find(answerId);
if (answer != null)
{
try
{
dbContext.Answers.Remove(answer);
dbContext.SaveChanges();
ErrorSuccessNotifier.AddSuccessMessage("Answer successfully deleted");
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex.Message);
}
}
else
{
ErrorSuccessNotifier.AddErrorMessage("This answer does not exist anymore");
}
}
protected void OnBtnSaveChanges_Click(object sender, EventArgs e)
{
var dbContext = new PollSystemEntities();
int questionId = Convert.ToInt32(Request.Params["questionId"]);
var question = dbContext.Questions.Find(questionId);
if (question != null)
{
try
{
string questionText = this.TextBoxQuestionText.Text;
question.Text = questionText;
dbContext.SaveChanges();
ErrorSuccessNotifier.AddSuccessMessage("Question successfully edited");
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
else
{
ErrorSuccessNotifier.AddErrorMessage("This question does not exist anymore");
}
}
protected void OnLinkButtonDeleteQuestion_Command(object sender, CommandEventArgs e)
{
var dbContext = new PollSystemEntities();
int questionId = Convert.ToInt32(e.CommandArgument);
var question = dbContext.Questions.Find(questionId);
if (question != null)
{
try
{
var answers = question.Answers.ToList();
foreach (var answer in answers)
{
dbContext.Answers.Remove(answer);
}
dbContext.Questions.Remove(question);
dbContext.SaveChanges();
this.GridViewQuestions.PageIndex = 0;
ErrorSuccessNotifier.AddSuccessMessage("Question successfully deleted");
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex.Message);
}
}
else
{
ErrorSuccessNotifier.AddErrorMessage("This question does not exist anymore");
}
}
public IQueryable <Question> GridViewAllQuestions_GetData()
{
var context = new PollSystemEntities();
var questions = context.Questions.OrderBy(q => q.Text);
return(questions);
}
protected void LinkButtonSaveQuestion_Click(object sender, EventArgs e)
{
using (var context = new PollSystemEntities())
{
string questionIdStr = Request.Params["questionId"];
Question question;
if (string.IsNullOrEmpty(questionIdStr))
{
question = new Question();
context.Questions.Add(question);
}
else
{
int questionId = Convert.ToInt32(questionIdStr);
question = context.Questions.FirstOrDefault(x => x.QuestionId == questionId);
}
question.Text = this.TextBoxQuestionText.Text;
try
{
context.SaveChanges();
Response.Redirect("EditQuestions.aspx", false);
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
}
protected void LinkButtonSaveQuestion_Click(object sender, EventArgs e)
{
using (var context = new PollSystemEntities())
{
string questionIdStr = Request.Params["questionId"];
Question question;
if (string.IsNullOrEmpty(questionIdStr))
{
question = new Question();
context.Questions.Add(question);
}
else
{
int questionId = Convert.ToInt32(questionIdStr);
question = context.Questions.FirstOrDefault(x => x.QuestionId == questionId);
}
question.Text = this.TextBoxQuestionText.Text;
try
{
context.SaveChanges();
Response.Redirect("EditQuestions.aspx", false);
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
}
public IQueryable <PollSystem.Models.Question> GridViewQuestions_GetData()
{
var dbContext = new PollSystemEntities();
var questions = dbContext.Questions
.Include("Answers").OrderBy(q => q.Text);
return(questions);
}
protected void Page_Load(object sender, EventArgs e)
{
var context = new PollSystemEntities();
var questions = context.Questions.Take(3);
this.ListViewQuestions.DataSource = questions.ToList();
this.DataBind();
}
protected void Page_PreRender(object sender, EventArgs e)
{
var dbContext = new PollSystemEntities();
var questions = dbContext.Questions
.Include("Answers").OrderBy(q => Guid.NewGuid()).Take(3);
this.ListViewPollQuestions.DataSource = questions.ToList();
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var context = new PollSystemEntities();
var questions = context.Questions.Take(3);
this.ListViewQuestions.DataSource = questions.ToList();
this.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
int questionId = Convert.ToInt32(Request.Params["questionId"]);
var context = new PollSystemEntities();
var question = context.Questions.FirstOrDefault(x => x.QuestionId == questionId);
this.LiteralQuestion.Text = question.Text;
this.RepeaterAnswerResult.DataSource = question.Answers.ToList();
this.DataBind();
}
protected void LinkButtonVote_Command(object sender, CommandEventArgs e)
{
int answerId = Convert.ToInt32(e.CommandArgument);
var context = new PollSystemEntities();
Answer answer = context.Answers.Find(answerId);
answer.Votes++;
context.SaveChanges();
Response.Redirect("VotingResults.aspx?questionId=" + answer.QuestionId);
}
protected void Page_Load(object sender, EventArgs e)
{
int questionId = Convert.ToInt32(Request.Params["questionId"]);
var context = new PollSystemEntities();
var question = context.Questions.FirstOrDefault(x => x.QuestionId == questionId);
this.LiteralQuestion.Text = question.Text;
this.RepeaterAnswerResult.DataSource = question.Answers.ToList();
this.DataBind();
}
protected void LinkButtonVote_Command(object sender, CommandEventArgs e)
{
int answerId = Convert.ToInt32(e.CommandArgument);
var context = new PollSystemEntities();
Answer answer = context.Answers.Find(answerId);
answer.Votes++;
context.SaveChanges();
Response.Redirect("VotingResults.aspx?questionId=" + answer.QuestionId);
}
protected void Page_PreRender(object sender, EventArgs e)
{
string questionIdStr = Request.Params["questionId"];
if (!string.IsNullOrEmpty(questionIdStr))
{
int questionId = Convert.ToInt32(questionIdStr);
using (var context = new PollSystemEntities())
{
Question question = context.Questions.FirstOrDefault(x => x.QuestionId == questionId);
this.TextBoxQuestionText.Text = question.Text;
this.RepeaterAnswerResult.DataSource = question.Answers.ToList();
this.RepeaterAnswerResult.DataBind();
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
string questionIdStr = Request.Params["questionId"];
if (!string.IsNullOrEmpty(questionIdStr))
{
int questionId = Convert.ToInt32(questionIdStr);
using (var context = new PollSystemEntities())
{
Question question = context.Questions.FirstOrDefault(x => x.QuestionId == questionId);
this.TextBoxQuestionText.Text = question.Text;
this.RepeaterAnswerResult.DataSource = question.Answers.ToList();
this.RepeaterAnswerResult.DataBind();
}
}
}
// The id parameter name should match the DataKeyNames value set on the control
public void GridViewQuestions_DeleteItem(int questionId)
{
var context = new PollSystemEntities();
Question question = context.Questions.Include("Answers")
.FirstOrDefault(q => q.QuestionId == questionId);
try
{
context.Answers.RemoveRange(question.Answers);
context.Questions.Remove(question);
context.SaveChanges();
this.GridViewQuestions.PageIndex = 0;
ErrorSuccessNotifier.AddInfoMessage("Question deleted.");
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
var dbContext = new PollSystemEntities();
int questionId = Convert.ToInt32(Request.Params["questionId"]);
var question = dbContext.Questions.Find(questionId);
if (question != null)
{
this.LabelQuestionText.Text = Server.HtmlEncode(question.Text);
this.RepeaterAnswers.DataSource = question.Answers.ToList();
this.DataBind();
}
else
{
ErrorSuccessNotifier.AddErrorMessage("This question does not exist anymore");
}
}
protected void GridViewQuestions_SelectedIndexChanged(object sender, EventArgs e)
{
var dbContext = new PollSystemEntities();
int questionId =
Convert.ToInt32(this.GridViewQuestions.SelectedDataKey.Value);
var question = dbContext.Questions.Find(questionId);
if (question != null)
{
this.RepeaterAnswers.DataSource = question.Answers.ToList();
this.RepeaterAnswers.DataBind();
}
else
{
ErrorSuccessNotifier.AddErrorMessage("This question doesn't exist anymore");
}
}
protected void OnBtnCreateQuestion_Click(object sender, EventArgs e)
{
string questionText = this.TextBoxQuestionText.Text;
if (questionText.Length < 4)
{
ErrorSuccessNotifier.AddErrorMessage("The question's length must be in range [4, 200] inclusive");
if (answers.Count < 2)
{
ErrorSuccessNotifier.AddErrorMessage("The question must have at least 2 answers");
}
}
else if (answers.Count < 2)
{
ErrorSuccessNotifier.AddErrorMessage("The question must have at least 2 answers");
}
else
{
var question = new Question()
{
Answers = answers.Select(answer => new Answer()
{
Text = answer
}).ToList(),
Text = questionText
};
try
{
var dbContext = new PollSystemEntities();
dbContext.Questions.Add(question);
dbContext.SaveChanges();
this.TextBoxQuestionText.Text = "";
answers = new List <string>();
ErrorSuccessNotifier.AddSuccessMessage("Question created");
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
}
// The id parameter name should match the DataKeyNames value set on the control
public void GridViewQuestions_DeleteItem(int questionId)
{
var context = new PollSystemEntities();
Question question = context.Questions.Include("Answers")
.FirstOrDefault(q => q.QuestionId == questionId);
try
{
context.Answers.RemoveRange(question.Answers);
context.Questions.Remove(question);
context.SaveChanges();
this.GridViewQuestions.PageIndex = 0;
ErrorSuccessNotifier.AddInfoMessage("Question deleted.");
}
catch (Exception ex)
{
ErrorSuccessNotifier.AddErrorMessage(ex);
}
}
protected void OnBtnVote_Command(object sender, CommandEventArgs e)
{
var dbContext = new PollSystemEntities();
int answerId = Convert.ToInt32(e.CommandArgument);
var answer = dbContext.Answers.Find(answerId);
if (answer != null)
{
answer.Votes++;
dbContext.SaveChanges();
ErrorSuccessNotifier.AddInfoMessage("You voted for " + answer.Text);
Response.Redirect("~/VotingResults.aspx?questionId=" + answer.QuestionId);
}
else
{
ErrorSuccessNotifier.AddErrorMessage("This answer does not exist anymore");
}
}
public IQueryable <Question> GridViewQuestions_GetData()
{
var dbContext = new PollSystemEntities();
return(dbContext.Questions.OrderBy(q => q.Text));
}
public IQueryable<Question> GridViewAllQuestions_GetData()
{
var context = new PollSystemEntities();
var questions = context.Questions.OrderBy(q => q.Text);
return questions;
}
