public IEnumerable<DataContracts.IPerson> Search(PersonSearchParameters parameters)
{
var people = new List<IPerson>();
using (var connection = new SqlConnection(base.ConnectionString))
{
using (var command = new SqlCommand("sp_PersonSearch", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@firstName", (object)parameters.FirstName ?? DBNull.Value);
command.Parameters.AddWithValue("@middleName", (object)parameters.MiddleName ?? DBNull.Value);
command.Parameters.AddWithValue("@lastName", (object)parameters.LastName ?? DBNull.Value);
var adapter = new PersonAdapter();
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
people.Add((Person)adapter.Resolve(new Person(), reader));
}
}
}
return people;
}
public IEnumerable<DataContracts.IPerson> Search(PersonSearchParameters parameters)
{
throw new NotImplementedException();
}
