public CrimeType[] GetAllCrimeTypeByRegist(int idRegist)
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
RegistDataMapper registDataMapper = new RegistDataMapper(sqlconn);
var crimes = registDataMapper.GetCrimeType(idRegist);
return crimes.ToArray();
}
}
public CrimeType[] GetAllCrimeType()
{
try
{
using (var c = new Connect())
{
SqlConnection sqlconn = c.GetConnection();
var crimeMapper = new CrimeTypeDataMapper(sqlconn);
IEnumerable<CrimeType> list = crimeMapper.GetAll();
return list.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());
}
}
public int InsertParticipant(Participant val)
{
try
{
using (var c = new Connect())
{
c.BeginTrx();
var partiMapper = new ParticipantDataMapper(c.GetConnection());
partiMapper.SetTransaction(c.Transaction);
int ret = partiMapper.Insert(val);
c.Commit();
return ret;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public int InsertDocument(Document doc)
{
try
{
using (var connect = new Connect())
{
connect.BeginTrx();
SqlConnection sqlconn = connect.GetConnection();
var docmapper = new DocumentDataMapper(sqlconn);
docmapper.SetTransaction(connect.Transaction);
int ret = docmapper.Insert(doc);
connect.Commit();
return ret;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public int InsertBiometricType(BiometricType val)
{
try
{
using (var connect = new Connect())
{
connect.BeginTrx();
SqlConnection sqlconn = connect.GetConnection();
var bioDao = new BiometricTypeDataMapper(sqlconn);
bioDao.SetTransaction(connect.Transaction);
int result = bioDao.Insert(val);
connect.Commit();
return result;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public Regist[] GetRegists(int person_id)
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var registMapper = new RegistDataMapper(sqlconn);
IEnumerable<Regist> regist = registMapper.GetRegistsByPerson(person_id);
return regist.ToArray();
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
//
// Get an array of Regist associated with a person id
//
public Regist[] GetRegists(int person_id)
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var registMapper = new RegistDataMapper(sqlconn);
var crimeTypeMapper = new CrimeTypeDataMapper(sqlconn);
var partiMapper = new ParticipantDataMapper(sqlconn);
IEnumerable<Participant> participants = partiMapper.GetAll().Where(p => p.Person.Id == person_id);
var regists = new List<Regist>();
foreach (Participant part in participants)
{
regists.Add(registMapper.GetById(part.Regist.Id));
}
foreach (Regist r in regists)
{
foreach (Participant p in partiMapper.GetAll().Where(part => part.Regist.Id == r.Id))
{
r.AddParticipant(p);
}
r.SetParticipants();
}
return regists.ToArray();
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public BiometricType[] GetBiometricTypes(int person_id)
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var bioDao = new BiometricTypeDataMapper(sqlconn);
return bioDao.GetAll().Where(bio => bio.Person.Id == person_id).ToArray();
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public BiometricType GetBiometricType(int person_id, string name)
{
try
{
name = name.ToLower();
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var bioDao = new BiometricTypeDataMapper(sqlconn);
return bioDao.GetAll().FirstOrDefault(
bio =>
bio.Person.Id == person_id && bio.Name.ToLower().Equals(name));
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public Regist[] GetAllRegists()
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var registMapper = new RegistDataMapper(sqlconn);
var regists = registMapper.GetAll();
if (regists == null) return null;
return regists.ToArray();
}
}
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 ");
}
}
public string SignIn(Credential credential)
{
try
{
string user = credential.user;
string pass = credential.pass;
if (PdpUserProvider.IsValidUser(user, pass))
{
Interlocked.Increment(ref actives_users);
Interlocked.Increment(ref accesscounter);
Session session = new Session();
session.user = user;
using (var connect = new Connect())
{
connect.BeginTrx();
SqlConnection sqlconn = connect.GetConnection();
var smapper = new SessionDataMapper(sqlconn);
smapper.SetTransaction(connect.Transaction);
//smapper.Insert(session);
}
return authProvider.AutenticateUser(credential);
}
return null;
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
//
// Insert a Regist
//
public int InsertRegist(Regist val)
{
try
{
using (var c = new Connect())
{
c.BeginTrx();
var registMapper = new RegistDataMapper(c.GetConnection());
registMapper.SetTransaction(c.Transaction);
int result = registMapper.Insert(val);
c.Commit();
return result;
}
}
catch (Exception exception)
{
throw new FaultException<ServerError>(new ServerError());
}
}
public int GetNumberOfParticipants(int idRegist)
{
try
{
using (var connect = new Connect())
{
SqlConnection sqlconn = connect.GetConnection();
var partiMapper = new ParticipantDataMapper(sqlconn);
return partiMapper.GetCountParticipants(idRegist);
}
}
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());
}
}
public Document[] GetAllDocumentPerson(int idperson)
{
try
{
using (var c = new Connect())
{
SqlConnection sqlconn = c.GetConnection();
var mapper = new DocumentDataMapper(sqlconn);
IEnumerable<Document> list = mapper.GetAll().Where(d => d.Person.Id == idperson);
return list.ToArray();
}
}
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());
}
}
