private async Task RefreshOrderList() { MobileServiceInvalidOperationException exception = null; try { orders = await ordersTable .OrderByDescending(x => x.Id) .ToCollectionAsync(); customers = await customersTable.CreateQuery().ToCollectionAsync(); ListItems.ItemsSource = orders; TextCustomer.ItemsSource = customers; } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems. items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; } }
public async static Task <Face> GetLatestFace() { faces = await faceTable .OrderByDescending(faceTable => faceTable.UpdatedAt).ToCollectionAsync(); return(faces[0]); }
private async void RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable.OrderByDescending(items2=>items2.Score) .ToCollectionAsync(); for (int i = 0; i <= items.Count-1; i++) { items[i].Id = i + 1; } } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { listPoints.ItemsSource = items; } }
private async void RefreshAsync() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. items = await todoTable.ToCollectionAsync(); myList = new List <string>(); foreach (ToDoItem item in items) { myList.Add(item.Text); } } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { } else { list.ItemsSource = myList; } }
public void MobileServiceCollectionCanCopyToAndNotNotifies() { // Get the Books table MobileServiceTableQueryMock <Book> query = new MobileServiceTableQueryMock <Book>(); query.EnumerableAsyncThrowsException = true; MobileServiceCollection <Book> collection = new MobileServiceCollection <Book>(query); List <string> properties = new List <string>(); List <string> expectedProperties = new List <string>() { }; List <NotifyCollectionChangedAction> actions = new List <NotifyCollectionChangedAction>(); List <NotifyCollectionChangedAction> expectedActions = new List <NotifyCollectionChangedAction>() { }; Book book = new Book(); collection.Add(book); Book[] books = new Book[1]; ((INotifyPropertyChanged)collection).PropertyChanged += (s, e) => properties.Add(e.PropertyName); collection.CollectionChanged += (s, e) => actions.Add(e.Action); collection.CopyTo(books, 0); Assert.AreEqual(1, collection.Count); Assert.AreEqual(1, books.Count()); Assert.AreEqual(collection[0], books[0]); Assert.IsTrue(properties.SequenceEqual(expectedProperties)); Assert.IsTrue(actions.SequenceEqual(expectedActions)); }
public async Task <bool> RefreshSessionItems(dxevent _chosenSession) { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the session table. items = await sessionTable .Where(sessionItem => sessionItem.eventid == _chosenSession.id) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { //await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); return(false); } else { return(true); } }
public void MobileServiceCollectionCanClearAndNotifies() { // Get the Books table MobileServiceTableQueryMock <Book> query = new MobileServiceTableQueryMock <Book>(); query.EnumerableAsyncThrowsException = true; MobileServiceCollection <Book> collection = new MobileServiceCollection <Book>(query); List <string> properties = new List <string>(); List <string> expectedProperties = new List <string>() { "Count", "Item[]" }; List <NotifyCollectionChangedAction> actions = new List <NotifyCollectionChangedAction>(); List <NotifyCollectionChangedAction> expectedActions = new List <NotifyCollectionChangedAction>() { NotifyCollectionChangedAction.Reset }; Book book = new Book(); collection.Add(book); ((INotifyPropertyChanged)collection).PropertyChanged += (s, e) => properties.Add(e.PropertyName); collection.CollectionChanged += (s, e) => actions.Add(e.Action); collection.Clear(); Assert.AreEqual(0, collection.Count); Assert.IsTrue(properties.SequenceEqual(expectedProperties)); Assert.IsTrue(actions.SequenceEqual(expectedActions)); }
public async Task MobileServiceCollectionHasMoreItemsShouldBeFalseAfterRetrievingDataWhenNoPaging() { // Get the Books table MobileServiceTableQueryMock <Book> query = new MobileServiceTableQueryMock <Book>(); MobileServiceCollection <Book> collection = new MobileServiceCollection <Book>(query); CancellationTokenSource tokenSource = new CancellationTokenSource(); List <string> properties = new List <string>(); List <string> expectedProperties = new List <string>() { "HasMoreItems", "Count", "Item[]", "Count", "Item[]", "TotalCount" }; List <NotifyCollectionChangedAction> actions = new List <NotifyCollectionChangedAction>(); List <NotifyCollectionChangedAction> expectedActions = new List <NotifyCollectionChangedAction>() { NotifyCollectionChangedAction.Add, NotifyCollectionChangedAction.Add }; ((INotifyPropertyChanged)collection).PropertyChanged += (s, e) => properties.Add(e.PropertyName); collection.CollectionChanged += (s, e) => actions.Add(e.Action); int result = await collection.LoadMoreItemsAsync(tokenSource.Token); Assert.IsFalse(collection.HasMoreItems); Assert.IsTrue(properties.SequenceEqual(expectedProperties)); Assert.IsTrue(actions.SequenceEqual(expectedActions)); }
private async void RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { MessageBox.Show(exception.Message, "Error loading items"); } else { ListItems.ItemsSource = items; } }
private async Task RefreshTodoItems() { //App.MobileService.LoginAsync(MobileServiceAuthenticationProvider.MicrosoftAccount); MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; } }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable .Where(TodoItem => TodoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } //else //{ // ListItems.ItemsSource = items; // this.btnRefresh.IsEnabled = true; //} }
private async void GetData() { username = USERNAME.Text; password = PASSWORD.Password; if(username.Equals("") || password.Equals("")){ MessageBox.Show("Username or Password cannot be empty","Error",MessageBoxButton.OK); } else{ try { credentials = await credentialTable. Where(userCredentials => userCredentials.username == username && userCredentials.password == password). ToCollectionAsync(); } catch(MobileServiceInvalidOperationException e) { MessageBox.Show(e.Message,"Database Error",MessageBoxButton.OK); } int count = credentials.Count(); if (count == 1) { NavigationService.Navigate(new Uri("/MainPage.xaml", UriKind.Relative)); } } }
private async void radioButtonEliminar_Checked(object sender, RoutedEventArgs e) { disableTexBox(); comboBoxIdTecnicoEditar.IsEnabled = true; buttonEliminar.Visibility = Visibility.Visible; textBlockTitleNewEdit.Text = "Eliminar Técnico"; comboBoxIdTecnicoEditar.DisplayMemberPath = "id"; comboBoxIdTecnicoEditar.SelectedValuePath = "id"; try { ProgressBarBefore(); usuarios = await UsuariosTable .Select(Tecnicos => Tecnicos) .Where(Tecnicos => Tecnicos.Tipo == "Tecnico") .ToCollectionAsync(); comboBoxIdTecnicoEditar.ItemsSource = usuarios; ProgressBarAfter(); if (usuarios.Count >= 1) { comboBoxIdTecnicoEditar.SelectedIndex = 0; } } catch (MobileServiceInvalidOperationException ex) { exception = ex; } if (exception != null) { await new MessageDialog(exception.Message, "Error al cargar!").ShowAsync(); } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { int f = 0; StorageFolder folder = Windows.Storage.ApplicationData.Current.LocalFolder; StorageFile sampleFile = await folder.CreateFileAsync("Sample.txt", CreationCollisionOption.OpenIfExists); try { string testlol = await Windows.Storage.FileIO.ReadTextAsync(sampleFile); ids = JsonConvert.DeserializeObject <List <string> >(testlol); items = await Table.ToCollectionAsync(); } catch (Exception ex) { f = 1; } finally { if (f == 1) { MessageDialog m = new MessageDialog("Oops... There was some Problem Handling your Request"); await m.ShowAsync(); } else { Voice.ItemsSource = items; } } }
private async void RefreshAsync() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await SitesTable.ToCollectionAsync(); myList = new List<string>(); foreach (ToDoItem item in items) { myList.Add(item.Text); } } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { } else { list.ItemsSource = myList; } }
// Referesh List Method private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems user = await todoTable .Where(TodoItem => TodoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { var dialog = new MessageDialog("Successfully Updated"); await dialog.ShowAsync(); } }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { //ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; } }
async private void DeleteCourseForm_Tapped(object sender, TappedRoutedEventArgs e) { //populated delete course form information for easy deletion. MobileServiceInvalidOperationException exception1 = null; try { if (deleteSelectedName.SelectedValue != null) { classList = await completedCourses .Where(CoursesComplete => CoursesComplete.courseName == deleteSelectedName.SelectedItem.ToString() && CoursesComplete.courseRemoved == false) .ToCollectionAsync(); deleteId.Text = classList[0].Id; deleteCourseName.Text = classList[0].courseName; deleteCourseNumber.Text = classList[0].courseNumber; deleteCreditsReceived.Text = classList[0].courseCredits; deleteGrade.Text = classList[0].gradeReceived; deleteQuarter.Text = classList[0].quarterComplete; deleteInstructor.Text = classList[0].instructorName; } else { await new MessageDialog("Course Name not selected").ShowAsync(); } } catch (MobileServiceInvalidOperationException e2) { exception1 = e2; } }
public async static Task <Person> GetLatestPerson() { persons = await personTable .OrderByDescending(personTable => personTable.UpdatedAt).ToCollectionAsync(); return(persons[0]); }
private async void addyestoday() { Zw = Zd = 0; ys = await ya.Where(fthingItem => fthingItem.Year == year && fthingItem.Month == month && fthingItem.Day == day - 1 && fthingItem.User == Username) .ToCollectionAsync(); if (ys.Count == 0) { todayaddpoints t = new todayaddpoints(); t.Isadd = false; t.Year = year; t.Month = month; t.Day = day - 1; t.User = Username; t.Nowgp = 0; t.Nowtp = 0; await ya.InsertAsync(t); } if (ys.Count != 0) { /* uitems = await ut * .Where(userItem => userItem.Username == Username) * .ToCollectionAsync(); * user u = uitems.First(); * u.tp = u.tp + ys.First().Nowtp; * u.gp = u.gp + ys.First().Nowgp; * * * await ut.UpdateAsync(u);*/ Zw += ys.First().Nowgp; Zd += ys.First().Nowtp; } }
private async void tr() { String time = Time.Text; char[] s = new char[1]; s[0] = '/'; String[] t = time.Split(s); //Time.Text = t[0] + t[1] + t[2]; year = int.Parse(t[0]); month = int.Parse(t[1]); day = int.Parse(t[2]); try { items = await todoTable .Where(thingItem => thingItem.Year == year && thingItem.Month == month && thingItem.Day == day && thingItem.User == Username) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { MessageBox.Show(e.Message, "Error loading items", MessageBoxButton.OK); } ListItems.ItemsSource = items; }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable .OrderBy(todoItem => todoItem.Text) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; } }
private async void RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { MessageBox.Show(exception.Message, "Error loading items"); } else { ListItems.ItemsSource = items; } }
public async Task <TodoItem> RefreshTodoItemAsync(string key) { MobileServiceInvalidOperationException exception = null; MobileServiceCollection <TodoItem, TodoItem> items = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await todoTable .Where(l => l.Id == key) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading item").ShowAsync(); } return(items.ToList <TodoItem>().FirstOrDefault()); }
private async void Project_Tapped(object sender, TappedRoutedEventArgs e) { List <String> param = new List <String>(); string text = ((sender as StackPanel).FindName("projectId") as TextBlock).Text; param.Add(text); bids = await bidTable .Where(Bid => Bid.ProjectId == text) .Where(Bid => Bid.Bidder == "*****@*****.**") //Bidder should come from global.cs .ToCollectionAsync(); List <Bid> bidList = new List <Bid>(); bidList = bids.ToList(); if (bidList.Count == 0) // The user has not bid for this project before { Debug.Write("Add Bid"); param.Add("Add"); } else // The user wants to update the bid for this project { Debug.Write("Update Bid"); param.Add("Update"); } Debug.Write("Text: " + text); Frame.Navigate(typeof(Bidding), param); }
// gegevens uit database halen private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems. items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); //gegevens database in observeble collection plaatsn foreach (TodoItem item in items) { //item.Add(item);//items tovoegen } } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { //ListItems.ItemsSource = items; //this.ButtonSave.IsEnabled = true; } }
async private void LoadEditRecipe_Clicked(object sender, RoutedEventArgs e) { MobileServiceInvalidOperationException exception1 = null; try { if (editRecipeName.SelectedValue != null) { singleRecipe = await recipesList .Where(RecipesList => RecipesList.recipeName == editRecipeName.SelectedItem.ToString()) .ToCollectionAsync(); editHiddenID.Text = singleRecipe[0].Id; editHiddenRecipeName.Text = singleRecipe[0].recipeName; editRecipeShareable.IsChecked = singleRecipe[0].isChecked; editingredient1.Text = singleRecipe[0].ingredient1; editingredient2.Text = singleRecipe[0].ingredient2; editingredient3.Text = singleRecipe[0].ingredient3; editingredient4.Text = singleRecipe[0].ingredient4; editingredient5.Text = singleRecipe[0].ingredient5; editingredient6.Text = singleRecipe[0].ingredient6; editingredient7.Text = singleRecipe[0].ingredient7; } else { await new MessageDialog("Recipe Name not selected.").ShowAsync(); } } catch (MobileServiceInvalidOperationException e1) { exception1 = e1; } }
async private void EditRecipe_Clicked(object sender, RoutedEventArgs e) { AddRecipeGrid.Visibility = Visibility.Collapsed; EditRecipeGrid.Visibility = Visibility.Visible; ViewRecipeGridHeader.Visibility = Visibility.Collapsed; ClearUpdate(); MobileServiceInvalidOperationException exception = null; try { singleRecipe = await recipesList .Where(RecipesList => RecipesList.userID == MainPage.SessionUser.sessionUsername) .OrderBy(RecipesList => RecipesList.recipeName) .ToCollectionAsync(); if (singleRecipe.Count == 0) { await new MessageDialog("No Recipes Available to Update").ShowAsync(); } else { editRecipeName.Items.Clear(); for (int i = 0; i < singleRecipe.Count; i++) { editRecipeName.Items.Add(singleRecipe[i].recipeName); } } } catch (MobileServiceInvalidOperationException ex) { exception = ex; } }
public MainScreenMessage(bool isNew, TrainingItem trainingItem, MobileServiceCollection<TrainingItem, TrainingItem> items, IMobileServiceTable<TrainingItem> trainingItemsTable) { _isNewTraining = isNew; _trainingItem = trainingItem; _items = items; _trainingItemsTable = trainingItemsTable; }
private async void RefreshTodoItems() { // TODO: Mark this method as "async" and uncomment the following block of code. MobileServiceInvalidOperationException exception = null; try { // TODO #1: uncomment the following statment // that defines a simple query for all items. items = await todoTable.ToCollectionAsync(); // // TODO #2: More advanced query that filters out completed items. // items = await todoTable // .Where(todoItem => todoItem.Complete == false) // .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; } // Comment-out or delete the following lines of code. //this.ButtonSave.IsEnabled = true; //ListItems.ItemsSource = items; }
async void MainPage_Loaded(object sender, RoutedEventArgs e) { Start.channel.PushNotificationReceived += channel_PushNotificationReceived; test = new ObservableCollection<ChatPubList>(); items = await Table.OrderByDescending(ChatPublic => ChatPublic.__CreatedAt).ToCollectionAsync(); var networkProfiles = Windows.Networking.Connectivity.NetworkInformation.GetConnectionProfiles(); var adapter = networkProfiles.First<Windows.Networking.Connectivity.ConnectionProfile>().NetworkAdapter;//takes the first network adapter string networkAdapterId = adapter.NetworkAdapterId.ToString(); foreach (ChatPublic k in items) { ChatPubList a = new ChatPubList(); a.date = k.__CreatedAt.Date.ToString(); a.time = k.__CreatedAt.TimeOfDay.ToString(); a.time=a.time.Remove(5); a.date=a.date.Remove(10); a.Name = k.Name; a.Message = k.Message; if (a.Name == networkAdapterId) { a.col = "#FF9B0E00"; } else { a.col = "#FF5D340C"; } test.Add(a); } lol.ItemsSource = test; test.CollectionChanged += test_CollectionChanged; }
protected override async void OnNavigatedTo(NavigationEventArgs e) { this.navigationHelper.OnNavigatedTo(e); string title = (string)e.Parameter; MobileServiceInvalidOperationException exception = null; try { CommentsItems = await CommentsTable. Where(Comments => Comments.to == title). ToCollectionAsync(); } catch (MobileServiceInvalidOperationException ex) { exception = ex; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { int length = CommentsItems.Count(); for (int count = 0; count < length; count++) { ListItems.Items.Add(CommentsItems[count].title); } } Ring.IsActive = false; }
private async void nowpoints() { nfitems = await ftodoTable .Where(fthingItem => fthingItem.Year == year && fthingItem.Month == month && fthingItem.Day == day && fthingItem.User == Username) .ToCollectionAsync(); int g = 0; int t = 0; fthing[] n = nfitems.ToArray(); DateTime d = DateTime.Now; int i = 0; while (i < n.Length) { if (n[i].Type == "个人") { if (n[i].Level == "日常") { g += 5; } if (n[i].Level == "周期") { g += 8; } if (n[i].Level == "特殊") { g += 16; } if (n[i].Level == "生死攸关") { g += 30; } g -= n[i].Fhour; } if (n[i].Type == "团体") { if (n[i].Level == "日常") { t += 5; } if (n[i].Level == "周期") { t += 8; } if (n[i].Level == "特殊") { t += 16; } if (n[i].Level == "生死攸关") { t += 30; } t -= n[i].Fhour; } i++; } ntpoint = t; ngpoint = g; }
private async void SearchButton2_Click(object sender, RoutedEventArgs e) { StoreListView2.Visibility = Visibility.Collapsed; SearchButton2.Visibility = Visibility.Collapsed; LoadingBar2.Visibility = Visibility.Visible; LoadingBar.IsIndeterminate = true; try { items2 = await Table2.Where(Collections => Collections.Name.Contains(Box2.Text)).ToCollectionAsync(); StoreListView2.ItemsSource = items2; Box2.Visibility = Visibility.Visible; StoreListView2.Visibility = Visibility.Visible; SearchButton2.Visibility = Visibility.Visible; LoadingBar2.Visibility = Visibility.Collapsed; //write code to navigate to detail page of collection } catch (Exception) { MessageDialog msgbox = new MessageDialog("Something is not right at this time"); await msgbox.ShowAsync(); LoadingBar2.Visibility = Visibility.Collapsed; } }
private async void submit() { submityes = await suby .Where(fthingItem => fthingItem.Year == year && fthingItem.Month == month && fthingItem.Day == day - 1 && fthingItem.User == Username) .ToCollectionAsync(); todayaddpoints tt = submityes.First(); if (tt.Isadd == false) { todayaddpoints t = submityes.First(); t.Isadd = true; await tftodoTable.UpdateAsync(t); pgoint += Zw; ptoint += Zd; tp.Text = ptoint.ToString(); gp.Text = pgoint.ToString(); uitems = await ut .Where(userItem => userItem.Username == Username) .ToCollectionAsync(); user u = uitems.First(); u.gp = pgoint; u.tp = ptoint; await ut.UpdateAsync(u); } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { rec = new StoreListing(); LoadingBar.Visibility = Visibility.Visible; LoadingBar.IsIndeterminate = true; rec = e.Parameter as StoreListing; Title.Text = rec.Title; Cover.Source = rec.Image; FullCost.Text = "Tour " + rec.Price; string[] ids = rec.MyId.Split(','); try { foreach (string nid in ids) { if (nid != "") { recM = new StoreListing(); items = await Table.Where(Scrap => Scrap.Id == nid).ToCollectionAsync(); recM.Id = items[0].Id; recM.Title = items[0].Title; recM.MyId = items[0].Point_List; recM.Image = new Windows.UI.Xaml.Media.Imaging.BitmapImage(new Uri(this.BaseUri, "Assets/augmented-reality-for-blog.jpg")); // image fromasset store sl.Add(recM); } } StoreListView.DataContext = sl; } catch (Exception) { } }
private async void Button_Click(object sender, RoutedEventArgs e) { LoadingBar.Visibility = Visibility.Visible; LoadingBar.IsActive = true; try { items2 = await Table2.Where(User => User.username == testlol).ToCollectionAsync(); User a = items2[0]; if (!(Funds.Text.All(char.IsDigit))) { LoadingBar.Visibility = Visibility.Collapsed; MessageDialog msgbox = new MessageDialog("Enter correct amount"); await msgbox.ShowAsync(); return; } a.wallet += int.Parse(Funds.Text); await Table2.UpdateAsync(a); MessageDialog msgbox1 = new MessageDialog("Money Added!!"); LoadingBar.Visibility = Visibility.Collapsed; await msgbox1.ShowAsync(); Frame.Navigate(typeof(MainPage)); } catch (Exception) { LoadingBar.Visibility = Visibility.Collapsed; MessageDialog msgbox = new MessageDialog("Can't add money"); await msgbox.ShowAsync(); } }
private async void LoadChartContents(DateTime date) { MobileServiceInvalidOperationException exception = null; string idDeshidratadora; object selectedItem = comboBox.SelectedValue.ToString(); idDeshidratadora = selectedItem.ToString(); try { ProgressBarBefore(); temperaturas = await TempDeshTable .Where(Tempe => Tempe.Fecha == date.ToString("yyyy-MM-dd") && Tempe.idDeshidratadora == idDeshidratadora) .ToCollectionAsync(); if (temperaturas.Count >= 1) { foreach (var c in temperaturas) { string[] hora = c.Hora.Split(' '); c.Hora = hora[1]; } CategoryAxis categoryAxis = new CategoryAxis() { Orientation = AxisOrientation.X, Location = AxisLocation.Bottom, AxisLabelStyle = App.Current.Resources["VerticalAxisStyle"] as Style }; (LineSeries.Series[0] as LineSeries).IndependentAxis = categoryAxis; (LineSeries.Series[0] as LineSeries).ItemsSource = temperaturas; LineSeries.Visibility = Visibility.Visible; ProgressBarAfter(); } else { LineSeries.Visibility = Visibility.Collapsed; MessageDialog mensaje = new MessageDialog("No existe registro para esta fecha.", "No existe registro"); await mensaje.ShowAsync(); ProgressBarAfter(); } } catch (MobileServiceInvalidOperationException ex) { exception = ex; } if (exception != null) { await new MessageDialog(exception.Message, "Error!").ShowAsync(); } // (LineSeries.Series[0] as LineSeries).ItemsSource = financialStuffList; }
private async void ReadItemsTable() { try { itemsCollection = await itemsTable.ToCollectionAsync(); Content.ItemsSource = itemsCollection; } catch (InvalidOperationException) { } }
// returns an ordered list of location that matches the search query public static IEnumerable<Event> GetMatchingEvents(MobileServiceCollection<Event, Event> eventlist, string query) { return eventlist .Where(c => c.Title.IndexOf(query, StringComparison.CurrentCultureIgnoreCase) > -1 || c.Location.IndexOf(query, StringComparison.CurrentCultureIgnoreCase) > -1 || c.Category.IndexOf(query, StringComparison.CurrentCultureIgnoreCase) > -1) .OrderByDescending(c => c.Title.StartsWith(query, StringComparison.CurrentCultureIgnoreCase)) .ThenByDescending(c => c.Location.StartsWith(query, StringComparison.CurrentCultureIgnoreCase)) .ThenByDescending(c => c.Category.StartsWith(query, StringComparison.CurrentCultureIgnoreCase)); }
private async void RefreshTodoItems() { try { items = await todoTable .Where(todoItem => todoItem.Complete == false).ToCollectionAsync(); ListItems.ItemsSource = items; } catch (HttpRequestException) { ShowError(); } }
public async Task<PodcastEpisode> GetTimeAsync(int shownum) { try { //retrieve postcast based off show number podcasts = await podcastTable.Where(p=>p.ShowNumber == shownum).ToCollectionAsync(); return podcasts.Count > 0 ? podcasts[0] : null; } catch (Exception ex) { } return new PodcastEpisode { ShowNumber = shownum, CurrentTime = 0 }; }
private async void RefreshTodoItems() { try { items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { MessageBox.Show(e.Message, "Error loading items", MessageBoxButton.OK); } //ListItems.ItemsSource = items; }
private async void RefreshTodoItems() { // This code refreshes the entries in the list view be querying the TodoItems table. // The query excludes completed TodoItems try { items = await Common.GetIncompleteItems() .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { MessageBox.Show(e.Message, "Error loading items", MessageBoxButton.OK); } ListItems.ItemsSource = items; }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems _items = await _trainingItemsTable.ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { fetchedTrainingsList.ItemsSource = _items; } }
async void MainPage_Loaded(object sender, RoutedEventArgs e) { //PushNotificationChannel channel; //channel = await Windows.Networking.PushNotifications.PushNotificationChannelManager.CreatePushNotificationChannelForApplicationAsync(); //try //{ // await App.Mugd_appClient.GetPush().RegisterNativeAsync(channel.Uri); // //await App.Mugd_appClient.InvokeApiAsync("notifyAllUsers", // // new JObject(new JProperty("toast", "Sample Toast"))); //} //catch (Exception exception) //{ // HandleRegisterException(exception); //} Start.channel.PushNotificationReceived += channel_PushNotificationReceived; test = new ObservableCollection<ChatPubList>(); items = await Table.OrderByDescending(ChatPublic => ChatPublic.CreatedAt).ToCollectionAsync(); var networkProfiles = Windows.Networking.Connectivity.NetworkInformation.GetConnectionProfiles(); var adapter = networkProfiles.First<Windows.Networking.Connectivity.ConnectionProfile>().NetworkAdapter;//takes the first network adapter string networkAdapterId = adapter.NetworkAdapterId.ToString(); foreach (ChatPublic k in items) { ChatPubList a = new ChatPubList(); a.date = k.CreatedAt.Date.ToString(); a.time = k.CreatedAt.TimeOfDay.ToString(); a.time = a.time.Remove(5); a.date = a.date.Remove(10); a.Name = k.Name; a.Message = k.Message; if (a.Name == networkAdapterId) { a.col = "#FF9B0E00"; } else { a.col = "#FF5D340C"; } test.Add(a); } lol.ItemsSource = test; test.CollectionChanged += test_CollectionChanged; }
private async void button_Click(object sender, RoutedEventArgs e) { try { ProgressBarBefore(); usuarios = await UsuarioTable .Select(Usuarios => Usuarios) .Where(Usuarios => Usuarios.id == textBoxUser.Text && Usuarios.contrasena == passwordBox.Password.ToString()) .ToCollectionAsync(); ProgressBarAfter(); if(usuarios.Count >= 1) { var rsUsuario = usuarios.First(); if(rsUsuario.Tipo == "Tecnico") { Frame.Navigate(typeof(Administrador), "Tecnico"); } else { Frame.Navigate(typeof(Administrador), "Administrador"); } } else { MessageDialog mensaje = new MessageDialog("Usuario o contraseña incorrectos.", "Credenciales invalidas"); await mensaje.ShowAsync(); } } catch (MobileServiceInvalidOperationException ex) { exception = ex; } if (exception != null) { await new MessageDialog(exception.Message, "Error!").ShowAsync(); } }
private async void button_Click(object sender, RoutedEventArgs e) { String userName = userNameText.Text; String password = passwordBox.Password; try { guests = await guestTable.Where(guests => guests.name == userName && guests.password == password).ToCollectionAsync(); } catch (MobileServiceInvalidOperationException ex) { await new MessageDialog(ex.Message, "Could not connect to server.").ShowAsync(); System.Diagnostics.Debug.WriteLine("This is user name and password :"******"username"] = userName; this.Frame.Navigate(typeof(Home), null); var channel = await Windows.Networking.PushNotifications.PushNotificationChannelManager.CreatePushNotificationChannelForApplicationAsync(); string deviceId = GetDeviceId(); string uri = channel.Uri; System.Diagnostics.Debug.WriteLine("uri is :" + uri); try { await App.azure_rendezvous_mobile_service_3Client.GetPush().RegisterNativeAsync(channel.Uri); await App.azure_rendezvous_mobile_service_3Client.InvokeApiAsync("modifychanneluri", new JObject(new JProperty("channeluri", uri), new JProperty("username", userName))); } catch (MobileServiceInvalidOperationException ex) { System.Diagnostics.Debug.WriteLine("exception is :" + ex.Message); } } else { MessageDialog msgBox = new MessageDialog("Invalid username or password"); await msgBox.ShowAsync(); } }
private async void RefreshTodoItems() { // This code refreshes the entries in the list view be querying the TodoItems table. // The query excludes completed TodoItems try { items = await todoTable .Where(todoItem => todoItem.Complete == false) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { MessageBox.Show(e.Message, "Error loading items", MessageBoxButton.OK); } ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; }
// Refresh the item list each time we navigate to this page private async void RefreshEventList(string query) { eventTable = App.MobileService.GetTable<Event>(); if (query == null) { try { events = await eventTable.ToCollectionAsync(); } catch (Exception ex) { Debug.WriteLine(ex.StackTrace.ToString()); ErrorText.Text = "Connectivity error, please try again"; ErrorText.Visibility = Visibility.Visible; } finally { ProgressRing.IsActive = false; SearchBox.Visibility = Visibility.Visible; } eventListGridView.ItemsSource = events; if(events.Count == 0) { ErrorText.Text = "No Events Found"; ErrorText.Visibility = Visibility.Visible; } } else { var MatchEvents = EventController.GetMatchingEvents(events, query).ToList<Event>(); if(MatchEvents.Count > 0) { ErrorText.Visibility = Visibility.Collapsed; eventListGridView.ItemsSource = MatchEvents; } else { eventListGridView.ItemsSource = null; ErrorText.Text = "No Events Found"; ErrorText.Visibility = Visibility.Visible; } } }
public async Task MobileServiceCollectionMultipleLoadItemsAsyncShouldThrow() { // Get the Books table MobileServiceTableQueryMock<Book> query = new MobileServiceTableQueryMock<Book>(); MobileServiceCollection<Book, Book> collection = new MobileServiceCollection<Book, Book>(query); CancellationTokenSource tokenSource = new CancellationTokenSource(); Exception ex = null; try { await TaskEx.WhenAll(collection.LoadMoreItemsAsync(tokenSource.Token), collection.LoadMoreItemsAsync(tokenSource.Token)); } catch (InvalidOperationException e) { ex = e; } Assert.IsNotNull(ex); }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // Query that returns all items. items = await todoTable.ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = items; this.ButtonSave.IsEnabled = true; } }
private async void searchbtnclicked(object sender, RoutedEventArgs e) { String location = ((ComboBoxItem)locationcomboBox.SelectedItem).Content.ToString(); String category = ((ComboBoxItem)categorycomboBox.SelectedItem).Content.ToString(); var parameters = new Dictionary<String, String> { {"Location",location}, { "Category",category} }; // parameters.Add("Location",location); // parameters.Add("Category",category); try { restaurants = await restaurantTable.WithParameters(parameters).ToCollectionAsync(); } catch (MobileServiceInvalidOperationException ex) { await new MessageDialog(ex.Message, "Could not connect to server.").ShowAsync(); } Boolean containsvalue = restaurants.Any<Restaurant>(); if (!containsvalue) { await new MessageDialog("No restaurants matching!").ShowAsync(); } ListItems.ItemsSource = restaurants; // Restaurant res1 = restaurants.First<Restaurant>(); // Restaurant res2 = restaurants.Last<Restaurant>(); // System.Diagnostics.Debug.WriteLine("first element returned:" + res1.Name); // System.Diagnostics.Debug.WriteLine("last element returned:" + res2.Name); }
private async Task RefreshPersons() { MobileServiceInvalidOperationException exception = null; try { persons = await personsTable.ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading").ShowAsync(); } else { PersonsCollection = new ObservableCollection<Person>(persons); } }
protected async override void OnNavigatedTo(NavigationEventArgs e) { int f = 0; StorageFolder folder = Windows.Storage.ApplicationData.Current.LocalFolder; StorageFile sampleFile = await folder.CreateFileAsync("Sample.txt", CreationCollisionOption.OpenIfExists); try { string testlol = await Windows.Storage.FileIO.ReadTextAsync(sampleFile); ids = JsonConvert.DeserializeObject<List<string>>(testlol); items = await Table.ToCollectionAsync(); } catch(Exception ex) { f = 1; } finally { if (f == 1) { MessageDialog m = new MessageDialog("Oops... There was some Problem Handling your Request"); await m.ShowAsync(); } else { Voice.ItemsSource = items; } } }
private async Task RefreshOrderList() { MobileServiceInvalidOperationException exception = null; try { orders = await ordersTable .OrderByDescending(x => x.Id) .ToCollectionAsync(); customers = await customersTable.CreateQuery().ToCollectionAsync(); ListItems.ItemsSource = orders; TextCustomer.ItemsSource = customers; } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { // This code refreshes the entries in the list view by querying the TodoItems table. // The query excludes completed TodoItems items = await unitLogTable.OrderByDescending(unitLog => unitLog.ReportedTime) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = items; } }
private async Task RefreshTodoItems() { MobileServiceInvalidOperationException exception = null; try { _items = await _groceriesTable .Where(x => x.OwnerUserId == _user.UserId) .ToCollectionAsync(); } catch (MobileServiceInvalidOperationException e) { exception = e; } if (exception != null) { await new MessageDialog(exception.Message, "Error loading items").ShowAsync(); } else { ListItems.ItemsSource = _items; ButtonSave.IsEnabled = true; } }
public void MobileServiceCollectionCanClearAndNotifies() { // Get the Books table MobileServiceTableQueryMock<Book> query = new MobileServiceTableQueryMock<Book>(); query.EnumerableAsyncThrowsException = true; MobileServiceCollection<Book, Book> collection = new MobileServiceCollection<Book, Book>(query); List<string> properties = new List<string>(); List<string> expectedProperties = new List<string>() { "Count", "Item[]" }; List<NotifyCollectionChangedAction> actions = new List<NotifyCollectionChangedAction>(); List<NotifyCollectionChangedAction> expectedActions = new List<NotifyCollectionChangedAction>() { NotifyCollectionChangedAction.Reset }; Book book = new Book(); collection.Add(book); ((INotifyPropertyChanged)collection).PropertyChanged += (s, e) => properties.Add(e.PropertyName); collection.CollectionChanged += (s, e) => actions.Add(e.Action); collection.Clear(); Assert.AreEqual(0, collection.Count); Assert.IsTrue(properties.SequenceEqual(expectedProperties)); Assert.IsTrue(actions.SequenceEqual(expectedActions)); }