Esempio n. 1
0
        public bool Insert(int PersonId, string PublicationTitle, string PublicationAbstract, string PublicationAttachmentPath)
        {
            PersonPublicationDAC personpublicationComponent = new PersonPublicationDAC();
            int PersonPublicationId = 0;

            return(personpublicationComponent.InsertNewPersonPublication(ref PersonPublicationId, PersonId, PublicationTitle, PublicationAbstract, PublicationAttachmentPath));
        }
Esempio n. 2
0
        public PersonPublication GetByID(int _personPublicationId)
        {
            PersonPublicationDAC _personPublicationComponent = new PersonPublicationDAC();
            IDataReader          reader             = _personPublicationComponent.GetByIDPersonPublication(_personPublicationId);
            PersonPublication    _personPublication = null;

            while (reader.Read())
            {
                _personPublication = new PersonPublication();
                if (reader["PersonPublicationId"] != DBNull.Value)
                {
                    _personPublication.PersonPublicationId = Convert.ToInt32(reader["PersonPublicationId"]);
                }
                if (reader["PersonId"] != DBNull.Value)
                {
                    _personPublication.PersonId = Convert.ToInt32(reader["PersonId"]);
                }
                if (reader["PublicationTitle"] != DBNull.Value)
                {
                    _personPublication.PublicationTitle = Convert.ToString(reader["PublicationTitle"]);
                }
                if (reader["PublicationAbstract"] != DBNull.Value)
                {
                    _personPublication.PublicationAbstract = Convert.ToString(reader["PublicationAbstract"]);
                }
                if (reader["PublicationAttachmentPath"] != DBNull.Value)
                {
                    _personPublication.PublicationAttachmentPath = Convert.ToString(reader["PublicationAttachmentPath"]);
                }
                _personPublication.NewRecord = false;
            }
            reader.Close();
            return(_personPublication);
        }
Esempio n. 3
0
        public bool Insert(PersonPublication personpublication)
        {
            int autonumber = 0;
            PersonPublicationDAC personpublicationComponent = new PersonPublicationDAC();
            bool endedSuccessfuly = personpublicationComponent.InsertNewPersonPublication(ref autonumber, personpublication.PersonId, personpublication.PublicationTitle, personpublication.PublicationAbstract, personpublication.PublicationAttachmentPath);

            if (endedSuccessfuly)
            {
                personpublication.PersonPublicationId = autonumber;
            }
            return(endedSuccessfuly);
        }
Esempio n. 4
0
        public List <PersonPublication> GetAll()
        {
            PersonPublicationDAC     _personPublicationComponent = new PersonPublicationDAC();
            IDataReader              reader = _personPublicationComponent.GetAllPersonPublication().CreateDataReader();
            List <PersonPublication> _personPublicationList = new List <PersonPublication>();

            while (reader.Read())
            {
                if (_personPublicationList == null)
                {
                    _personPublicationList = new List <PersonPublication>();
                }
                PersonPublication _personPublication = new PersonPublication();
                if (reader["PersonPublicationId"] != DBNull.Value)
                {
                    _personPublication.PersonPublicationId = Convert.ToInt32(reader["PersonPublicationId"]);
                }
                if (reader["PersonId"] != DBNull.Value)
                {
                    _personPublication.PersonId = Convert.ToInt32(reader["PersonId"]);
                }
                if (reader["PublicationTitle"] != DBNull.Value)
                {
                    _personPublication.PublicationTitle = Convert.ToString(reader["PublicationTitle"]);
                }
                if (reader["PublicationAbstract"] != DBNull.Value)
                {
                    _personPublication.PublicationAbstract = Convert.ToString(reader["PublicationAbstract"]);
                }
                if (reader["PublicationAttachmentPath"] != DBNull.Value)
                {
                    _personPublication.PublicationAttachmentPath = Convert.ToString(reader["PublicationAttachmentPath"]);
                }
                _personPublication.NewRecord = false;
                _personPublicationList.Add(_personPublication);
            }
            reader.Close();
            return(_personPublicationList);
        }
Esempio n. 5
0
        public bool Update(int PersonId, string PublicationTitle, string PublicationAbstract, string PublicationAttachmentPath, int Original_PersonPublicationId)
        {
            PersonPublicationDAC personpublicationComponent = new PersonPublicationDAC();

            return(personpublicationComponent.UpdatePersonPublication(PersonId, PublicationTitle, PublicationAbstract, PublicationAttachmentPath, Original_PersonPublicationId));
        }
Esempio n. 6
0
        public bool Update(PersonPublication personpublication, int old_personPublicationId)
        {
            PersonPublicationDAC personpublicationComponent = new PersonPublicationDAC();

            return(personpublicationComponent.UpdatePersonPublication(personpublication.PersonId, personpublication.PublicationTitle, personpublication.PublicationAbstract, personpublication.PublicationAttachmentPath, old_personPublicationId));
        }
Esempio n. 7
0
        public int UpdateDataset(System.Data.DataSet dataset)
        {
            PersonPublicationDAC personpublicationcomponent = new PersonPublicationDAC();

            return(personpublicationcomponent.UpdateDataset(dataset));
        }
Esempio n. 8
0
        public void Delete(int Original_PersonPublicationId)
        {
            PersonPublicationDAC personpublicationComponent = new PersonPublicationDAC();

            personpublicationComponent.DeletePersonPublication(Original_PersonPublicationId);
        }