public void TestExcelGetNextMatchday()
{
var settings = new Settings {
TargetFileName = ""
}; // insert file here
var excel = new ExcelHandler();
excel.OpenFile(settings.TargetFileName);
var matchday = excel.ReadMatchdayNo();
Assert.AreEqual(19, matchday); // insert expected matchday here
}
public void TestExcelReadUserList()
{
var settings = new Settings {
TargetFileName = ""
}; // insert file here
var excel = new ExcelHandler();
excel.OpenFile(settings.TargetFileName);
var users = excel.ReadUserList();
Assert.AreEqual(20, users.Count);
Assert.AreEqual("", users[0].Name); // insert expected username here
Assert.AreEqual("", users[7].Name); // insert expected username here
Assert.AreEqual("", users[19].Name); // insert expected username here
}
public void TestExcelGetNextMatchdayMatches()
{
var settings = new Settings {
TargetFileName = ""
}; // insert file here
var excel = new ExcelHandler();
excel.OpenFile(settings.TargetFileName);
var matchday = excel.GetNextMatchdayMatches();
Assert.AreEqual(9, matchday.Count);
Assert.AreEqual(new FootballMatch {
TeamA = "", TeamB = ""
}, matchday[1]); // insert expected match here
Assert.AreEqual(new FootballMatch {
TeamA = "", TeamB = ""
}, matchday[8]); // insert expected match here
}