// Метод для выборки вопросов в билет
private QuestionsFromDb GetFromlistQuestionsFromDb()
{
//MessageBox.Show(randomNumber.ToString(),"");
QuestionsFromDb tempQuestionsFromDb = listQuestionsFromDb[randomIndex];
return(tempQuestionsFromDb);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
// Очистка всего списка вопросов с конкретного предмета
listQuestionsFromDb.Clear();
using (ExamTicket_dbEntities db = new ExamTicket_dbEntities())
{
// Выяснить количество вопросов в билете
var countQues = from s in db.Subjects
where s.name_subject == (string)labelSubject.Content
select s;
foreach (var tt in countQues)
{
countQuestion = (int)tt.quantity_questions_of_tiket;
current_id_subject = tt.id_subject;
}
// Загрузка вопросов в класс и массив
var questions = from q in db.Questions
where q.id_subject_ques == current_id_subject
select new { id = q.id_question, category = q.id_category_ques, text = q.text_quesation, picture = q.pathToPicture };
foreach (var query in questions)
{
QuestionsFromDb qFromDb = new QuestionsFromDb();
qFromDb.Id = query.id;
qFromDb.Category = query.category;
qFromDb.Text = query.text;
qFromDb.Picture = query.picture;
listQuestionsFromDb.Add(qFromDb);
}
}
// Вывод вопросов и рисунков
Generating();
}
