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; }
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; }
public void Delete(int Original_LookupLanguageId) { LookupLanguagesDAC lookuplanguagesComponent = new LookupLanguagesDAC(); lookuplanguagesComponent.DeleteLookupLanguages(Original_LookupLanguageId); }
public int UpdateDataset(System.Data.DataSet dataset) { LookupLanguagesDAC lookuplanguagescomponent = new LookupLanguagesDAC(); return lookuplanguagescomponent.UpdateDataset(dataset); }
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); }
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); }
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); }
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; }