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); }