Sithik Blog's: February 2015

Saturday 14 February 2015

Add item to sharepoint apps using napa office 365 clientWebPart

1.Create a Custom List Name as "Emp" and Create a below Column Name

2.Paste the below code in ClientWebpart.aspx

<%-- The following 4 lines are ASP.NET directives needed when using SharePoint components --%>
<%@ Page Inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" language="C#" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>


<WebPartPages:AllowFraming runat="server" />

<html>
<head>

<script type="text/javascript" src="../Scripts/jquery-1.9.1.min.js"></script>
<script type="text/javascript" src="/_layouts/15/MicrosoftAjax.js"></script>
<script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script>
<script type="text/javascript" src="/_layouts/15/sp.js"></script>


<link rel="Stylesheet" type="text/css" href="../Content/App.css" />

<script type="text/javascript">
'use strict';

// Set the style of the client web part page to be consistent with the host web
(function () {
var hostUrl = '';
if (document.URL.indexOf('?') != -1) {
var params = document.URL.split('?')[1].split('&');
for (var i = 0; i < params.length; i++) {
var p = decodeURIComponent(params[i]);
if (/^SPHostUrl=/i.test(p)) {
hostUrl = p.split('=')[1];
document.write('<link rel="stylesheet" href="' + hostUrl + '/_layouts/15/defaultcss.ashx" />');
break;
}
}
}
if (hostUrl == '') {
document.write('<link rel="stylesheet" href="/_layouts/15/1033/styles/themable/corev15.css" />');
}
})();
</script>
</head>

<body>

<table align="center">
<tr>
<td>
<label>First Name</label>
</td>
<td>
<input id="firstname" type="text" />
</td>
</tr>
<tr>
<td>
<label>Last Name</label>
</td>
<td>
<input class="lastname type="text" />
</td>
</tr>
<tr>
<td>
<label>Location</label>
</td>
<td>
<input class="Location type="text" />
</td>
</tr>
<tr>
<td>
<input type="button" value="Save" onclick="SetEmpData();" />

</td>
</tr>
</table>

</body>
<script type="text/javascript">
var context;
var web;
var list;
var listitem;


function SetEmpData()
{
context = SP.ClientContext.get_current();
var url = "https://sharepoint22.sharepoint.com/sites/DevSite";
var parentCtx = new SP.AppContextSite(context, url);
web = parentCtx.get_web();
context.load(web);
list = web.get_lists().getByTitle('Emp');
var itemCreateInfo = new SP.ListItemCreationInformation();
var listItem = list.addItem(itemCreateInfo);
listItem.set_item("Title","Mr");
listItem.set_item("FirstName", $('#firstname').val());
listItem.set_item("LastName", $('.lastname').val());
listItem.set_item("Location", $('.Location').val());
listItem.update();
context.load(listItem);
context.executeQueryAsync(
Function.createDelegate(this, this.onQuerySucceeded),
Function.createDelegate(this, this.onQueryFailed)
);
}

function onQuerySucceeded(sender, args) {
alert('Item Added SuccessFully');
}

function onQueryFailed(sender, args) {
alert(args.get_message());

}

</script>

</html>

3.output

Friday 13 February 2015

Programmatically Get items from sharepoint list in sharepoint apps using Napa office 365 tool

1.Create a Custom List Name as "Emp" and Create a below Column Name

2.Paste the below code in Default.aspx

<%-- The following 4 lines are ASP.NET directives needed when using SharePoint components --%>

<%@ Page Inherits="Microsoft.SharePoint.WebPartPages.WebPartPage, Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" MasterPageFile="~masterurl/default.master" Language="C#" %>

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%-- The markup and script in the following Content element will be placed in the <head> of the page --%>

<asp:Content ContentPlaceHolderID="PlaceHolderAdditionalPageHead" runat="server">

.myOtherTable { background-color:#FFFFE0;border-collapse:collapse;color:#000;font-size:18px; }

.myOtherTable th { background-color:#BDB76B;color:white;width:32%; }

.myOtherTable td, .myOtherTable th { padding:5px;border:0; }

.myOtherTable td { border-bottom:1px dotted #BDB76B; }

</style>

</asp:Content>

<%-- The markup in the following Content element will be placed in the TitleArea of the page --%>

<asp:Content ContentPlaceHolderID="PlaceHolderPageTitleInTitleArea" runat="server">

Page Title

</asp:Content>

<%-- The markup and script in the following Content element will be placed in the <body> of the page --%>

<asp:Content ContentPlaceHolderID="PlaceHolderMain" runat="server">

<h2>Get Items</h2>

</div>

</asp:Content>

3.Paste the below code in App.js

'use strict';

var hostweburl;

var appweburl;

var sFullHtml = '';

$(document).ready(function () {

hostweburl = decodeURIComponent(getQueryStringParameter("SPHostUrl"));

appweburl = decodeURIComponent(getQueryStringParameter("SPAppWebUrl"));

var scriptbase = hostweburl + "/_layouts/15/";

$.getScript(scriptbase + "SP.RequestExecutor.js", loadPage);

});

function getQueryStringParameter(paramToRetrieve) {

var params = document.URL.split("?")[1].split("&");

for (var i = 0; i < params.length; i = i + 1) {

var singleParam = params[i].split("=");

if (singleParam[0] == paramToRetrieve) return singleParam[1];

}

function loadPage() {

getListItems();

}

//Retrieve all of the list items

function getListItems() {

var executor;

executor = new SP.RequestExecutor(appweburl);

executor.executeAsync({

url: appweburl + "/_api/SP.AppContextSite(@target)/web/lists/getbytitle('Emp')/items?@target='" + hostweburl + "'",

method: "GET",

headers: {

"Accept": "application/json; odata=verbose"

success: getListItemsSuccessHandler,

error: getListItemsErrorHandler

});

}

//Populate the selectListItems control after retrieving all of the list items.

function getListItemsSuccessHandler(data) {

var jsonObject = JSON.parse(data.body);

var results = jsonObject.d.results;

sFullHtml += '<table id="TblEmpInfo" class="myOtherTable" >';

sFullHtml += ' <tr >';

sFullHtml += ' <th>First Name</th>';

sFullHtml += ' <th>Last Name</th>';

sFullHtml += ' <th>Location</th>';

sFullHtml += ' </tr>';

for (var i = 0; i < results.length; i++) {

var Title=results[i].Title;

var Fname=results[i].FirstName;

var Lname=results[i].LastName;

var Location=results[i].Location;

sFullHtml += '<tr>';

sFullHtml += '<td align="left" valign="top">'+ Fname +'</td>';

sFullHtml += '<td align="left" valign="top">'+ Lname +'</td>';

sFullHtml += '<td align="left" valign="top">'+ Location +'</td>';

sFullHtml += '</tr>';

}

sFullHtml += '</table>';

$(".EmpInfo").html(sFullHtml);

}

function getListItemsErrorHandler(data, errorCode, errorMessage) {

alert("Could not get list items: " + errorMessage);

}

4.After Publishing the App the output will look like this

Wednesday 4 February 2015

get items from sharepoint list using spservices

1.Create a Custom List Name as "Emp" and Create a below Column Name

FirstName - Single Line Text
LastName-Single Line Text
Location-Single Line Text

2.Create one Content Editor WebPart and paste the below code

<script type="text/javascript" src="https://Site Collection Url/sites/TestSite/Style Library/Samples/jquery-1.8.0.min.js"></script>
<script type="text/javascript" src="https://Site Collection Url/sites/TestSite/Style Library/Samples/jquery.SPServices-2014.02.min.js"></script>
<script type="text/javascript" src="https://github.com/douglascrockford/JSON-js/blob/master/json2.js"></script>

<script type="text/javascript">
$(document).ready(function() {
GetEmpListItemData();
});
function GetEmpListItemData() {

// get Emp list data
var datarows = [];
$().SPServices({
operation: "GetListItems",
webURL:"https://Site Collection Url/sites/TestSite",
async: false,
listName: "Emp",
CAMLViewFields: "<ViewFields><FieldRef Name='Title'/><FieldRef Name='FirstName'/><FieldRef Name='LastName'/><FieldRef Name = 'Location'/></ViewFields>",
CAMLQuery: "<Query><OrderBy><FieldRef Name='ID' Ascending='True'/></OrderBy></Query>",
completefunc: function(xData, Status) {
var listitemrows = $(xData.responseXML).find("z\\:row, row");
$(listitemrows).each(function() {
var Id = $(this).attr("ows_ID");
var Title = $(this).attr("ows_Title");
var FirstName = $(this).attr("ows_FirstName");
var LastName = $(this).attr("ows_LastName");
var Location = $(this).attr("ows_Location");
datarows.push({Id: Id, Title: Title,FirstName: FirstName,LastName: LastName,Location: Location});
});
}

});

var myJsonString = JSON.stringify(datarows);
alert(myJsonString);
for (var arrayIndex in datarows) {
var Id=datarows[arrayIndex].Id;
alert(Id);
}
}

</script>

get sharepoint list items using rest api

1.Create a Custom List Name as "Emp" and Create a below Column Name

FirstName - Single Line Text
LastName-Single Line Text
Location-Single Line Text

2.Create one Content Editor WebPart and paste the below code

<script type="text/javascript" src="https://Site Collection Url/sites/TestSite/Style Library/Samples/jquery-1.8.0.min.js"></script>

<style>

<style type="text/css">
.EmpTable { background-color:#FFFFE0;border-collapse:collapse;color:#000;font-size:18px; }
.EmpTable th { background-color:#BDB76B;color:white;width:32%; }
.EmpTable td, .EmpTable th { padding:5px;border:0; }
.EmpTable td { border-bottom:1px dotted #BDB76B; }

</style>

<script type="text/javascript">

$(document).ready(function() {


$.getJSON("https://Site Collection Url/sites/TestSite/_vti_bin/ListData.svc/Emp?$select=Id,Title,FirstName,LastName",function(data) {

var datarows = [];


$.each(data.d.results, function(i,result) {

var Title = result.Title;
var Id = result.Id;
var FirstName = result.FirstName;
var LastName = result.LastName;

datarows.push({Id: Id, Title: Title,FirstName: FirstName,LastName: LastName});



});

var sFullHtml = '';

sFullHtml += '<table id="TblEmpInfo" class="EmpTable" >';
sFullHtml += ' <tr >';
sFullHtml += ' <th>First Name</th>';
sFullHtml += ' <th>Last Name</th>';
sFullHtml += ' <th>Id</th>';
sFullHtml += ' </tr>';

for (var arrayIndex in datarows) {
var FirstName=datarows[arrayIndex].FirstName;
var LastName=datarows[arrayIndex].LastName;
var Id=datarows[arrayIndex].Id;

sFullHtml += '<tr>';
   sFullHtml += '<td align="left" valign="top">'+ FirstName +'</td>';
sFullHtml += '<td align="left" valign="top">'+ LastName +'</td>';
sFullHtml += '<td align="left" valign="top">'+ Id +'</td>';
sFullHtml += '</tr>';

}

sFullHtml += '</table>';

$(".EmpInfo").html(sFullHtml);

});
});

</script>

<div class="EmpInfo" style="margin-top:10px;">

</div>

output:-