public void LookupTest()
{
string filename = @"planning kinderen en leiding.xlsx";
ExcelDataReader target = new ExcelDataReader(filename);
int groupnumber = 26;
DateTime time = new DateTime(2011, 10, 15, 10, 00, 00);//(15-10-2011 10:00:00);
string expected = "Klimtoren"; //See cell G6,7,8 on Kleine speltakken
string actual = target.Lookup(groupnumber, time); //TODO: Works only for group Klein
Assert.AreEqual(expected, actual);
}
void Window1_Loaded(object sender, RoutedEventArgs e)
{
Console.WriteLine("Window Loaded");
#if DEBUG
//MessageBox.Show("Welkom bij de JOTARI!");
//MessageBox.Show("Welkom bij de JOTARI 2!");
#endif
timer = new DispatcherTimer();
timer.Interval = new TimeSpan(0, 1, 0);
timer.Tick += new EventHandler(timer_Tick);
timer.Start();
timer_Tick(null, null);
Console.WriteLine("Creating ExcelDataReader");
excel = new ExcelDataReader(@"planning kinderen en leiding.xlsx");
Console.WriteLine("Creating ZBarInterface");
scanner = new ZBarInterface();
scanner.CodeRead += new CodeReadHandler(scanner_CodeRead);
Console.WriteLine("Starting Scanner");
scanner.Start();
Console.WriteLine("Getting schedule from file");
schedule = excel.GenerateActivityTimeLines(36, 48);//GetSchedule();
#region fill comboboxes
for (int k = 1; k <= 36; k++)
{
groupSelector.Items.Add("Klein" + k.ToString());
}
for (int g = 1; g <= 48; g++)
{
groupSelector.Items.Add("Groot" + g.ToString());
}
#endregion
Keyboard.Focus(groupSelector);
}