public static void CreateCustomer(Resources d365) { try { var CustomerCollection = new DataServiceCollection <Customer>(d365); Customer obj = new Customer(); CustomerCollection.Add(obj); obj.Name = "Test 02"; obj.CustomerAccount = "KSC-000011"; obj.CustomerGroupId = "Group 01"; obj.DataAreaId = "ksc"; obj.PartyType = "Organization"; obj.DAXIntegrationId = Guid.Empty; //obj.CustomerWithholdingContributionType = CustWhtContributionType_BR.Other; //d365.Customers[0] = obj; // d365.AddToCustomers(obj); d365.SaveChanges(SaveChangesOptions.BatchWithSingleChangeset); //d365.SaveChanges(); } catch (Exception ex) { string mesd = ex.Message; } }
private void LoadCustomers() { Customers = new DataServiceCollection <Customer>(m_Context); var query = m_Context.Customers; Customers.Load(query); }
private void LoadInspectionAttributes() { InspectionAttributes = new DataServiceCollection <InspectionAttribute>(m_Context); var query = m_Context.InspectionAttributes; InspectionAttributes.Load(query); }
private void CodeFirst_Page_Loaded(object sender, RoutedEventArgs e) { // Initialize the context and the binding collection context = new ProductContext(northwindUri); products = new DataServiceCollection<Product>(context); context.Products.AddQueryOption("$top", 10); // Define a LINQ query that returns all customers. var query = from cust in context.Products //where cust.ProductId == 2761685473 select cust; var query2 = context.Products.Take(10); // Register for the LoadCompleted event. products.LoadCompleted += new EventHandler<LoadCompletedEventArgs>(products_LoadCompleted); // Load the customers feed by executing the LINQ query. products.LoadAsync(query); }
public void LoadAnnouncements() { Announcements = new DataServiceCollection <Announcement>(context); var query = from a in context.Announcements.OrderByDescending(a => a.PublishDate) select a; Announcements.LoadAsync(query); }
public void AddRemoveNullEntity() { var ctxwrap = this.CreateWrappedContext <DefaultContainer>(); var context = ctxwrap.Context; DataServiceCollection <Customer> DSC = new DataServiceCollection <Customer>(context); try { DSC.Add(null); Assert.True(false, "Expected error not thrown"); } catch (InvalidOperationException e) { StringResourceUtil.VerifyDataServicesClientString(e.Message, "DataBinding_BindingOperation_ArrayItemNull", "Add"); } try { DSC.Remove(null); Assert.True(false, "Expected error not thrown"); } catch (InvalidOperationException e) { StringResourceUtil.VerifyDataServicesClientString(e.Message, "DataBinding_BindingOperation_ArrayItemNull", "Remove"); } this.EnqueueTestComplete(); }
public void DerivedEntityTypeShouldOnlySerializeChangedProperties() { EntityType entity = new DerivedEntityType { ID = 7, Complex = new ComplexType { Name = "June", Home = new Address("Xiadu", 71) }, StringCollection = new ObservableCollection <string>(new string[] { "first", "second" }), Name = "July", Home = new HomeAddress("Xingang", 17, "Guangzhou") }; DataServiceCollection <DerivedEntityType> collection = new DataServiceCollection <DerivedEntityType>(context, null, TrackingMode.AutoChangeTracking, "EntitySet", null, null); collection.Add((DerivedEntityType)entity); context.Entities.FirstOrDefault().State = EntityStates.Unchanged; entity.ID = 71; entity.Complex.Home.Code = 17; ((DerivedEntityType)entity).Home.City = "Guangzhou"; Assert.AreEqual(EntityStates.Modified, context.Entities.FirstOrDefault().State); ValidateBodyContent(context, "{\"ID\":71,\"Complex\":{\"Name\":\"June\",\"Home\":{\"Code\":17,\"Street\":\"Xiadu\"}},\"Home\":{\"City\":\"Guangzhou\",\"Code\":17,\"Street\":\"Xingang\"}}"); }
public DevWPhoto(DataServiceCollection<T_RubbingPhoto> rubbingPhotos, T_RubbingPhoto currentRubbingPhoto ) { InitializeComponent(); _vmPhoto = new VMPhotos(rubbingPhotos, currentRubbingPhoto); LoadImage(); SetButtonEnable(); }
public void LoadPropertyCollection() { var ctxwrap = this.CreateWrappedContext<DefaultContainer>(); var context = ctxwrap.Context; var querry = (from c in context.Customer where c.CustomerId == -10 select c) as DataServiceQuery<Customer>; var ar = querry.BeginExecute(null, null).EnqueueWait(this); var cus = querry.EndExecute(ar).First(); DataServiceCollection<Customer> dsc = new DataServiceCollection<Customer>(context) {cus}; var ar02 = context.BeginLoadProperty(cus, "Orders", null, null).EnqueueWait(this); context.EndLoadProperty(ar02); foreach (Order o in cus.Orders) { o.OrderId = (134); } int fristCount = context.Entities.Count; foreach (var ed in context.Entities) { if (ed.Entity.GetType() == cus.Orders.First().GetType()) { Assert.Equal(EntityStates.Modified, ed.State); } } var o1 = new Order { OrderId = 1220 }; cus.Orders.Add(o1); Assert.Equal(fristCount + 1, context.Entities.Count); cus.Orders.Remove(o1); Assert.Equal(fristCount, context.Entities.Count); this.EnqueueTestComplete(); }
public void LoadSessions() { Sessions = new DataServiceCollection <Session>(context); var query = from s in context.Sessions where s.Event_ID == Constants.EventId select s; Sessions.LoadAsync(query); }
protected override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); if (totalParticipants != 0) // Page already loaded return; id = long.Parse(NavigationContext.QueryString["debtCalculationId"]); _container = ApiHelper.GetContainer(); _participants = new DataServiceCollection<Participant>(_container); // Cannot localize ApplicationBar unless it is created in code behind ApplicationBar = new ApplicationBar { BackgroundColor = Color.FromArgb(255, 0x86, 0xC4, 0x40), //"#86C440" Opacity = 1, ForegroundColor = Colors.White }; ContentPanel.Children.Add(new ProgressBar { IsIndeterminate = true, Width = 300, Margin = new Thickness(0, 30, 0, 0) }); var query = _container.Participants .Expand(p => p.User) .Where(p => p.DebtCalculation.Id == id); _participants.LoadCompleted += ShowExpenseParticipants; _participants.LoadAsync(query); }
public void LoadSpeakers() { Speakers = new DataServiceCollection <Person>(context); var query = context.CreateQuery <Person>("Speakers").AddQueryOption("eventId", Constants.EventId).OrderBy(p => p.LastName); Speakers.LoadAsync(query); }
public void LoadTracks() { Tracks = new DataServiceCollection <Track>(context); var query = from t in context.Tracks.Where(t => t.Event_ID == Constants.EventId) select t; Tracks.LoadAsync(query); }
private void LoadPersons() { Persons = new DataServiceCollection <Person>(m_Context); var query = m_Context.People; Persons.Load(query); }
public void PostFullPropertiesInBatch() { var batchFlags = new SaveChangesOptions[] { SaveChangesOptions.BatchWithSingleChangeset, SaveChangesOptions.BatchWithIndependentOperations }; foreach (var batchFlag in batchFlags) { List <ODataResource> entries = new List <ODataResource>(); this.TestClientContext.Configurations.RequestPipeline.OnEntryEnding((arg) => { entries.Add(arg.Entry); }); DataServiceCollection <CustomerPlus> people = new DataServiceCollection <CustomerPlus>(this.TestClientContext, "People", null, null); var person = new CustomerPlus(); people.Add(person); person.FirstNamePlus = "Nelson"; person.LastNamePlus = "Black"; person.NumbersPlus = new ObservableCollection <string> { }; person.EmailsPlus = new ObservableCollection <string> { "*****@*****.**" }; person.PersonIDPlus = 10001; person.CityPlus = "London"; person.TimeBetweenLastTwoOrdersPlus = new TimeSpan(1); person.HomeAddressPlus = new HomeAddressPlus() { CityPlus = "Redmond", PostalCodePlus = "98052", StreetPlus = "1 Microsoft Way" }; DataServiceCollection <AccountPlus> accounts = new DataServiceCollection <AccountPlus>(this.TestClientContext); var account = new AccountPlus(); accounts.Add(account); account.AccountIDPlus = 110; account.CountryRegionPlus = "CN"; DataServiceCollection <ProductPlus> products = new DataServiceCollection <ProductPlus>(this.TestClientContext); ProductPlus product = new ProductPlus(); products.Add(product); product.NamePlus = "Apple"; product.ProductIDPlus = 1000000; product.QuantityInStockPlus = 20; product.QuantityPerUnitPlus = "Pound"; product.UnitPricePlus = 0.35f; product.DiscontinuedPlus = false; product.CoverColorsPlus = new ObservableCollection <ColorPlus>(); //Post entity into an entity set this.TestClientContext.SaveChanges(batchFlag); Assert.Equal(10, entries.Where(e => e.TypeName.Contains("CustomerPlus")).First().Properties.Count()); Assert.Equal(2, entries.Where(e => e.TypeName.Contains("AccountPlus")).First().Properties.Count()); Assert.Equal(9, entries.Where(e => e.TypeName.Contains("ProductPlus")).First().Properties.Count()); } }
public void UpdateByPatchPartialPropertieInBatchWithCustomizedName() { int expectedPropertyCount = 1; this.TestClientContext.Configurations.RequestPipeline.OnEntryEnding( (arg) => { Assert.AreEqual(expectedPropertyCount, arg.Entry.Properties.Count()); }); DataServiceCollection <OrderPlus> orders = new DataServiceCollection <OrderPlus>(this.TestClientContext.OrdersPlus.Expand("OrderDetails")); DataServiceCollection <PersonPlus> people = new DataServiceCollection <PersonPlus>(this.TestClientContext.PeoplePlus); DataServiceCollection <PersonPlus> boss = new DataServiceCollection <PersonPlus>(this.TestClientContext.BossPlus); orders[1].OrderDatePlus = DateTimeOffset.Now; ((CustomerPlus)people[0]).CityPlus = "Redmond"; boss.Single().FirstNamePlus = "Bill"; orders[0].OrderDetailsPlus.First().QuantityPlus = 1; this.TestClientContext.SaveChanges(SaveChangesOptions.BatchWithSingleChangeset); }
private void LoadRooms() { Rooms = new DataServiceCollection <BuildingRoom>(m_Context); var query = m_Context.BuildingRooms.Expand("Building"); Rooms.Load(query); }
private void LoadBuildings() { Buildings = new DataServiceCollection <DomainModelService.Building>(m_Context); var query = m_Context.Buildings.Expand("Rooms, Address"); Buildings.Load(query); }
public void ClientSerializeGeographyTest_BindingAddChangeShouldBeDetected() { DataServiceContext ctx = new DataServiceContext(new Uri("http://localhost")); DataServiceCollection<SpatialEntityType> dsc = new DataServiceCollection<SpatialEntityType>(ctx, null, TrackingMode.AutoChangeTracking, "Entities", null, null); dsc.Add(testEntity); ClientSerializeGeographyTest_Validate(ctx); }
private static void DataServiceCollectionSubQueryTrackingItems( DataServiceContextWrapper <DefaultContainer> contextWrapper) { var query = from p in contextWrapper.Context.Customer where p.Name != null select new Customer() { Name = p.Name, Orders = new DataServiceCollection <Order>( from r in p.Orders select new Order() { OrderId = r.OrderId, CustomerId = r.CustomerId }) }; var tmpResult0 = query.ToList()[0]; DataServiceCollection <Order> collection = tmpResult0.Orders; // the collection tracking items int tmpCount = collection.Count; collection.Load(contextWrapper.Context.Execute(collection.Continuation)); // for testing newly loaded item's tracking Assert.IsTrue(collection.Count > tmpCount, "Should have loaded another page."); bool someItemNotTracked = false; tmpResult0.Orders.ToList().ForEach(s => { EntityStates state = contextWrapper.Context.GetEntityDescriptor(s).State; s.CustomerId = s.CustomerId + 1; state = contextWrapper.Context.GetEntityDescriptor(s).State; someItemNotTracked = (state == EntityStates.Unchanged) || someItemNotTracked; }); Assert.IsFalse(someItemNotTracked, "All items should have been tracked."); }
public void TrackEntityInstance <T>(T entityInstance) where T : class { DataServiceCollection <T> dataServiceCollection = new DataServiceCollection <T>(this); dataServiceCollection.Add(entityInstance); }
private static void DataServiceCollectionTrackingItems( DataServiceContextWrapper <DefaultContainer> contextWrapper) { var query = from p in contextWrapper.Context.Customer where p.CustomerId > -100000 // try to get many for paging select new Customer() { CustomerId = p.CustomerId, Name = p.Name }; DataServiceCollection <Customer> collection = new DataServiceCollection <Customer>(query); // the collection to track items int tmpCount = collection.Count; collection.Load(contextWrapper.Context.Execute(collection.Continuation)); // for testing newly loaded item's tracking Assert.IsTrue(collection.Count > tmpCount, "Should have loaded another page."); bool someItemNotTracked = false; collection.ToList().ForEach(s => { s.Name = "value to test tracking"; EntityStates state = contextWrapper.Context.GetEntityDescriptor(s).State; someItemNotTracked = (state == EntityStates.Unchanged) || someItemNotTracked; }); Assert.IsFalse(someItemNotTracked, "All items should have been tracked."); }
protected override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); id = long.Parse(NavigationContext.QueryString["debtCalculationId"]); _container = ApiHelper.GetContainer(); _calculations = new DataServiceCollection<DebtCalculation>(_container); // Cannot localize ApplicationBar unless it is created in code behind ApplicationBar = new ApplicationBar { BackgroundColor = Color.FromArgb(255, 0x86, 0xC4, 0x40), //"#86C440" Opacity = 1, ForegroundColor = Colors.White }; ContentPanel.Children.Add(new ProgressBar { IsIndeterminate = true, Width = 300, Margin = new Thickness(0, 30, 0, 0) }); var query = _container.DebtCalculations .Expand("Expenses/Payer") .Expand("Expenses/Debtors/User") .Expand("Participants/User") .Expand("Debts/Debtor") .Expand("Debts/Creditor") .Expand(dc => dc.Creator) .Where(dc => dc.Id == id); _calculations.LoadCompleted += ShowCalculation; _calculations.LoadAsync(query); }
private void Window1_Loaded(object sender, RoutedEventArgs e) { try { // Instantiate the DataServiceContext. context = new NorthwindEntities(svcUri); // Define a LINQ query that returns Orders and // Order_Details for a specific customer. var ordersQuery = from o in context.Orders.Expand("Order_Details") where o.Customers.CustomerID == customerId select o; // Create an DataServiceCollection<T> based on // execution of the LINQ query for Orders. DataServiceCollection <Orders> customerOrders = new DataServiceCollection <Orders>(ordersQuery); // Make the DataServiceCollection<T> the binding source for the Grid. this.orderItemsGrid.DataContext = customerOrders; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
public void UpdateComplexPropertyShouldOnlySerializeChangedProperties() { EntityType entity = new EntityType { ID = 1, Complex = new ComplexType { Name = "June", Home = new Address("Dongchuan", 200) }, StringCollection = new ObservableCollection <string>(new string[] { "first", "second" }) }; DataServiceCollection <EntityType> collection = new DataServiceCollection <EntityType>(context, null, TrackingMode.AutoChangeTracking, "EntitySet", null, null); collection.Add(entity); context.Entities.FirstOrDefault().State = EntityStates.Unchanged; entity.Complex = new ComplexType { Name = "July", Home = new Address("Jiaotong", 16) }; Assert.AreEqual(EntityStates.Modified, context.Entities.FirstOrDefault().State); ValidateBodyContent(context, "{\"Complex\":{\"Name\":\"July\",\"Home\":{\"Code\":16,\"Street\":\"Jiaotong\"}}}"); }
public void LoadSponsors() { Sponsors = new DataServiceCollection <Sponsor>(context); var query = from s in context.Sponsors.OrderBy(s => s.Name) select s; Sponsors.LoadAsync(query); }
public static Task <DataServiceCollection <T> > AsyncQuery <T>( this DataServiceCollection <T> data, IQueryable <T> query = null) { var asyncr = new SimpleAsyncResult(); Exception exResult = null; data.LoadCompleted += delegate(object sender, LoadCompletedEventArgs e) { exResult = e.Error; asyncr.Finish(); }; if (query == null) { data.LoadAsync(); } else { data.LoadAsync(query); } return(Task <DataServiceCollection <T> > .Factory.FromAsync(asyncr , r => { if (exResult != null) { throw new AggregateException("Async call problem", exResult); } return data; } )); }
private void LoadActivities() { Activities = new DataServiceCollection <Activity>(m_Context); var query = m_Context.Activities; Activities.Load(query); }
public void LoadTimeslots() { Timeslots = new DataServiceCollection <Timeslot>(context); var query = from ts in context.Timeslots select ts; Timeslots.LoadAsync(query); }
public void ClearListTest() { var ctxwrap = this.CreateWrappedContext <DefaultContainer>(); var context = ctxwrap.Context; DataServiceCollection <Customer> DSC = new DataServiceCollection <Customer>(context); Customer c = new Customer { CustomerId = 1002 }; Customer c2 = new Customer { CustomerId = 1003 }; Customer c3 = new Customer { CustomerId = 1004 }; DSC.Add(c); DSC.Add(c2); DSC.Add(c3); Order o = new Order { OrderId = 2001, Customer = c, CustomerId = 1002 }; c.Orders.Add(o); VerifyCtxCount(context, 4, 1); DSC.Clear(); VerifyCtxCount(context, 0, 0); this.EnqueueTestComplete(); }
private void LoadQuestions() { Questions = new DataServiceCollection <Question>(m_Context); var query = m_Context.Questions; Questions.Load(query); }
public void LoadCollectionExceptionShouldNotRuinEntityTracking() { var ctxwrap = this.CreateWrappedContext <DefaultContainer>(); var context = ctxwrap.Context; int[] customerIds = { /*existing*/ -9, /*non-existing*/ 0, /*existing*/ -10 }; foreach (var customerId in customerIds) { Customer customer = null; try { var query = context.Customer.Where(c => c.CustomerId == customerId); var collection = new DataServiceCollection <Customer>(query); customer = collection.Single(); } catch (DataServiceQueryException e) { var inner = e.InnerException as DataServiceClientException; if (inner != null && inner.StatusCode == (int)HttpStatusCode.NotFound) { continue; } throw; } context.SaveChanges(); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { try { // Initialize the context for the data service. context = new NorthwindEntities(new Uri(svcUri)); //<snippetMasterDetailBinding> // Create a LINQ query that returns customers with related orders. var customerQuery = from cust in context.Customers.Expand("Orders") where cust.Country == customerCountry select cust; // Create a new collection for binding based on the LINQ query. trackedCustomers = new DataServiceCollection <Customer>(customerQuery); // Bind the root StackPanel element to the collection; // related object binding paths are defined in the XAML. LayoutRoot.DataContext = trackedCustomers; //</snippetMasterDetailBinding> } catch (DataServiceQueryException ex) { MessageBox.Show("The query could not be completed:\n" + ex.ToString()); } catch (InvalidOperationException ex) { MessageBox.Show("The following error occurred:\n" + ex.ToString()); } }
/// <summary> /// Asynchronously executes an <see cref="T:System.Linq.IQueryable`1"/> and loads results into the <see cref="T:System.Data.Services.Client.DataServiceCollection`1"/>. /// </summary> /// <typeparam name="T">Entity type of the <see cref="T:System.Data.Services.Client.DataServiceCollection`1"/> instance.</typeparam> /// <param name="bindingCollection">The <see cref="T:System.Data.Services.Client.DataServiceCollection`1"/> instance on which this extension method is enabled.</param> /// <param name="query">Query that when executed loads entities into the collection.</param> /// <returns>A <see cref="T:System.Threading.Tasks.Task`1"/> that, when completed, returns a <see cref="T:System.Data.Services.Client.LoadCompletedEventArgs"/>.</returns> public static async Task <LoadCompletedEventArgs> LoadAsync <T>(this DataServiceCollection <T> bindingCollection, IQueryable <T> query) { var tcs = new TaskCompletionSource <LoadCompletedEventArgs>(); EventHandler <LoadCompletedEventArgs> handler = delegate(object o, LoadCompletedEventArgs e) { if (e.Error != null) { tcs.TrySetException(e.Error); } else if (e.Cancelled) { tcs.TrySetCanceled(); } else { tcs.TrySetResult(e); } }; bindingCollection.LoadCompleted += handler; bindingCollection.LoadAsync(query); LoadCompletedEventArgs eventArgs = await tcs.Task; bindingCollection.LoadCompleted -= handler; return(eventArgs); }
private void LoadAddresses() { Addresses = new DataServiceCollection <Address>(m_Context); var query = m_Context.Addresses.Expand(i => i.Buildings); Addresses.Load(query); }
public void AddRemoveNullEntity() { var ctxwrap = this.CreateWrappedContext <DefaultContainer>(); var context = ctxwrap.Context; DataServiceCollection <Customer> dsc = new DataServiceCollection <Customer>(context); try { dsc.Add(null); Assert.True(false, "Expected error not thrown"); } catch (InvalidOperationException e) { Assert.NotNull(e); } try { dsc.Remove(null); Assert.True(false, "Expected error not thrown"); } catch (InvalidOperationException e) { Assert.NotNull(e); } this.EnqueueTestComplete(); }
private void LoadAvailableProjects() { var uri = new Uri(_settings.ServiceUrl+"/Projects"); var context = IoC.Get<TFSDataServiceContext>(); _collection = new DataServiceCollection<Project>(context); _collection.LoadCompleted += this.ItemsLoadCompleted; _collection.LoadAsync(uri); }
public void LoadData() { var uri = new Uri(App.AWSERVICE); entities = new AdventureWorksLT2008R2Entities(uri); DSProducts = new DataServiceCollection<Product>(entities); var query = entities.Products; DSProducts.LoadAsync(query); }
public async Task SaveChangesTest() { var context = this.CreateWrappedContext<DefaultContainer>().Context; context.MergeOption = MergeOption.OverwriteChanges; int expectedPropertyCount = 1; Action<WritingEntryArgs> onEntryEnding = args => { Assert.Equal(expectedPropertyCount, args.Entry.Properties.Count()); }; context.Configurations.RequestPipeline.OnEntryEnding(onEntryEnding); DataServiceCollection<Customer> customers = new DataServiceCollection<Customer>(context, "Customer", null, null); Customer c1 = new Customer(); customers.Add(c1); c1.CustomerId = 1; c1.Name = "testName"; //Partial Post an Entity expectedPropertyCount = 2; var response = await context.SaveChangesAsync(SaveChangesOptions.PostOnlySetProperties); Assert.True((response.First() as ChangeOperationResponse).StatusCode == 201, "StatusCode == 201"); Order o1 = new Order { OrderId = 1000, CustomerId = 1, Concurrency = new ConcurrencyInfo() { Token = "token1" } }; context.AddToOrder(o1); context.AddLink(c1, "Orders", o1); //Post with batch expectedPropertyCount = 3; await context.SaveChangesAsync(SaveChangesOptions.BatchWithSingleChangeset); List<Order> orders = new List<Order>(); for (int i = 1; i <= 9; i++) { Order order = new Order { OrderId = 1000 + i }; context.AddToOrder(order); orders.Add(order); } //Post with batch await context.SaveChangesAsync(SaveChangesOptions.BatchWithIndependentOperations); //Post $ref foreach (var order in orders) { context.AddLink(c1, "Orders", order); } await context.SaveChangesAsync(); //Load property await context.LoadPropertyAsync(c1, "Orders"); //Partial Update an Entity expectedPropertyCount = 1; c1.Orders[0].Concurrency.Token = "UpdatedToken"; await context.SaveChangesAsync(SaveChangesOptions.None); this.EnqueueTestComplete(); }
private void FetchAll() { var all = from p in context.People select p; DataServiceCollection<Person> peopleCollection = new DataServiceCollection<Person>(all); //var allPeople=context.People.ToList(); LstOfPeople.DataContext = peopleCollection; }
private void BahadurPeopleButton_Click(object sender, RoutedEventArgs e) { var bahadurPeople = from p in context.People where p.LastName.Equals("Bahadur", StringComparison.OrdinalIgnoreCase) select p; DataServiceCollection<Person> peopleCollection = new DataServiceCollection<Person>(bahadurPeople); //var allPeople=context.People.ToList(); LstOfPeople.DataContext = peopleCollection; }
public BingSynonymsData() { serviceUri = new Uri(ROOT_SERVICE_URL); context = new BingSynonymsContainer(serviceUri); context.IgnoreMissingProperties = true; context.Credentials = new NetworkCredential(USER_ID, SECURE_ACCOUNT_ID); dataCollection = new DataServiceCollection<GetSynonymsEntitySet>(context); SynonymsList = new ObservableCollection<string>(); dataCollection.LoadCompleted += new EventHandler<LoadCompletedEventArgs>(dataCollection_LoadCompleted); }
public IList<BlogClass> GetBlogs() { List<BlogClass> blogs = new List<BlogClass>(); using (var db = new LocalBlogContext(ConnectionString)) { var query = from e in db.Blogs select e; blogs = query.ToList(); } return blogs; }
public MainViewModel() { MessengerInstance.Register<RefreshEventListMessage>(this, (message) => RunQuery()); if (IsInDesignMode) { // Code runs in Blend --> create design time data. } else { Events = new DataServiceCollection<ApprovedEvents>(context); RunQuery(); } }
public void ClientSerializeGeographyTest_BindingUpdateChangeShouldBeDetected() { DataServiceContext ctx = new DataServiceContext(new Uri("http://localhost")); DataServiceCollection<SpatialEntityType> dsc = new DataServiceCollection<SpatialEntityType>(ctx, null, TrackingMode.AutoChangeTracking, "Entities", null, null); dsc.Add(testEntity); Assert.AreEqual(1, ctx.Entities.Count); ctx.Entities.FirstOrDefault().State = EntityStates.Unchanged; testEntity.Prop1 = testEntity.Prop1; Assert.AreEqual(EntityStates.Modified, ctx.Entities.FirstOrDefault().State); ClientSerializeGeographyTest_ValidateUpdate(ctx); }
private static void SelectFunctionItems(RoleDTO role, DataServiceCollection<FunctionItemDTO> functionItems) { for (int i = functionItems.Count - 1; i >= 0; i--) { var temp = functionItems[i]; if (role.RoleFunctions.All(p => p.FunctionItemId != temp.Id)) { functionItems.Remove(temp); continue; } SelectFunctionItems(role, temp.SubFunctionItems); } }
public void AddDeleteEntitySave() { var ctxwrap = this.CreateWrappedContext<DefaultContainer>(); var context = ctxwrap.Context; DataServiceCollection<Customer> dsc = new DataServiceCollection<Customer>(context); Customer c = new Customer { CustomerId = 1002 }; dsc.Add(c); dsc.Remove(c); Assert.True(VerifyCtxCount(context, 0, 0)); this.SaveChanges(context); Assert.True(VerifyCtxCount(context, 0, 0)); this.EnqueueTestComplete(); }
public MainPage() { InitializeComponent(); Uri uri = new Uri("/BlogService.svc", UriKind.Relative); svc = new BlogContext(uri); blogs = new DataServiceCollection<Blogs>(svc); this.LayoutRoot.DataContext = blogs; blogs.LoadCompleted += new EventHandler<LoadCompletedEventArgs>(blogs_LoadCompleted); var q = svc.Blogs; blogs.LoadAsync(q); }
public void LoadData(DataServiceCollection<Blogs> blogs = null) { //var rows = from e in GetBlogs() // select "id: " + e.Id + " name: " + e.Name + " owner: " + e.Owner; //lstBlogs.ItemsSource = rows; if (blogs == null) blogs = new DataServiceCollection<Blogs>(); var source = GetBlogs(); foreach (var b in blogs) { source.Add(new BlogClass(b)); } lstBlogs.ItemsSource = source; }
public void GetSessions(Action<DataServiceCollection<Session>> onSuccess, Action<bool> onBusyStateChanged, Action<Exception> onError) { var sessions = new DataServiceCollection<Session>(null, TrackingMode.None); sessions.LoadCompleted += (s, e) => { DispatchBusyStateChanged(onBusyStateChanged, false); if (e.Cancelled) return; if (e.Error != null) DispatchError(e.Error, onError); else onSuccess(sessions); }; DispatchBusyStateChanged(onBusyStateChanged, true); sessions.LoadAsync(Context.Sessions); }
private void btnFindCommodity_Click(object sender, RoutedEventArgs e) { // Initialize the context and the binding collection context = new TopCarrotEntities(topCarrotDataUri); context.SendingRequest += new EventHandler<SendingRequestEventArgs>(context_SendingRequest); commodityPluCodes = new DataServiceCollection<CommodityPluCode>(context); //Show the progress bar pageIndicators.ShowProgress(this); if (UserInputUtilities.IsPluCode(txtCommodityToFind.Text)) { txtblkInstructions.Text = "By PLU code entered"; SearchQuery = from CommodityPluCode PluData in context.CommodityPluCodes where PluData.PLU == txtCommodityToFind.Text.ToString() select PluData; } if (UserInputUtilities.IsCropNumber(txtCommodityToFind.Text)) { txtblkInstructions.Text = "By crop ID entered"; SearchQuery = from CommodityPluCode PluData in context.CommodityPluCodes where PluData.Commodity == txtCommodityToFind.Text.ToUpper() select PluData; } else { txtblkInstructions.Text = "By commondity name entered"; SearchQuery = from CommodityPluCode PluData in context.CommodityPluCodes where PluData.Commodity == txtCommodityToFind.Text.ToUpper() select PluData; } // Register for the LoadCompleted event. commodityPluCodes.LoadCompleted += new EventHandler<LoadCompletedEventArgs>(commodityPluCodes_LoadCompleted); // Load the customers feed by executing the LINQ query. commodityPluCodes.LoadAsync(SearchQuery); }
private void PhoneApplicationPage_Loaded(object sender, RoutedEventArgs e) { DataServiceCollection<SampleData> sampleDataCollection; var context = CloudStorageContext.Current.Resolver.CreateTableServiceContext(); sampleDataCollection = new DataServiceCollection<SampleData>(context); sampleDataCollection.LoadCompleted += (s2, e2) => { List<SampleData> cloudNotes = sampleDataCollection.ToList(); ListPics.ItemsSource = cloudNotes; }; var tableUri = new Uri( string.Format( CultureInfo.InvariantCulture, "{0}/{1}()", context.BaseUri, "pics"), UriKind.Absolute); sampleDataCollection.Clear(); sampleDataCollection.LoadAsync(tableUri); }
/// <summary> /// Downloads a radio map for the building with the specified id. /// </summary> /// <param name="buildingId"></param> public static void DownloadRadioMap(int buildingId) { radiomapContext = new radiomapEntities(radiomapUri); buildings = new DataServiceCollection<Building>(radiomapContext); String expandOptions = "Building_Floors,Vertices,Vertices/AbsoluteLocations,Vertices/SymbolicLocations,Vertices/Edges,Edges,Edges/Vertices,Edges/Vertices/AbsoluteLocations"; var query = from b in radiomapContext.Buildings.Expand(expandOptions) where b.ID == buildingId select b; // Register for the LoadCompleted event. buildings.LoadCompleted += new EventHandler<LoadCompletedEventArgs>(buildings_LoadCompleted); buildings.LoadAsync(query); }
public void Load() { announcements = App.MainViewModel.Announcements; RaisePropertyChanged(() => Announcements); }
public void Load() { speakers = App.MainViewModel.Speakers; RaisePropertyChanged(() => Speakers); }
public void OnCloneComposition(object obj) { Repository.DataService.Composition sourceComposition = CompositionManager.Composition; SetDimensions(sourceComposition); var verses = new DataServiceCollection<Repository.DataService.Verse>(null, TrackingMode.None); var staffgroups = new DataServiceCollection<Repository.DataService.Staffgroup>(null, TrackingMode.None); var arcs = new DataServiceCollection<Repository.DataService.Arc>(null, TrackingMode.None); var composition = CompositionManager.Create(); Cache.Clear(); foreach (var sourceStaffgroup in sourceComposition.Staffgroups) { var staffgroup = StaffgroupManager.Clone(composition.Id, sourceStaffgroup); var staffs = new DataServiceCollection<Repository.DataService.Staff>(null, TrackingMode.None); foreach (var sourceStaff in sourceStaffgroup.Staffs) { var staff = StaffManager.Clone(staffgroup.Id, sourceStaff); var measures = new DataServiceCollection<Repository.DataService.Measure>(null, TrackingMode.None); foreach (var sourceMeasure in sourceStaff.Measures) { var measure = MeasureManager.Clone(staff.Id, sourceMeasure); var chords = new DataServiceCollection<Repository.DataService.Chord>(null, TrackingMode.None); foreach (var sourceChord in sourceMeasure.Chords) { ChordManager.Measure = measure; var chord = ChordManager.Clone(measure, sourceChord); var notes = new DataServiceCollection<Repository.DataService.Note>(null, TrackingMode.None); foreach (var sourceNote in sourceChord.Notes) { var note = NoteController.Clone(chord.Id, sourceChord, measure, sourceNote.Location_X, sourceNote.Location_Y, sourceNote); if (note != null) { _repository.Context.AddLink(chord, "Notes", note); notes.Add(note); } } chord.Notes = notes; _repository.Context.AddLink(measure, "Chords", chord); chords.Add(chord); } measure.Chords = chords; _repository.Context.AddLink(staff, "Measures", measure); measures.Add(measure); } staff.Measures = measures; _repository.Context.AddLink(staffgroup, "Staffs", staff); staffs.Add(staff); } staffgroup.Staffs = staffs; _repository.Context.AddLink(composition, "Staffgroups", staffgroup); staffgroups.Add(staffgroup); } int s; for (s = 0; s < sourceComposition.Arcs.Count; s++) { var arc = ArcManager.Clone(sourceComposition.Arcs[s]); _repository.Context.AddLink(composition, "Arcs", arc); arcs.Add(arc); } for (s = 0; s < sourceComposition.Verses.Count; s++) { var verse = VerseManager.Clone(composition.Id, sourceComposition.Verses[s]); Cache.Verses.Add(verse); _repository.Context.AddLink(composition, "Verses", verse); verses.Add(verse); } composition.Instrument_Id = sourceComposition.Instrument_Id; composition.Key_Id = sourceComposition.Key_Id; composition.Provenance = sourceComposition.Provenance; composition.Arcs = arcs; composition.Verses = verses; composition.Staffgroups = staffgroups; _ea.GetEvent<NewComposition>().Publish(composition); }
public static void OnCreateNewComposition(object obj) { var payload = (Tuple<string, List<string>, _Enum.StaffConfiguration, List<short>>)obj; _repository = ServiceLocator.Current.GetInstance<DataServiceRepository<Repository.DataService.Composition>>(); var verses = new DataServiceCollection<Repository.DataService.Verse>(null, TrackingMode.None); var staffgroups = new DataServiceCollection<Staffgroup>(null, TrackingMode.None); var collaborations = new DataServiceCollection<Repository.DataService.Collaboration>(null, TrackingMode.None); var composition = Create(); composition.Provenance.TitleLine = payload.Item1; composition.StaffConfiguration = (short)payload.Item3; ClefIds = payload.Item4; for (int sgIndex = 0; sgIndex < Infrastructure.Support.Densities.StaffgroupDensity; sgIndex++) { var staffgroup = StaffgroupManager.Create(composition.Id, _staffgroupSequence); _staffgroupSequence += Defaults.SequenceIncrement; var staffs = new DataServiceCollection<Staff>(null, TrackingMode.None); _staffSequence = 0; for (int sIndex = 0; sIndex < Infrastructure.Support.Densities.StaffDensity; sIndex++) { var staff = StaffManager.Create(staffgroup.Id, _staffSequence); //clefIds was populated in NewCompositionPanel. it's a list of selected staff clef Ids top to bottom. //if Dimensions.StaffDensity > then in multi instrument staffconfiguration - each staff clef is the //same as the first staff clef. otherwise the staff clefs are whatever was specified in the newcompositionpanel staff.Clef_Id = (Infrastructure.Support.Densities.StaffDensity > 2) ? ClefIds[0] : ClefIds[sIndex % 2]; _staffSequence += Defaults.SequenceIncrement; var measures = new DataServiceCollection<Repository.DataService.Measure>(null, TrackingMode.None); _measureSequence = 0; for (int mIndex = 0; mIndex < Infrastructure.Support.Densities.MeasureDensity; mIndex++) { var measure = MeasureManager.Create(staff.Id, _measureSequence); _measureSequence += Defaults.SequenceIncrement; measure.Index = _measureIndex; _measureIndex++; _repository.Context.AddLink(staff, "Measures", measure); //if this is the last measure on the last staff then measure.bar is the EndBar. if (mIndex == Infrastructure.Support.Densities.MeasureDensity - 1) { if (sgIndex == Infrastructure.Support.Densities.StaffgroupDensity - 1) { if (sIndex == Infrastructure.Support.Densities.StaffDensity - 1) { measure.Bar_Id = 1; } } } measures.Add(measure); } staff.Measures = measures; _repository.Context.AddLink(staffgroup, "Staffs", staff); staffs.Add(staff); } staffgroup.Staffs = staffs; _repository.Context.AddLink(composition, "Staffgroups", staffgroup); staffgroups.Add(staffgroup); } composition.Staffgroups = staffgroups; Repository.DataService.Collaboration collaboration = CollaborationManager.Create(composition, 0); _repository.Context.AddLink(composition, "Collaborations", collaboration); collaborations.Add(collaboration); composition.Collaborations = collaborations; composition.Verses = verses; Ea.GetEvent<NewComposition>().Publish(composition); }
/// <summary> /// Reloads notes from server /// </summary> private void LoadData() { this.IsDataLoaded = false; this.IsUiEnabled = false; // preparing a data context this._context = new NotesDataContext(new Uri(NotesDataServiceUri)); // passing the authentication token obtained from Microsoft Account via the Authorization header this._context.SendingRequest += (sender, args) => { // let our header look a bit custom args.RequestHeaders["Authorization"] = Constants.AuthorizationHeaderPrefix + this._authenticationToken; }; var notes = new DataServiceCollection<Note>(this._context); notes.LoadCompleted += (sender, args) => { if (this.Notes.Continuation != null) { this.Notes.LoadNextPartialSetAsync(); return; } if (args.Error == null) { this.IsDataLoaded = true; } else { this.OnError.FireSafely(args.Error); } this.IsUiEnabled = true; }; // Defining a query var query = from note in this._context.Notes orderby note.TimeCreated descending select note; // Demonstrating LINQ query dynamic generation. notes.LoadAsync ( this._showTodaysNotesOnly ? // This will be translated into DynamoDb Query on the server, like this: // DynamoDb index query: SELECT * FROM Note WHERE TimeCreated GreaterThan <some DateTime> AND UserId Equal <some userId> ORDER BY TimeCreated DESC. Index name: TimeCreatedIndex query.Where(note => note.TimeCreated > DateTime.Today) : query ); this.Notes = notes; this.NotifyPropertyChanged(() => this.Notes); }
private void fetchData(string filter, Action<List<Post>> callback) { StackOverflow.StackOverflow context = new StackOverflow.StackOverflow(new System.Uri("https://odata.sqlazurelabs.com/OData.svc/v0.1/rp1uiewita/StackOverflow")); var query = from t in context.Posts where t.Tags.Contains("Silverlight") && t.Score > 5 select t; if (!String.IsNullOrWhiteSpace(filter)) query = query.Where(t => t.Body.Contains(filter) || t.Title.Contains(filter)); DataServiceCollection<Post> posts = new DataServiceCollection<Post>(); posts.LoadCompleted += (s, e) => { if (e.Error != null) throw e.Error; callback(posts.ToList()); }; posts.LoadAsync(query.OrderByDescending(t => t.CreationDate).Take(30)); }
private static void DataServiceCollectionTrackingItems( DataServiceContextWrapper<DefaultContainer> contextWrapper) { var query = from p in contextWrapper.Context.Customer where p.CustomerId > -100000 // try to get many for paging select new Customer() { CustomerId = p.CustomerId, Name = p.Name }; DataServiceCollection<Customer> collection = new DataServiceCollection<Customer>(query); // the collection to track items int tmpCount = collection.Count; collection.Load(contextWrapper.Context.Execute(collection.Continuation)); // for testing newly loaded item's tracking Assert.IsTrue(collection.Count > tmpCount, "Should have loaded another page."); bool someItemNotTracked = false; collection.ToList().ForEach(s => { s.Name = "value to test tracking"; EntityStates state = contextWrapper.Context.GetEntityDescriptor(s).State; someItemNotTracked = (state == EntityStates.Unchanged) || someItemNotTracked; }); Assert.IsFalse(someItemNotTracked, "All items should have been tracked."); }