public void GetItemsByQueryAndInclude()
{
CSOMSharePointRepository <CommunityEventModel> events = new CSOMSharePointRepository <CommunityEventModel>(testUrl);
string listName = "CommunityEvents";
CSOMCamlQuery query = new CSOMCamlQuery();
string include = "";
IEnumerable <CommunityEventModel> e = events.GetItemsByQuery(listName, query, include);
Assert.IsNotNull(e);
}
public void GetItemsByQueryWithRowLimit()
{
IEnumerable <CommunityEventModel> events;
CSOMSharePointRepository <CommunityEventModel> repository = new CSOMSharePointRepository <CommunityEventModel>(testUrl);
string listName = "CommunityEvents";
int rowLimit = 1;
CSOMCamlQuery query = new CSOMCamlQuery();
query.Caml = "<Where><Eq><FieldRef Name='ShowOnCalendar' /><Value Type='Choice'>Yes</Value></Eq></Where>";
query.RowLimit = rowLimit;
events = repository.GetItemsByQuery(listName, query);
Assert.IsNotNull(events);
Assert.AreEqual(rowLimit, events.Count());
}
public void GetItemsByQuery()
{
IEnumerable <CommunityEventModel> events;
CSOMSharePointRepository <CommunityEventModel> repository = new CSOMSharePointRepository <CommunityEventModel>(testUrl);
string listName = "CommunityEvents";
CSOMCamlQuery query = new CSOMCamlQuery();
query.Caml = "<Where><Eq><FieldRef Name='ShowOnCalendar' /><Value Type='Choice'>Yes</Value></Eq></Where>";
events = repository.GetItemsByQuery(listName, query);
Assert.IsNotNull(events);
if (events.Count() <= 0)
{
Assert.Fail("No items were returned");
}
}
public void GetItemsByQueryWithOrder()
{
IEnumerable <CommunityEventModel> events;
CSOMSharePointRepository <CommunityEventModel> repository = new CSOMSharePointRepository <CommunityEventModel>(testUrl);
string listName = "CommunityEvents";
CSOMCamlQuery query = new CSOMCamlQuery();
query.Caml = "<Where><Eq><FieldRef Name='ShowOnCalendar' /><Value Type='Choice'>Yes</Value></Eq></Where>";
query.OrderByFields = "<FieldRef Name='Title' />";
events = repository.GetItemsByQuery(listName, query);
Assert.IsNotNull(events);
if (events.Count() <= 0)
{
Assert.Fail("No items were returned");
}
else
{
CommunityEventModel e = events.First();
Assert.AreEqual("A", e.Title.Substring(0, 1).ToUpper());
}
}