using statements;

namespace SPWebservices
{
    public class SPServices
    {
 	 static string pageCnt = string.Empty;

         public void GetListItems(string serviceURL, string libName)
         {
         
            try
            {                

                #region Retrieve Items & Folders under library
                XmlDocument doc = new XmlDocument();

		//open the web service connection
                using (Lists listProxy = new Lists())
                {
		    //check the page count
                    while (pageCnt != null)
                    {
                        string query = GetQuery();

                        doc.LoadXml(query);

                        XmlNode queryNode = doc.SelectSingleNode("//Query");
                        XmlNode viewNode = doc.SelectSingleNode("//ViewFields");
                        XmlNode optionNode = doc.SelectSingleNode("//QueryOptions");

			//pass the web service url to get the list of methods over there
                        listProxy.Url = serviceURL;

			//pass the default credentials to access the same.

                        listProxy.UseDefaultCredentials = true;
                        

			//get the items from server and set the row limit of 5,000, in SP that is the max limit to get the items without any issue's.

                        XmlNode retNode = listProxy.GetListItems(libraryName, string.Empty, queryNode, viewNode, "5000", optionNode, "");

                        //the below line help us to get the next set of records and to pass this in CAML query we can get next set of records

                        XmlNode xmlPageCnt = retNode.SelectSingleNode("//@ListItemCollectionPositionNext");

			//assign current page count to the varriable, this help us to get the next set of records.
                        pageCnt = xmlPageCnt != null ? xmlPageCnt.InnerXml : null;


                        DataSet ds = new DataSet();
                        using (StringReader sr = new StringReader(retNode.OuterXml))
                            ds.ReadXml(sr);


                        if (ds.Tables["Row"] != null && ds.Tables["Row"].Rows.Count > 0)
                        {

                            //perform action as you want here
                        }
                    }
                }
                #endregion
               
            }

            catch (Exception ex)
            {
                throw;
            }

        }


        private static string GetViewFields()
        {
            
            string query = string.Empty;
            try
            {
                
                #region ViewFields
                query = @"<mylistitemrequest>
                                <Query>                                   

                                </Query>
                                <ViewFields>                                 
                                  
                                </ViewFields>
                                <QueryOptions>
                                    <Paging ListItemCollectionPositionNext='{0}' />
                                    <ViewAttributes Scope='RecursiveAll' IncludeRootFolder='FALSE' />
                                </QueryOptions>
                            </mylistitemrequest>";
                
                query = string.Format(query, pageCnt);
                #endregion

                
            }
            catch (Exception ex)
            {
                throw;
            }
            return query;
        }
   }
}