private void PhoneApplicationPage_Loaded(object sender, RoutedEventArgs e) { using (var db = new DatabaseManager()) { listBox1.ItemsSource = db.GovBidContext.Bids.Where(p => p.Favorite == true); } }
private void listBox1_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (listBox1.SelectedIndex != -1) { //Get the selected bid var bid = listBox1.Items[listBox1.SelectedIndex] as Bid; //From DB using (var databaseManager = new DatabaseManager()) { if (databaseManager.GovBidContext.BidsViewed.Count(p => p.Id == bid.ItemID) <= 0) { bid.Viewed = true; databaseManager.GovBidContext.BidsViewed.InsertOnSubmit(new BidsViewed() { Date = DateTime.Now, Id = bid.ItemID }); databaseManager.GovBidContext.SubmitChanges(); } } //Navigate to the web browser bid view NavigationService.Navigate(new Uri("/Pages/BidWebView.xaml?Id=" + bid.ItemID, UriKind.Relative)); } }
private void updateDb() { using (var db = new DatabaseManager()) { List<Bid> bids = db.GovBidContext.Bids.ToList(); var bidsV = (from b in db.GovBidContext.BidsViewed select b); foreach (var bV in bidsV) { try { bids.First(p => p.ItemID == bV.Id).Viewed = true; } catch { } } listBox1.ItemsSource = bids; } }
/// <summary> /// Event that handles the application loaded state. /// Use for loading data. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void PhoneApplicationPage_Loaded(object sender, RoutedEventArgs e) { //Retrieve all if ((App.Current as App).filterSettings.Update) { (App.Current as App).filterSettings.Update = false; updateWeb(); } else { using (var db = new DatabaseManager()) { if (db.GovBidContext.Bids.Count() > 0) { var settings = IsolatedStorageSettings.ApplicationSettings; DateTime last = new DateTime(1995, 6, 22); if (!settings.TryGetValue("LastUpdated", out last)) settings.Add("LastUpdated", last); if ((last - DateTime.Now).TotalDays > 0) { updateWeb(); } else { updateDb(); } } else updateWeb(); } } }
private void MenuItem_Click_2(object sender, RoutedEventArgs e) { //Get the menu item var menuItem = sender as MenuItem; //Get the id string Id = menuItem.Tag.ToString(); using (var db = new DatabaseManager()) { //Get the bid var bid = db.GovBidContext.Bids.First(p => p.ItemID.ToString() == Id) as Bid; if (bid.Favorite) bid.Favorite = false; else bid.Favorite = true; db.GovBidContext.SubmitChanges(); updateDb(); } }
//Mark as... click event private void MenuItem_Click(object sender, RoutedEventArgs e) { //Get the menu item var menuItem = sender as MenuItem; //Get the id string Id = menuItem.Tag.ToString(); //Get the bid var bid = (from m in listBox1.Items where (m as Bid).ItemID.ToString() == Id select m).First(); using (var databaseManager = new DatabaseManager()) { if ((bid as Bid).Viewed) { var bV = from p in databaseManager.GovBidContext.BidsViewed where p.Id.ToString() == Id select p; databaseManager.GovBidContext.BidsViewed.DeleteOnSubmit(bV.First()); } else { databaseManager.GovBidContext.BidsViewed.InsertOnSubmit(new BidsViewed() { Date = DateTime.Now, Id = Convert.ToInt32(Id) }); databaseManager.GovBidContext.SubmitChanges(); } databaseManager.GovBidContext.SubmitChanges(); updateDb(); } }
/// <summary> /// Event handler for the Soap Client when it finishes a call to GetBids /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void client_GetBidsCompleted(object sender, GetBidsCompletedEventArgs e) { //Get the progress indicator from the system tray var proggressIndicator = SystemTray.GetProgressIndicator(this); proggressIndicator.IsIndeterminate = false; proggressIndicator.IsVisible = false; //Detect errors if (e.Error == null) { (IsolatedStorageSettings.ApplicationSettings)["LastUpdated"] = DateTime.Now; (IsolatedStorageSettings.ApplicationSettings).Save(); var bids = getBidListFromXml(e.Result); //From DB using (var databaseManager = new DatabaseManager()) { var bidsV = (from b in databaseManager.GovBidContext.BidsViewed select b); foreach (var bV in bidsV) { try { bids.First(p => p.ItemID == bV.Id).Viewed = true; } catch { } } databaseManager.GovBidContext.Bids.DeleteAllOnSubmit(databaseManager.GovBidContext.Bids); databaseManager.GovBidContext.Bids.InsertAllOnSubmit(bids); databaseManager.GovBidContext.SubmitChanges(); } listBox1.ItemsSource = bids; } else MessageBox.Show("Error con conexión de internet."); }