Get the Selected Date/Time within a SharePoint 2010 Calendar using jQuery

The selected date in a SharePoint 2010 calendar may be needed when writing custom solutions. This can be retrieved using JavaScript and jQuery.  First, we need to determine if we are in the month, week, or day scope of the calendar.  There is probably a better way to do this, but the following seems to work: 



// make these global
var selectedDate = 'no date selected';
var selectedTime = 'no time selected';


// put the rest of the code in a function
function GetSelectedDate() {

  var dayScope = $('table.ms-acal-detail');
  var weekScope = $('table.ms-acal-detail');
  var monthScope = $('table.ms-acal-month');


  var isDayScope = dayScope.length > 0 ? dayScope.attr('summary').indexOf('Daily') > -1 : false;
  var isWeekScope = weekScope.length > 0 ? weekScope.attr('summary').indexOf('Weekly') > -1 : false;
  var isMonthScope = monthScope.length > 0 ? monthScope.attr('summary').indexOf('Monthly') > -1 : false;


Now lets get the selected element:


var selecteddateelement = $('.ms-acal-vitem');


Now that we know which view we are in, and have the selected element, we can determine the selected date if we are in the monthly scope.


  if(isMonthScope) {
var tditem = selecteddateelement.parent();
var tritem = selecteddateelement.parent().parent();
var prevtr = tritem.prev();
var indx = tritem.children().index(tditem) + 2;
var dttd = prevtr.children(':nth-child(' + indx + ')');
if(selecteddateelement.length > 0) selectedDate = dttd.attr('date');
  }

Next lets handle the weekly  scope .

  else if(isWeekScope) {
var weektritem = selecteddateelement.parent();
var weekdayindx = weektritem.children().index(selecteddateelement) + 1;
var weekselectedhalfhourstarttime = $('[class^=ms-acal-hour]').index(weektritem) / 2;
var weekdttd = $('.ms-acal-week-top').children(':nth-child(' + weekdayindx + ')');
if(weekdttd.length > 0) selectedDate = weekdttd.attr('date');
if(weekselectedhalfhourstarttime >= 0) selectedTime = weekselectedhalfhourstarttime;
  }

And finally the daily  scope .

  else if(isDayScope) {
var verbosedaydate = $('.ms-acal-display').text();
var daydatesplit = verbosedaydate.split(/,| /);
var month = daydatesplit[1];
var dayscopemonth = (new Date()).getMonth() + 1; // default to current month


if(month == "January") dayscopemonth = 1;
else if(month == "February") dayscopemonth = 2;
else if(month == "March") dayscopemonth = 3;
else if(month == "April") dayscopemonth = 4;
else if(month == "May") dayscopemonth = 5;
else if(month == "June") dayscopemonth = 6;
else if(month == "July") dayscopemonth = 7;
else if(month == "August") dayscopemonth = 8;
else if(month == "September") dayscopemonth = 9;
else if(month == "October") dayscopemonth = 10;
else if(month == "November") dayscopemonth = 11;
else if(month == "December") dayscopemonth = 12;


var dayscopeday = daydatesplit[2];
var dayscopeyear = daydatesplit[3];


selectedDate = dayscopemonth + '/' + dayscopeday + '/' + dayscopeyear;


var daytr = selecteddateelement.parent();
var dayselectedhalfhourstarttime = $('[class^=ms-acal-hour]').index(daytr) / 2;
if(dayselectedhalfhourstarttime >= 0) selectedTime = dayselectedhalfhourstarttime;
  }

Now the selectedDate and selectedTime will be populated.  Echo these to the console to see the values:

  console.log("selectedDate:    " + selectedDate); // change this to do something with the date
  console.log("selectedTime:    " + selectedTime); // change this to do something with the time
  // end the function
}

The selectedDate and selectedTime variables should be global variables.  This allows the preceding code to be put into a function, say "GetSelectedDate()" and bound to a click event on the calendar.  The issue with not doing this is if you are trying to call this code from a button or anchor click outside of the calendar, when clicked, first the calendar looses focus, then the ms-acal-vitem class is stripped.  The result is that nothing is selected when the code would run, coming back with "no date selected" every time.  Binding to click would look like this:



$(document).ready(function () {
$('.ms-acal-rootdiv').unbind("click").click(function () {
GetSelectedDate();
});
});


Doing so will set the global variables selectedDate and selectedTime every time a click is made.  Another thing you may want to do is create a function to set these variables to the current date and time.  This could be called first, then the preceding code, resulting in selectedDate and selectedTime always having a date populated.

It seems like a long way to go to get the selected date, and does not handle localization.  I would love to see what others are doing to solve this issue.  I know there are some xslt solutions out there too.

Thanks to 
http://franknezrick.blogspot.in/2012/03/get-selected-datetime-within-sharepoint.html

Asp.Net Page Postback from Javascript

If you need to do page postback from javascript, this one is for you...
Today I came across situation where we were using Jquery calendar but we needed postback as soon as date is selected by user.

Step 1- Bind Javascript function to onselect event of Jquery calendar

$("#mydatepicker").datepicker({
    onSelect: function(dateText, inst) {
        _doPostBack("buttonidoranyvalue","");
    }
});​

Above will make sure page is post back as soon as date is selected by user.
first parameter is eventtarget, second paramerter is eventargument.
Same can be used in any java scripts functions

Step 2 - Check Event Target in Request.Forms parameters and do whatever you want man :) like below

if(Request.Form.Params.Get("_EVENTTARGET") == "buttonidoranyvalue") {
//do whatever you want }

Hope this helps...Happy Coding!!!!

SharePoint and jQuery–Getting & Setting SharePoint Form Fields

Question 1: From where to download JQuery Base Library?
Answer 1: http://code.jquery.com/jquery-1.7.2.min.js

Question 2: How to include JQuery Script?
Answer 2: Upload the JQuery base library to the Assets list and include the library using the below syntax
<script type="text/javascript" src="../../Assets/jquery-1.7.2.min.js"></script>

Question 3: What attribute to use for getting the INPUT object?
Answer 3: We need to use the title attribute of the INPUT control

<input name="ctl00$m$g_e2bcfa9c_6e16_4b44_9833_22e44201a72b$ctl00$ctl04$ctl03$ctl00$ctl00$ctl04$ctl00$ctl00$TextField" type="text" maxlength="255" id="ctl00_m_g_e2bcfa9c_6e16_4b44_9833_22e44201a72b_ctl00_ctl04_ctl03_ctl00_ctl00_ctl04_ctl00_ctl00_TextField" title="Email" class="ms-long" />

Question 4: How to write JQuery function?
Answer 4:

<script type="text/javascript" src="../../Assets/jquery-1.7.2.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {

});

}
</script>

Note: $(document).ready(function ()... is referred as the MAIN() function

Question 5: How to get the value of the INPUT field?
Answer 5: var variablename = $("input[title='title of the input control']").val();

Question 6: How to make the field readonly?
Answer 6: $("input[title='title of the input control']").attr("readonly","true");

Question 7: How to get the value of the Dropdown?
Answer 7: var variablename = $("select[title='title of the dropdown control']").val();

Question 8: How to set the value to the text field?
Answer 8: $("input[title='title of the input control']").val("enter value here");

Question 9: How to remove the readonly of the text field?
Answer 9: $("input[title='title of the input control']").removeAttr("readonly"); 

Question 10: How to set focus to the text field?
Answer 10: $("input[title='title of the input control']").focus(); 

Question 11: How to use JQuery in PreSaveAction?
Answer 11: <script type="text/javascript" src="../../Assets/jquery-1.7.2.min.js"></script>
<script language = "Javascript">
function PreSaveAction()
{

var variablename = $("input[title='title of the input control']").val();

}

</script>

Note: do not include $(document).ready(function ()... 

Question 12: How to call JQuery function in Dropdown value change?
Answer 12:
<script type="text/javascript" src="../../Assets/jquery-1.7.2.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {

$("select[title='title of the control']").change(function () {
//write logic here
});
});
</script>

Question 13: How to set the width of the Text field?
Answer 13: $("input[title='title of the control']").width(100);

Question 14: How to disable Textfield?
Answer 14: $("input[title='title of the control']").attr('disabled','disabled');
Question 15: How to Remove disable attribute on Textfield?
Answer 15: $("input[title='title of the control']").removeAttr('disabled');

Question 16: How to check numeric value in Text field?
Answer 16:
var numbervaluefield = $("input[title='title of the control']").val();
var numericheckvaariable = $.isNumeric(numbervaluefield);

Note: The function will return boolean value

Question 17: How to compare date in Jquery?
Answer 17:

var startdate = new Date($("input[title='Start Date']").val());
var enddate = new Date($("input[title='End Date']").val());

if(enddate < startdate)
{
 alert("End Date cannot be lesser than Start date.");
 $("input[title='End Date']").focus();
 return false;
}
else
{

 return true;
}

Question 18: How to set default value in Rich Text field?
Answer 18:

<script type="text/javascript" src="../../Assets/jquery-1.7.2.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {

var htmlcontentval = "<table border='1' cellpadding='0' cellspacing='0'><tr><td colspan='3'>Month-Year</td></tr><tr><td>Milestone</td>       <td>Onsite Effort</td><td>Offshore Effort</td></tr><tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr></table>";

$("textarea[title='Milestone Information']").val(htmlcontentval);
});
</script>

Note: Milestone information is the title of the textarea used in the Rich text field

Question 19: How to hide the Sharepoint Enhanced Richtext field?
Answer 19:

 $("textarea[title='richtexttitle']").closest("tr").hide();

Question 20: How to unhide the Sharepoint Enhanced Richtext field?
Answer 20:

 $("textarea[title='richtexttitle']").closest("tr").show();

Question 21: How to convert string to uppercase?
Answer 21
$("input[title='titlename']").val().toUpperCase();

Question 22: How to check length of the string?
Answer 22
$("input[title='titlename']").val().val().length;

Question 23: How to validate Email address?
Answer 23:

var emailReg = /^([\w-\.]+@([\w-]+\.)+[\w-]{2,4})?$/;
var emailaddressVal = $("input[title='titlename']").val();
if(!emailReg.test(emailaddressVal))
{
 alert("Please enter valid email address");
}

Question 24: How to get the lookup text value (Dropdown text value)?

Answer 24:

$("option:selected", $("select[title='titlename']")).text();

Hope this helps...Happy Coding!!!

Disable Control in default Add/Edit List form

We might have came across situation where we need to disabled controls on add/edit form based on user selection or for that matter based on any condition/requirement.

Add Content Editor Webpart below the NewForm/EditForm, then include the Javascript in source editor of Content Editor Webpart

<script language="javascript">
$("input[title='title of the input control']").attr("readonly","true"); 
</script>

Note - Make sure jquery libraries is referenced in master page or else call it content editor webpart itself

Hope this helps...Happy Coding!!!!

Taxonomy hidden list in SharePoint

The taxonomy hidden list contains all the metadata taxonomy terms that are used in your site collections. Below are some of the facts about this list:

a. As the name of the list indicates, the list is a hidden list which means you will not be seeing a link to this list anywhere in your site collection.

b. The URL of the list would be like: http://YourSharePointSite/Lists/TaxonomyHiddenList/

c. This list will only be present in the root site of your site collection.

d. The list by default has read access to all NT\Authenticated users. Make sure to verify this when your users have issues with using the metadata taxonomy service.

e. The list contains only the taxonomy terms that were used anywhere in your site collections. That means when you are using a taxonomy term for the first time in any list, that term gets added as a new list item in the taxonomy hidden list.

f. This list contains the following fields to store the data about the taxonomy terms:

Hope this helps...Happy Coding!!!

Ref - http://sharesilver.wordpress.com/2013/10/25/taxonomy-hidden-list-in-sharepoint/

Deploy Site Pages with Webpart with WSP

How to create a webpart page and embed a webpart into it using elements xml file.

To start with, create an Empty SharePoint project in visual studio 2010.

The next step is to create a visual webpart, we will be embedding this into our webpart page

For demonstration, I added a label control with text property set to “Cool Webpart”

Now add a new module to the project

This will create two files into the solution

Delete the sample text file. Add an aspx page.

Now open the aspx page and paste following markup

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>
<%@ Import Namespace="Microsoft.SharePoint.ApplicationPages" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" 
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, 
PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" 
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, 
PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="asp" Namespace="System.Web.UI" 
Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
PublicKeyToken=31bf3856ad364e35" %>
<%@ Import Namespace="Microsoft.SharePoint" %>
<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, 
PublicKeyToken=71e9bce111e9429c" %>
<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" 
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, 
PublicKeyToken=71e9bce111e9429c" %>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MyPage.aspx.cs" 
Inherits="WebpartPages.MyPage" masterpagefile="~masterurl/default.master" %>

<asp:Content ID="Main" ContentPlaceHolderID="PlaceHolderMain" runat="server">
    <WebPartPages:WebPartZone runat="server" ID="wpzMyZone">
    <ZoneTemplate></ZoneTemplate>
    </WebPartPages:WebPartZone>
</asp:Content>

Open the code behind and ensure the page inherits WebPartPage

using System;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;

namespace WebpartPages
{
    public partial class MyPage : WebPartPage
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
    }
}

Now open up the elements xml file and update it as below

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
  <Module Name="Webpartpage" Url="SitePages">
    <File Path="Webpartpage\MyPage.aspx" Url="MyPage.aspx"  
          Type="GhostableInLibrary" IgnoreIfAlreadyExists="FALSE">
      <AllUsersWebPart WebPartOrder ="0" WebPartZoneID ="wpzMyZone">
        <![CDATA[ 
          <webParts>
            <webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
              <metaData>
                <type name="WebpartPages.MyWebpart.MyWebpart, WebpartPages, 
                Version=1.0.0.0, Culture=neutral, PublicKeyToken=132122a1200767d5" />
                <importErrorMessage>Cannot import this Web Part.</importErrorMessage>
              </metaData>
              <data>
                <properties>
                  <property name="Title" type="string">MyWebpart</property>
                  <property name="Description" type="string">Mywebpart</property>
                      
                </properties>
              </data>
            </webPart>
          </webParts>
        ]]>
      </AllUsersWebPart>
    </File>
  </Module>
</Elements>

Deploy the solution. Now open up the SitePages library, there you can see the new webpart page we just created.

Hope this helps...Happy Coding!!!!

Get Set Value in PeopleEditor Webpart in Visual Webpart

Adding to Webpart

<SharePoint:PeopleEditor ID="myPeoplePicker" runat="server" Width="300" BorderStyle="Solid" BorderColor="Black" BorderWidth="1" />


Reading Value from Control

if(myPeoplePicker.ResolvedEntities.Count >0 )
{
PickerEntity objEntity = (PickerEntity) myPeoplePicker.ResolvedEntities[0];
    SPUserInfo objInfo = new SPUserInfo();
    objInfo.LoginName = objEntity.Key;
    strAccountName = objInfo.LoginName;
//objEntity.EntityData Gets or sets a data-mapping structure that is defined by the consumer of the PickerEntity class. This properties has all data related to user entity.

}

Setting Value to Control

myPeoplePicker.CommaSeparatedAccounts = "domain\username";
myPeoplePicker.ValidateEntity()


Hope this helps...Happy Coding!!!

List of Sharepoint WebServices

Following are list of SharePoint Web Service References.

Service Administration (_vti_adm/Admin.asmx) Administrative methods for creating deleting sites and retrieving languages used in the deployment

• CreateSite
• DeleteSite
• GetLanguage
• RefreshConfigCache

Alerts (Alerts.asmx) Methods for working with SharePoint list item alerts

• DeleteAlerts
• GetAlerts

Authentication (Authentication.asmx) Client proxy that provides user authentication for sites that use forms-based authentication

• Login (Used to authenticate)
• Mode (Returns the authentication mode of the current site)

Copy (Copy.asmx) Methods to copy files between or within sites

• CopyIntoItems (Copy document as byte array to location on server)
• CopyIntoItemsLocal (Copy document from one location on the same server to another)
• GetItem (Creates a byte array of a document that can be passed to theCopyIntoItems method)

Document Workspace (Dws.asmx) Methods for managing Document Workspace sites and data

• CanCreateDwsUrl
• CreateDws
• CreateFolder
• FindDwsDoc
• GetDwsData
• GetDwsMetaData
• RemoveDwsUser
• RenameDws
• UpdateDwsData

Forms (Forms.asmx) Methods for returning forms that are used in the user interface when working with the contents of a list

• GetForm
• GetFormCollection

Imaging (Imaging.asmx) Methods to create and manager picture libraries

• CheckSubwebAndList
• CreateNewFolder
• Delete
• Download
• Edit
• GetItemsByIds
• GetItemsXMLData
• GetListItems
• ListPictureLibrary
• Rename
• Upload

List Data Retrieval (DspSts.asmx) Perform queries against sites and list in SharePoint

• Query (Performs queries against SharePoint lists and sites)

Lists (Lists.asmx) Methods for working with Lists and List Data

• AddAttachment
• AddDiscussionBoardItem
• AddList
• AddListFromFeature
• ApplyContentTypeToList
• DeleteAttachment
• DeleteContentType
• DeleteContentTypeXmlDocument
• DeleteList
• GetAttachmentCollection
• GetList
• GetListAndView
• GetListCollection
• GetListContentType
• GetListContentTypes
• GetListItemChanges
• GetListItemChangesSinceToken
• GetListItems
• GetVersionCollection
• UndoCheckout
• UpdateContentType
• UpdateContentTypesXmlDocument
• UpdateContentTypeXmlDocument
• UpdateList
• UpdateListItems

Meetings(Meetings.asmx) Create and manage Meeting Workspace Sites

• AddMeeting
• AddMeetingFromICal
• CreateWorkspace
• DeleteWorkspace
• GetMeetingInformation
• GetMeetingWorkspaces
• RemoveMeeting
• RestoreMeeting
• SetAttendeeResponse
• SetWorkspaceTitle
• UpdateMeeting
• UpdateMeetingFromICal

People(People.asmx) Resolve and find Principals

• ResolvePrincipals

Permissions (Permissions.asmx) Methods for working with permissions for a site or list

• AddPermission
• AddPermissionCollection
• GetPermissionCollection
• RemovePermission
• RemovePermissionCollection
• UpdatePermission

Directory Management(sharepointemailws.asmx) Methods for managing Active Directory e-mail distribution groups and their memberships

• ChangeContactsMembershipInDistributionGroup
• ChangeUsersmembershipInDistributionGroup
• CreateContact
• CreateDistributionGroup
• DeleteContact
• DeleteDistributionGroup
• GetJobStatus
• ModifyContact
• ModifyDistributionGroup
• RenameDistributionGroup

Site Data (SiteData.asmx) Methods that return metadata or list data from sites or lists

• EnumerateFolder
• GetAttachments
• GetChanges
• GetContent
• GetList
• GetListCollection
• GetListItems
• GetSite
• GetSiteAndWeb
• GetSiteUrl
• GetURLSegments
• GetWeb

Sites(Sites.asmx) Methods for returning information about the collection or site template

• ExportWeb
• GetSiteTemplates
• GetUpdatedFormDigest
• ImportWeb

Search(spsearch.asmx) Methods for searching via search services

• Query
• QueryEx
• Registration
• Status

Users & Groups(usergroup.asmx) Methods for working with users role definitions and groups

• AddGroup
• AddGroupToRole
• AddRole
• AddRoleDef
• AddUserCollectionToGroup
• AddUserCollectionToRole
• AddUserToGroup
• AddUserToRole
• GetAllUserCollectionFromWeb
• GetGroupCollection
• GetList
• GetListAndView
• GetListCollection
• GetGroupCollectionFromRole
• GetGroupCollectionFromSite
• GetGroupCollectionFromUser
• GetGroupCollectionFromWeb
• GetGroupInfo
• GetRoleCollection
• GetRoleCollectionFromGroup
• GetRoleCollectionFromUser
• GetRoleCollectionFromWeb
• GetRoleInfo
• GetRolesAndPermissionsForCurrentUser
• GetRolesAndPermissionsForSite
• GetUserCollection
• GetUserCollectionFromGroup
• GetUserCollectionFromRole
• GetUserCollectionFromSite
• GetUserCollectionFromWeb
• GetUserInfo
• GetUserLoginFromEmail
• RemoveGroup
• RemoveGroupFromRole
• RemoveRole
• RemoveUserCollectionFromGroup
• RemoveUserCollectionFromRole
• RemoveUserCollectionFromSite
• RemoveUserFromGroup
• RemoveUserFromRole
• RemoveUserFromSite
• RemoveUserFromWeb
• UpdateGroupInfo
• UpdateRoleDefInfo
• UpdateRoleInfo
• UpdateUserInfo

Versions (Versions.asmx) Methods for working with file versions

• DeleteAllVersions
• DeleteVersion
• GetVersions
• RestoreVersion

Views(Views.asmx) Methods for working with list views

• AddView
• DeleteView
• GetViewCollection
• GetViewHtml
• UpdateView
• UpdateViewHtml
• UpdateViewHtml2

Web Part Pages(WebPartPages.asmx) Methods for working with Web Part Pages

• AddWebPart
• AddWebPartToZone
• AssociateWorkflowMarkup
• ConvertWebPartFormat
• DeleteWebPart
• ExecuteProxyUpdates
• FetchLegalWorkflowActions
• GetAssemblyMetaData
• GetBindingResourceData
• GetCustomControlList
• GetDataFromDataSourceControl
• GetFormCapabilityFromDataSourceControl
• GetSafeAssemblyInfo
• GetWebPart
• GetWebPart2
• GetWebPartCrossPageCompatibility
• GetWebPartPage
• GetWebPartPageConnectionInfo
• GetWebPartPageDocument
• GetWebPartProperties
• GetWebPartProperties2
• RemoveWorkflowAssociation
• RenderWebPartForEdit
• SaveWebPart
• SaveWebPart2
• ValidateWorkflowMarkupAndCreateSupportObjects

Webs(Webs.asmx) Methods for working with sites and subsites

·  CreateContentType

·  CustomizeCss

·  DeleteContentType

·  GetActivatedFeatures

·  GetAllSubWebCollection

·  GetColumns

·  GetContentType

·  GetContentTypes

·  GetCustomizedPageStatus

·  GetListTemplates

·  GetWeb

·  GetWebCollection

·  RemoveContentTypeXmlDocument

·  RevertAllFileContentStreams

·  RevertCss

·  RevertFileContentStream

·  UpdateColumns

·  UpdateContentType

·  UpdateContentTypeXmlDocument

·  WebUrlFromPageUrl MOSS Search (Search.asmx) Methods for searching via MOSS (Microsoft Office SharePoint Server) Search services, which also includes a method to retrieve the managed search properties

• GetSearchMetadata (Search managed properties)
• Query
• QueryEx
• Registration
• Status

Area Service (areaservice.asmx)

User Profile Service (userprofileservice.asmx)

SPS Crawl Service (spscrawl.asmx)

Outlook Adapter Service (outlookadapter.asmx)