using ITR.SharePoint.Client.CSOM;
using Microsoft.SharePoint.Client;
using Microsoft.SharePoint.Client.WebParts;
using System;
using System.Linq;

namespace SP.DEMO.PROVISIONING
{
    class Program {
        private static string username = "alnstrange@alnstrange.onmicrosoft.com";
        private static string siteURL = "https://alnstrange.sharepoint.com/sites/provisioning";

        //Opret SharePoint Team Site
        //Opret liste med felter: Site Title, URL, IsProvisioned
        //Hent listen ud i koden
        //opret subsite på nye elementer
        //Ryd forsiden for webparts
        //Indsæt en Youtube video på forsiden (efter ejet valg)

        static void Main(string[] args) {

            // Starting with SPClientContext, the constructor requires a URL to the
            // server running SharePoint.
            Console.WriteLine("Please enter password:");
            using (SPClientContext ctx = new SPClientContext(siteURL)) {
                ctx.Credentials = new SharePointOnlineCredentials(username, ctx.GetPasswordFromConsoleInput());

                // The SharePoint web at the URL.
                Web web = ctx.Web;

                ctx.Load(web);
                ctx.Load(web, x => x.Lists);

                ctx.ExecuteQuery();

                Console.WriteLine(string.Format("Connected to site with title of '{0}'", web.Title));
                Console.WriteLine();

                CamlQuery query = new CamlQuery();

                List myList = web.Lists.GetByTitle("websitelist");

                var myListFieldCollection = myList.Fields;

                ListItemCollection websites = myList.GetItems(query);
                ctx.Load<List>(myList);
                ctx.Load<ListItemCollection>(websites);
                ctx.Load<FieldCollection>(myListFieldCollection);
                ctx.ExecuteQuery();

                Console.WriteLine("Getting list items...");
                Console.WriteLine("-------------------------------");

                var siteTitleColumnInternalName = myListFieldCollection.First(t => t.Title == "Site Title").InternalName;
                var urlColumnInternalName = myListFieldCollection.First(t => t.Title == "URL").InternalName;
                var isProvisionedTitleColumnInternalName = myListFieldCollection.First(t => t.Title == "IsProvisioned").InternalName;

                foreach (var website in websites)
                {
                    var siteTitle = (string)website.FieldValues.First(k => k.Key == siteTitleColumnInternalName).Value;
                    var url = (string)website.FieldValues.First(k => k.Key == urlColumnInternalName).Value;
                    var isProvisioned = (bool)website.FieldValues.First(k => k.Key == isProvisionedTitleColumnInternalName).Value;

                    if (isProvisioned == false)
                    {
                        Console.WriteLine("Generating subsite from list with IsProvisioned 'False'...");

                        WebCreationInformation creation = new WebCreationInformation();
                        creation.Title = siteTitle;
                        creation.Url = url;
                        Web newWeb = ctx.Web.Webs.Add(creation);
                        ctx.Load(newWeb, w => w.Title);
                        website.ParseAndSetFieldValue("IsProvisioned", "true");
                        website.Update();
                        ctx.ExecuteQuery();

                        Console.WriteLine("Subsite created! - Title: " + "(" + siteTitle + ") " + "URL: " + "(" + url + ")");

                       // Console.WriteLine("Inserting webpart to subsite...");

                    }

                    else
                    {
                        Console.WriteLine("Site Title: " + siteTitle);
                        Console.WriteLine("URL: " + url);
                        Console.WriteLine("isProvisioned: " + isProvisioned);
                        Console.WriteLine("-------------------------------");
                    }

                }

                    var webPartXml = @"<?xml version='1.0' encoding='utf-8'?>
<webParts>
  <webPart xmlns='http://schemas.microsoft.com/WebPart/v3'>
    <metaData>
      <type name='Microsoft.Office.Server.Search.WebControls.ContentBySearchWebPart, Microsoft.Office.Server.Search,Version=16.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c' />
      <importErrorMessage>$Resources:core,ImportErrorMessage;</importErrorMessage>
    </metaData>
    <data>
      <properties>
        <property name='Title' type='string'>$Resources:Microsoft.Office.Server.Search,CBS_Title;</property>
        <property name='Description' type='string'>$Resources:Microsoft.Office.Server.Search,CBS_Description;</property>
        <property name='ChromeType'>None</property>
        <property name='AllowMinimize' type='bool'>true</property>
        <property name='AllowClose' type='bool'>true</property>
        <property name='Hidden' type='bool'>false</property>
        <property name='DataProviderJSON' type='string'>{'Properties':{'TryCache':true,'Scope':'{Site.URL}'},'PropertiesJson':'{\'TryCache\':true,\'Scope\':\'{Site.URL}\'}'}</property>
     </properties>
</data>
</webPart>
</webParts>";


                Console.ReadLine();
            }
        }
    }
}