using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Security;
using Microsoft.SharePoint.Client;
using System.Net;
using System.IO;

namespace ManageLibraryContent
{
    public partial class FormManageLibrary : System.Windows.Forms.Form
    {


        public FormManageLibrary()
        {
            InitializeComponent();

        }

        private void buttonShowLibaries_Click(object sender, EventArgs e)
        {
            string url = "https://thomasmorestudent06.sharepoint.com/teams/FitGezond";
            string gebruiker = "admin@ThomasMoreStudent06.onmicrosoft.com";
            SecureString paswoord = new SecureString();
            foreach (char c in "TMPassword06".ToCharArray()) paswoord.AppendChar(c);

            using (ClientContext clientContext = new ClientContext(url))
            {
                clientContext.Credentials = new SharePointOnlineCredentials(gebruiker, paswoord);

                //opvragen en laden sitecollection
                Site siteCollection = clientContext.Site;
                clientContext.Load(siteCollection);
                clientContext.ExecuteQuery();
                //drukken sitecollection
                Console.WriteLine(siteCollection.Url);
                Console.WriteLine(siteCollection.ServerRelativeUrl);

                ListCollection colList = clientContext.Web.Lists;


                clientContext.Load(colList, lists => lists.Include(list => list.Title).Where(list => list.BaseType == BaseType.DocumentLibrary));

                clientContext.ExecuteQuery();

                foreach (List list in colList) {
                    listBoxLibraries.Items.Add(list.Title);
                }

            }
        }

        private void listBoxLibraries_SelectedValueChanged(object sender, EventArgs e)
        {
            string url = "https://thomasmorestudent06.sharepoint.com/teams/FitGezond";
            string gebruiker = "admin@ThomasMoreStudent06.onmicrosoft.com";
            SecureString paswoord = new SecureString();
            foreach (char c in "TMPassword06".ToCharArray()) paswoord.AppendChar(c);

            using (ClientContext clientContext = new ClientContext(url))
            {
                clientContext.Credentials = new SharePointOnlineCredentials(gebruiker, paswoord);

                //opvragen en laden sitecollection
                Site siteCollection = clientContext.Site;
                clientContext.Load(siteCollection);
                clientContext.ExecuteQuery();
                //drukken sitecollection
                Console.WriteLine(siteCollection.Url);
                Console.WriteLine(siteCollection.ServerRelativeUrl);

                List list2 = clientContext.Web.Lists.GetByTitle(listBoxLibraries.SelectedItem.ToString());

                CamlQuery query = new CamlQuery();

                query.ViewXml = "<View/>";
                ListItemCollection listItems = list2.GetItems(query);

                clientContext.Load(listItems, items => items.Include(item => item["ID"],
                                                                item => item["LinkFilename"],
                                                                item => item["Author"],
                                                                item => item["Created"],
                                                                item => item["Editor"],
                                                                item => item["Modified"]));

                clientContext.ExecuteQuery();

                DataTable table = new DataTable();
                table.Columns.Add("Id");
                table.Columns.Add("Name");
                table.Columns.Add("Author");
                table.Columns.Add("Created");
                table.Columns.Add("Editor");
                table.Columns.Add("Modified");

                foreach (ListItem item in listItems){
                    FieldUserValue author = (FieldUserValue)item["Author"];
                    FieldUserValue editor = (FieldUserValue)item["Editor"];
                    table.Rows.Add(item["ID"], item["LinkFilename"], author.LookupValue, item["Created"], editor.LookupValue, item["Modified"]);

                }

                dataGridViewContent.DataSource = table;

            }
        }

        private void buttonUpload_Click(object sender, EventArgs e)
        {
            string url = "https://thomasmorestudent06.sharepoint.com/teams/FitGezond";
            string gebruiker = "admin@ThomasMoreStudent06.onmicrosoft.com";
            SecureString paswoord = new SecureString();
            foreach (char c in "TMPassword06".ToCharArray()) paswoord.AppendChar(c);

            using (ClientContext clientContext = new ClientContext(url))
            {
                clientContext.Credentials = new SharePointOnlineCredentials(gebruiker, paswoord);

                DialogResult result = openFileDialogDocument.ShowDialog();

                if (result == DialogResult.OK)
                {
                    FileCreationInformation newFile = new FileCreationInformation();
                    newFile.Content = System.IO.File.ReadAllBytes(openFileDialogDocument.FileName);
                    newFile.Url = Path.GetFileName(openFileDialogDocument.FileName);

                    ClientContext context = new ClientContext(textBoxServer.Text);
                    context.Credentials = new SharePointOnlineCredentials(gebruiker, paswoord);
                    List list = context.Web.Lists.GetByTitle(listBoxLibraries.SelectedItem.ToString());

                    list.RootFolder.Files.Add(newFile);
                    context.ExecuteQuery();
                }
            }
        }




    }
}