public void Delete(DalAnswer e)
{
if (context.Database.Connection.State != ConnectionState.Open)
context.Database.Connection.Open();
Answers answer = context.Set<Answers>().FirstOrDefault(a => a.id == e.Id);
context.Set<Answers>().Remove(answer);
}
public void Create(DalAnswer e)
{
if (context.Database.Connection.State != ConnectionState.Open)
context.Database.Connection.Open();
Answers answer = new Answers()
{
id = e.Id,
AnswerStructure = e.AnswerStructure,
AnswerValue = e.AnswerValue,
QuestionId = e.QuestionId
};
context.Set<Answers>().Add(answer);
}
public bool ExistAnswer(DalQuestion question, DalAnswer answer)
{
if (context.Database.Connection.State != ConnectionState.Open)
context.Database.Connection.Open();
return context.Set<Answers>()
.Any(answers => answers.AnswerStructure == answer.AnswerStructure
&& answers.QuestionId == question.Id);
}
public void Update(DalAnswer entity)
{
if (context.Database.Connection.State != ConnectionState.Open)
context.Database.Connection.Open();
Answers answer = context.Set<Answers>().FirstOrDefault(a => a.id == entity.Id);
answer.AnswerStructure = entity.AnswerStructure;
answer.AnswerValue = entity.AnswerValue;
answer.QuestionId = entity.QuestionId;
}
