async static Task <BackgroundTaskModel> PopFromBackgroundQueue(int TaskTypeId, bool getLatest = true)
{
Service = new SimpleDataService <BackgroundTaskModel>(Connection, TableConsts.BACKGROUND_TASK_TABLE);
var backgroundQueue = await Service.GetItemsAsync();
var elements = backgroundQueue;
BackgroundTaskModel popedElement = null;
if (TaskTypeId != -1)
{
elements = backgroundQueue.Where(t => t.ID_TaskType == TaskTypeId);
}
if (getLatest)
{
popedElement = elements
.OrderByDescending(x => x.CreationDateTime)
.FirstOrDefault();
}
popedElement = elements
.OrderBy(x => x.CreationDateTime)
.FirstOrDefault();
if (popedElement != null)
{
await RemoveElementFromQueue(Connection, popedElement);
}
return(popedElement);
}
public static async Task <int> GetQueueElementCount(SQLiteConnection connection)
{
Connection = connection;
Service = new SimpleDataService <BackgroundTaskModel>(Connection, TableConsts.BACKGROUND_TASK_TABLE);
var queue = await Service.GetItemsAsync();
return(queue.Count());
}
public void TestSimpleDataServiceGetItemsFromWaterModels()
{
SimpleDataService <WaterModel> simpleService = new SimpleDataService <WaterModel>(_connection, "WaterModels");
IEnumerable <WaterModel> result = simpleService.GetItemsAsync().Result;
Assert.NotNull(result);
List <WaterModel> waterModels = (List <WaterModel>)result;
Assert.True(waterModels.Count > 0);
}
public async void TestGetSettings()
{
DataServiceFactory.Connection = _connection;
SimpleDataService <SettingModel> factory = DataServiceFactory.GetSettingFactory();
Assert.NotNull(factory);
IEnumerable <SettingModel> settings = await factory.GetItemsAsync();
Assert.NotNull(settings);
List <SettingModel> settingsList = (List <SettingModel>)settings;
Assert.True(settingsList.Count > 0);
}
