public void DeleteBindGroup(int id_q, int id_a)
{
AnswerAll tmp = db2.SetAnswerAll.FirstOrDefault(u => u.QuestionID == id_q && u.AnswerKey == id_a);
tmp.BindGroup = null;
db2.SaveChanges();
}
public void Answer(AnswerModel tmp)
{
if (ModelState.IsValid)
{
if (tmp.Id > 0)
{
QuestionModel question = db.SetQuestions.FirstOrDefault(u => u.Id == tmp.QuestionID);
AnswerModel answer = db.SetAnswers.Where(u => u.Id == tmp.Id).FirstOrDefault();
answer.QuestionID = question.Id;
answer.AnswerText = tmp.AnswerText;
answer.isFreeArea = tmp.isFreeArea;
answer.Index = tmp.Index;
db.SaveChanges();
}
else
{
AnswerAll answerAll = new AnswerAll();
db.Entry(tmp).State = EntityState.Added;
db.SaveChanges();
answerAll.AnswerKey = tmp.Id;
answerAll.QuestionID = tmp.QuestionID;
answerAll.AnswerType = 1;
answerAll.BindGroup = null;
setAnswerAll(answerAll);
}
}
}
public void deleteAnswerAll(int id_answer)
{
AnswerAll tmpAnswerAll = db.SetAnswerAll.Where(u => u.Id == id_answer).FirstOrDefault();
db.SetAnswerAll.Remove(tmpAnswerAll);
db.SaveChanges();
}
public void deleteAnswer(int Id)
{
AnswerModel answer = db.SetAnswers.Where(u => u.Id == Id).First();
AnswerAll tmpAnswerAll = db.SetAnswerAll.Where(u => u.AnswerKey == Id).FirstOrDefault();
List <AnswerModel> list_tmp_answer = db.SetAnswers.Where(u => u.QuestionID == answer.QuestionID && u.Index > answer.Index).ToList();
if (list_tmp_answer != null)
{
int count = answer.Index;
foreach (var item in list_tmp_answer)
{
item.Index = count;
count++;
}
}
DeleteQuota(db.SetQuestions.First(u => u.Id == answer.QuestionID).ProjectID, answer.QuestionID);
db.SetAnswerAll.Remove(tmpAnswerAll);
db.Entry(answer).State = EntityState.Deleted;
db.SaveChanges();
}
public void setAnswerAll(AnswerAll answer)
{
db.SetAnswerAll.Add(answer);
db.SaveChanges();
}
