public void TestEq() { //Text Field string caml = CamlBuilder.BuildCaml(TestList, new Eq("textcol", "text1")); Assert.IsNotNull(caml); this.spQuery.Query = caml; var items = this.TestList.GetItems(this.spQuery); Assert.IsTrue(items.Count == 1); //Number Field caml = CamlBuilder.BuildCaml(TestList, new Eq("numbercol", "100")); Assert.IsNotNull(caml); this.spQuery.Query = caml; items = this.TestList.GetItems(this.spQuery); Assert.IsTrue(items.Count == 1); //DateTime Field DateTime dt = new DateTime(2000, 1, 1, 5, 10, 59); string dts = Microsoft.SharePoint.Utilities.SPUtility.CreateISO8601DateTimeFromSystemDateTime(dt); caml = CamlBuilder.BuildCaml(TestList, new Eq("datetimecol", dts)); Assert.IsNotNull(caml); this.spQuery.Query = caml; items = this.TestList.GetItems(this.spQuery); Assert.IsTrue(items.Count == 1); //Bool Field caml = CamlBuilder.BuildCaml(TestList, new Eq("BoolCol", "1")); Assert.IsNotNull(caml); this.spQuery.Query = caml; items = this.TestList.GetItems(this.spQuery); Assert.IsTrue(items.Count == 1); }
public static bool grantPermission(String cuurentUserId, String listName, String fileID) { var spClient = GetInstance(listName); List <CamlQuery_oneField> dataToUpdate = new List <CamlQuery_oneField>(); dataToUpdate.Add(new CamlQuery_oneField("ID", "Text", fileID, CamlQuery_oneField.EQ_COMP)); dataToUpdate.Add(new CamlQuery_oneField("permissions", "Text", ";#-1;#i:0#.w|" + cuurentUserId, CamlQuery_oneField.EQ_COMP)); spClient.updateRecored(CamlBuilder.buildCamlUpdateQuery(dataToUpdate)); return(true); }
public void TestAnd() { string caml = CamlBuilder.BuildCaml(TestList, new And(new Eq("textCol", "text1"), new Eq("ID", "1"))); Assert.IsNotNull(caml); this.spQuery.Query = caml; var items = this.TestList.GetItems(this.spQuery); Assert.IsTrue(items.Count == 1); }
public static List <EservicesDomain.ExternalDomain.SP.Attachment> getAttachments(String listName, String jobID) { SharePointHandler spClient = GetInstance(listName); string viewFieldsCluase = CamlBuilder.buildCamlViewFields(new string[] { "ID", "Name", "upLoaderName", "activityName", "Created" }); string queryOptions = CamlBuilder.buildCamlQueryOptions(folder: listName + "/" + jobID, recursive: true); List <Dictionary <String, Object> > data = spClient.viewRecord(viewFieldsCluase, null, queryOptions); List <EservicesDomain.ExternalDomain.SP.Attachment> returnedData = SPFacade.getAttachmentsList(data, listName); return(returnedData); }