public void CheckPersonWithIdGreaterThan2AndLessThan4()
{
List<IPerson> mockPersons = table.GetTable().Where(p => p.Id > 2 && p.Id < 4).ToList();
using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
{
conn.Open();
IList<Person> persons = conn.GetList<Person>("Select Id,Name From PERSON Where Id > @from and Id < @to",
new { from = 2, to = 4 });
}
}
public ICollection<Rule> GetRules()
{
using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var list = connection.GetList<Rule>();
connection.Close();
return list.ToList();
}
}
public IList<Model.Entities.UserModule> GetAllUserModuleByLdapUser(Model.Entities.UserModule userModule)
{
IEnumerable<UserModule> result = new List<UserModule>();
using (SqlConnection cn = new SqlConnection(ApplicationConfiguration.ConnectionString))
{
cn.Open();
var predicateGroup = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List<IPredicate>() };
predicateGroup.Predicates.Add(Predicates.Field<UserModule>(f => f.LdapName, Operator.Eq, userModule.LdapName));
result = cn.GetList<UserModule>(predicateGroup);
cn.Close();
}
return result.ToList();
}
public void CheckPersonWithNameLikeM()
{
List<IPerson> mockPersons = table.GetTable().Where(p => p.Name.StartsWith("M")).ToList();
using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
{
conn.Open();
var persons = conn.GetList<Person>("Select Id,Name From PERSON Where Name like 'M%'");
Assert.AreEqual(mockPersons.Count, persons.Count);
for (int i = 0; mockPersons.Count > i; i++)
{
Assert.AreEqual(mockPersons[i].Id, persons[i].Id);
Assert.AreEqual(mockPersons[i].Name, persons[i].Name);
}
}
}
public void NullDOB()
{
using (SqlConnection conn = new SqlConnection(SqlServerUtility.ConnectionString))
{
conn.Open();
Assert.DoesNotThrow(() =>
{
conn.GetList<Person>("Select NULL as DateOfBirth From PERSON");
});
}
}
