<script type="text/javascript" src="/Scripts/jquery-1.8.1.min.js"></script>
<script type="text/javascript">
var strProject = "";
var strProjectStatus = "";
function PreSaveItem()
{
strProject = document.getElementById('ctl00_m_g_f2d95e24_befb_49d2_b15f_823d71c9c758_ctl00_ctl04_ctl00_ctl00_ctl00_ctl04_ctl00_ctl00_TextField').value;
strProjectStatus = document.getElementById('ctl00_m_g_f2d95e24_befb_49d2_b15f_823d71c9c758_ctl00_ctl04_ctl01_ctl00_ctl00_ctl04_ctl00_DropDownChoice').value;
GetProjectID();
return true;
}
function GetProjectID(){
var soapEnv = "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \
<soap:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>Teams</listName> \
<query><Query><Where><Eq><FieldRef Name='Project'/><Value Type='Text'>"+ strProject +"</Value> </Eq></Where></Query></query> \
<viewFields> \
<ViewFields> \
<FieldRef Name='ID' /> \
<FieldRef Name='Title' /> \
</ViewFields> \
</viewFields> \
<rowLimit>99999</rowLimit> \
<queryOptions xmlns:SOAPSDK9='http://schemas.microsoft.com/sharepoint/soap/' ><QueryOptions/> \
</queryOptions> \
</GetListItems> \
</soap:Body> \
</soap:Envelope>";
jQuery.ajax({
url: "/itsglobal/_vti_bin/lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
complete: ResultMethod,
contentType: "text/xml; charset=\"utf-8\""
});
}
function ResultMethod(xData, status)
{
if (status=="success")
{
var oldbatch = "";
$(xData.responseXML).find("z\\:row").each(function()
{
oldbatch = AddTobatch(oldbatch, $(this).attr("ows_ID"));
});
UpdateTeamItem(oldbatch);
}
}
function AddTobatch(oldbatch, itemId)
{
//Specify the batch query
var _batch = "<Method ID='1' Cmd='Update'><Field Name='ID'>" + itemId +"</Field><Field Name='ProjectStatus'>"+ strProjectStatus +"</Field></Method>";
oldbatch = oldbatch + _batch;
return oldbatch;
}
function UpdateTeamItem(batch)
{
var soapEnv = "<?xml version=\'1.0\' encoding=\'utf-8\'?> \
<soap:Envelope xmlns:xsi=\'http://www.w3.org/2001/XMLSchema-instance\' \
xmlns:xsd=\'http://www.w3.org/2001/XMLSchema\' \
xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/\'> \
<soap:Body> \
<UpdateListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>Teams</listName> \
<updates> \
<Batch OnError='Continue'>" + batch + "</Batch> \
</updates> \
</UpdateListItems> \
</soap:Body> \
</soap:Envelope>";
$.ajax({
url: "/itsglobal/_vti_bin/lists.asmx",
beforeSend: function(xhr) { xhr.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
},
type: "POST",
dataType: "xml",
data: soapEnv,
complete: updateResult,
contentType: "text/xml; charset=\"utf-8\""
});
}
function updateResult(xData, status) {
if (status != 'success' )
alert("Update Project Status in Teams library failed");
}
</script>
<script type="text/javascript" src="/Scripts/jquery-1.8.1.min.js"></script>
<script type="text/javascript">
//This function will call when OK button will be pressed on a List's default form (e.g. EditItem.aspx).
function PreSaveItem()
{
var project = "Project A";
GetProjectID(project);
return true;
}
function GetProjectID(project){
var soapEnv = "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \
<soap:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>Teams</listName> \
<query><Query><Where><Eq><FieldRef Name='Project'/><Value Type='Text'>"+ project +"</Value> </Eq></Where></Query></query> \
<viewFields> \
<ViewFields> \
<FieldRef Name='ID' /> \
<FieldRef Name='Title' /> \
</ViewFields> \
</viewFields> \
<rowLimit>99999</rowLimit> \
<queryOptions xmlns:SOAPSDK9='http://schemas.microsoft.com/sharepoint/soap/' ><QueryOptions/> \
</queryOptions> \
</GetListItems> \
</soap:Body> \
</soap:Envelope>";
jQuery.ajax({
url: "/itsglobal/_vti_bin/lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
complete: ResultMethod,
contentType: "text/xml; charset=\"utf-8\""
});
}
function ResultMethod(xData, status)
{
if (status=="success")
{
alert(status);
$(xData.responseXML).find("z\\:row").each(function()
{
alert($(this).attr("ows_ID"));
});
}
}
</script>
<script src="/Scripts/jquery-1.8.0.min.js" type="text/javascript"></script>
<script type="text/javascript">
function LoadFeed()
{
var varFeedURL = new Array();
varFeedURL[0] = "http://feeds.bbci.co.uk/news/business/rss.xml";
varFeedURL[1] = "http://www.ft.com/rss/home/uk";
varFeedURL[2] = "http://www.ft.com/rss/home/us";
for (i = 0; i < varFeedURL.length; i++)
{
$.get(varFeedURL[i], function(data) {
var $xml = $(data);
$xml.find("item").each(function() {
var $this = $(this),
item = {
title: $this.find("title").text(),
link: $this.find("link").text(),
description: $this.find("description").text(),
pubDate: $this.find("pubDate").text()
}
//Show only Today's Items
var a = new Date(item.pubDate);
var b = new Date(); //Today's Date
var msDateA = Date.UTC(a.getFullYear(), a.getMonth()+1, a.getDate());
var msDateB = Date.UTC(b.getFullYear(), b.getMonth()+1, b.getDate());
if (parseFloat(msDateA) == parseFloat(msDateB))
{
var content = document.getElementById('content');
content.appendChild(document.createTextNode(item.title));
content.appendChild(document.createElement('br'));
content.appendChild(document.createTextNode(item.description));
content.appendChild(document.createElement('br'));
content.appendChild(document.createTextNode(item.link));
content.appendChild(document.createElement('br'));
content.appendChild(document.createElement('hr'));
CreateNewItem(item.title, item.description, item.link);
}
});
});
}
alert('Done');
}
function CreateNewItem(varTitle, varDescription, varLink)
{
var batch =
"<Batch OnError=\"Continue\"> \
<Method ID=\"1\" Cmd=\"New\"> \
<Field Name=\"Title\">" + varTitle + "</Field> \
<Field Name=\"Description\">" + varDescription + "</Field> \
<Field Name=\"Link\">" + varLink + "</Field> \
</Method> \
</Batch>";
var soapEnv =
"<?xml version=\"1.0\" encoding=\"utf-8\"?> \
<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" \
xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" \
xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"> \
<soap:Body> \
<UpdateListItems xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\"> \
<listName>RSSData</listName> \
<updates> \
" + batch + "</updates> \
</UpdateListItems> \
</soap:Body> \
</soap:Envelope>";
$.ajax({
url: "http://portalstg.amr.kworld.kpmg.com/_vti_bin/lists.asmx",
beforeSend: function(xhr) {
xhr.setRequestHeader("SOAPAction",
"http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
},
type: "POST",
dataType: "xml",
data: soapEnv,
complete: processResult,
contentType: "text/xml; charset=utf-8"
});
}
function processResult(xData, status) {
//alert(status);
}
</script>
<input id="btnGo" onclick="LoadFeed()" type="button" value="Get RSS Data" />
<script type="text/javascript">
function Redirect()
{
window.location = "http://SharePoint2010:1000/Pages/Search.aspx?q=" + document.getElementById('Text1').value;
}
</script>
<input name="Text1" type="text">
<button name="Abutton1" onclick="Redirect();">button</button>
public class SharePointManagement
{
ViewsService.Views objViewsService = new SPViewsService.ViewsService.Views();
ListsService.Lists objListsService = new SPViewsService.ListsService.Lists();
string strSiteURL = "http://mySharepointServer:1100";
string strUserName = "username";
string strDomain = "us";
string strPassword = "password";
string strListName = "Announcements";
string strQuery = "";
string strViewFields = "";
string strQueryOptions = "";
ArrayList lstViewID = new ArrayList();
public void GetViewQuery(string strListName)
{
try
{
#region Source URL
//get the lists for the Source URL
this.objViewsService.Url = this.strSiteURL.Trim('/') + "/_vti_bin/views.asmx";
//get the domain
if (this.strUserName.IndexOf("\\") > 0)
{
this.strDomain = this.strUserName.Split("\\".ToCharArray())[0];
this.strUserName = this.strUserName.Split("\\".ToCharArray())[1];
}
this.objViewsService.Credentials = new System.Net.NetworkCredential(this.strUserName, this.strPassword, this.strDomain);
#endregion
System.Xml.XmlNode xnAllView = this.objViewsService.GetViewCollection(strListName);
foreach (System.Xml.XmlNode node in xnAllView)
{
if (node.Name == "View")
{
this.lstViewID.Add(node.Attributes["Name"].Value);
}
}
//Get the First View
System.Xml.XmlNode xnViewData = this.objViewsService.GetView(this.strListName, lstViewID[0].ToString());
foreach (System.Xml.XmlNode node in xnViewData)
{
if (node.Name == "Query")
{
this.strQuery = node.InnerXml;
}
if (node.Name == "ViewFields")
{
this.strViewFields = node.InnerXml;
}
}
}
catch (System.Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
public void GetViewData()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
#region Source URL
//get the lists for the Source URL
this.objListsService.Url = this.strSiteURL.Trim('/') + "/_vti_bin/lists.asmx";
//get the domain
if (this.strUserName.IndexOf("\\") > 0)
{
this.strDomain = this.strUserName.Split("\\".ToCharArray())[0];
this.strUserName = this.strUserName.Split("\\".ToCharArray())[1];
}
this.objListsService.Credentials = new System.Net.NetworkCredential(this.strUserName, this.strPassword, this.strDomain);
#endregion
//get the Data from the List
System.Xml.XmlDocument xdListData = new System.Xml.XmlDocument();
System.Xml.XmlNode xnQuery = xdListData.CreateElement("Query");
System.Xml.XmlNode xnViewFields = xdListData.CreateElement("ViewFields");
System.Xml.XmlNode xnQueryOptions = xdListData.CreateElement("QueryOptions");
//*Use CAML query*/
xnQuery.InnerXml = this.strQuery;
xnViewFields.InnerXml = this.strViewFields;
xnQueryOptions.InnerXml = this.strQueryOptions;
System.Xml.XmlNode xnListData = this.objListsService.GetListItems(this.strListName, null, xnQuery, xnViewFields, null, xnQueryOptions, null);
StringReader sr = new StringReader(xnListData.OuterXml.Replace("ows_", ""));
ds.ReadXml(sr);
return dt;
}
catch (System.Exception exp)
{
MessageBox.Show(exp.ToString());
return dt;
}
}
}
using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Xml;
using System.IO;
namespace ELLP_Content
{
class Program
{
static void Main(string[] args)
{
SharePointManagement objSPManagement = new SharePointManagement();
objSPManagement.GetListContent();
}
}
public class SharePointManagement
{
MOSSListsService.Lists objListService = new ELLP_Content.MOSSListsService.Lists();
public void GetListContent()
{
try
{
string strSiteURL = ConfigurationSettings.AppSettings["SiteURL"];
string strUserName = ConfigurationSettings.AppSettings["Login"];
string strDomain = string.Empty;
string strPassword = ConfigurationSettings.AppSettings["Password"];
string strListName = ConfigurationSettings.AppSettings["List"];
#region Source URL
//get the lists for the Source URL
objListService.Url = strSiteURL.Trim('/') + "/_vti_bin/lists.asmx";
//get the domain
if (strUserName.IndexOf("\\") > 0)
{
strDomain = strUserName.Split("\\".ToCharArray())[0];
strUserName = strUserName.Split("\\".ToCharArray())[1];
}
objListService.Credentials = new System.Net.NetworkCredential(strUserName, strPassword, strDomain);
#endregion
//get the Data from the List
System.Xml.XmlDocument xdListData = new System.Xml.XmlDocument();
System.Xml.XmlNode xnQuery = xdListData.CreateElement("Query");
System.Xml.XmlNode xnViewFields = xdListData.CreateElement("ViewFields");
System.Xml.XmlNode xnQueryOptions = xdListData.CreateElement("QueryOptions");
//*Use CAML query*/
xnQuery.InnerXml = "<Where><Neq><FieldRef Name=\"Exclude_x0020_From_x0020_Country\" /><Value Type=\"Boolean\">0</Value></Neq></Where>";
xnQueryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns><DateInUtc>TRUE</DateInUtc>";
System.Xml.XmlNode xnListData = objListService.GetListItems(strListName, null, xnQuery, xnViewFields, null, xnQueryOptions, null);
foreach (System.Xml.XmlNode node in xnListData)
{
if (node.Name == "rs:data")
{
for (int i = 0; i < node.ChildNodes.Count; i++)
{
if (node.ChildNodes[i].Name == "z:row")
{
Console.WriteLine(node.ChildNodes[i].Attributes["ows_Title"].Value);
}
}
}
}
Console.ReadKey();
}
catch (System.Web.Services.Protocols.SoapException ex)
{
this.WriteLog("Message:\n" + ex.Message + "\nDetail:\n" + ex.Detail.InnerText + "\nStackTrace:\n" + ex.StackTrace);
}
}
private void WriteLog(string strLine)
{
string FilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationSettings.AppSettings["InputLog"]);
StreamWriter objFile;
if (!File.Exists(FilePath))
{
objFile = new StreamWriter(FilePath);
}
else
{
objFile = File.AppendText(FilePath);
}
objFile.WriteLine(DateTime.Now + "\\t" + strLine);
objFile.WriteLine();
objFile.Close();
}
}
}
//Class Level Variables
//You need to add the web reference to the project
public static string strVersionWebServiceURL;
WSLists.Lists _listService;
WSVersion.Versions _versionService;
// Actual Function
private void btnGetListCollection_Click(object sender, EventArgs e)
{
// List and Version web service declaration and initialization
strListWebServiceURL = txtSiteURL.Text + "/_vti_bin/lists.asmx";
strVersionWebServiceURL = txtSiteURL.Text + "/_vti_bin/versions.asmx";
System.Net.NetworkCredential nt = new System.Net.NetworkCredential(txtUserName.Text, txtPassword.Text);
_listService = new WSLists.Lists();
_listService.Credentials = nt;
_listService.Url = strListWebServiceURL;
_versionService = new WSVersion.Versions();
_versionService.Credentials = nt;
_versionService.Url = strVersionWebServiceURL;
// end declaration
if (txtSiteURL.Text != string.Empty && txtUserName.Text != string.Empty && txtPassword.Text != string.Empty)
{
lsListCollection.Items.Clear();
XmlNode _xmlListCollection = _listService.GetListCollection();
for (int i = 0; i < _xmlListCollection.ChildNodes.Count; i++)
{
string strListName = _xmlListCollection.ChildNodes[i].Attributes["Title"].Value.ToLower();
lsListCollection.Items.Add(strListName);
}// End For Loop
}
else
{
MessageBox.Show("Site URL, User Name and Password must be entered");
}
}
private void btnDeleteAllVersionofList_Click(object sender, EventArgs e)
{
string strndQuery = "<OrderBy><FieldRef Name=\"Modified\" Ascending=\"FALSE\" /></OrderBy>";
/*string strndQuery = "<Where><Eq><FieldRef Name='ID' /><Value Type='Integer'>" + "76" + "</Value></Eq></Where>" +
"<OrderBy><FieldRef Name=\"Modified\" Ascending=\"FALSE\" /></OrderBy>";
**/
XmlNodeList _nodelist = GetListItems(strndQuery);
if (_nodelist != null)
{
for (int i = 0; i < _nodelist.Count; i++)
{
try
{
XmlNode _node = _nodelist[i];
string strItemURL = _node.Attributes["ows_EncodedAbsUrl"].Value;
// MessageBox.Show(strItemURL);
XmlNode xmlVersionCollection = _versionService.DeleteAllVersions(strItemURL);
}
catch {}
}
MessageBox.Show("Done!!!");
}
}
private XmlNodeList GetListItems(string strndQuery)
{
XmlNodeList _nodelist = null;
string strListName = lsListCollection.SelectedItem.ToString();
XmlDocument xmlDoc = new XmlDocument();
XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", "");
XmlNode ndViewFields =
xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", "");
XmlNode ndQueryOptions =
xmlDoc.CreateNode(XmlNodeType.Element, "QueryOptions", "");
ndQueryOptions.InnerXml =
"<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" +
"<DateInUtc>TRUE</DateInUtc>" + "<ViewAttributes Scope='Recursive'/>";
ndQuery.InnerXml = strndQuery;
//add view fields to fix
ndViewFields.InnerXml =
"<FieldRef Name='Title' />" +
"<FieldRef Name='Abstract' />" +
"<FieldRef Name='ContentURL' />" +
"<FieldRef Name='LinkFilename' />" +
"<FieldRef Name='Last_x0020_Modified' />" +
"<FieldRef Name='DocIcon' />" +
"<FieldRef Name='DaysNew' />" +
"<FieldRef Name='RiskManagementLevel' />" +
"<FieldRef Name='File_x0020_Size' />" +
"<FieldRef Name='CategoryFilter_x002F_USDocumentType' />" +
"<FieldRef Name='ID' />" +
"<FieldRef Name='MediaType' />" +
"<FieldRef Name='EncodedAbsUrl' />" +
"<FieldRef Name='USPrimaryServiceLine_x002F_USPrimarySubService' />" +
"<FieldRef Name='USSecondaryServiceLine_x002F_USSecondarySubService' />" +
"<FieldRef Name='USIndustry_x002F_USSector' />" +
"<FieldRef Name='USServiceLine_x002F_ServiceOffering' /><FieldRef Name='ServerUrl' /><FieldRef Name='Modified' />";
try
{
XmlDocument _xmlDocument = new XmlDocument();
XmlNamespaceManager _xmlNameSpaceMngr = new XmlNamespaceManager(_xmlDocument.NameTable);
_xmlNameSpaceMngr.AddNamespace("rs", "urn:schemas-microsoft-com:rowset");
_xmlNameSpaceMngr.AddNamespace("z", "#RowsetSchema");
XmlNode ndListItems = null;
ndListItems =
_listService.GetListItems(strListName, null, ndQuery,
ndViewFields, "2500", ndQueryOptions, null);
_nodelist = ndListItems.SelectNodes("/rs:data/z:row", _xmlNameSpaceMngr);
}
catch
{
}
return _nodelist;
}
