private static void AddPublishingPage(ClientContext context, PublishingWeb webPub, ListItemCollection allPageLayouts, OfficeDevPnP.Core.Framework.Provisioning.Model.PublishingPage page)
        {
            ListItem layout = null;

            //try to get layout by Title
            layout = allPageLayouts.Where(x => x["Title"] != null && x["Title"].ToString().Equals(page.Layout)).FirstOrDefault();

            //try to get layout by DisplayName
            if (layout == null)
            {
                layout = allPageLayouts.Where(x => x.DisplayName == page.Layout).FirstOrDefault();
            }

            //we need to have a layout for a publishing page
            if (layout == null)
            {
                throw new ArgumentNullException(string.Format("Layout '{0}' for page {1} can not be found.", page.Layout, page.Name));
            }

            context.Load(layout);

            // Create a publishing page
            PublishingPageInformation publishingPageInfo = new PublishingPageInformation();

            publishingPageInfo.Name = page.Name;
            publishingPageInfo.PageLayoutListItem = layout;

            Microsoft.SharePoint.Client.Publishing.PublishingPage publishingPage = webPub.AddPublishingPage(publishingPageInfo);

            //publishingPage.ListItem.File.Approve(string.Empty);

            context.Load(publishingPage);
            context.Load(publishingPage.ListItem.File, obj => obj.ServerRelativeUrl);
            context.ExecuteQuery();
        }
Exemplo n.º 2
0
 public static IQueryable <ListItem> QueryByHeroId(this ListItemCollection collection, int id)
 {
     return(collection.Where(component => component.Id == id)
            .Include(component => component.Id,
                     component => component["ComponentName"],
                     component => component["Text"]));
 }
Exemplo n.º 3
0
 public static IQueryable <ListItem> QueryBlogPosts(this ListItemCollection pages)
 {
     return(pages.Where(page => page.ContentType.Name == "BlogPage")
            .Include(page => page.Id,
                     page => page["Hero"],
                     page => page["PublishedDate1"],
                     page => page["Text"],
                     page => page["PageName"]));
 }
Exemplo n.º 4
0
        public static void CreatePublishingPage(ClientContext clientContext, string pageName, string pagelayoutname, string url, string queryurl)
        {
            var publishingPageName = pageName + ".aspx";

            Web web = clientContext.Web;

            clientContext.Load(web);

            List pages = web.Lists.GetByTitle("Pages");

            clientContext.Load(pages.RootFolder, f => f.ServerRelativeUrl);
            clientContext.ExecuteQuery();

            Microsoft.SharePoint.Client.File file =
                web.GetFileByServerRelativeUrl(pages.RootFolder.ServerRelativeUrl + "/" + pageName + ".aspx");
            clientContext.Load(file, f => f.Exists);
            clientContext.ExecuteQuery();
            if (file.Exists)
            {
                file.DeleteObject();
                clientContext.ExecuteQuery();
            }
            PublishingWeb publishingWeb = PublishingWeb.GetPublishingWeb(clientContext, web);

            clientContext.Load(publishingWeb);

            if (publishingWeb != null)
            {
                List publishingLayouts = clientContext.Site.RootWeb.Lists.GetByTitle("Master Page Gallery");

                ListItemCollection allItems = publishingLayouts.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(allItems, items => items.Include(item => item.DisplayName).Where(obj => obj.DisplayName == pagelayoutname));
                clientContext.ExecuteQuery();

                ListItem layout = allItems.Where(x => x.DisplayName == pagelayoutname).FirstOrDefault();
                clientContext.Load(layout);

                PublishingPageInformation publishingpageInfo = new PublishingPageInformation()
                {
                    Name = publishingPageName,
                    PageLayoutListItem = layout,
                };

                PublishingPage publishingPage = publishingWeb.AddPublishingPage(publishingpageInfo);
                publishingPage.ListItem.File.CheckIn(string.Empty, CheckinType.MajorCheckIn);
                publishingPage.ListItem.File.Publish(string.Empty);
                clientContext.ExecuteQuery();
            }
            SetSupportCaseContent(clientContext, "SupportCasesPage", url, queryurl);
        }
Exemplo n.º 5
0
 public static IQueryable <ListItem> QueryHomePages(this ListItemCollection pages)
 {
     return(pages.Where(page => page.ContentType.Name == "HomePage")
            .Include(page => page["PageName"],
                     page => page["Hero"],
                     page => page["TopContentTitle"],
                     page => page["TopContent"],
                     page => page["MiddleContentTitle"],
                     page => page["MiddleContentLeft"],
                     page => page["MiddleContentRight"],
                     page => page["BottomContentTitle"],
                     page => page["BottomContent"],
                     page => page["ShowBlogPosts"],
                     page => page["FooterContentTitle"],
                     page => page["FooterTopContent"]));
 }
Exemplo n.º 6
0
 private static string InsertListInBD(string Uri, string User, string Password, string NameTable, string StringConnectionBD)
 {
     try {
         //Instancia de la Uri (ejm: https://miremingtonedu.sharepoint.com/sites/Pruebas) en este link se encuentra la lista
         var context = new ClientContext(Uri);
         //se obtiene el contexto de la paginaa
         Web web = context.Web;
         //se convierte la contraseña a un objeto SecureString
         SecureString password = GetPassword(Password);
         //se ingresan las credenciales del usuario
         context.Credentials = new SharePointOnlineCredentials(User, password);
         //se obtiene la tabla indicada
         List tabla = web.Lists.GetByTitle(NameTable);
         //-------se realiza un query sobre todos los elementos de la lista-------
         CamlQuery          query    = CamlQuery.CreateAllItemsQuery();//query para consultar
         ListItemCollection columnas = tabla.GetItems(query);
         //-----------------------------------------------------------------------
         //se carga la consulta y se ejecuta
         context.Load(columnas);
         context.ExecuteQuery();
         //se recorren todos los items pendientes
         var list        = columnas.Where(x => x["Estado"].ToString().Equals("Pendiente"));
         int Countslopes = list.Count();
         if (Countslopes != 0)
         {
             foreach (ListItem item in list)
             {
                 Console.WriteLine("------------");
                 Console.WriteLine(item["Title"].ToString() + " | " + item["Fecha_Creacion"].ToString()
                                   + " | " + item["Estado"].ToString());
                 Console.WriteLine("------------");
                 InsertTicket(StringConnectionBD, item["Title"].ToString(), item["Fecha_Creacion"].ToString(), item["Estado"].ToString());
                 item["Estado"] = "En Proceso";
                 item.Update();
                 context.ExecuteQuery();
             }
             return("1|Succesfull");
         }
         else
         {
             return("1|No hay elementos en la lista");
         }
     }
     catch (Exception e) {
         return("0|Error no controlado: " + e.ToString());
     }
 }
Exemplo n.º 7
0
        private static void childUpdate(ClientContext ctx, CamlQuery q, ListItem oitem)
        {
            #region child
            // CamlQuery q = new CamlQuery();
            //Find all replies for topic with ID=1
            q.ViewXml = @"<View Scope='Recursive'>
                <Query>
                    <Where>
                        <Eq>
                            <FieldRef Name=""ParentFolderId"" />
                            <Value Type=""Integer"">" + oitem["ID"] + "</Value></Eq></Where><OrderBy><FieldRef Name='ID' /></OrderBy></Query></View>";
            ListItemCollection replies = oitem.ParentList.GetItems(q);
            ctx.Load(replies);
            ctx.ExecuteQuery();
            Console.WriteLine(replies.Count);
            foreach (ListItem i in replies)
            {
                int parentItemId = Convert.ToInt16(i["ParentItemID"].ToString());
                int pID          = Convert.ToInt32(oitem["ID"]);
                // Console.WriteLine(i["Text"]);
                Console.WriteLine(i["ID"]);
                FieldUserValue author           = (FieldUserValue)i["Author"];
                FieldUserValue editor           = (FieldUserValue)i["Editor"];
                FieldUserValue parentItemEditor = (FieldUserValue)i["ParentItemEditor"];
                Console.WriteLine(string.Format("Reply : Author {0} Editor {1} ParentItemEditor {2}", author.LookupValue, editor.LookupValue, parentItemEditor.LookupValue));

                if (parentItemId == pID)
                {
                    i["ParentItemEditor"] = resolveUser(author.LookupValue, ctx);
                }
                else
                {
                    var    onewItem = replies.Where(e => e["ID"].ToString() == parentItemId.ToString());
                    string value    = ((FieldUserValue)onewItem.First()["Author"]).LookupValue;
                    i["ParentItemEditor"] = resolveUser(value, ctx);
                }
                i.Update();
                ctx.ExecuteQuery();
                i["Editor"] = resolveUser(author.LookupValue, ctx);
                i.Update();
                ctx.ExecuteQuery();
            }
            #endregion
        }
Exemplo n.º 8
0
        public void AddPublishingPage()
        {
            string pageName = "CustomPage3.aspx";
            Web    webSite  = context.Web;

            context.Load(webSite);
            PublishingWeb web = PublishingWeb.GetPublishingWeb(context, webSite);

            context.Load(web);

            if (web != null)
            {
                List pages = context.Site.RootWeb.Lists.GetByTitle("Pages");
                ListItemCollection defaultPages = pages.GetItems(CamlQuery.CreateAllItemsQuery());
                context.Load(defaultPages, items => items.Include(item => item.DisplayName).Where(obj => obj.DisplayName == pageName));
                context.ExecuteQuery();
                if (defaultPages != null && defaultPages.Count > 0)
                {
                }
                else
                {
                    List publishingLayouts      = context.Site.RootWeb.Lists.GetByTitle("Master Page Gallery");
                    ListItemCollection allItems = publishingLayouts.GetItems(CamlQuery.CreateAllItemsQuery());
                    context.Load(allItems, items => items.Include(item => item.DisplayName).Where(obj => obj.DisplayName == "PageLayoutTemplate"));
                    context.ExecuteQuery();
                    ListItem layout = allItems.Where(x => x.DisplayName == "PageLayoutTemplate").FirstOrDefault();
                    context.Load(layout);
                    PublishingPageInformation publishingPageInfo = new PublishingPageInformation();
                    publishingPageInfo.Name = pageName;
                    publishingPageInfo.PageLayoutListItem = layout;
                    PublishingPage publishingPage = web.AddPublishingPage(publishingPageInfo);
                    publishingPage.ListItem.File.CheckIn(string.Empty, CheckinType.MajorCheckIn);
                    publishingPage.ListItem.File.Publish(string.Empty);
                    publishingPage.ListItem.File.Approve(string.Empty);
                    context.Load(publishingPage);
                    context.Load(publishingPage.ListItem.File, obj => obj.ServerRelativeUrl);
                    context.ExecuteQuery();
                }
            }
        }
Exemplo n.º 9
0
        public IEnumerable <string> GetSuperheroesByFilm(int filmId)
        {
            ListItemCollection filmsuperheroes = website.Lists.GetByTitle("FilmSuperheroes").GetItems(CamlQuery.CreateAllItemsQuery());

            clientContext.Load(filmsuperheroes);
            clientContext.ExecuteQuery();

            List <int> superheroIds = filmsuperheroes.Where(f => Convert.ToInt32(f["Title"]) == filmId)
                                      .Select(fs => Convert.ToInt32(fs["SuperheroId"]))
                                      .ToList();

            ListItemCollection superheroes = website.Lists.GetByTitle("Superheroes").GetItems(CamlQuery.CreateAllItemsQuery());

            clientContext.Load(superheroes);
            clientContext.ExecuteQuery();

            List <string> result = superheroes.Where(f => superheroIds.Any(id => Convert.ToInt32(f.Id) == id))
                                   .Select(fs => fs["Title"].ToString())
                                   .ToList();

            return(result);
        }
Exemplo n.º 10
0
        /// <summary>
        /// Check for the list item named Matter Center Briefcase already exists, if not then only create new folder
        /// </summary>
        /// <param name="clientContext">SP client context</param>
        /// <param name="list">Name of the list</param>
        /// <param name="usersMySite">My Site URL of the user</param>
        internal static void CreateBriefcaseIfNotExists(ClientContext clientContext, List list, string usersMySite)
        {
            CamlQuery briefcaseQuery = new CamlQuery();

            briefcaseQuery.ViewXml = string.Format(CultureInfo.InvariantCulture, ServiceConstantStrings.BriefcaseFolderQuery, ServiceConstantStrings.LegalBriefcaseFolder);
            ListItemCollection briefcases = list.GetItems(briefcaseQuery);

            clientContext.Load(briefcases, listItems => listItems.Include(item => item.DisplayName));
            clientContext.ExecuteQuery();
            ListItem listItem = briefcases.Where(item => item.DisplayName == ServiceConstantStrings.LegalBriefcaseFolder).FirstOrDefault();

            if (null == listItem)      // Check for Matter Center Briefcase folder exists, if not then create
            {
                ListItemCreationInformation newItem = new ListItemCreationInformation();
                newItem.FolderUrl            = string.Concat(usersMySite, ServiceConstantStrings.OneDriveDocumentLibraryTitle);
                newItem.LeafName             = ServiceConstantStrings.LegalBriefcaseFolder;
                newItem.UnderlyingObjectType = FileSystemObjectType.Folder;
                listItem = list.AddItem(newItem);
                listItem.Update();
                clientContext.Load(listItem, field => field.DisplayName);
                clientContext.ExecuteQuery();
            }
        }
Exemplo n.º 11
0
        public IEnumerable <string> GetFilmsBySuperhero(int superheroId)
        {
            CamlQuery camlQuery = new CamlQuery();

            camlQuery.ViewXml = $@"<View>
                                    <Query>
                                        <Where>
                                            <Eq>
                                                <FieldRef Name='SuperheroId'/>
                                                <Value Type='Number'>{superheroId}</Value>
                                            </Eq>
                                        </Where>
                                    </Query>
                                    </View>";

            ListItemCollection filmsuperheroes = website.Lists.GetByTitle("FilmSuperheroes").GetItems(camlQuery);

            clientContext.Load(filmsuperheroes);
            clientContext.ExecuteQuery();

            List <int> filmIds = filmsuperheroes
                                 //.Where(f => Convert.ToInt32(f["SuperheroId"]) == superheroId)
                                 .Select(fs => Convert.ToInt32(fs["Title"]))
                                 .ToList();

            ListItemCollection films = website.Lists.GetByTitle("Films").GetItems(CamlQuery.CreateAllItemsQuery());

            clientContext.Load(films);
            clientContext.ExecuteQuery();

            List <string> result = films.Where(f => filmIds.Any(id => Convert.ToInt32(f.Id) == id))
                                   .Select(a => a["Title"].ToString())
                                   .ToList();

            return(result);
        }
Exemplo n.º 12
0
        static void Main(string[] args)
        {
            string pathArchivoCompleto = "C:\\Users\\k697344\\Documents\\Comex PPG\\Documentacion\\Documentos Control Documental_V1_004.xlsx";
            string nombrePestana       = "CM FINAL";


            string usuarioSharePoint  = "S004221";
            string passwordSharePoint = "Julio2019";

            string urlShareFolder    = "\\\\10.104.175.150\\Campania\\Reporte";
            string urlCompletoFolder = "";

            string urlSharePointOrigen  = "https://one.web.ppg.com/la/mexico/ppgmexico/CalidadTotal/Control_Documental/BckP_SJDR";
            string urlSharePointDestino = "https://one.web.ppg.com/la/mexico/ppgmexico/CalidadTotal/Control_Documental/DocsPublic";
            string urlCompletoOrigen    = "";
            string urlCompletoDestino   = "";

            string siteUrl = "https://one.web.ppg.com/la/mexico/ppgmexico/CalidadTotal/Control_Documental/";
            string bibliotecaDocumentoSP = "Manual de Calidad";
            string catalogoArea          = "Area";
            string catalogoDepartamento  = "Department";
            string catalogoDocType       = "DocType";
            string catalogoSBU           = "SBU";
            string catalogoCliente       = "Clientes";

            ExcelQueryFactory book        = new ExcelQueryFactory();
            List <Archivo>    ListArchivo = new List <Archivo>();

            List <Archivo> ListArchivoEncontrado = new List <Archivo>();

            //string nombreArchivo = "\\\\10.104.175.150\\Campania\\Reporte\\Guid.NewGuid().ToString()" + ".xls";
            string pathArchivoExcel = "\\\\10.104.175.150\\Campania\\Reporte\\Archivos_Cargados_" + Guid.NewGuid().ToString() + ".xls";

            DataSet   dsArchivoExcel = new DataSet();
            DataTable dtArchivoExcel = new DataTable();

            DataSet   dsCatalogos    = new DataSet();
            DataTable dtArea         = new DataTable();
            DataTable dtDepartamento = new DataTable();
            DataTable dtDocType      = new DataTable();

            dtArchivoExcel.Columns.Add("Area");
            dtArchivoExcel.Columns.Add("Departamento");
            dtArchivoExcel.Columns.Add("TipoDocumento");
            dtArchivoExcel.Columns.Add("DepartamentoCodigo");
            dtArchivoExcel.Columns.Add("Codigo");
            dtArchivoExcel.Columns.Add("NombreDocumento");
            dtArchivoExcel.Columns.Add("DescripcionDocumento");
            dtArchivoExcel.Columns.Add("NumeroRevision");
            dtArchivoExcel.Columns.Add("FCambioFijo");
            dtArchivoExcel.Columns.Add("FCambioFrecuente");
            dtArchivoExcel.Columns.Add("SBU");
            dtArchivoExcel.Columns.Add("Cliente");

            try
            {
                ////LECTURA DEL ARCHIVO EXCEL
                //book = new ExcelQueryFactory(pathArchivoCompleto);

                //ListArchivo = book.Worksheet(nombrePestana).AsEnumerable()
                //                .Select(n => new Archivo
                //                {
                //                    Area = n["Area"].Cast<string>(),
                //                    Departamento = n["Department"].Cast<string>(),
                //                    TipoDocumento = n["Document"].Cast<string>(),
                //                    DepartamentoCodigo = n["Department Code"].Cast<string>(),
                //                    Codigo = n["Archivo"].Cast<string>(),
                //                    NombreDocumento = n["Archivo"].Cast<string>(),
                //                    DescripcionDocumento = n["Name Document"].Cast<string>(),
                //                    NumeroRevision = n["Revision"].Cast<string>(),
                //                    FCambioFijo = n["Date Revision"].Cast<string>(),
                //                    FCambioFrecuente = n["Date Revision"].Cast<string>(),
                //                    SBU = n["SBU"].Cast<string>(),
                //                    Cliente = n["Cliente"].Cast<string>()
                //                }).ToList();

                ////CARGAR CLIENTE
                ////ListArchivo = ListArchivo.Where(n => !string.IsNullOrEmpty(n.DescripcionDocumento)).ToList();

                //ListArchivo = ListArchivo.Where(n => !string.IsNullOrEmpty(n.Area) && n.Area.ToUpper() == "SATELITES").ToList();

                #region CARGAR ORIGEN DESTINO

                /*
                 * //CARGAR ARCHIVOS A SHARE POINT
                 * foreach (Archivo a in ListArchivo.ToList())
                 *  //.Where(n => !string.IsNullOrEmpty(n.Codigo) && n.Codigo.Trim() == "IT-1509").ToList())
                 * {
                 *  if (!string.IsNullOrEmpty(a.Codigo))
                 *  {
                 *      //SE BUSCA EN FORMATO EXCEL
                 *      ///////////////////////////
                 *      urlCompletoOrigen = Path.Combine(HttpUtility.HtmlEncode(urlSharePointOrigen), a.Codigo.Trim()); //+ ".xls");
                 *      urlCompletoFolder = Path.Combine(HttpUtility.HtmlEncode(urlShareFolder), a.Codigo.Trim()); //+ ".xls");
                 *      urlCompletoDestino = Path.Combine(HttpUtility.HtmlEncode(urlSharePointDestino), a.Codigo.Trim()); //+ ".xls");
                 *
                 *      try
                 *      {
                 *          using (WebClient client = new WebClient())
                 *          {
                 *              client.Credentials = new NetworkCredential(usuarioSharePoint, passwordSharePoint);
                 *              client.DownloadFile(urlCompletoOrigen, urlCompletoFolder);
                 *              client.UploadFile(urlCompletoDestino, "PUT", urlCompletoFolder);
                 *
                 *              a.Codigo = a.Codigo.Trim(); //+ ".xls";
                 *
                 *              ListArchivoEncontrado.Add(a);
                 *
                 *              continue;
                 *          }
                 *
                 *          //a.Codigo = a.Codigo.Trim(); //+ ".xls";
                 *
                 *          //ListArchivoEncontrado.Add(a);
                 *      }
                 *      catch (Exception ex)
                 *      {
                 *          continue;
                 *      }
                 *
                 *      ////INTENTO SIN ESPACIOS EN BLANCO
                 *      //urlCompletoOrigen = Path.Combine(HttpUtility.HtmlEncode(urlSharePointOrigen), a.Codigo.Trim().Replace(" ", "") + ".xls");
                 *      //urlCompletoFolder = Path.Combine(HttpUtility.HtmlEncode(urlShareFolder), a.Codigo.Trim().Replace(" ", "") + ".xls");
                 *      //urlCompletoDestino = Path.Combine(HttpUtility.HtmlEncode(urlSharePointDestino), a.Codigo.Trim().Replace(" ", "") + ".xls");
                 *
                 *      //try
                 *      //{
                 *      //    using (WebClient client = new WebClient())
                 *      //    {
                 *      //        client.Credentials = new NetworkCredential(usuarioSharePoint, passwordSharePoint);
                 *      //        client.DownloadFile(urlCompletoOrigen, urlCompletoFolder);
                 *      //        client.UploadFile(urlCompletoDestino, "PUT", urlCompletoFolder);
                 *
                 *      //        a.Codigo = a.Codigo.Trim().Replace(" ", "") + ".xls";
                 *
                 *      //        ListArchivoEncontrado.Add(a);
                 *
                 *      //        continue;
                 *      //    }
                 *      //}
                 *      //catch (Exception ex)
                 *      //{
                 *
                 *      //}
                 *
                 *      ////SE BUSCA EN FORMATO WORD
                 *      ////////////////////////////
                 *      //urlCompletoOrigen = Path.Combine(HttpUtility.HtmlEncode(urlSharePointOrigen), a.Codigo.Trim() + ".doc");
                 *      //urlCompletoFolder = Path.Combine(HttpUtility.HtmlEncode(urlShareFolder), a.Codigo.Trim() + ".doc");
                 *      //urlCompletoDestino = Path.Combine(HttpUtility.HtmlEncode(urlSharePointDestino), a.Codigo.Trim() + ".doc");
                 *
                 *      //try
                 *      //{
                 *      //    using (WebClient client = new WebClient())
                 *      //    {
                 *      //        client.Credentials = new NetworkCredential(usuarioSharePoint, passwordSharePoint);
                 *      //        client.DownloadFile(urlCompletoOrigen, urlCompletoFolder);
                 *      //        client.UploadFile(urlCompletoDestino, "PUT", urlCompletoFolder);
                 *
                 *      //        a.Codigo = a.Codigo.Trim().Replace(" ", "") + ".doc";
                 *
                 *      //        ListArchivoEncontrado.Add(a);
                 *
                 *      //        continue;
                 *      //    }
                 *      //}
                 *      //catch (Exception ex)
                 *      //{
                 *
                 *      //}
                 *
                 *      ////INTENTO SIN ESPACIOS EN BLANCO
                 *      //urlCompletoOrigen = Path.Combine(HttpUtility.HtmlEncode(urlSharePointOrigen), a.Codigo.Trim().Replace(" ", "") + ".doc");
                 *      //urlCompletoFolder = Path.Combine(HttpUtility.HtmlEncode(urlShareFolder), a.Codigo.Trim().Replace(" ", "") + ".doc");
                 *      //urlCompletoDestino = Path.Combine(HttpUtility.HtmlEncode(urlSharePointDestino), a.Codigo.Trim().Replace(" ", "") + ".doc");
                 *
                 *      //try
                 *      //{
                 *      //    using (WebClient client = new WebClient())
                 *      //    {
                 *      //        client.Credentials = new NetworkCredential(usuarioSharePoint, passwordSharePoint);
                 *      //        client.DownloadFile(urlCompletoOrigen, urlCompletoFolder);
                 *      //        client.UploadFile(urlCompletoDestino, "PUT", urlCompletoFolder);
                 *
                 *      //        a.Codigo = a.Codigo.Trim().Replace(" ", "") + ".doc";
                 *
                 *      //        ListArchivoEncontrado.Add(a);
                 *
                 *      //        continue;
                 *      //    }
                 *      //}
                 *      //catch (Exception ex)
                 *      //{
                 *
                 *      //}
                 *
                 *      ////SE BUSCA EN FORMATO PDF
                 *      ///////////////////////////
                 *      //urlCompletoOrigen = Path.Combine(HttpUtility.HtmlEncode(urlSharePointOrigen), a.Codigo.Trim() + ".pdf");
                 *      //urlCompletoFolder = Path.Combine(HttpUtility.HtmlEncode(urlShareFolder), a.Codigo.Trim() + ".pdf");
                 *      //urlCompletoDestino = Path.Combine(HttpUtility.HtmlEncode(urlSharePointDestino), a.Codigo.Trim() + ".pdf");
                 *
                 *      //try
                 *      //{
                 *      //    using (WebClient client = new WebClient())
                 *      //    {
                 *      //        client.Credentials = new NetworkCredential(usuarioSharePoint, passwordSharePoint);
                 *      //        client.DownloadFile(urlCompletoOrigen, urlCompletoFolder);
                 *      //        client.UploadFile(urlCompletoDestino, "PUT", urlCompletoFolder);
                 *
                 *      //        a.Codigo = a.Codigo.Trim() + ".pdf";
                 *
                 *      //        ListArchivoEncontrado.Add(a);
                 *
                 *      //        continue;
                 *      //    }
                 *      //}
                 *      //catch (Exception ex)
                 *      //{
                 *
                 *      //}
                 *
                 *      ////INTENTO SIN ESPACIOS EN BLANCO
                 *      //urlCompletoOrigen = Path.Combine(HttpUtility.HtmlEncode(urlSharePointOrigen), a.Codigo.Trim().Replace(" ", "") + ".pdf");
                 *      //urlCompletoFolder = Path.Combine(HttpUtility.HtmlEncode(urlShareFolder), a.Codigo.Trim().Replace(" ", "") + ".pdf");
                 *      //urlCompletoDestino = Path.Combine(HttpUtility.HtmlEncode(urlSharePointDestino), a.Codigo.Trim().Replace(" ", "") + ".pdf");
                 *
                 *      //try
                 *      //{
                 *      //    using (WebClient client = new WebClient())
                 *      //    {
                 *      //        client.Credentials = new NetworkCredential(usuarioSharePoint, passwordSharePoint);
                 *      //        client.DownloadFile(urlCompletoOrigen, urlCompletoFolder);
                 *      //        client.UploadFile(urlCompletoDestino, "PUT", urlCompletoFolder);
                 *
                 *      //        a.Codigo = a.Codigo.Trim().Replace(" ", "") + ".pdf";
                 *
                 *      //        ListArchivoEncontrado.Add(a);
                 *
                 *      //        continue;
                 *      //    }
                 *      //}
                 *      //catch (Exception ex)
                 *      //{
                 *
                 *      //}
                 *
                 *  }
                 * }
                 *
                 */
                #endregion


                ClientContext clientContext  = new ClientContext(siteUrl);
                SP.Web        myWeb          = clientContext.Web;
                List          myListArchivos = myWeb.Lists.GetByTitle(bibliotecaDocumentoSP);

                ListItemCollection listItems = myListArchivos.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(listItems);
                clientContext.ExecuteQuery();


                #region CREAR ARCHIVO EXCEL

                /////////////////////
                //////CREAR ARCHIVO EXCEL

                //listItems.ToList().ForEach(item =>
                //{
                //    dtArchivoExcel.Rows.Add(item["Area"] == null ? "" : ((FieldLookupValue)item["Area"]).LookupValue,
                //                                    item["Department"] == null ? "" : ((FieldLookupValue)item["Department"]).LookupValue,
                //                                    item["DocType"] == null ? "" : ((FieldLookupValue)item["DocType"]).LookupValue,
                //                                    item["DepartmentCode"] == null ? "" : item["DepartmentCode"].ToString(),
                //                                    item["FileLeafRef"] == null ? "" : item["FileLeafRef"].ToString(),
                //                                    item["Title"] == null ? "" : item["Title"].ToString(),
                //                                    item["Cliente"] == null ? "" : ((FieldLookupValue)item["Cliente"]).LookupValue,
                //                                    item["Revision"] == null ? "" : item["Revision"].ToString(),
                //                                    item["Update"] == null ? "" : item["Update"].ToString(),
                //                                    item["Created"] == null ? "" : item["Created"].ToString(),
                //                                    item["SBU"] == null ? "" : ((FieldLookupValue)item["SBU"]).LookupValue,
                //                                    item["Modified"] == null ? "" : item["Modified"].ToString());
                //});


                //dsArchivoExcel.Tables.Add(dtArchivoExcel);

                //ExcelLibrary.DataSetHelper.CreateWorkbook(pathArchivoExcel, dsArchivoExcel);

                #endregion


                //CATALOGO AREA
                List myListCatalogoArea = myWeb.Lists.GetByTitle(catalogoArea);

                ListItemCollection listCatalogoArea = myListCatalogoArea.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(listCatalogoArea);
                clientContext.ExecuteQuery();

                //CATALOGO DEPARTAMENTE
                List myListCatalogoDepartamento = myWeb.Lists.GetByTitle(catalogoDepartamento);

                ListItemCollection listCatalogoDepartamento = myListCatalogoDepartamento.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(listCatalogoDepartamento);
                clientContext.ExecuteQuery();

                //CATALOGO DOC TYPE
                List myListCatalogoDocType = myWeb.Lists.GetByTitle(catalogoDocType);

                ListItemCollection listCatalogoDocType = myListCatalogoDocType.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(listCatalogoDocType);
                clientContext.ExecuteQuery();

                //CATALOGO SBU
                List myListCatalogoSBU = myWeb.Lists.GetByTitle(catalogoSBU);

                ListItemCollection listCatalogoSBU = myListCatalogoSBU.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(listCatalogoSBU);
                clientContext.ExecuteQuery();

                //CATALOGO CLIENTE
                List myListCatalogoCliente = myWeb.Lists.GetByTitle(catalogoCliente);

                ListItemCollection listCatalogoCliente = myListCatalogoCliente.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(listCatalogoCliente);
                clientContext.ExecuteQuery();

                #region ACTUALIZAR CODIGO ARCHIVO

                long maxId = listItems.Max(n => Convert.ToInt64(((ListItem)n).FieldValues["ID"]));
                long minId = listItems.Min(n => Convert.ToInt64(((ListItem)n).FieldValues["ID"]));

                var uno = listItems.Where(n => ((ListItem)n).FieldValues["DepartmentCode"] != null).ToList();


                string codigoDocumento = string.Empty;
                listItems.ToList().ForEach(n =>
                {
                    var area          = ((ListItem)n).FieldValues["Area"];
                    var departamento  = ((ListItem)n).FieldValues["Department"];
                    var tipoDocumento = ((ListItem)n).FieldValues["DocType"];
                    var id            = ((ListItem)n).FieldValues["ID"];
                    long idc          = 0;

                    idc      = Convert.ToInt64(id) - 6525;
                    n["IDC"] = idc;

                    //n.Update();

                    if (area != null && departamento != null && tipoDocumento != null)
                    {
                        //clientContext.ExecuteQuery();


                        if (Convert.ToInt64(id) >= 1)
                        {
                            codigoDocumento = ((FieldLookupValue)area).LookupValue.ToUpper().Substring(0, 3) + "-" +
                                              ((FieldLookupValue)departamento).LookupValue.ToUpper().Substring(0, 3) + "-" +
                                              ((FieldLookupValue)tipoDocumento).LookupValue.ToUpper().Substring(0, 3) + "-" +
                                              idc.ToString("0000");

                            n["DepartmentCode"] = codigoDocumento;

                            //n.Update();
                        }
                    }

                    n.Update();

                    if (Convert.ToInt64(id) % 100 == 0)
                    {
                        //n.Update();

                        clientContext.ExecuteQuery();
                    }

                    if (listItems.Count == Convert.ToInt64(id))
                    {
                        clientContext.ExecuteQuery();
                    }
                });

                clientContext.ExecuteQuery();


                #endregion

                #region ACTUALIZAR AREA

                //ListItem AreaTot = listCatalogoArea.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains("SATELITES")).ToList().FirstOrDefault();

                //var res = listItems.Where(n => n.FieldValues["Area"] != null && ((FieldLookupValue)n.FieldValues["Area"]).LookupValue.ToUpper().Trim().Contains(AreaTot["Title"].ToString().ToUpper()));


                //foreach (ListItem item in res)
                //{
                //    ListItem Area = listCatalogoArea.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains("LOCALIDADES PPG")).ToList().FirstOrDefault();

                //    if (Area != null)
                //    {
                //        item["Area"] = Area;
                //        item.Update();
                //    }
                //    else
                //    {
                //        //Area = listCatalogoArea.ToList().FirstOrDefault();

                //        //item["Area"] = Area;

                //        continue;
                //    }
                //}

                //clientContext.ExecuteQuery();

                #endregion


                #region ACTUALIZAR DEPARTAMENTO

                //string departamento = "Powder";
                //string departamentoNuevo = "Pintura en Polvo";

                //ListItem DepartamentoTot = listCatalogoDepartamento.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(departamento.ToUpper())).ToList().FirstOrDefault();

                //var resDep = listItems.Where(n => n.FieldValues["Department"] != null && ((FieldLookupValue)n.FieldValues["Department"]).LookupValue.ToUpper().Trim().Contains(DepartamentoTot["Title"].ToString().ToUpper()));


                //foreach (ListItem item in resDep)
                //{
                //    ListItem Departamento = listCatalogoDepartamento.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(departamentoNuevo.ToUpper())).ToList().FirstOrDefault();

                //    if (Departamento != null)
                //    {
                //        item["Department"] = Departamento;
                //        item.Update();
                //    }
                //    else
                //    {
                //        //Area = listCatalogoArea.ToList().FirstOrDefault();

                //        //item["Area"] = Area;

                //        continue;
                //    }
                //}

                //clientContext.ExecuteQuery();

                #endregion

                //CARGAR METADATOS A SHARE POINT
                foreach (Archivo am in ListArchivo.ToList())//.Where(n => !string.IsNullOrEmpty(n.SBU) || !string.IsNullOrEmpty(n.DescripcionDocumento)))
                //foreach (Archivo am in ListArchivoEncontrado.ToList())
                {
                    try
                    {
                        ListItem item = listItems.ToArray().Where(n => ((ListItem)n).FieldValues["FileLeafRef"] != null && ((ListItem)n).FieldValues["FileLeafRef"].ToString() == am.Codigo).ToList().FirstOrDefault();

                        if (item != null)
                        {
                            try
                            {
                                //item.Update();
                                item.File.CheckOut();
                                clientContext.ExecuteQuery();
                            }
                            catch (Exception ex)
                            {
                            }

                            ////item.File.UndoCheckOut();

                            //item["Title"] = am.Codigo;

                            //item["Loop"] = "Si";
                            ////item["SBU"] = string.IsNullOrEmpty(am.SBU) ? "": am.SBU;

                            ////item["DepartmentCode"] = am.DepartamentoCodigo;
                            //////item["Cliente"] = string.IsNullOrEmpty(am.DescripcionDocumento) ? "": am.DescripcionDocumento;

                            //item["Revision"] = am.NumeroRevision;
                            ////item["Area"] = "";
                            ////item["Department"] = "";
                            ////item["DocType"] = "";

                            #region Catalogo Area

                            if (!string.IsNullOrEmpty(am.Area))
                            {
                                //ListItem Area = listCatalogoArea.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(am.Area.ToUpper().Trim())).ToList().FirstOrDefault();

                                ListItem Area = listCatalogoArea.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(am.Area.ToUpper().Trim())).ToList().FirstOrDefault();

                                if (Area != null)
                                {
                                    item["Area"] = Area;
                                }
                                else
                                {
                                    //Area = listCatalogoArea.ToList().FirstOrDefault();

                                    //item["Area"] = Area;

                                    continue;
                                }
                            }
                            else
                            {
                                //ListItem Area = listCatalogoArea.ToList().FirstOrDefault();

                                //item["Area"] = Area;

                                continue;
                            }

                            #endregion

                            //#region Catalogo Departamento

                            //if (!string.IsNullOrEmpty(am.Departamento))
                            //{
                            //    ListItem Departamento = listCatalogoDepartamento.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(am.Departamento.ToUpper().Trim())).ToList().FirstOrDefault();

                            //    if (Departamento != null)
                            //    {
                            //        item["Department"] = Departamento;
                            //    }
                            //    else
                            //    {
                            //        //Departamento = listCatalogoDepartamento.ToList().FirstOrDefault();

                            //        //item["Department"] = Departamento;

                            //        continue;
                            //    }
                            //}
                            //else
                            //{
                            //    //ListItem Departamento = listCatalogoDepartamento.ToList().FirstOrDefault();

                            //    //item["Department"] = Departamento;

                            //    continue;
                            //}

                            //#endregion

                            //#region Catalogo TipoDocumento

                            //if (!string.IsNullOrEmpty(am.TipoDocumento))
                            //{
                            //    ListItem DocType = listCatalogoDocType.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(am.TipoDocumento.ToUpper().Trim())).ToList().FirstOrDefault();

                            //    if (DocType != null)
                            //    {
                            //        item["DocType"] = DocType;
                            //    }
                            //    else
                            //    {
                            //        //DocType = listCatalogoDocType.ToList().FirstOrDefault();

                            //        //item["DocType"] = DocType;

                            //        //continue;

                            //        item["DocType"] = null;
                            //    }
                            //}
                            //else
                            //{
                            //    //ListItem DocType = listCatalogoDocType.ToList().FirstOrDefault();

                            //    //item["DocType"] = DocType;

                            //    item["DocType"] = null;
                            //}

                            //#endregion

                            //#region SBU

                            //if (!string.IsNullOrEmpty(am.SBU))
                            //{
                            //    ListItem SBU = listCatalogoSBU.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(am.SBU.ToUpper().Trim())).ToList().FirstOrDefault();

                            //    if (SBU != null)
                            //    {
                            //        item["SBU"] = SBU;
                            //    }
                            //    else
                            //    {
                            //        item["SBU"] = null;
                            //    }
                            //}
                            //else
                            //{
                            //    item["SBU"] = null;
                            //}

                            //#endregion

                            //#region Catalogo Cliente

                            //if (!string.IsNullOrEmpty(am.Cliente))
                            //{
                            //    ListItem Clientes = listCatalogoCliente.ToArray().Where(n => ((ListItem)n).FieldValues["Title"] != null && ((ListItem)n).FieldValues["Title"].ToString().ToUpper().Trim().Contains(am.Cliente.ToUpper().Trim())).ToList().FirstOrDefault();

                            //    if (Clientes != null)
                            //    {
                            //        item["Cliente"] = Clientes;
                            //    }
                            //    else
                            //    {
                            //        item["Cliente"] = null;
                            //    }
                            //}
                            //else
                            //{
                            //    item["Cliente"] = null;
                            //}

                            //#endregion

                            //ACTUALIZAR INFORMACION DE METADATOS
                            //item.File.UndoCheckOut();
                            item.Update();
                            //clientContext.ExecuteQuery();

                            //REALIZAR CHECKOUT PARA TOMAR LOS ARCHIVOS
                            //item.File.CheckOut();
                            //clientContext.ExecuteQuery();

                            //REALIZAR CHECKIN DE LOS ARCHIVOS
                            item.File.CheckIn("", CheckinType.OverwriteCheckIn);
                            clientContext.ExecuteQuery();

                            dtArchivoExcel.Rows.Add(string.IsNullOrEmpty(am.Area) ? " ": am.Area,
                                                    string.IsNullOrEmpty(am.Departamento) ? " ": am.Departamento,
                                                    string.IsNullOrEmpty(am.TipoDocumento) ? " ": am.TipoDocumento,
                                                    string.IsNullOrEmpty(am.DepartamentoCodigo) ? " " : am.DepartamentoCodigo,
                                                    string.IsNullOrEmpty(am.Codigo) ? " ": am.Codigo,
                                                    string.IsNullOrEmpty(am.NombreDocumento) ? " ": am.NombreDocumento,
                                                    string.IsNullOrEmpty(am.DescripcionDocumento) ? " " : am.DescripcionDocumento,
                                                    string.IsNullOrEmpty(am.NumeroRevision) ? " ": am.NumeroRevision,
                                                    string.IsNullOrEmpty(am.FCambioFijo) ? " ": am.FCambioFijo,
                                                    string.IsNullOrEmpty(am.FCambioFrecuente) ? " ": am.FCambioFrecuente,
                                                    string.IsNullOrEmpty(am.SBU) ? " " : am.SBU,
                                                    string.IsNullOrEmpty(am.Cliente) ? " " : am.Cliente);

                            //if(dtArchivoExcel.Rows.Count % 200 == 0)
                            //{
                            //clientContext.ExecuteQuery();
                            //}
                        }
                    }
                    catch (Exception ex)
                    {
                    }
                }

                //clientContext.ExecuteQuery();


                //CREAR ARCHIVO EXCEL

                dsArchivoExcel.Tables.Add(dtArchivoExcel);

                ExcelLibrary.DataSetHelper.CreateWorkbook(pathArchivoExcel, dsArchivoExcel);

                ////EXPORTAR CATALOGOS
                ////AREA
                //dtArea.Columns.Add("Title");
                //dtArea.Columns.Add("Code");
                //foreach(ListItem item in listCatalogoArea)
                //{
                //    dtArea.Rows.Add(item["Title"], item["Code"]);
                //}

                ////DEPARTAMENTO
                //dtDepartamento.Columns.Add("Title");
                //dtDepartamento.Columns.Add("Area");
                //dtDepartamento.Columns.Add("Code");
                //foreach (ListItem item in listCatalogoDepartamento)
                //{
                //    dtDepartamento.Rows.Add(item["Title"], ((FieldLookupValue)item["Area"]).LookupValue, item["b8ph"]);
                //}
                ////DOC TYPE
                //dtDocType.Columns.Add("Title");
                //foreach (ListItem item in listCatalogoDocType)
                //{
                //    dtDocType.Rows.Add(item["Title"]);
                //}

                //dsCatalogos.Tables.Add(dtArea);
                //dsCatalogos.Tables.Add(dtDepartamento);
                //dsCatalogos.Tables.Add(dtDocType);

                //ExcelLibrary.DataSetHelper.CreateWorkbook(pathArchivoExcel, dsCatalogos);
            }
            catch (Exception ex)
            {
                Console.WriteLine("Mensaje: " + ex.Message + ", Source: " + ex.Source + ", StackTrace: " + ex.StackTrace);
            }
        }
Exemplo n.º 13
0
        private static void CreatePublishingPage2013(ClientContext ctx, Web web, XElement xPage)
        {
            Web webSite = web;

            ctx.Load(webSite);

            PublishingWeb pubWeb = PublishingWeb.GetPublishingWeb(ctx, webSite);

            ctx.Load(pubWeb);

            string pageName       = xPage.Attribute("Name").Value;
            string layoutPageName = xPage.Attribute("LayoutPageName").Value;
            string pageLibrary    = xPage.Attribute("PageLibrary").Value;

            if (pubWeb != null)
            {
                // Get library to hold new page

                List targetLibrary = webSite.Lists.GetByTitle(pageLibrary);

                ListItemCollection existingPages = targetLibrary.GetItems(CamlQuery.CreateAllItemsQuery());

                ctx.Load(existingPages, items => items.Include(item => item.DisplayName).Where(obj => obj.DisplayName == pageName));
                ctx.ExecuteQuery();

                if (existingPages != null && existingPages.Count > 0)
                {
                    // Page already exists
                }
                else
                {
                    // Get publishing page layouts

                    List publishingLayouts = ctx.Web.Lists.GetByTitle("Master Page Gallery");

                    ListItemCollection layoutPages = publishingLayouts.GetItems(CamlQuery.CreateAllItemsQuery());
                    ctx.Load(layoutPages, items => items.Include(item => item.DisplayName).Where(obj => obj.DisplayName == layoutPageName));
                    ctx.ExecuteQuery();

                    ListItem layoutPage = layoutPages.Where(x => x.DisplayName == layoutPageName).FirstOrDefault();
                    ctx.Load(layoutPage);

                    // Create a publishing page

                    PublishingPageInformation newPublishingPageInfo = new PublishingPageInformation();
                    newPublishingPageInfo.Name = pageName;
                    newPublishingPageInfo.PageLayoutListItem = layoutPage;

                    PublishingPage newPublishingPage = pubWeb.AddPublishingPage(newPublishingPageInfo);

                    newPublishingPage.ListItem.File.CheckIn(string.Empty, CheckinType.MajorCheckIn);
                    newPublishingPage.ListItem.File.Publish(string.Empty);
                    newPublishingPage.ListItem.File.Approve(string.Empty);

                    ctx.Load(newPublishingPage);
                    ctx.Load(newPublishingPage.ListItem.File, obj => obj.ServerRelativeUrl);

                    ctx.ExecuteQuery();
                }
            }
        }
        static void Main(string[] args)
        {
            Console.WriteLine("Please Enter Site Address: ");
            string siteUrl      = Console.ReadLine();
            bool   siteOnline   = false;
            string siteUser     = "";
            string sitePassword = "";
            string siteDomain   = "";

            if (siteUrl.Contains(".sharepoint.com"))
            {
                Console.WriteLine("This site is SharePoint Online Right ? (Y/N): ");
                string OnlineAnswer = Console.ReadLine();

                if (OnlineAnswer.ToUpper() == "Y")
                {
                    siteOnline = true;
                }
            }

            if (siteOnline)
            {
                Console.WriteLine("Please Enter Site Login User Email Address: ");
                siteUser = Console.ReadLine();

                Console.WriteLine("Please Enter Site Login User Password: "******"Please Enter Site Login User Domain Name: ");
                siteDomain = Console.ReadLine();

                Console.WriteLine("Please Enter Site Login User Name: ");
                siteUser = Console.ReadLine();

                Console.WriteLine("Please Enter Site Login User Password: "******"Please Enter Master Page Gallery Name: ");
            string siteMasterPageGallery = Console.ReadLine();

            Console.WriteLine("Please Enter Create Publishing Page Content Type Display Name: ");
            string pageContentType = Console.ReadLine();

            Console.WriteLine("Please Enter Create Publishing Page Name: ");
            string pageName = Console.ReadLine();

            Console.WriteLine("Do You Have Add Page Field Value (Y/N): ");
            string addPageValuAnswer  = Console.ReadLine();
            bool   addPageValue       = false;
            string addPageValueString = "";

            if (addPageValuAnswer.ToUpper() == "Y")
            {
                addPageValue = true;
                Console.WriteLine("Please Enter Page Field Data ( ':' Separator Using For Field Name And Value, ';' Separator Using For Each Field Data ): ");
                Console.WriteLine("For Example ---> Title:TestPage;Comments:TestPage Comments ");
                Console.WriteLine("");
                addPageValueString = Console.ReadLine();
            }

            Console.WriteLine("Please Wait Start Create Process....");

            ClientContext  clientContext  = null;
            PublishingPage publishingPage = null;
            Web            web            = null;

            try
            {
                clientContext = new ClientContext(siteUrl);

                if (siteOnline)
                {
                    clientContext.AuthenticationMode = ClientAuthenticationMode.Default;

                    string password = sitePassword;
                    System.Security.SecureString passwordChar = new System.Security.SecureString();
                    foreach (char ch in password)
                    {
                        passwordChar.AppendChar(ch);
                    }

                    clientContext.Credentials = new SharePointOnlineCredentials(siteUser, passwordChar);
                }
                else
                {
                    clientContext.Credentials = new NetworkCredential(siteUser, sitePassword, siteDomain);
                }

                web = clientContext.Web;
                clientContext.Load(web);
                clientContext.ExecuteQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine("This Site Connect Error Please Check Your Information And Try Again");
                Console.WriteLine("Error Message: " + ex.Message);
                Console.ReadLine();
                Environment.Exit(0);
            }

            try
            {
                Console.WriteLine("This Site Connection Success....");
                Console.WriteLine("Please Wait Create Publishing Page.....");

                List publishingLayouts      = clientContext.Site.RootWeb.Lists.GetByTitle(siteMasterPageGallery);
                ListItemCollection allItems = publishingLayouts.GetItems(CamlQuery.CreateAllItemsQuery());
                clientContext.Load(allItems, items => items.Include(item => item.DisplayName).Where(obj => obj.DisplayName == pageContentType));
                clientContext.ExecuteQuery();
                ListItem layout = allItems.Where(x => x.DisplayName == pageContentType).FirstOrDefault();
                clientContext.Load(layout);

                PublishingWeb publishingWeb = PublishingWeb.GetPublishingWeb(clientContext, web);
                clientContext.Load(publishingWeb);

                PublishingPageInformation publishingPageInfo = new PublishingPageInformation();
                publishingPageInfo.Name = pageName.Contains(".aspx") ? pageName : pageName + ".aspx";
                publishingPageInfo.PageLayoutListItem = layout;

                publishingPage = publishingWeb.AddPublishingPage(publishingPageInfo);

                clientContext.Load(publishingPage);
                clientContext.Load(publishingPage.ListItem.File);
                clientContext.ExecuteQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine("This During Publishing Page Error Please Check Your Information And Try Again");
                Console.WriteLine("Error Message: " + ex.Message);
                Console.ReadLine();
                Environment.Exit(0);
            }

            Console.WriteLine("this Publishing Page Create Success....");

            if (addPageValue)
            {
                try
                {
                    Console.WriteLine("Please Wait Add Field Data Publishing Page....");

                    ListItem listItem = publishingPage.ListItem;

                    string[] dataArray = addPageValueString.Split(';');

                    foreach (string data in dataArray)
                    {
                        listItem[data.Split(':')[0]] = data.Split(':')[1];
                    }

                    listItem.Update();

                    publishingPage.ListItem.File.CheckIn(string.Empty, CheckinType.MajorCheckIn);
                    publishingPage.ListItem.File.Publish(string.Empty);

                    clientContext.Load(publishingPage);

                    clientContext.ExecuteQuery();

                    Console.WriteLine("Tihs Publishing Page Add Field Data Success....");
                }
                catch (Exception ex)
                {
                    Console.WriteLine("This During Publishing Page Add Field Data Error Please Check Your Information And Try Again");
                    Console.WriteLine("Error Message: " + ex.Message);
                    Console.ReadLine();
                    Environment.Exit(0);
                }
            }

            Console.WriteLine("All Process Complete Success...");
            Console.ReadLine();
            Environment.Exit(0);
        }
Exemplo n.º 15
0
 public static IQueryable <ListItem> QueryByFlexibleListItemId(this ListItemCollection collection, int id)
 {
     return(collection.Where(component => component.Id == id)
            .IncludeWithDefaultProperties(component => component.ContentType));
 }
        static public void ChangeInvoiceStatusToInvoiced(string baseUrl, string subWebsite, string user, string password, string listName, string barcode)
        {
            try
            {
                string[] parts = user.Split('\\');

                using (ClientContext clientContext = new ClientContext(baseUrl + subWebsite))
                {
                    clientContext.Credentials = new NetworkCredential(parts[1], password, parts[0]);

                    Web site = clientContext.Web;

                    List list = site.Lists.GetByTitle(listName);

                    CamlQuery query = new CamlQuery()
                    {
                        ViewXml = "<View Scope=\"RecursiveAll\">" +
                                  "<Query>" +
                                  "<Where>" +
                                  "<And>" +
                                  "<Eq>" +
                                  "<FieldRef Name=\"IFUInvoiceStatus\"/>" +
                                  "<Value Type=\"Text\">" + "Frei zur Zahlung" + "</Value>" +
                                  "</Eq>" +
                                  "<Eq>" +
                                  "<FieldRef Name=\"IFUInvoiceBarcode\"/>" +
                                  "<Value Type=\"Text\">" + barcode + "</Value>" +
                                  "</Eq>" +
                                  "</And>" +
                                  "</Where>" +
                                  "</Query>" +
                                  "</View>"
                    };

                    ListItemCollection itemColl = list.GetItems(query);

                    clientContext.Load(itemColl);
                    clientContext.ExecuteQuery();

                    ListItem item = itemColl.Where(li => (li.FieldValues["IFUInvoiceBarcode"].ToString()) == barcode).First();

                    /* foreach (ListItem li in itemColl) {
                     *   clientContext.Load(li);
                     *   clientContext.ExecuteQuery();
                     *   if (li.FieldValues["IFUInvoiceBarcode"] != null) {
                     *       if (li.FieldValues["IFUInvoiceBarcode"].ToString() == barcode) {
                     *           item = li;
                     *           break;
                     *       }
                     *   }
                     * }*/

                    if (item != null)
                    {
                        clientContext.Load(item);
                        clientContext.ExecuteQuery();

                        item["IFUInvoiceStatus"] = "Fakturiert";
                        item.Update();

                        clientContext.ExecuteQuery();
                    }
                    else
                    {
                        logger.Error("Invoice was not found: " + barcode);
                    }
                }
            }
            catch (Exception ex)
            {
                logger.Error(ex.Message);
                logger.Debug(ex.StackTrace);
            }
        }