Posts

Showing posts from September 15, 2016

Download Excel File Using C#

function download(strData, strFileName, "application/vnd.ms-excel") {     var D = document,         a = D.createElement("a");     strMimeType = strMimeType || "application/octet-stream";     if (navigator.msSaveBlob) { // IE10+         return navigator.msSaveBlob(new Blob([strData], {             type: strMimeType         }), strFileName);     } /* end if(navigator.msSaveBlob) */     if ('download' in a) { //html5 A[download]         if (window.URL) {             a.href = window.URL.createObjectURL(new Blob([strData]));         } else {             a.href = "data:" + strMimeType + "," + encodeURIComponent(strData);         }         a.setAttribute("download", strFileName);         a.innerHTML = "downloading...";         D.body.appendChild(a);         setTimeout(function() {             a.click();             D.body.removeChild(a);             if (window.URL) {                 setTimeout

Rest Sample URL Construction

var url = "/_api/Web/lists/getByTitle('Favorite')/items?$select=ID,Title,Modified,Url,UserName/ID,UserName/Title&$expand=UserName&$filter=UserName/ID%20eq%20" + _spPageContextInfo.userId + "&$orderby=Modified%20desc";  var url = "/_api/Web/lists/getByTitle('DB')/items?$select=ID,Title,Project/ID,Project/Title,AuthorId,FileRef,ProjectId,Modified&$expand=Project&$orderby=Modified%20desc";   var  url = "/_api/Web/lists/getByTitle('UserProfile')/items?$select=FirstName,LastName,PicPath,UserLoginId&$filter=" + qryParam.substring(0, qryParam.length - 4) //UserLogin eq " + LatesTop[j].AuthorId; var  url = "/_api/Web/lists/getByTitle('DB')/items?$select=ID,Title,AuthorId,FileRef,Project/Title,AuthorId,ProjectId,Modified&$expand=Project&$filter=Author eq " + _spPageContextInfo.userId + "&$orderby=Modified desc"; var  url = "/_api/Web/lists/getByTitle(&

Jquerry Using Grep Function

var ActiveUserData = $.grep(usersData, function(i, j) {       return i.LastAccessed > date; }); var TotalContributerData = $.grep(usersData, function(i, j) {       return i.LastContributed != null; });

Filter to Arrays, Comparing Two Arrays In Jquerry

plantArray.push({name:Anil},{name:Kumar},{name:Dintakurthi}); var length=plantArray.length; var onlySeltedPlants=[];  $.grep(plantArray, function(el) {       if (jQuery.inArray(el.name, plantScoreArray) > 0) onlySeltedPlants.push(el);  });

Sorting an Jquerry Array

Var TopPerformingPlant=[]; TopPerformingPlant.pus({Socore:1,ID:1}{Socore:2,ID:2}); var length=TopPerformingPlant.length; TopPerformingPlant.sort(function(a, b) {      return parseFloat(b.Score) - parseFloat(a.Score); });

Get List Items Using Rest API Sharepoint 2013

function getItems(url, callback) {     $.ajax({         url: _spPageContextInfo.webAbsoluteUrl + url,         type: "GET",         headers: {             "accept": "application/json;odata=verbose",         },         success: function(data) {             callback(data.d.results);         },         error: function(error) {             alert(JSON.stringify(error));         }     }); }

Get Document Library MetaData And File Path (Both) USing Rest API Sharepoint 2013

function getToolLibrayAllReords(callback) {     $.ajax({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/Lists/GetByTitle('ToolsLibrary')/" + "GetItems(query=@v1)?" + "$expand=ListItemAllFields,File&@v1={\"FolderServerRelativeUrl\" : \"/Sites/EMS/ToolsLibrary\", \"ViewXml\":\"" + "<View Scope='RecursiveAll'><Query><Where><Eq><FieldRef Name='IsRecommended' /><Value Type='Boolean'>1</Value></Eq></Where><OrderBy><FieldRef Name='Modified' Ascending='False' /></OrderBy></Query></View>\"}",         type: "POST",         headers: {             "accept": "application/json;odata=verbose",             "X-RequestDigest": $("#__REQUESTDIGEST").val(),             "content-Type": "application/json;odata=

Get Logged In user FirstName and Last Name Properties Using REST API Sharepoint 2013

/****************Get FirstNaem LastName ****************/ function GetUserProperties(callback) {     $.ajax({         url: _spPageContextInfo.webAbsoluteUrl + "/_api/SP.UserProfiles.PeopleManager/GetMyProperties/UserProfileProperties",         headers: {             Accept: "application/json;odata=verbose"         },         async: false,         success: function(data) {             callback(data);         },         error: function(jQxhr, errorCode, errorThrown) {             alert(errorThrown);         }     }); }