示例#1
0
        public bool Insert(AbstractAuthorsLanguage abstractauthorslanguage)
        {
            int autonumber = 0;
            AbstractAuthorsLanguageDAC abstractauthorslanguageComponent = new AbstractAuthorsLanguageDAC();
            bool endedSuccessfuly = abstractauthorslanguageComponent.InsertNewAbstractAuthorsLanguage(ref autonumber, abstractauthorslanguage.AbstractAuthorId, abstractauthorslanguage.FirstName, abstractauthorslanguage.FamilyName, abstractauthorslanguage.Title, abstractauthorslanguage.Degree, abstractauthorslanguage.Email, abstractauthorslanguage.Address, abstractauthorslanguage.AffilitationDepartment, abstractauthorslanguage.AffilitationInstitutionHospital, abstractauthorslanguage.AffilitationCity, abstractauthorslanguage.AffilitationCountry, abstractauthorslanguage.Country, abstractauthorslanguage.POBox, abstractauthorslanguage.ZipCode, abstractauthorslanguage.City, abstractauthorslanguage.LanguageID);

            if (endedSuccessfuly)
            {
                abstractauthorslanguage.AbstractAuthorLanguageId = autonumber;
            }
            return(endedSuccessfuly);
        }
示例#2
0
        public List <AbstractAuthorsLanguage> GetAll()
        {
            AbstractAuthorsLanguageDAC _abstractAuthorsLanguageComponent = new AbstractAuthorsLanguageDAC();
            IDataReader reader = _abstractAuthorsLanguageComponent.GetAllAbstractAuthorsLanguage().CreateDataReader();
            List <AbstractAuthorsLanguage> _abstractAuthorsLanguageList = new List <AbstractAuthorsLanguage>();

            while (reader.Read())
            {
                if (_abstractAuthorsLanguageList == null)
                {
                    _abstractAuthorsLanguageList = new List <AbstractAuthorsLanguage>();
                }
                AbstractAuthorsLanguage _abstractAuthorsLanguage = new AbstractAuthorsLanguage();
                if (reader["AbstractAuthorLanguageId"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.AbstractAuthorLanguageId = Convert.ToInt32(reader["AbstractAuthorLanguageId"]);
                }
                if (reader["AbstractAuthorId"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.AbstractAuthorId = Convert.ToInt32(reader["AbstractAuthorId"]);
                }
                if (reader["FirstName"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.FirstName = Convert.ToString(reader["FirstName"]);
                }
                if (reader["FamilyName"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.FamilyName = Convert.ToString(reader["FamilyName"]);
                }
                if (reader["Title"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.Title = Convert.ToString(reader["Title"]);
                }
                if (reader["Degree"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.Degree = Convert.ToString(reader["Degree"]);
                }
                if (reader["Email"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.Email = Convert.ToString(reader["Email"]);
                }
                if (reader["Address"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.Address = Convert.ToString(reader["Address"]);
                }
                if (reader["AffilitationDepartment"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.AffilitationDepartment = Convert.ToString(reader["AffilitationDepartment"]);
                }
                if (reader["AffilitationInstitutionHospital"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.AffilitationInstitutionHospital = Convert.ToString(reader["AffilitationInstitutionHospital"]);
                }
                if (reader["AffilitationCity"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.AffilitationCity = Convert.ToString(reader["AffilitationCity"]);
                }
                if (reader["AffilitationCountry"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.AffilitationCountry = Convert.ToString(reader["AffilitationCountry"]);
                }
                if (reader["Country"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.Country = Convert.ToString(reader["Country"]);
                }
                if (reader["POBox"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.POBox = Convert.ToString(reader["POBox"]);
                }
                if (reader["ZipCode"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.ZipCode = Convert.ToString(reader["ZipCode"]);
                }
                if (reader["City"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.City = Convert.ToString(reader["City"]);
                }
                if (reader["LanguageID"] != DBNull.Value)
                {
                    _abstractAuthorsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
                }
                _abstractAuthorsLanguage.NewRecord = false;
                _abstractAuthorsLanguageList.Add(_abstractAuthorsLanguage);
            }
            reader.Close();
            return(_abstractAuthorsLanguageList);
        }
示例#3
0
        public bool Update(AbstractAuthorsLanguage abstractauthorslanguage, int old_abstractAuthorLanguageId)
        {
            AbstractAuthorsLanguageDAC abstractauthorslanguageComponent = new AbstractAuthorsLanguageDAC();

            return(abstractauthorslanguageComponent.UpdateAbstractAuthorsLanguage(abstractauthorslanguage.AbstractAuthorId, abstractauthorslanguage.FirstName, abstractauthorslanguage.FamilyName, abstractauthorslanguage.Title, abstractauthorslanguage.Degree, abstractauthorslanguage.Email, abstractauthorslanguage.Address, abstractauthorslanguage.AffilitationDepartment, abstractauthorslanguage.AffilitationInstitutionHospital, abstractauthorslanguage.AffilitationCity, abstractauthorslanguage.AffilitationCountry, abstractauthorslanguage.Country, abstractauthorslanguage.POBox, abstractauthorslanguage.ZipCode, abstractauthorslanguage.City, abstractauthorslanguage.LanguageID, old_abstractAuthorLanguageId));
        }