//Inserting into all types of fields
function insertItem()
{
var context=new SP.ClientContext.get_current();
var web=context.get_web();
context.load(web);
var list=web.get_lists().getByTitle("FieldsTypeDemo1");
context.load(list);
var itemCreateInfo = new SP.ListItemCreationInformation();
var oListItem = list.addItem(itemCreateInfo);
oListItem.set_item("SingleText",SingleText);
oListItem.set_item("MultiPlainText",MultiPlainText);
oListItem.set_item('MultiRichText',MultiRichText);
oListItem.set_item('ChoiceDropDown',ChoiceDropDown);
oListItem.set_item('ChoiceRadio',ChoiceRadio);
oListItem.set_item('ChoiceCheckBox',ChoiceCheckBox);
oListItem.set_item('Num',Num);
oListItem.set_item('Currency',Currency);
//Convert date to SharePoint Date format
if(DateOnly!="")
{
var toDate=new Date(DateOnly);
var newDateOnly=(toDate.getMonth()+1)+"/"+toDate.getDate()+"/"+toDate.getFullYear();
oListItem.set_item('DateOnly',newDateOnly);
}
//Convert date and time to SharePoint DateTime format
if(DateAndTime!="")
{
//alert(time[0]);
var toDate1=new Date(DateAndTime);
var newDateTime=(toDate1.getMonth()+1)+"/"+toDate1.getDate()+"/"+toDate1.getFullYear()+" "+hr+min;
alert(newDateTime);
oListItem.set_item('DateAndTime',newDateTime);
}
var lookUp = new SP.FieldLookupValue();
lookUp.set_lookupId(LookUpField);
oListItem.set_item('LookUpField',lookUp);
oListItem.set_item('Y_x002f_N',YN);
if(HyperLink!="http://")
oListItem.set_item('HyperLink',HyperLink);
if(Picture!="http://")
oListItem.set_item('Picture',Picture);
//Converting to Taxonomy Managed metadata field
if(ManagedMetadata!="")
{
var field= list.get_fields().getByInternalNameOrTitle("ManagedMetadata");
var taxField = context.castTo(field, SP.Taxonomy.TaxonomyField);
var termValue = new SP.Taxonomy.TaxonomyFieldValue();
var id="";
for(var i=0;i<termsLbl.length;i++)
{
if(termsLbl[i]==ManagedMetadata)
{
id=termsId[i];
}
}
termValue.set_label(ManagedMetadata);
termValue.set_termGuid(id);
taxField.setFieldValueByValue(oListItem, termValue);
}
oListItem.update();
context.load(oListItem);
context.executeQueryAsync(success,fail);
function success()
{
alert("Row Inserted Successfully");
window.location.reload();
}
function fail(sender,args)
{
alert(args);
window.location.reload();
}
function insertItem()
{
var context=new SP.ClientContext.get_current();
var web=context.get_web();
context.load(web);
var list=web.get_lists().getByTitle("FieldsTypeDemo1");
context.load(list);
var itemCreateInfo = new SP.ListItemCreationInformation();
var oListItem = list.addItem(itemCreateInfo);
oListItem.set_item("SingleText",SingleText);
oListItem.set_item("MultiPlainText",MultiPlainText);
oListItem.set_item('MultiRichText',MultiRichText);
oListItem.set_item('ChoiceDropDown',ChoiceDropDown);
oListItem.set_item('ChoiceRadio',ChoiceRadio);
oListItem.set_item('ChoiceCheckBox',ChoiceCheckBox);
oListItem.set_item('Num',Num);
oListItem.set_item('Currency',Currency);
//Convert date to SharePoint Date format
if(DateOnly!="")
{
var toDate=new Date(DateOnly);
var newDateOnly=(toDate.getMonth()+1)+"/"+toDate.getDate()+"/"+toDate.getFullYear();
oListItem.set_item('DateOnly',newDateOnly);
}
//Convert date and time to SharePoint DateTime format
if(DateAndTime!="")
{
//alert(time[0]);
var toDate1=new Date(DateAndTime);
var newDateTime=(toDate1.getMonth()+1)+"/"+toDate1.getDate()+"/"+toDate1.getFullYear()+" "+hr+min;
alert(newDateTime);
oListItem.set_item('DateAndTime',newDateTime);
}
var lookUp = new SP.FieldLookupValue();
lookUp.set_lookupId(LookUpField);
oListItem.set_item('LookUpField',lookUp);
oListItem.set_item('Y_x002f_N',YN);
if(HyperLink!="http://")
oListItem.set_item('HyperLink',HyperLink);
if(Picture!="http://")
oListItem.set_item('Picture',Picture);
//Converting to Taxonomy Managed metadata field
if(ManagedMetadata!="")
{
var field= list.get_fields().getByInternalNameOrTitle("ManagedMetadata");
var taxField = context.castTo(field, SP.Taxonomy.TaxonomyField);
var termValue = new SP.Taxonomy.TaxonomyFieldValue();
var id="";
for(var i=0;i<termsLbl.length;i++)
{
if(termsLbl[i]==ManagedMetadata)
{
id=termsId[i];
}
}
termValue.set_label(ManagedMetadata);
termValue.set_termGuid(id);
taxField.setFieldValueByValue(oListItem, termValue);
}
oListItem.update();
context.load(oListItem);
context.executeQueryAsync(success,fail);
function success()
{
alert("Row Inserted Successfully");
window.location.reload();
}
function fail(sender,args)
{
alert(args);
window.location.reload();
}
}
//retriving from all types of fields
function getAllItems()
{
var context=new SP.ClientContext.get_current();
var web=context.get_web();
context.load(web);
var list=web.get_lists().getByTitle("FieldsTypeDemo1");
context.load(list);
var query = new SP.CamlQuery();
var items = list.getItems(query);
context.load(items);
context.executeQueryAsync(success,fail);
function fail(sender,args)
{
alert("Call failed:"+args.get_message());
}
function success()
{
var item = items.getEnumerator();
while(item.moveNext())
{
var row = item.get_current();
$("#SingleTextInfo").text(row.get_item("SingleText"));
$("#MultiPlainTextInfo").text(row.get_item("MultiPlainText"));
document.getElementById("MultiRichTextInfo").innerHTML=row.get_item("MultiRichText");
$("#ChoiceDropDownInfo").text(row.get_item("ChoiceDropDown"));
$("#ChoiceRadioInfo").text(row.get_item("ChoiceRadio"));
$("#ChoiceCheckBoxInfo").text(row.get_item("ChoiceCheckBox"));
$("#NumInfo").text(row.get_item("Num"));
$("#CurrencyInfo").text(row.get_item("Currency"));
var date1=new Date(row.get_item("DateOnly"));
$("#DateOnlyInfo").text(((date1.getMonth()+1)+"/"+date1.getDate()+"/"+date1.getFullYear()));
var date2=new Date(row.get_item("DateAndTime"));
$("#DateAndTimeInfo").text(((date2.getMonth()+1)+"/"+date2.getDate()+"/"+date2.getFullYear()+" "+date2.getHours()+":"+date2.getMinutes()));
//get Lookup value for look up field
$("#LookUpFieldInfo").text(row.get_item("LookUpField").get_lookupValue());
if(row.get_item("Y_x002f_N")==true)
$("#YNInfo").text("Yes");
else
$("#YNInfo").text("No");
//get URL for HyperLink an dPicture fields
var url1=row.get_item("HyperLink").get_url();
var url2=row.get_item("Picture").get_url();
document.getElementById("HyperLinkInfo").innerHTML='<a href="'+url1+'" target="new">'+url1+'</a>';
document.getElementById("PictureInfo").innerHTML='<a href="'+url2+'" target="new">'+url2+'</a>';
//display label name
$("#ManagedMetadataInfo").text(row.get_item("ManagedMetadata").$0_1);
}
}
}
No comments:
Post a Comment