//
// Get an array of Regist associated with a person id
//
public Person[] GetAllPersonByIdRegist(int idRegist)
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var personMapper = new PersonDataMapper(sqlconn);
var participants = personMapper.GetAllPersonByRegist(idRegist);
return(participants.ToArray());
}
}
//
// Get a Person instance identify by his id
//
public Person GetPerson(int id)
{
try
{
using (var c = new Connect())
{
var personDoa = new PersonDataMapper(c.GetConnection());
return(personDoa.GetById(id));
}
}
catch (Exception exception)
{
throw new FaultException <ServerError>(new ServerError());
}
}
//
// Get an array of all Person in the database
//
public Person[] GetAllPerson(params String[] filters)
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var personDoa = new PersonDataMapper(sqlconn);
// personDoa.GetAll().Where(p => p.Name == filters[0] && p.Birthplace == filters[1]);
return(personDoa.GetAll().ToArray());
}
}
catch (Exception exception)
{
throw new FaultException <ServerError>(new ServerError());
}
}
//
// Insert a Person
//
public int InsertPerson(Person val)
{
try
{
using (var c = new Connect())
{
c.BeginTrx(IsolationLevel.ReadCommitted);
var personDoa = new PersonDataMapper(c.GetConnection());
personDoa.SetTransaction(c.Transaction);
int result = personDoa.Insert(val);
c.Commit();
return(result);
}
}
catch (Exception exception)
{
throw new FaultException <ServerError>(new ServerError());
}
}
//
// Get an array of all Person that match the PersonSearchParams parameters in the database
//
// Argumentos 1º name , 2º birthday , 3º nacionalidade
public PersonSearchResult GetAllPerson(PersonSearchParams personSearchParams)
{
try
{
string[] filters = personSearchParams.filters;
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var personDoa = new PersonDataMapper(sqlconn);
PersonSearchResult sr = new PersonSearchResult();
sr.result = personDoa.GetAll().Where(p => p.Birthplace == filters[2]).ToArray();
return(sr);
}
}
catch (Exception exception)
{
throw new FaultException <ServerError>(new ServerError(), "Server Error ");
}
}
//
// Insert a Person
//
public int InsertPerson(Person val)
{
try
{
using (var c = new Connect())
{
c.BeginTrx(IsolationLevel.ReadCommitted);
var personDoa = new PersonDataMapper(c.GetConnection());
personDoa.SetTransaction(c.Transaction);
int result = personDoa.Insert(val);
c.Commit();
return result;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
//
// Get a Person instance identify by his id
//
public Person GetPerson(int id)
{
try
{
using (var c = new Connect())
{
var personDoa = new PersonDataMapper(c.GetConnection());
return personDoa.GetById(id);
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
//
// Get an array of Regist associated with a person id
//
public Person[] GetAllPersonByIdRegist(int idRegist)
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var personMapper = new PersonDataMapper(sqlconn);
var participants = personMapper.GetAllPersonByRegist(idRegist);
return participants.ToArray();
}
}
//
// Get an array of all Person that match the PersonSearchParams parameters in the database
//
// Argumentos 1º name , 2º birthday , 3º nacionalidade
public PersonSearchResult GetAllPerson(PersonSearchParams personSearchParams)
{
try
{
string[] filters = personSearchParams.filters;
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var personDoa = new PersonDataMapper(sqlconn);
PersonSearchResult sr = new PersonSearchResult();
sr.result = personDoa.GetAll().Where(p => p.Birthplace == filters[2]).ToArray();
return sr;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError(), "Server Error ");
}
}
//
// Get an array of all Person in the database
//
public Person[] GetAllPerson(params String[] filters)
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var personDoa = new PersonDataMapper(sqlconn);
// personDoa.GetAll().Where(p => p.Name == filters[0] && p.Birthplace == filters[1]);
return personDoa.GetAll().ToArray();
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
static void Main(string[] args)
{
try
{
PersonDataMapper personDataMapper = new PersonDataMapper(ConfigurationManager.ConnectionStrings["connectionStringSchool"].ConnectionString);
/*
* personDataMapper.Insert(new Person
* {
* LastName = "Munguia",
* FirstName = "Isack",
* HireDate = DateTime.Now,
* EnrollmentDate = DateTime.Now,
* Discriminator = "Instructor"
* });
*/
List <DataMapper.Models.Person> personas = personDataMapper.GetFiltered("AND FirstName = 'Isack'", "LastName", 10, 1).ToList();
//List<Person> personasConApellidoPerez = personDataMapper.GetFiltered("LastName = 'Perez'", "", int.MaxValue, 1).ToList();
//personas.ForEach(Console.WriteLine);
//ISpecification<DataMapper.Models.Person> personasQueSeLlamanIsack = new ExpressionSpecification<DataMapper.Models.Person>(persona => persona.FirstName == "Isack");
//ISpecification<DataMapper.Models.Person> personasConApellidoSuarez = new ExpressionSpecification<DataMapper.Models.Person>(persona => persona.LastName == "Suarez");
//ISpecification<DataMapper.Models.Person> personasQueNoSonEstudiantes = new ExpressionSpecification<DataMapper.Models.Person>(persona => persona.Discriminator != "Student");
//ISpecification<DataMapper.Models.Person> todasLasEspecificaciones = personasQueSeLlamanIsack.Or(personasConApellidoSuarez).Or(personasQueNoSonEstudiantes);
//personas.FindAll(()=>personasQueSeLlamanIsack.IsSatisfiedBy).ForEach(Console.WriteLine);
//var dataFiltrada = personas.FindAll(persona => todasLasEspecificaciones.IsSatisfiedBy());
//personas.FindAll(persona => new PropertyEqualsSpecification<DataMapper.Models.Person>("Discriminator", "Student").IsSatisfiedBy(persona)).ForEach(Console.WriteLine);
var p1 = new Person {
LastName = "Munguia",
FirstName = "Isack",
HireDate = DateTime.Now,
EnrollmentDate = DateTime.Now,
Discriminator = "Instructor"
};
var p2 = new Person
{
LastName = "Herrera",
FirstName = "Gysela",
HireDate = null,
EnrollmentDate = DateTime.Now,
Discriminator = "Instructor"
};
ISpecification <Person> specification0 = new PersonDiscriminatorSpecification("Instructor");
ISpecification <Person> specification1 = new PersonFirstNameSpecification("Isack");
ISpecification <Person> specification2 = new ExpressionSpecification <Person>(p => p.FirstName.FirstOrDefault().Equals('A'));
ISpecification <Person> specification3 = new ExpressionSpecification <Person>(p => p.LastName.FirstOrDefault().Equals('A'));
var todasLasEspecificaciones = specification3.Or(specification2);
List <Person> persons = new List <Person>();
using (new ContextCreation())
{
var repository = PersonRepository.Instance;
//var itemToCreate = repository.Create(pp);
//var itemToDelete = repository.Delete(specification1);
//var itemToDelete = repository.Delete(p2);
//repository.SaveChanges();
persons = repository.Filter(todasLasEspecificaciones).ToList();
//var updateResult = repository.Update(p2);
}
Console.WriteLine($"{nameof(persons)}: {persons.Count}");
persons.ToList().ForEach(Console.WriteLine);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
Console.ReadKey();
}
}