public Answer Add(PollAnswerDetails answer)
{
if (answer == null)
{
throw new ArgumentNullException("answer");
}
try
{
User_Answer user_ans = new User_Answer();
//ans.description = answer.answerDesc;
user_ans.answer_id = (db.Answers.Where(a => (a.description == answer.answerDesc && a.question_id == answer.questionId)).FirstOrDefault()).id;
user_ans.user_id = answer.userId;
user_ans.activity_id = answer.activityId;
user_ans.question_id = answer.questionId;
db.User_Answer.Add(user_ans);
db.SaveChanges();
Answer ans = db.Answers.Where(a => a.id == user_ans.answer_id).FirstOrDefault();
if (ans.count == null)
{
ans.count = 1;
}
else
{
ans.count = ans.count + 1;
}
db.SaveChanges();
//int count = (int)db.Answers.Where(a => a.id == user_ans.answer_id).FirstOrDefault().count;
//count = count + 1;
//db.Answers.Select(string.Format());
return(ans);
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (Exception e)
{
Console.WriteLine("Error occured: " + e.Message);
throw e;
}
}
public Answer PostPollAnswer(PollAnswerDetails answer)
{
try
{
return(repo.Add(answer));
}
catch (Exception ex)
{
throw ex;
}
}