Esempio n. 1
0
        public bool Insert(int LookupId, int LanguageId, int RefId, string LookupValue, string LookupValueDescription)
        {
            LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
            int LookupLanguageId = 0;

            return(lookuplanguagesComponent.InsertNewLookupLanguages(ref LookupLanguageId, LookupId, LanguageId, RefId, LookupValue, LookupValueDescription));
        }
Esempio n. 2
0
        public bool Insert(LookupLanguages lookuplanguages)
        {
            int autonumber = 0;
            LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();
            bool endedSuccessfuly = lookuplanguagesComponent.InsertNewLookupLanguages(ref autonumber, lookuplanguages.LookupId, lookuplanguages.LanguageId, lookuplanguages.RefId, lookuplanguages.LookupValue, lookuplanguages.LookupValueDescription);

            if (endedSuccessfuly)
            {
                lookuplanguages.LookupLanguageId = autonumber;
            }
            return(endedSuccessfuly);
        }
Esempio n. 3
0
        public List <LookupLanguages> GetAllByLookupName(string LookupName, int LanguageId)
        {
            LookupLanguagesDAC     _lookupLanguagesComponent = new LookupLanguagesDAC();
            IDataReader            reader = _lookupLanguagesComponent.GetByLanguageIDLookupLanguages(LookupName, LanguageId);
            List <LookupLanguages> _lookupLanguagesList = new List <LookupLanguages>();

            while (reader.Read())
            {
                if (_lookupLanguagesList == null)
                {
                    _lookupLanguagesList = new List <LookupLanguages>();
                }
                LookupLanguages _lookupLanguages = new LookupLanguages();
                if (reader["LookupLanguageId"] != DBNull.Value)
                {
                    _lookupLanguages.LookupLanguageId = Convert.ToInt32(reader["LookupLanguageId"]);
                }
                if (reader["LookupId"] != DBNull.Value)
                {
                    _lookupLanguages.LookupId = Convert.ToInt32(reader["LookupId"]);
                }
                if (reader["LanguageId"] != DBNull.Value)
                {
                    _lookupLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
                }
                if (reader["RefId"] != DBNull.Value)
                {
                    _lookupLanguages.RefId = Convert.ToInt32(reader["RefId"]);
                }
                if (reader["LookupValue"] != DBNull.Value)
                {
                    _lookupLanguages.LookupValue = Convert.ToString(reader["LookupValue"]);
                }
                if (reader["LookupValueDescription"] != DBNull.Value)
                {
                    _lookupLanguages.LookupValueDescription = Convert.ToString(reader["LookupValueDescription"]);
                }
                _lookupLanguages.NewRecord = false;
                _lookupLanguagesList.Add(_lookupLanguages);
            }
            reader.Close();
            return(_lookupLanguagesList);
        }
Esempio n. 4
0
        public LookupLanguages GetByID(int _lookupLanguageId)
        {
            LookupLanguagesDAC _lookupLanguagesComponent = new LookupLanguagesDAC();
            IDataReader        reader           = _lookupLanguagesComponent.GetByIDLookupLanguages(_lookupLanguageId);
            LookupLanguages    _lookupLanguages = null;

            while (reader.Read())
            {
                _lookupLanguages = new LookupLanguages();
                if (reader["LookupLanguageId"] != DBNull.Value)
                {
                    _lookupLanguages.LookupLanguageId = Convert.ToInt32(reader["LookupLanguageId"]);
                }
                if (reader["LookupId"] != DBNull.Value)
                {
                    _lookupLanguages.LookupId = Convert.ToInt32(reader["LookupId"]);
                }
                if (reader["LanguageId"] != DBNull.Value)
                {
                    _lookupLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
                }
                if (reader["RefId"] != DBNull.Value)
                {
                    _lookupLanguages.RefId = Convert.ToInt32(reader["RefId"]);
                }
                if (reader["LookupValue"] != DBNull.Value)
                {
                    _lookupLanguages.LookupValue = Convert.ToString(reader["LookupValue"]);
                }
                if (reader["LookupValueDescription"] != DBNull.Value)
                {
                    _lookupLanguages.LookupValueDescription = Convert.ToString(reader["LookupValueDescription"]);
                }
                _lookupLanguages.NewRecord = false;
            }
            reader.Close();
            return(_lookupLanguages);
        }
Esempio n. 5
0
        public int UpdateDataset(System.Data.DataSet dataset)
        {
            LookupLanguagesDAC lookuplanguagescomponent = new LookupLanguagesDAC();

            return(lookuplanguagescomponent.UpdateDataset(dataset));
        }
Esempio n. 6
0
        public void Delete(int Original_LookupLanguageId)
        {
            LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();

            lookuplanguagesComponent.DeleteLookupLanguages(Original_LookupLanguageId);
        }
Esempio n. 7
0
        public bool Update(int LookupId, int LanguageId, int RefId, string LookupValue, string LookupValueDescription, int Original_LookupLanguageId)
        {
            LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();

            return(lookuplanguagesComponent.UpdateLookupLanguages(LookupId, LanguageId, RefId, LookupValue, LookupValueDescription, Original_LookupLanguageId));
        }
Esempio n. 8
0
        public bool Update(LookupLanguages lookuplanguages, int old_lookupLanguageId)
        {
            LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC();

            return(lookuplanguagesComponent.UpdateLookupLanguages(lookuplanguages.LookupId, lookuplanguages.LanguageId, lookuplanguages.RefId, lookuplanguages.LookupValue, lookuplanguages.LookupValueDescription, old_lookupLanguageId));
        }