コード例 #1
0
        public List <ContactPerson> GetContactPersonById(int id)
        {
            DBConnection         connection = null;
            MySqlCommand         command    = null;
            MySqlDataReader      reader     = null;
            List <ContactPerson> result     = new List <ContactPerson>();

            try
            {
                connection          = new DBConnection();
                command             = connection.GetConnection().CreateCommand();
                command.CommandText = "SELECT * FROM contact_person WHERE id_societe = @idsociete";
                command.Parameters.AddWithValue("@idsociete", id);
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    ContactPerson contact = new ContactPerson();
                    contact.SetId(reader.GetInt32(0));
                    contact.SetIdSociete(reader.GetInt32(1));
                    contact.SetNomPersonne(reader.GetString(2));
                    contact.SetPoste(reader.GetString(3));
                    result.Add(contact);
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                try
                {
                    if (reader != null)
                    {
                        reader.Close();
                    }
                    if (command != null)
                    {
                        command.Dispose();
                    }
                    if (connection != null)
                    {
                        connection.CloseConnection();
                    }
                }
                catch (Exception)
                {
                    throw;
                }
            }
            return(result);
        }