private void LoadData()
{
using (var accessor = new SQLiteShared.SQLiteDataAccessor())
{
data = accessor.CreateQuery <T>().ToArray();
}
}
private void InitPage()
{
btnShuffleQuestions.Tag = false;
//fetch ticket ids from database
using (var dataAccessor = new SQLiteShared.SQLiteDataAccessor())
{
Tickets = dataAccessor.CreateQuery <SQLiteShared.Models.Tickets>().ToArray();
}
//assign them to listview
listTickets.ItemsSource = Tickets;
listTickets.SelectionChanged += listTickets_SelectionChanged;
//disable "start" button
EnableControls();
}
public void SessionSelectsRightQuestions()
{
var ticketNums = new int[] { 1 };
ISession session;
var parameters = new SessionParameters()
{
Mode = QuestionsGenerationMode.SelectedTickets, TicketNums = ticketNums
};
var creationResult = SessionFactory.CreateSession(parameters, out session);
IEnumerable <string> questions;
using (var accessor = new SQLiteShared.SQLiteDataAccessor())
{
var ticketIds = accessor.CreateQuery <SQLiteShared.Models.Tickets>().Where(ticket => ticketNums.Contains(ticket.num)).Select(ticket => ticket.id);
questions = accessor.CreateQuery <SQLiteShared.Models.Questions>().Where(question => ticketIds.Contains(question.ticket_id)).Select(question => question.question).ToArray();
}
Assert.IsNotNull(session);
Assert.AreEqual(ParametersValidationResult.Valid, creationResult);
Assert.IsTrue(session.Tickets.Any());
Assert.IsTrue(questions.All(question => session.Tickets.SelectMany(ticket => ticket.Questions).Any(q => q.Text == question)));
}
