/// <summary>
 /// Load List of all UserDevice objects from Context for Partition Key.
 /// </summary>
 /// <param name="p_Partition">Partition key of the table</param>
 /// <returns>List of all UserDevice </returns>
 public List<UserDevice> GetAllForPartition( string PartitionKey )
 {
     List<UserDevice> rez = new List<UserDevice>();
     NextRecordInfo nextRec = new NextRecordInfo() ;
         do
         {
             DataServiceQuery<UserDevices> Qtran = (DataServiceQuery<UserDevices>)servCtx.CreateQuery<UserDevices>(TableName).Where(c => c.PartitionKey == PartitionKey);
            	nextRec = GetNextPage(ref rez, Qtran, nextRec, 0);
         }
         while (!string.IsNullOrEmpty(nextRec.NextPartition));
     return rez;
 }
Пример #2
0
        /*

        //   This is an example of custom developed query
        public List<UserLocation> MethodName(list of method parameters )
        {
            List<UserLocation> rez = new List<UserLocation>();
            NextRecordInfo nextRec = new NextRecordInfo() ;
                do
                {
                    DataServiceQuery<UserLocations> Qtran = (DataServiceQuery<UserLocations>)servCtx.CreateQuery<UserLocations>(TableName).Where(c => enter query details here );
                   	nextRec = GetNextPage(ref rez, Qtran, nextRec, 0);
                }
                while (!string.IsNullOrEmpty(nextRec.NextPartition));
            return rez;
        }

        */
        //Add your extension methods here for  UserLocationContext class.
        public List<UserLocation> GetProximityUsers(double latitude , double longitude)
        {
            List<UserLocation> rez = new List<UserLocation>();
            RadiusBox radBox = RadiusBox.Create(latitude, longitude, PROXIMITY_RADIUS);

            NextRecordInfo nextRec = new NextRecordInfo() ;
                do
                {
                    //DataServiceQuery<UserLocations> Qtran = (DataServiceQuery<UserLocations>)servCtx.CreateQuery<UserLocations>(TableName).Where(c => c.PartitionKey <= topline
                    //                                                                                            && double.Parse(c.PartitionKey) >= radBox.BottomLine
                    //                                                                                            &&  double.Parse(c.RowKey) <=radBox.RightLine
                    //                                                                                            && double.Parse(c.RowKey) >=radBox.LeftLine);

                    DataServiceQuery<UserLocations> Qtran = (DataServiceQuery<UserLocations>)servCtx.CreateQuery<UserLocations>(TableName).Where(c => c.PartitionKey.CompareTo(radBox.TopLine.ToString()) < 0
                                                                                                              && c.PartitionKey.CompareTo(radBox.BottomLine.ToString()) > 0
                                                                                                              && c.RowKey.CompareTo(radBox.RightLine.ToString()) > 0
                                                                                                              && c.RowKey.CompareTo(radBox.LeftLine.ToString()) < 0);

                   	nextRec = GetNextPage(ref rez, Qtran, nextRec, 0);
                }
                while (!string.IsNullOrEmpty(nextRec.NextPartition));
            return rez;
        }
 /// <summary>
 /// Load  next page of UserDevice objects from Context for the passed in query and
 /// adds this page to passed in lis.
 /// </summary>
 /// <param name="list">List results will be added to.</param>
 /// <param name="Query">DataServiceQuery object</param>
 /// <param name="nextRec"> NextRecordInfo object define begining of the page to load</param>
 /// <param name="PageSize">Size of the page.  If value is 0  or value greater than 1000 system will limit paze size to 1000 records  </param>
 /// <returns> NextRecordInfo object for the next page</returns>
 private NextRecordInfo GetNextPage(ref List<UserDevice> list, DataServiceQuery<UserDevices> Query, NextRecordInfo nextRec, int PageSize)
 {
     NextRecordInfo Result = new NextRecordInfo();
        QueryOperationResponse qor;
        if (!string.IsNullOrEmpty(nextRec.NextPartition))
        Query = Query.AddQueryOption("NextPartitionKey", nextRec.NextPartition).AddQueryOption("NextRowKey", nextRec.NextKey);
        if (PageSize > 0)
        qor = (QueryOperationResponse)((DataServiceQuery<UserDevices>)Query.Take(PageSize)).Execute();
        else
        qor = (QueryOperationResponse)(Query).Execute();
        string nextPartition = String.Empty;
        string nextRow = String.Empty;
        qor.Headers.TryGetValue("x-ms-continuation-NextPartitionKey", out nextPartition);
        qor.Headers.TryGetValue("x-ms-continuation-NextRowKey", out nextRow);
        IQueryable<UserDevices> qt = (IQueryable<UserDevices>)qor.AsQueryable();
        Result.NextKey = nextRow;
        Result.NextPartition = nextPartition;
        	   var enumer = qt.GetEnumerator();
        while (enumer.MoveNext())
     list.Add( new UserDevice(enumer.Current));
        return Result;
 }