public void LoadPeriodsTestCase()
{
XlDatasource xlDatasource = new XlDatasource(connectionString, templateFilePath);
xlDatasource.LoadPeriods();
Assert.AreEqual(3, xlDatasource.Periods.Count);
}
public void PeriodGetPeriodTestCase()
{
XlDatasource xlDatasource = new XlDatasource(connectionString, templateFilePath);
xlDatasource.LoadPeriods();
Period period = xlDatasource.GetPeriod("2018", Month.January);
Assert.AreEqual("2018-January", period.PeriodName);
}
public void DeletePeriodWorkBookTestCase()
{
XlDatasource xlDatasource = new XlDatasource(connectionString, templateFilePath);
xlDatasource.LoadPeriods();
xlDatasource.DeletePeriod(period);
Assert.AreEqual("/home/olamide/Projects/BrewLog/BrewingModel/bin/Debug/2018", xlPeriod.FileInfo.DirectoryName);
}
public void DatasourceSaveBrewTestCase()
{
//CreateAndAddPeriodTestCase();
XlDatasource xlDatasource = new XlDatasource(connectionString, templateFilePath);
xlDatasource.LoadPeriods();
Brew brew = new Brew("01.01.2018", "Amstel", "AM18007");
brew.SetProcessParameterValue(ProcessEquipment.MashCopper, MashCopperProcessParameters.MashingInStartTime.ToString(), "01.01.2018 12:00:00");
brew.SetProcessParameterValue(ProcessEquipment.MashCopper, MashCopperProcessParameters.MashingInEndTime.ToString(), "01.01.2018 12:40:00");
string month = brew.Month;
xlDatasource.SaveBrew(brew);
Period period = xlDatasource.GetPeriod(brew);
Assert.AreEqual("2018-January", period.PeriodName);
}
public void PeriodUpdateBrewTestCase()
{
//CreateAndAddPeriodTestCase();
XlDatasource xlDatasource = new XlDatasource(connectionString, templateFilePath);
xlDatasource.LoadPeriods();
Brew brew = new Brew("01.01.2018", "Amstel", "AM18007");
brew.SetProcessParameterValue(ProcessEquipment.MashCopper, MashCopperProcessParameters.MashingInStartTime.ToString(), "01.01.2018 12:00:00");
brew.SetProcessParameterValue(ProcessEquipment.MashCopper, MashCopperProcessParameters.MashingInEndTime.ToString(), "01.01.2018 12:30:00");
Period period = xlDatasource.GetPeriod("2018", Month.January);
int oldBrewCount = period.Brews.Count;
period.UpdateBrew(brew);
Assert.AreEqual("2018-January", period.PeriodName);
Assert.AreEqual(oldBrewCount, period.Brews.Count);
}
