public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// ExecuteDictionary.
//
Dictionary <int, Person> dic;
dic = pa.GetPersonDictionary1();
dic = pa.GetPersonDictionary2();
dic = pa.GetPersonDictionary3();
foreach (int id in dic.Keys)
{
Console.WriteLine("{0}: {1} {2}", id, dic[id].FirstName, dic[id].LastName);
}
// ExecuteScalarDictionary.
//
Dictionary <int, string> sdic = pa.GetPersonNameDictionary();
foreach (int id in dic.Keys)
{
Console.WriteLine("{0}: {1}", id, sdic[id]);
}
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// ExecuteList.
//
IList list;
list = pa.GetPersonList1();
list = pa.GetPersonList2();
foreach (Person p in list)
{
Console.WriteLine("{0}: {1} {2}", p.ID, p.FirstName, p.LastName);
}
// ExecuteScalarList.
//
List <int> slist = pa.GetPersonIDList();
foreach (int id in slist)
{
Console.WriteLine("{0}", id);
}
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
Person p = pa.SelectByName("Tester", "Testerson");
Assert.AreEqual(2, p.ID);
}
public void Test2()
{
PersonAccessor da = PersonAccessor.CreateInstance();
List <Person> list = da.SelectBy("FirstName", "John");
Assert.AreNotEqual(0, list.Count);
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
List <Person> list = pa.GetPersonList(2);
Assert.That(list, Is.Not.Null);
Assert.That(list.Count, Is.LessThanOrEqualTo(2));
}
public void Test3()
{
PersonAccessor da = PersonAccessor.CreateInstance();
List <Person> list = da.SelectByLastName("Testerson", 1);
Assert.AreNotEqual(0, list.Count);
}
public void Test4()
{
PersonAccessor da = PersonAccessor.CreateInstance();
List <Person> list = da.SelectID(42);
Assert.AreEqual(42, list[0].ID);
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
List <Person> list = new List <Person>();
pa.SelectAll(list);
Assert.AreNotEqual(0, list.Count);
}
public void TransactionTest()
{
using (DbManager db = new DbManager())
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
db.BeginTransaction();
// Insert and get id.
//
Person person = Person.CreateInstance();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa.Insert(db, person);
person = pa.SelectByID(db, id);
TypeAccessor.WriteConsole(person);
Assert.IsNotNull(person);
// Update.
//
person.Gender = Gender.Other;
pa.Query.Update(db, person);
person = pa.SelectByID(db, person.ID);
TypeAccessor.WriteConsole(person);
Assert.AreEqual(Gender.Other, person.Gender);
// Delete.
//
pa.Query.Delete(db, person);
person = pa.SelectByID(db, person.ID);
Assert.IsNull(person);
db.CommitTransaction();
// Get All.
//
List <Person> list = pa.Query.SelectAll(db);
foreach (Person p in list)
{
TypeAccessor.WriteConsole(p);
}
}
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// ExecuteObject.
//
Assert.IsNotNull(pa.GetByID(1));
Assert.IsNotNull(pa.GetPersonByID(2));
Assert.IsNotNull(pa.GetPersonByName("Tester", "Testerson"));
Assert.IsNotNull(pa.SelectByName("Tester", "Testerson"));
}
public void Test()
{
PersonAccessor pa = /*[a]*/ DataAccessor /*[/a]*/./*[a]*/ CreateInstance/*[/a]*/ <PersonAccessor>();
Person person1 = pa.SelectByKey(1);
Assert.IsNotNull(person1);
Person person2 = pa.GetByName(person1.FirstName, person1.LastName);
Assert.AreEqual(person1.PersonID, person2.PersonID);
}
public void Test()
{
PersonAccessor pa = /*[a]*/ PersonAccessor.CreateInstance/*[/a]*/ ();
Person person1 = pa.SelectByKey(1);
Assert.IsNotNull(person1);
Person person2 = pa.AnyName(person1.FirstName, person1.LastName);
Assert.AreEqual(person1.ID, person2.ID);
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// Insert and get id.
//
Person person = Person.CreateInstance();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa.Insert(person);
person = pa.SelectByID(id);
TypeAccessor.WriteConsole(person);
Assert.IsNotNull(person);
// Update.
//
person.Gender = Gender.Other;
pa.Query.Update(person);
person = pa.SelectByID(person.ID);
TypeAccessor.WriteConsole(person);
Assert.AreEqual(Gender.Other, person.Gender);
// Delete.
//
pa.Query.Delete(person);
person = pa.SelectByID(person.ID);
Assert.IsNull(person);
// Get All.
//
List <Person> list = pa.Query.SelectAll();
foreach (Person p in list)
{
TypeAccessor.WriteConsole(p);
}
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// ExecuteDictionary.
//
Dictionary <CompoundValue, Person> dic = pa.GetPersonDictionary();
foreach (CompoundValue idx in dic.Keys)
{
Console.WriteLine("{0}: {1} {2}", dic[idx].ID, dic[idx].FirstName, dic[idx].LastName);
}
// ExecuteScalarDictionary.
//
Dictionary <CompoundValue, string> sdic = pa.GetPersonNameDictionary();
string firstName = sdic[new CompoundValue(2, "Testerson")];
Assert.AreEqual("Tester", firstName);
}
public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
// ExecuteScalar.
//
Assert.IsTrue(pa.GetCount() > 0);
// Insert and get id.
//
Person person = new Person();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa./*[a]*/ Insert(person) /*[/a]*/;
Assert.IsFalse(id == 0);
new SprocQuery <Person>().DeleteByKey(id);
}
public void Test()
{
using (DbManager db = new DbManager())
{
PersonAccessor pa = /*[a]*/ DataAccessor.CreateInstance <PersonAccessor>(db) /*[/a]*/;
pa.BeginTransaction();
// Insert and get id.
//
Person person = new Person();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa./*[a]*/ Insert(person) /*[/a]*/;
// SelectByName.
//
person = pa./*[a]*/ SelectByName("Crazy", "Frog") /*[/a]*/;
Assert.IsNotNull(person);
// Select top.
//
Dictionary <int, Person> dic = pa./*[a]*/ SelectTop(10) /*[/a]*/;
Assert.IsTrue(dic.Count <= 10);
// Delete.
//
pa.Query.Delete(person);
pa.CommitTransaction();
}
}
public void TestScenario02_ComparingNames()
{
var parser = new SpelExpressionParser();
var ctx = new StandardEvaluationContext();
ctx.AddPropertyAccessor(new SecurityPrincipalAccessor());
// Multiple options for supporting this expression: "p.name == principal.name"
// (1) If the right person is the root context object then "name==principal.name" is good enough
var expr = parser.ParseRaw("Name == Principal.Name");
ctx.SetRootObject(new Person("Andy"));
var value = expr.GetValue(ctx, typeof(bool));
Assert.True((bool)value);
ctx.SetRootObject(new Person("Christian"));
value = expr.GetValue(ctx, typeof(bool));
Assert.False((bool)value);
// (2) Or register an accessor that can understand 'p' and return the right person
expr = parser.ParseRaw("P.Name == Principal.Name");
var pAccessor = new PersonAccessor();
ctx.AddPropertyAccessor(pAccessor);
ctx.SetRootObject(null);
pAccessor.ActivePerson = new Person("Andy");
value = expr.GetValue(ctx, typeof(bool));
Assert.True((bool)value);
pAccessor.ActivePerson = new Person("Christian");
value = expr.GetValue(ctx, typeof(bool));
Assert.False((bool)value);
}
public IEnumerable <Person> GetPeople()
{
return(PersonAccessor.GetPeople());
}
public Person AddPerson(Person person)
{
return(PersonAccessor.AddPerson(person));
}
public void DeletePerson(Person person)
{
PersonAccessor.DeletePerson(person);
}
public Person GetPerson(int id)
{
return(PersonAccessor.GetPerson(id));
}
public Task <Person> GetPersonAsync(ITurnContext turnContext, CancellationToken cancellationToken)
{
return(PersonAccessor.GetAsync(turnContext, () => new Person(), cancellationToken));
}
public async Task SavePersonAsync(ITurnContext turnContext, Person person, CancellationToken cancellationToken)
{
await PersonAccessor.SetAsync(turnContext, person, cancellationToken);
await UserState.SaveChangesAsync(turnContext, cancellationToken : cancellationToken);
}
