public void FillAnswers(Object sender, EventArgs e)
{
QuestionAnswersStruct question_answer = model_edit_question.GetAnswers(iquestionEdit.question_checked);
iquestionEdit.answerA_new_text = question_answer.answerA;
iquestionEdit.answerB_new_text = question_answer.answerB;
iquestionEdit.answerC_new_text = question_answer.answerC;
iquestionEdit.answerD_new_text = question_answer.answerD;
}
public void Edit(Object sender, EventArgs e)
{
QuestionAnswersStruct question_answer = new QuestionAnswersStruct();
question_answer.question_old = iquestionEdit.question_checked;
question_answer.question_new = iquestionEdit.question_new_text;
question_answer.answerA = iquestionEdit.answerA_new_text;
question_answer.answerB = iquestionEdit.answerB_new_text;
question_answer.answerC = iquestionEdit.answerC_new_text;
question_answer.answerD = iquestionEdit.answerD_new_text;
model_edit_question.Edit(question_answer);
UpdateView();
}
public QuestionAnswersStruct GetAnswers(String question)
{
using (var db = new EntityDM.MillionareDBEntities3())
{
IQueryable <EntityDM.Answers> answers = db.Answers;
var answer = answers.Where(x => x.Questions.Question == question).ToList().First();
QuestionAnswersStruct qa = new QuestionAnswersStruct();
qa.answerA = answer.Answer_A;
qa.answerB = answer.Answer_B;
qa.answerC = answer.Answer_C;
qa.answerD = answer.Answer_D;
return(qa);
}
}
public void Edit(QuestionAnswersStruct qa)
{
try
{
using (var db = new EntityDM.MillionareDBEntities3())
{
IQueryable <EntityDM.Questions> q = db.Questions;
IQueryable <EntityDM.Answers> a = db.Answers;
var question = q.Where(x => x.Question.Equals(qa.question_old)).ToList().First();
var answer = a.Where(x => x.Questions_FK == question.Id).ToList().First();
answer.Answer_A = qa.answerA;
answer.Answer_B = qa.answerB;
answer.Answer_C = qa.answerC;
answer.Answer_D = qa.answerD;
question.Question = qa.question_new;
db.SaveChanges();
Update();
}
}
catch
{ throw; }
}