public List <ConferenceMediaReference> GetAll(int ConferenceId, int LanguageId)
        {
            ConferenceMediaReferenceDAC _conferenceMediaReferenceComponent = new ConferenceMediaReferenceDAC();
            IDataReader reader = _conferenceMediaReferenceComponent.GetAllConferenceMediaReference(string.Format("ConferenceId = {0} and LanguageId = {1}", ConferenceId, LanguageId)).CreateDataReader();
            List <ConferenceMediaReference> _conferenceMediaReferenceList = new List <ConferenceMediaReference>();

            while (reader.Read())
            {
                if (_conferenceMediaReferenceList == null)
                {
                    _conferenceMediaReferenceList = new List <ConferenceMediaReference>();
                }
                ConferenceMediaReference _conferenceMediaReference = new ConferenceMediaReference();
                if (reader["ConferenceMediaReferenceId"] != DBNull.Value)
                {
                    _conferenceMediaReference.ConferenceMediaReferenceId = Convert.ToInt32(reader["ConferenceMediaReferenceId"]);
                }
                if (reader["ConferenceId"] != DBNull.Value)
                {
                    _conferenceMediaReference.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
                }
                if (reader["LanguageId"] != DBNull.Value)
                {
                    _conferenceMediaReference.LanguageId = Convert.ToInt32(reader["LanguageId"]);
                }
                if (reader["ReferenceOrder"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceOrder = Convert.ToInt32(reader["ReferenceOrder"]);
                }
                if (reader["Title"] != DBNull.Value)
                {
                    _conferenceMediaReference.Title = Convert.ToString(reader["Title"]);
                }
                if (reader["ReferenceUrl"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceUrl = Convert.ToString(reader["ReferenceUrl"]);
                }
                if (reader["ReferenceName"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceName = Convert.ToString(reader["ReferenceName"]);
                }
                if (reader["ReferenceLogo"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceLogo = Convert.ToString(reader["ReferenceLogo"]);
                }
                if (reader["PublishingDate"] != DBNull.Value)
                {
                    _conferenceMediaReference.PublishingDate = Convert.ToDateTime(reader["PublishingDate"]);
                }
                _conferenceMediaReference.NewRecord = false;
                _conferenceMediaReferenceList.Add(_conferenceMediaReference);
            }
            reader.Close();
            return(_conferenceMediaReferenceList);
        }
        public bool Insert(ConferenceMediaReference conferencemediareference)
        {
            int autonumber = 0;
            ConferenceMediaReferenceDAC conferencemediareferenceComponent = new ConferenceMediaReferenceDAC();
            bool endedSuccessfuly = conferencemediareferenceComponent.InsertNewConferenceMediaReference(ref autonumber, conferencemediareference.ConferenceId, conferencemediareference.LanguageId, conferencemediareference.ReferenceOrder, conferencemediareference.Title, conferencemediareference.ReferenceUrl, conferencemediareference.ReferenceName, conferencemediareference.ReferenceLogo, conferencemediareference.PublishingDate);

            if (endedSuccessfuly)
            {
                conferencemediareference.ConferenceMediaReferenceId = autonumber;
            }
            return(endedSuccessfuly);
        }
        public ConferenceMediaReference GetByID(int _conferenceMediaReferenceId)
        {
            ConferenceMediaReferenceDAC _conferenceMediaReferenceComponent = new ConferenceMediaReferenceDAC();
            IDataReader reader = _conferenceMediaReferenceComponent.GetByIDConferenceMediaReference(_conferenceMediaReferenceId);
            ConferenceMediaReference _conferenceMediaReference = null;

            while (reader.Read())
            {
                _conferenceMediaReference = new ConferenceMediaReference();
                if (reader["ConferenceMediaReferenceId"] != DBNull.Value)
                {
                    _conferenceMediaReference.ConferenceMediaReferenceId = Convert.ToInt32(reader["ConferenceMediaReferenceId"]);
                }
                if (reader["ConferenceId"] != DBNull.Value)
                {
                    _conferenceMediaReference.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
                }
                if (reader["LanguageId"] != DBNull.Value)
                {
                    _conferenceMediaReference.LanguageId = Convert.ToInt32(reader["LanguageId"]);
                }
                if (reader["ReferenceOrder"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceOrder = Convert.ToInt32(reader["ReferenceOrder"]);
                }
                if (reader["Title"] != DBNull.Value)
                {
                    _conferenceMediaReference.Title = Convert.ToString(reader["Title"]);
                }
                if (reader["ReferenceUrl"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceUrl = Convert.ToString(reader["ReferenceUrl"]);
                }
                if (reader["ReferenceName"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceName = Convert.ToString(reader["ReferenceName"]);
                }
                if (reader["ReferenceLogo"] != DBNull.Value)
                {
                    _conferenceMediaReference.ReferenceLogo = Convert.ToString(reader["ReferenceLogo"]);
                }
                if (reader["PublishingDate"] != DBNull.Value)
                {
                    _conferenceMediaReference.PublishingDate = Convert.ToDateTime(reader["PublishingDate"]);
                }
                _conferenceMediaReference.NewRecord = false;
            }
            reader.Close();
            return(_conferenceMediaReference);
        }
        public bool Update(ConferenceMediaReference conferencemediareference, int old_conferenceMediaReferenceId)
        {
            ConferenceMediaReferenceDAC conferencemediareferenceComponent = new ConferenceMediaReferenceDAC();

            return(conferencemediareferenceComponent.UpdateConferenceMediaReference(conferencemediareference.ConferenceId, conferencemediareference.LanguageId, conferencemediareference.ReferenceOrder, conferencemediareference.Title, conferencemediareference.ReferenceUrl, conferencemediareference.ReferenceName, conferencemediareference.ReferenceLogo, conferencemediareference.PublishingDate, old_conferenceMediaReferenceId));
        }