public void AddPeriodTestCase()
{
XlDatasource xlDatasource = new XlDatasource(connectionString, templateFilePath);
xlDatasource.AddPeriod(period);
Assert.AreEqual("/home/olamide/Projects/BrewLog/BrewingModel/bin/Debug/2018", xlPeriod.FileInfo.DirectoryName);
}
static void Main()
{
BrewingProcessHandler brewingProcessHandler = BrewingProcessHandler.GetInstance();
//brewingProcessHandler.StartNewBrew("09/09/2018", "Maltina", "258");
//ApplicationSettings appsettings = new ApplicationSettings();
MyAppSettings appSettings = MyAppSettings.GetInstance();
//string connectionString = appsettings.ConnectionString;
//string templateFilePath = appsettings.TemplateFilePath;
string connectionString = appSettings.ConnectionString;
string periodTemplateFilePath = appSettings.PeriodTemplateFilePath;
//string templateFilePath = $"{AppDomain.CurrentDomain.BaseDirectory}period_template.xlsx";
// Setup Datasource Handler
Datasource datasource = new XlDatasource(connectionString, periodTemplateFilePath);
DatasourceHandler datasourceHandler = DatasourceHandler.GetInstance(datasource);
// Gui Thread
ThreadStart guiRef = new ThreadStart(StartGui);
Thread guiThread = new Thread(guiRef);
guiThread.Start();
// Main thread
//BrewMonitorTimer brewMonitorTimer = BrewMonitorTimer.GetInstance();
//BrewMonitorTimer.Startup();
StartBrewMonitor();
//TestDataSource();
}
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 XlReportGenerator()
{
MyAppSettings appSettings = MyAppSettings.GetInstance();
string connectionString = appSettings.ConnectionString;
string templatePath = appSettings.PeriodTemplateFilePath;
Datasource xlDatasource = new XlDatasource(connectionString, templatePath);
datasourceHandler = DatasourceHandler.GetInstance(xlDatasource);
}
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);
}
