public void Insert(Int32 diff, String qeuestion_, String answerA, String answerB, String answerC, String answerD)
{
try
{
using (var db = new EntityDM.MillionareDBEntities3())
{
if (db.Questions.Where(x => x.Question.Equals(qeuestion_)).ToList().Count == 0)
{
var question = new EntityDM.Questions {
Difficulty = diff, Question = qeuestion_
};
db.Questions.Add(question);
db.SaveChanges();
var answer = new EntityDM.Answers
{
Questions_FK = db.Questions.Where(x => x.Question.Equals(qeuestion_)).ToList().First().Id,
Answer_A = answerA,
Answer_B = answerB,
Answer_C = answerC,
Answer_D = answerD
};
db.Answers.Add(answer);
db.SaveChanges();
}
else
{
throw (new Exception("Такой вопрос уже есть в базе"));
}
}
}
catch
{
throw;
}
}
public void delete(string qeuestion_)
{
try
{
using (var db = new EntityDM.MillionareDBEntities3())
{
IQueryable <EntityDM.Questions> question = db.Questions;
IQueryable <EntityDM.Answers> answer = db.Answers;
var q = question.Where(x => x.Question.Equals(qeuestion_)).ToList().First();
var a = answer.Where(x => x.Questions_FK == q.Id).ToList().First();
db.Answers.Remove(a);
db.Questions.Remove(q);
db.SaveChanges();
Update();
}
}
catch
{ throw; }
}
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; }
}