public void TestVbStrComp()
{
//
// Create list People.
//
var lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
Test.Add(lst, p1);
People p2 = new People()
{
FirstName = "John", LastName = "De Smet", Age = 54, IsMember = false, ShortBio = "Family"
};
Test.Add(lst, p2);
//
// Get query with Visual Basic string compare.
//
var res = TestHelpersVb.Helpers.StrCmp(site).AsEnumerable();
Assert.IsTrue(res.Count() == 1 && res.First().FirstName == "Bart", "Visual Basic string compare parse failure in query predicate.");
}
public void ProjectSingleton()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Projections.
//
AssertProject(src, p => p.Age, new double[] { 24, 52 }, "Integer projection failure");
AssertProject(src, p => p.FirstName + " " + p.LastName, new string[] { "Bart De Smet", "Bill Gates" }, "String projection failure");
}
public void GetEntityById()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
Test.Add(lst, p1);
//
// Get entity by id.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
People _p1 = src.GetEntityById(1, false);
Assert.IsTrue(p1.Equals(_p1), "Invalid entity returned by GetEntityById method");
}
public void BoolPredicate()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Test queries.
//
AssertWhere(src, p => p.IsMember, 1, "Invalid result for Boolean check (true)");
AssertWhere(src, p => !p.IsMember, 1, "Invalid result for Boolean check (false)");
}
public void DefaultQuery()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
Test.Add(lst, p1);
//
// Test default query.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
var res1 = (from p in src select p).AsEnumerable();
Assert.IsTrue(res1.Count() == 1, "Query did not return results.");
}
public void MultiWhere()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Multipe where clauses.
//
var res1 = (from p in src where p.Age >= 24 where p.FirstName == "Bart" select p).AsEnumerable();
Assert.IsTrue(res1.Count() == 1 && res1.First().FirstName == "Bart", "Invalid result for multiple where clauses (1).");
var res2 = (from p in src where p.FirstName == "Bart" where p.Age >= 24 select p).AsEnumerable();
Assert.IsTrue(res2.Count() == 1 && res2.First().FirstName == "Bart", "Invalid result for multiple where clauses (2).");
var res3 = (from p in src where 1 == 1 where p.FirstName == "Bart" select p).AsEnumerable();
Assert.IsTrue(res3.Count() == 1 && res3.First().FirstName == "Bart", "Invalid result for multiple where clauses (3).");
var res4 = (from p in src where p.FirstName == "Bart" where 1 == 1 select p).AsEnumerable();
Assert.IsTrue(res4.Count() == 1 && res4.First().FirstName == "Bart", "Invalid result for multiple where clauses (4).");
var res5 = (from p in src where 1 == 0 where p.FirstName == "Bart" select p).AsEnumerable();
Assert.IsTrue(res5.Count() == 0, "Invalid result for multiple where clauses (5).");
var res6 = (from p in src where p.FirstName == "Bart" where 1 == 0 select p).AsEnumerable();
Assert.IsTrue(res6.Count() == 0, "Invalid result for multiple where clauses (6).");
}
public void NullChecks()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = null, LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Test queries.
//
AssertWhere(src, p => p.FirstName == null, 1, "Invalid IsNull result");
//AssertWhere(src, p => p.FirstName.Equals(null), 1, "Invalid IsNull result (.Equals)");
AssertWhere(src, p => null == p.FirstName, 1, "Invalid IsNull result (inverse)");
AssertWhere(src, p => p.FirstName != null, 1, "Invalid IsNotNull result");
//AssertWhere(src, p => !p.FirstName.Equals(null), 1, "Invalid IsNotNull result (.Equals)");
AssertWhere(src, p => null != p.FirstName, 1, "Invalid IsNotNull result (inverse)");
AssertWhere(src, p => !(p.FirstName == null), 1, "Invalid IsNotNull result 2");
AssertWhere(src, p => !(null == p.FirstName), 1, "Invalid IsNotNull result 2 (inverse)");
//
// Use of variable.
//
string s = null;
AssertWhere(src, p => p.FirstName == s, 1, "Invalid IsNull result (variable)");
AssertWhere(src, p => s == p.FirstName, 1, "Invalid IsNull result (variable) (inverse)");
AssertWhere(src, p => p.FirstName != s, 1, "Invalid IsNotNull result (variable)");
AssertWhere(src, p => s != p.FirstName, 1, "Invalid IsNotNull result (variable) (inverse)");
}
public void BooleanOptimizations()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
People p3 = new People()
{
ID = 3, FirstName = "Bart", LastName = "Simpson", Age = 15, IsMember = false, ShortBio = "Funny guy"
};
People p4 = new People()
{
ID = 4, FirstName = "Ray", LastName = "Ozzie", Age = 52, IsMember = false, ShortBio = "Chief Software Architect at Microsoft Corporation"
};
People p5 = new People()
{
ID = 5, FirstName = "Anders", LastName = "Hejlsberg", Age = 47, IsMember = true, ShortBio = "C# language architect"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
Test.Add(lst, p3);
Test.Add(lst, p4);
Test.Add(lst, p5);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Optimize.
//
AssertWhere(src, p => 1 == 1, 5, "Boolean optimization failed (1).");
AssertWhere(src, p => 1 == 0, 0, "Boolean optimization failed (2).");
AssertWhere(src, p => p.FirstName == "Bart" && 1 == 1, 2, "Boolean optimization failed (3).");
AssertWhere(src, p => p.FirstName == "Bart" && 1 == 0, 0, "Boolean optimization failed (4).");
AssertWhere(src, p => p.FirstName == "Bart" || 1 == 1, 5, "Boolean optimization failed (5).");
AssertWhere(src, p => p.FirstName == "Bart" || 1 == 0, 2, "Boolean optimization failed (6).");
}
public void Choice()
{
//
// Create list.
//
SPList lst = Test.CreateList <ChoiceTest>(site.RootWeb);
//
// Add fields.
//
lst.Fields.Add("Options", SPFieldType.Choice, true);
lst.Update();
SPFieldChoice fld = new SPFieldChoice(lst.Fields, "Options");
fld.Choices.Add("A");
fld.Choices.Add("B");
fld.Choices.Add("C & D");
fld.Update();
lst.Update();
//
// Add items.
//
SPListItem item = lst.Items.Add();
item["Title"] = "1";
item["Options"] = "A";
item.Update();
item = lst.Items.Add();
item["Title"] = "2";
item["Options"] = "C & D";
item.Update();
//
// List source.
//
SharePointDataSource <ChoiceTest> src = new SharePointDataSource <ChoiceTest>(site);
src.CheckListVersion = false;
//
// Queries.
//
var res1 = (from c in src where c.Options == Options.A select c).AsEnumerable();
Assert.IsTrue(res1.Count() == 1 && res1.First().Title == "1", "Test for Choice fields failed (1).");
var res2 = (from c in src where c.Options == Options.CD select c).AsEnumerable();
Assert.IsTrue(res2.Count() == 1 && res2.First().Title == "2", "Test for Choice fields failed (2).");
var res3 = (from c in src where c.Options == Options.A || c.Options == Options.CD select c).AsEnumerable();
Assert.IsTrue(res3.Count() == 2, "Test for Choice fields failed (3).");
}
public void ComplexProjection()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Complex projection. Should trigger recursive parsing of the projection expression to find view fields.
//
var res = (from p in src
where p.Age == 24
select new
{
p.FirstName,
Ages = new double[] { p.Age },
Ages2 = new List <double>()
{
p.Age
},
DoubleAge = p.Age * 2,
Member = p.IsMember ? p.IsMember : p.IsMember,
NoMember = !p.IsMember,
NameLower = (p.FirstName + " " + p.LastName).ToLower(),
LastName = new String(p.LastName.ToCharArray()),
CharactersInBio = Helper(p.ShortBio)
}).AsEnumerable().First();
Assert.IsTrue(res.FirstName == "Bart" && res.Ages[0] == 24 && res.Ages2[0] == 24 && res.DoubleAge == 48 && res.Member == true && res.NoMember == false && res.NameLower == "bart de smet" && res.LastName == "De Smet" && res.CharactersInBio == 15);
}
public void EmptyList()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Empty list test.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
var res1 = (from p in src select p).AsEnumerable();
Assert.IsTrue(res1.Count() == 0, "Query on empty list did return results.");
}
public void Nullable()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, SecondAge = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, SecondAge = null, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
People p3 = new People()
{
ID = 3, FirstName = "William", LastName = "Gates", Age = 52, SecondAge = null, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
Test.Add(lst, p3);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Test queries.
//
AssertWhere(src, p => p.SecondAge.HasValue, 1, "Invalid result for nullable query (1)");
AssertWhere(src, p => !p.SecondAge.HasValue, 2, "Invalid result for nullable query (2)");
AssertWhere(src, p => p.SecondAge != null, 1, "Invalid result for nullable query (3)");
AssertWhere(src, p => p.SecondAge == null, 2, "Invalid result for nullable query (4)");
AssertWhere(src, p => p.SecondAge == 24, 1, "Invalid result for nullable query (5)");
AssertWhere(src, p => p.SecondAge.Value == 24, 1, "Invalid result for nullable query (6)");
AssertWhere(src, p => p.SecondAge >= 25, 0, "Invalid result for nullable query (7)");
}
public void Contains()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Contains empty string.
//
AssertWhere(src, p => p.ShortBio.Contains(""), 2, "Contains with empty string failed");
//
// Contains with valid parameter.
//
AssertWhere(src, p => p.ShortBio.Contains("Corp"), 1, "Contains with valid parameter failed");
//
// Contains without results.
//
AssertWhere(src, p => p.ShortBio.Contains("azerty"), 0, "Empty Contains failed");
}
public void Junk()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Test.
//
//var res = (from p in src select p.Age).First(); //24.0
//var res = (from p in src where p.Age > 100 select p.Age).First(); //empty sequence
//var res = (from p in src select p.Age).First(p => p > 50); //52.0
//var res = (from p in src select p).First(); //Bart
/*
* TODO: coalescing of two or more adjacent where clauses; last where clause can't be translated in this case
*
* var res = from p in src where p.Age == 24 where p.FirstName == "Bart" orderby p.LastName where p.IsMember select p;
*/
}
public void Take()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Take operation.
//
var res1 = (from p in src select p).Take(1).AsEnumerable();
Assert.IsTrue(res1.Count() == 1, "Take failed (1).");
var res2 = (from p in src select p).Take(0).AsEnumerable();
Assert.IsTrue(res2.Count() == 0, "Take failed (2).");
var res3 = (from p in src select p).Take(3).AsEnumerable();
Assert.IsTrue(res3.Count() == 2, "Take failed (3).");
}
public void TestWsAndSp()
{
/*
* Temporary test to check ws results against sp results.
*/
//
// Create list People.
//
var lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
Test.Add(lst, p1);
//
// Sources.
//
SharePointDataSource <People> sp = new SharePointDataSource <People>(site);
sp.CheckListVersion = false;
SharePointDataSource <People> ws = new SharePointDataSource <People>(url);
ws.CheckListVersion = false;
//
// Test.
//
AssertWsEqualsSp <People>(ws, sp, p => p.FirstName.StartsWith("B"), "WS and SP data source did not return the same results.");
}
public void DateTime()
{
//
// Create list DateTimeTest.
//
var lst = Test.Create <DateTimeTest>(site.RootWeb);
//
// Add items.
//
System.DateTime now = System.DateTime.Now; //new System.DateTime(2007, 5, 21, 11, 11, 0);
DateTimeTest t1 = new DateTimeTest()
{
ID = 1, Name = "Yesterday", DateTime = System.DateTime.Today.AddDays(-1)
};
DateTimeTest t2 = new DateTimeTest()
{
ID = 2, Name = "Today", DateTime = System.DateTime.Today
};
DateTimeTest t3 = new DateTimeTest()
{
ID = 3, Name = "Tomorrow", DateTime = System.DateTime.Today.AddDays(1)
};
DateTimeTest t4 = new DateTimeTest()
{
ID = 4, Name = "Now", DateTime = now
};
Test.Add(lst, t1);
Test.Add(lst, t2);
Test.Add(lst, t3);
Test.Add(lst, t4);
//
// List source.
//
SharePointDataSource <DateTimeTest> src = new SharePointDataSource <DateTimeTest>(site);
src.CheckListVersion = false;
//
// Queries.
//
var res1 = (from t in src where t.DateTime == now select t).AsEnumerable(); //KNOWN ISSUE with Eq check on hh:MM:ss (2032)
Assert.IsTrue(res1.Count() == 2, "DateTime test failure (1).");
var res2 = (from t in src where t.DateTime > System.DateTime.Today select t).AsEnumerable();
Assert.IsTrue(res2.Count() == 1, "DateTime test failure (2).");
var res3 = (from t in src where t.DateTime < System.DateTime.Today select t).AsEnumerable();
Assert.IsTrue(res3.Count() == 1, "DateTime test failure (3).");
var res4 = (from t in src where t.DateTime == System.DateTime.Today select t).AsEnumerable();
Assert.IsTrue(res4.Count() == 2, "DateTime test failure (4).");
var res5 = (from t in src where t.DateTime <= System.DateTime.Today select t).AsEnumerable();
Assert.IsTrue(res5.Count() == 3, "DateTime test failure (5).");
//
// TODO: Check for eligible use of Now.
//
}
public void AndOr()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
People p3 = new People()
{
ID = 3, FirstName = "Bart", LastName = "Simpson", Age = 15, IsMember = false, ShortBio = "Funny guy"
};
People p4 = new People()
{
ID = 4, FirstName = "Ray", LastName = "Ozzie", Age = 52, IsMember = false, ShortBio = "Chief Software Architect at Microsoft Corporation"
};
People p5 = new People()
{
ID = 5, FirstName = "Anders", LastName = "Hejlsberg", Age = 47, IsMember = true, ShortBio = "C# language architect"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
Test.Add(lst, p3);
Test.Add(lst, p4);
Test.Add(lst, p5);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// And.
//
AssertWhere(src, p => p.FirstName == "Bart" && p.Age >= 24, 1, "And failed (1).");
AssertWhere(src, p => p.ShortBio.Contains("Microsoft") && p.Age == 52, 2, "And failed (2).");
AssertWhere(src, p => p.FirstName.StartsWith("B") && p.IsMember && p.ShortBio.Contains("founder"), 1, "And failed (3).");
//
// Or.
//
AssertWhere(src, p => p.Age == 24 || p.Age == 52, 3, "Or failed (1).");
AssertWhere(src, p => p.Age == 52 || p.FirstName == "Bart", 4, "Or failed (2).");
AssertWhere(src, p => p.Age >= 40 || p.Age <= 20 || p.Age == 24, 5, "Or failed (3).");
//
// Mixed.
//
AssertWhere(src, p => p.FirstName.StartsWith("B") && (p.Age == 24 || p.Age == 52), 2, "And/Or failed (1).");
AssertWhere(src, p => p.FirstName.StartsWith("B") || (p.FirstName == "Anders" && p.Age >= 40), 4, "And/Or failed (2).");
//
// De Morgan.
//
AssertWhere(src, p => !(p.FirstName == "Bart" && p.Age <= 24), 3, "De Morgan failed (1).");
AssertWhere(src, p => !(p.FirstName == "Bill" || p.LastName == "De Smet"), 3, "De Morgan failed (2).");
}
public void Ordering()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
People p3 = new People()
{
ID = 3, FirstName = "Bart", LastName = "Simpson", Age = 15, IsMember = false, ShortBio = "Funny guy"
};
People p4 = new People()
{
ID = 4, FirstName = "Ray", LastName = "Ozzie", Age = 52, IsMember = false, ShortBio = "Chief Software Architect at Microsoft Corporation"
};
People p5 = new People()
{
ID = 5, FirstName = "Anders", LastName = "Hejlsberg", Age = 47, IsMember = true, ShortBio = "C# language architect"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
Test.Add(lst, p3);
Test.Add(lst, p4);
Test.Add(lst, p5);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Ascending.
//
var res1 = (from p in src orderby p.FirstName select p).AsEnumerable().ToArray();
Assert.IsTrue(res1.First().FirstName == "Anders" && res1.Last().FirstName == "Ray", "Ascending order failed");
//
// Descending.
//
var res2 = (from p in src orderby p.LastName descending select p).AsEnumerable().ToArray();
Assert.IsTrue(res2.First().LastName == "Simpson" && res2.Last().LastName == "De Smet", "Descending order failed");
//
// Multiple.
//
var res3 = (from p in src orderby p.Age ascending, p.FirstName descending select p).AsEnumerable().ToArray();
Assert.IsTrue(res3.First().LastName == "Simpson" && res3.Last().LastName == "Gates", "OrderBy/ThenBy failed");
}
public void StringEquality()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Using ==
//
AssertWhere(src, p => p.FirstName == "Bart", 1, "Equality check failed (==)");
AssertWhere(src, p => p.FirstName != "Bart", 1, "Inequality check failed (!=)");
//
// Using .Equals
//
AssertWhere(src, p => p.FirstName.Equals("Bart"), 1, "Equality check failed (.Equals)");
AssertWhere(src, p => !p.FirstName.Equals("Bart"), 1, "Inequality check failed (!.Equals)");
//
// Using == inverse order
//
AssertWhere(src, p => "Bart" == p.FirstName, 1, "Equality check failed (== inverse order)");
AssertWhere(src, p => "Bart" != p.FirstName, 1, "Inquality check failed (!= inverse order)");
//
// Using .Equals inverse order (NOT SUPPORTED)
//
//AssertWhere(src, p => "Bart".Equals(p.FirstName), 1, "Equality check failed (.Equals inverse order)");
//
// Using == with .ToString
//
AssertWhere(src, p => p.FirstName.ToString() == "Bart".ToString(), 1, "Equality check failed (== with .ToString)");
//
// Using .Equals with .ToString
//
AssertWhere(src, p => p.FirstName.ToString().Equals("Bart".ToString()), 1, "Equality check failed (.Equals with .ToString)");
//
// Using == with .ToString
//
AssertWhere(src, p => p.FirstName.ToString() == "Bart".ToString(), 1, "Equality check failed (== with .ToString inverse order)");
//
// Using .Equals with .ToString
//
//AssertWhere(src, p => p.FirstName.ToString().Equals("Bart".ToString()), 1, "Equality check failed (.Equals with .ToString inverse order)");
}
private void GetLookupLists(out SPList child, out SPList parent)
{
//
// Child list.
//
child = Test.Create <LookupChild>(site.RootWeb);
//
// Parent list.
//
parent = Test.CreateList <LookupParent>(site.RootWeb);
parent.Fields.AddLookup("Child", child.ID, false);
parent.Update();
SPFieldLookup lookup = new SPFieldLookup(parent.Fields, "Child");
lookup.LookupField = "Title";
lookup.Update();
parent.Update();
//
// Add child items.
//
SPListItem c = child.Items.Add();
c["Title"] = "Child 1";
c["Number"] = 1;
c.Update();
c = child.Items.Add();
c["Title"] = "Child 2";
c["Number"] = 2;
c.Update();
c = child.Items.Add();
c["Title"] = "Child 3";
c["Number"] = 3;
c.Update();
//
// Add parent items.
//
SPListItem p = parent.Items.Add();
p["Title"] = "Parent 11";
p["Child"] = "1;#Child 1";
p.Update();
p = parent.Items.Add();
p["Title"] = "Parent 12";
p["Child"] = "1;#Child 1";
p.Update();
p = parent.Items.Add();
p["Title"] = "Parent 21";
p["Child"] = "2;#Child 2";
p.Update();
p = parent.Items.Add();
p["Title"] = "Parent 22";
p["Child"] = "2;#Child 2";
p.Update();
p = parent.Items.Add();
p["Title"] = "Parent 31";
p["Child"] = "3;#Child 3";
p.Update();
p = parent.Items.Add();
p["Title"] = "Parent 32";
p["Child"] = "3;#Child 3";
p.Update();
}
public void LtLeqGtGeq()
{
//
// Create list People.
//
lst = Test.Create <People>(site.RootWeb);
//
// Add items.
//
People p1 = new People()
{
ID = 1, FirstName = "Bart", LastName = "De Smet", Age = 24, IsMember = true, ShortBio = "Project founder"
};
People p2 = new People()
{
ID = 2, FirstName = "Bill", LastName = "Gates", Age = 52, IsMember = false, ShortBio = "Microsoft Corporation founder"
};
Test.Add(lst, p1);
Test.Add(lst, p2);
//
// List source.
//
SharePointDataSource <People> src = new SharePointDataSource <People>(site);
src.CheckListVersion = false;
//
// Gt
//
AssertWhere(src, p => p.Age > 50, 1, "Invalid Gt result");
AssertWhere(src, p => 50 < p.Age, 1, "Invalid Gt result (inverse)");
AssertWhere(src, p => !(p.Age <= 50), 1, "Invalid Gt result (negated)");
AssertWhere(src, p => !(50 >= p.Age), 1, "Invalid Gt result (negated) (inverse)");
//
// Geq
//
AssertWhere(src, p => p.Age >= 52, 1, "Invalid Geq result");
AssertWhere(src, p => 52 <= p.Age, 1, "Invalid Geq result (inverse)");
AssertWhere(src, p => !(p.Age < 52), 1, "Invalid Geq result (negated)");
AssertWhere(src, p => !(52 > p.Age), 1, "Invalid Geq result (negated) (inverse)");
//
// Lt
//
AssertWhere(src, p => p.Age < 25, 1, "Invalid Lt result");
AssertWhere(src, p => 25 > p.Age, 1, "Invalid Lt result (inverse)");
AssertWhere(src, p => !(p.Age >= 25), 1, "Invalid Lt result (negated)");
AssertWhere(src, p => !(25 <= p.Age), 1, "Invalid Lt result (negated) (inverse)");
//
// Leq
//
AssertWhere(src, p => p.Age <= 24, 1, "Invalid Leq result");
AssertWhere(src, p => 24 >= p.Age, 1, "Invalid Leq result (inverse)");
AssertWhere(src, p => !(p.Age > 24), 1, "Invalid Leq result (negated)");
AssertWhere(src, p => !(24 < p.Age), 1, "Invalid Leq result (negated) (inverse)");
}
