コード例 #1
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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();
            }
        }
コード例 #2
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
 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());
     }
 }
コード例 #3
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
 //
 //  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());
     }
 }
コード例 #4
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #5
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #6
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #7
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #8
0
ファイル: Broker.cs プロジェクト: ProjectoFinal/PS
        //
        // 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());
            }
        }
コード例 #9
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
 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());
     }
 }
コード例 #10
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #11
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #12
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        //
        // 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();
            }
        }
コード例 #13
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        //
        // 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 ");
            }
        }
コード例 #14
0
ファイル: Broker.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #15
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
 //
 // 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());
     }
 }
コード例 #16
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #17
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        //
        // 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());
            }
        }
コード例 #18
0
ファイル: Server.svc.cs プロジェクト: ProjectoFinal/PS
        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());
            }
        }
コード例 #19
0
ファイル: Broker.cs プロジェクト: ProjectoFinal/PS
        //
        // 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());
            }
        }