private void RemoveTestTemplateQuestion(int?id)
{
if (id == null)
{
throw new ArgumentNullException("Null argument");
}
TestTemplates_Questions testTemplates_Questions = db.testTemplates_Questions.Find(id);
db.testTemplates_Questions.Remove(testTemplates_Questions);
}
public void AddQuestionsToTestScheme(IEnumerable <Question> questions, TestTemplate testTemplate)
{
foreach (Question _question in questions)
{
TestTemplates_Questions testTemplates_Questions = new TestTemplates_Questions
{
questionID = _question.questionID,
testTemplateID = testTemplate.testTemplateID,
};
db.testTemplates_Questions.Add(testTemplates_Questions);
}
SaveChanges();
}
protected override void Seed(DataAccessLayer.DatabaseContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
Category cat1 = new Category {
categoryID = 1, categoryName = "C#"
};
Category cat2 = new Category {
categoryID = 2, categoryName = "C++"
};
Category cat3 = new Category {
categoryID = 3, categoryName = "Java"
};
Category cat4 = new Category {
categoryID = 4, categoryName = "JavaScript"
};
Category cat5 = new Category {
categoryID = 5, categoryName = "Python"
};
QuestionType qt1 = new QuestionType {
questionTypeID = 1, typeName = "Otwarte"
};
QuestionType qt2 = new QuestionType {
questionTypeID = 2, typeName = "Jednokrotnego wyboru"
};
QuestionType qt3 = new QuestionType {
questionTypeID = 3, typeName = "Wielokrotnego wyboru"
};
Question qu1 = new Question {
questionID = 1, value = "Pytanie 1", categoryID = cat1.categoryID, points = 1, questionTypeID = qt1.questionTypeID
};
Question qu2 = new Question {
questionID = 2, value = "Pytanie 2", categoryID = cat2.categoryID, points = 2, questionTypeID = qt2.questionTypeID
};
Question qu3 = new Question {
questionID = 3, value = "Pytanie 3", categoryID = cat3.categoryID, points = 3, questionTypeID = qt3.questionTypeID
};
Answer a1 = new Answer {
answerID = 1, value = "odpowiedz 1", isCorrect = true, questionID = 2
};
Answer a2 = new Answer {
answerID = 2, value = "odpowiedz 2", isCorrect = false, questionID = 2
};
TestTemplate tt1 = new TestTemplate {
testTemplateID = 1, templateName = "Szablon 1", description = "Opis1"
};
TestTemplates_Questions ttq1 = new TestTemplates_Questions {
testTemplates_QuestionsID = 1, testTemplateID = tt1.testTemplateID, questionID = qu1.questionID
};
Test t1 = new Test
{
testID = 1,
isCompleted = false,
testKey = "testkey123",
completionDate = null,
expirationDate = new DateTime(2020, 1, 1),
testTemplateID = 1,
completionTime = null,
username = "******",
timeLimit = 1,
percentageScore = null,
isReviewed = false
};
context.categories.AddOrUpdate(cat1);
context.categories.AddOrUpdate(cat2);
context.categories.AddOrUpdate(cat3);
context.categories.AddOrUpdate(cat4);
context.categories.AddOrUpdate(cat5);
context.questionTypes.AddOrUpdate(qt1);
context.questionTypes.AddOrUpdate(qt2);
context.questionTypes.AddOrUpdate(qt3);
context.questions.AddOrUpdate(qu1);
context.questions.AddOrUpdate(qu2);
context.questions.AddOrUpdate(qu3);
context.answers.AddOrUpdate(a1);
context.answers.AddOrUpdate(a2);
context.testTemplates.AddOrUpdate(tt1);
context.testTemplates_Questions.AddOrUpdate(ttq1);
context.tests.AddOrUpdate(t1);
context.SaveChanges();
}
