public void ReadAndUpdateLiteDbData()
{
var bfLiteColl = dbConector.GetCollection <GingerBusinessFlow>("BusinessFlows");
var filterData = dbConector.FilterCollection(bfLiteColl, Query.Contains("Name", "bf name"));
filterData.ForEach(a => a.Name = a.Name + " Modified BF");
dbConector.SetCollection(bfLiteColl, filterData);
Assert.IsTrue(bfLiteColl.Count() > 0);
}
private async void LoadExecutionsHistoryData()
{
grdExecutionsHistory.Visibility = Visibility.Collapsed;
Loading.Visibility = Visibility.Visible;
mExecutionsHistoryList.Clear();
await Task.Run(() => {
if (WorkSpace.Instance.Solution != null && WorkSpace.Instance.Solution.LoggerConfigurations != null)
{
mRunSetExecsRootFolder = executionLoggerHelper.GetLoggerDirectory(WorkSpace.Instance.Solution.LoggerConfigurations.CalculatedLoggerFolder);
//pull all RunSets JSON files from it
string[] runSetsfiles = Directory.GetFiles(mRunSetExecsRootFolder, "RunSet.txt", SearchOption.AllDirectories);
try
{
foreach (string runSetFile in runSetsfiles)
{
RunSetReport runSetReport = (RunSetReport)JsonLib.LoadObjFromJSonFile(runSetFile, typeof(RunSetReport));
runSetReport.DataRepMethod = ExecutionLoggerConfiguration.DataRepositoryMethod.TextFile;
runSetReport.LogFolder = System.IO.Path.GetDirectoryName(runSetFile);
if (mExecutionHistoryLevel == eExecutionHistoryLevel.SpecificRunSet)
{
//filer the run sets by GUID
if (RunsetConfig != null && string.IsNullOrEmpty(runSetReport.GUID) == false)
{
Guid runSetReportGuid = Guid.Empty;
Guid.TryParse(runSetReport.GUID, out runSetReportGuid);
if (RunsetConfig.Guid.Equals(runSetReportGuid))
{
mExecutionsHistoryList.Add(runSetReport);
}
}
}
else
{
mExecutionsHistoryList.Add(runSetReport);
}
}
LiteDbConnector dbConnector = new LiteDbConnector(Path.Combine(mRunSetExecsRootFolder, "GingerExecutionResults.db"));
var rsLiteColl = dbConnector.GetCollection <LiteDbRunSet>(NameInDb <LiteDbRunSet>());
var runSetDataColl = rsLiteColl.FindAll();
foreach (var runSet in runSetDataColl)
{
RunSetReport runSetReport = new RunSetReport();
runSetReport.DataRepMethod = ExecutionLoggerConfiguration.DataRepositoryMethod.LiteDB;
runSetReport.SetLiteDBData(runSet);
mExecutionsHistoryList.Add(runSetReport);
}
}
catch { }
}
});
ObservableList <RunSetReport> executionsHistoryListSortedByDate = new ObservableList <RunSetReport>();
foreach (RunSetReport runSetReport in mExecutionsHistoryList.OrderByDescending(item => item.StartTimeStamp))
{
runSetReport.StartTimeStamp = runSetReport.StartTimeStamp.ToLocalTime();
runSetReport.EndTimeStamp = runSetReport.EndTimeStamp.ToLocalTime();
executionsHistoryListSortedByDate.Add(runSetReport);
}
grdExecutionsHistory.DataSourceList = executionsHistoryListSortedByDate;
grdExecutionsHistory.Visibility = Visibility.Visible;
Loading.Visibility = Visibility.Collapsed;
}