public bool DeleteByID(int id)
{
// 解除试题与题库之间的联系
var tmp1 = db.include_question_between_bank_and_trueorfalse.Where(p => p.BankID == id);
foreach (var i in tmp1)
{
db.include_question_between_bank_and_trueorfalse.Remove(i);
}
var tmp2 = db.include_question_between_bank_and_completion.Where(p => p.BankID == id);
foreach (var i in tmp2)
{
db.include_question_between_bank_and_completion.Remove(i);
}
var tmp3 = db.include_question_between_bank_and_selection.Where(p => p.BankID == id);
foreach (var i in tmp3)
{
db.include_question_between_bank_and_selection.Remove(i);
}
var tmp4 = db.include_question_between_bank_and_questionandanswer.Where(p => p.BankID == id);
foreach (var i in tmp4)
{
db.include_question_between_bank_and_questionandanswer.Remove(i);
}
var tmp5 = db.include_question_between_bank_and_reading.Where(p => p.BankID == id);
foreach (var i in tmp5)
{
db.include_question_between_bank_and_reading.Remove(i);
}
var tmp6 = db.include_question_between_bank_and_composition.Where(p => p.BankID == id);
foreach (var i in tmp6)
{
db.include_question_between_bank_and_composition.Remove(i);
}
// 删除题库
questionbank qb = db.questionbank.Where(p => p.ID == id).FirstOrDefault();
if (qb != null)
{
db.questionbank.Remove(qb);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool UpdateByID(int id, questionbank qb)
{
questionbank tmp = db.questionbank.Where(p => p.ID == id).FirstOrDefault();
if (tmp != null)
{
tmp.BankName = qb.BankName;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public questionbank Add(questionbank qb)
{
qb = db.questionbank.Add(qb);
db.SaveChanges();
return(qb);
}