Thursday 4 October 2012

Remove elements from a XML file



private static XDocument GetFilteredData(XDocument resultXML)
{
 //Remove elements of xpath item/title
 //that doesn't contains the title value as 'genome'
 resultXML.Descendants("item").Descendants("title").Where(x => !(x.Value.ToLower().Contains("genome"))).Select(tit => tit.Parent).Remove();

 return resultXML;
}


Merge XML files as one


private static XDocument MergeXMLDocs()
{
 XDocument resultXML = new XDocument();

 resultXML = XDocument.Load("RSSLink(XML data)");

 IEnumerable<XElement> newElements = XDocument.Load("New RSS Link(XML data)").Root.Elements();

 resultXML.Root.Add(newElements);

 return resultXML;
}

Add List Item in SharePoint



SPSecurity.RunWithElevatedPrivileges(delegate()
{
 using (SPSite site = new SPSite("http://mySite:4444/site1"))
 {
  using (SPWeb web = site.OpenWeb())
  {
   web.AllowUnsafeUpdates = true;

   SPList list = web.Lists.TryGetList("Tasks");

   if (list != null)
   {
    //Creates the structure
    SPListItem newListItem = list.Items.Add();

    //Check whether the column is in sharepoint list.
    if(newListItem.Fields.ContainsField("Title"))
     newListItem["Title"] = "Aditya";
    
    if (newListItem.Fields.ContainsField("Last Name"))
     newListItem["Last Name"] = "Reddy";

    if (newListItem.Fields.ContainsField("Employee ID"))
     newListItem["Employee ID"] = "34";

    //Updates the changes in content database
    newListItem.Update();
   }
  web.AllowUnsafeUpdates = false;
  }
 }
});