using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint.Client;

namespace SComTest
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                string siteUrl = "http://www.k2hongkong.com/WOMS";
                //string siteUrl = "http://inet.hysan.com.hk/site/woms/";
                using (ClientContext myContext = new ClientContext(siteUrl))
                {
                    //myContext.Load(myContext.Site);
                    //myContext.ExecuteQuery();
                    //Console.WriteLine(myContext.Site.Url);

                    List list = myContext.Web.Lists.GetByTitle("QE Attachments");
                    myContext.Load(list);
                    myContext.ExecuteQuery();
                    //Console.WriteLine(list.ItemCount);

                    //vary query = from listItems in list.

                    int Number = 2013300047;
                    for (int i = 0; i < 20; i++)
                    {
                        //string folderName = string.Format(@"/site/WOMS/QE Attachments/{0}", Number + i);
                        string folderName = string.Format(@"/WOMS/QE Attachments/{0}", Number + i);

                        Console.WriteLine("SubFolder {0}", folderName);
                        DateTime startTime = DateTime.Now;
                        GetFolderItems(folderName, list, myContext);
                        DateTime endTime = DateTime.Now;
                        Console.WriteLine("Duration: {0}", endTime.Subtract(startTime).TotalMilliseconds);
                    }

                }
            }
            catch (System.Exception ex)
            {
                Console.WriteLine("{0}", ex.ToString());
            }
        }


        static public void GetFolderItems(string folderServerRelativeUrl, List list, ClientContext clientContext)
        {
            try
            {

                var query = new CamlQuery();

                query.FolderServerRelativeUrl = folderServerRelativeUrl;

                query.ViewXml = "<View Scope=\"RecursiveAll\"> " +
                //query.ViewXml = "<View Scope=\"FilesOnly\"> " +
                    "<Query>" +
                    "<Where>" +
                                "<Eq>" +
                                    "<FieldRef Name=\"FileDirRef\" />" +
                                    "<Value Type=\"Text\">" + folderServerRelativeUrl + "</Value>" +
                                 "</Eq>" +
                    "</Where>" +
                    "</Query>" +
                    "</View>";

                var folderItems = list.GetItems(query);
                clientContext.Load(folderItems);
                clientContext.ExecuteQuery();

                foreach (ListItem item in folderItems)
                {
                    // item[ "..." ];
                    Console.WriteLine("{0}", (string)item["FileRef"]);
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine("{0}", ex);
            }
        }
    }
}