public KpiTableEntity GetUserDashboardTileData(int userId, int tilePosition) { var storageTable = new KpiScheduledTaskStorageTable(); var tableQuery = storageTable.Table.CreateQuery<KpiTableEntity>(); return tableQuery.Where(i => i.UserId == userId && i.TilePosition == tilePosition).SingleOrDefault(); }
public List<KpiTableEntity> UserDashboardDataList(int userId) { var storageTable = new KpiScheduledTaskStorageTable(); var tableQuery = storageTable.Table.CreateQuery<KpiTableEntity>(); return tableQuery.Where(i => i.UserId == userId).ToList(); }
public void DeleteUserDashboardAllocation() { CloudCoreDB.Context.Cloudcore_DashboardUserAllocationDelete(UserId, TilePosition); var storageTable = new KpiScheduledTaskStorageTable(); var tableQuery = storageTable.Table.CreateQuery<KpiTableEntity>(); var kpiItems = tableQuery.Where(i => i.UserId == UserId && i.TilePosition == TilePosition).ToList(); kpiItems.ForEach(storageTable.Delete); }
public static void UpdateDashboard(string dashboardGuid ) { var storageTable = new KpiScheduledTaskStorageTable(); var tableQuery = storageTable.Table.CreateQuery<KpiTableEntity>(); var guid = Guid.Parse(dashboardGuid); var kpiItems = tableQuery.Where(i => i.DashboardGuid == guid).ToList(); kpiItems.ForEach(i => { if (!CloudCoreDB.Context.Cloudcore_VwUserDashboard.Select(udi => udi.DashboardGuid == i.DashboardGuid && udi.UserId == i.UserId).Any()) { storageTable.Delete(i); kpiItems.Remove(i); } }); Instance.NotifyOfChanges(kpiItems); }
private void SaveToTableStorage(IEnumerable<KpiTableEntity> kpiBatchData) { try { var storageTable = new KpiScheduledTaskStorageTable(); var list = kpiBatchData.ToList(); storageTable.UpdateBatch(list); } catch (Exception ex) { ex.Data.Add(Guid.NewGuid().ToString(), "Failed trying to save to table storage."); throw; } }