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()); } }