ตอนที่ 11 : การทำ Refine Mobile Services queries with paging บน iOS / iPhone

    NSPredicate *predicate = [NSPredicate predicateWithFormat:@"complete == 'false' "];
    
    MSQuery * query = [self.table queryWithPredicate:predicate];
    
    query.fetchOffset = 0;
    query.fetchLimit = 3;

    NSPredicate *predicate = [NSPredicate predicateWithFormat:@"complete == 'false' "];
    
    MSQuery * query = [self.table queryWithPredicate:predicate];
    
    query.fetchOffset = 3;
    query.fetchLimit = 3;

- (void)refreshDataOnSuccess:(QSCompletionBlock)completion
{
    
    
    NSPredicate *predicate = [NSPredicate predicateWithFormat:@"status = '0' or status = '1' "];
    
    MSQuery * query = [self.table queryWithPredicate:predicate];
    
    query.fetchOffset = 0;
    query.fetchLimit = 3;
    
    [query readWithCompletion:^(NSArray *results, NSInteger totalCount, NSError *error) {
        
        [self logErrorIfNotNil:error];
        if (!error)
        {
            // Log total count.
            NSLog(@"Total item count: %@",[NSString stringWithFormat:@"%zd", (ssize_t) totalCount]);
        }
        
        items = [results mutableCopy];
        
        // Let the caller know that we finished
        completion();
        
    }];
    
}

//
//  ViewController.h
//  myAppMobileService
//
//  Created by Weerachai on 5/12/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import <UIKit/UIKit.h>

@interface ViewController : UIViewController
{
    IBOutlet UITableView *myTable;
}
 
@end

//
//  ViewController.m
//  myAppMobileService
//
//  Created by Weerachai on 5/12/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import <WindowsAzureMobileServices/WindowsAzureMobileServices.h>
#import "MyMemberService.h"

#import "ViewController.h"

@interface ViewController ()

// Private properties
@property (strong, nonatomic)   MyMemberService   *memberService;

@end


@implementation ViewController

@synthesize memberService;


- (void)viewDidLoad
{
    [super viewDidLoad];
    
    // Start Service
    self.memberService = [MyMemberService defaultService];
    [self.memberService refreshDataOnSuccess:^
     {
         [myTable reloadData];
     }];

}

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath
{
    
    static NSString *CellIdentifier = @"Cell";
    
    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];
    if (cell == nil) {
        cell = [[[UITableViewCell alloc] initWithStyle : UITableViewCellStyleSubtitle
                                       reuseIdentifier : CellIdentifier] autorelease];
    }
     
    NSDictionary *item = [self.memberService.items objectAtIndex:indexPath.row];
    
    NSString *col1 =[NSString stringWithFormat:@"id = %@ name = %@",
                     [item objectForKey:@"id"],
                     [item objectForKey:@"name"]];
    cell.textLabel.text = col1;
    
    NSString *col2 =[NSString stringWithFormat:@"email = %@ status = %@",
                     [item objectForKey:@"email"],
                     [item objectForKey:@"status"]];
    cell.detailTextLabel.text= col2;
    
    return cell;
    
}

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView
{
    // Always a single section
    return 1;
}

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
{
    // Return the number of items in the todoService items array
    return [self.memberService.items count];
    
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

- (void)dealloc {
    [myTable release];
    [super dealloc];
}
@end

//
//  MyMemberService.h
//  myAppMobileService
//
//  Created by Weerachai on 7/21/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import <WindowsAzureMobileServices/WindowsAzureMobileServices.h>
#import <Foundation/Foundation.h>


typedef void (^QSCompletionBlock) ();
typedef void (^QSBusyUpdateBlock) (BOOL busy);
 

@interface MyMemberService : NSObject

@property (nonatomic, strong)   NSArray *items;
@property (nonatomic, strong)   MSClient *client;
@property (nonatomic, copy)     QSBusyUpdateBlock busyUpdate;


+ (MyMemberService *)defaultService;

- (void)refreshDataOnSuccess:(QSCompletionBlock)completion;

- (void)handleRequest:(NSURLRequest *)request
                 next:(MSFilterNextBlock)next
             response:(MSFilterResponseBlock)response;

@end

//
//  MyMemberService.m
//  myAppMobileService
//
//  Created by Weerachai on 7/21/56 BE.
//  Copyright (c) 2556 Weerachai. All rights reserved.
//

#import "MyMemberService.h"
#import <WindowsAzureMobileServices/WindowsAzureMobileServices.h>


@interface MyMemberService() <MSFilter>

@property (nonatomic, strong)   MSTable *table;
@property (nonatomic)           NSInteger busyCount;

@end

@implementation MyMemberService

@synthesize items;


+ (MyMemberService *)defaultService
{
    // Create a singleton instance of MyMemberService
    static MyMemberService* service;
    static dispatch_once_t onceToken;
    dispatch_once(&onceToken, ^{
        service = [[MyMemberService alloc] init];
    });
    
    return service;
}

-(MyMemberService *)init
{
    self = [super init];
    
    if (self)
    {
        // Initialize the Mobile Service client with your URL and key
        MSClient *client = [MSClient clientWithApplicationURLString:@"https://thaicreate.azure-mobile.net/"
        applicationKey:@"uJPAhkAkcTBuTyCNxaOSnDKFzkoYqB49"];
         
        // Add a Mobile Service filter to enable the busy indicator
        self.client = [client clientWithFilter:self];
        
        // Create an MSTable instance to allow us to work with the TodoItem table
        self.table = [_client tableWithName:@"MyMember"];
        
        self.items = [[NSMutableArray alloc] init];
        self.busyCount = 0;
    }
    
    return self;
}

- (void)refreshDataOnSuccess:(QSCompletionBlock)completion
{
    
    
    NSPredicate *predicate = [NSPredicate predicateWithFormat:@"status = '0' or status = '1' "];
    
    MSQuery * query = [self.table queryWithPredicate:predicate];
    
    query.fetchOffset = 0;
    query.fetchLimit = 3;
    
    [query readWithCompletion:^(NSArray *results, NSInteger totalCount, NSError *error) {
        
        [self logErrorIfNotNil:error];
        if (!error)
        {
            // Log total count.
            NSLog(@"Total item count: %@",[NSString stringWithFormat:@"%zd", (ssize_t) totalCount]);
        }
        
        items = [results mutableCopy];
        
        // Let the caller know that we finished
        completion();
        
    }];
    
}

- (void)busy:(BOOL)busy
{
    // assumes always executes on UI thread
    if (busy)
    {
        if (self.busyCount == 0 && self.busyUpdate != nil)
        {
            self.busyUpdate(YES);
        }
        self.busyCount ++;
    }
    else
    {
        if (self.busyCount == 1 && self.busyUpdate != nil)
        {
            self.busyUpdate(FALSE);
        }
        self.busyCount--;
    }
}

- (void)logErrorIfNotNil:(NSError *) error
{
    if (error)
    {
        NSLog(@"ERROR %@", error);
    }
}


- (void)handleRequest:(NSURLRequest *)request
                 next:(MSFilterNextBlock)next
             response:(MSFilterResponseBlock)response
{
    // A wrapped response block that decrements the busy counter
    MSFilterResponseBlock wrappedResponse = ^(NSHTTPURLResponse *innerResponse, NSData *data, NSError *error)
    {
        [self busy:NO];
        response(innerResponse, data, error);
    };
    
    // Increment the busy counter before sending the request
    [self busy:YES];
    next(request, wrappedResponse);
}

@end