public List<AirLineLanguage> GetAll(int ParentID) { AirLineLanguageDAC _airLineLanguageComponent = new AirLineLanguageDAC(); IDataReader reader = _airLineLanguageComponent.GetAllAirLineLanguage("AirLineParentID="+ParentID).CreateDataReader(); List<AirLineLanguage> _airLineLanguageList = new List<AirLineLanguage>(); while (reader.Read()) { if (_airLineLanguageList == null) _airLineLanguageList = new List<AirLineLanguage>(); AirLineLanguage _airLineLanguage = new AirLineLanguage(); if (reader["ID"] != DBNull.Value) _airLineLanguage.ID = Convert.ToInt32(reader["ID"]); if (reader["Name"] != DBNull.Value) _airLineLanguage.Name = Convert.ToString(reader["Name"]); if (reader["LanguageID"] != DBNull.Value) _airLineLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["AirLineParentID"] != DBNull.Value) _airLineLanguage.AirLineParentID = Convert.ToInt32(reader["AirLineParentID"]); _airLineLanguage.NewRecord = false; _airLineLanguageList.Add(_airLineLanguage); } reader.Close(); return _airLineLanguageList; }
public AirLineLanguage GetByID(int _iD) { AirLineLanguageDAC _airLineLanguageComponent = new AirLineLanguageDAC(); IDataReader reader = _airLineLanguageComponent.GetByIDAirLineLanguage(_iD); AirLineLanguage _airLineLanguage = null; while(reader.Read()) { _airLineLanguage = new AirLineLanguage(); if(reader["ID"] != DBNull.Value) _airLineLanguage.ID = Convert.ToInt32(reader["ID"]); if(reader["Name"] != DBNull.Value) _airLineLanguage.Name = Convert.ToString(reader["Name"]); if(reader["LanguageID"] != DBNull.Value) _airLineLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if(reader["AirLineParentID"] != DBNull.Value) _airLineLanguage.AirLineParentID = Convert.ToInt32(reader["AirLineParentID"]); _airLineLanguage.NewRecord = false; } reader.Close(); return _airLineLanguage; }
public bool Update(AirLineLanguage airlinelanguage ,int old_iD) { AirLineLanguageDAC airlinelanguageComponent = new AirLineLanguageDAC(); return airlinelanguageComponent.UpdateAirLineLanguage( airlinelanguage.Name, airlinelanguage.LanguageID, airlinelanguage.AirLineParentID, old_iD); }
public bool Insert(AirLineLanguage airlinelanguage) { int autonumber = 0; AirLineLanguageDAC airlinelanguageComponent = new AirLineLanguageDAC(); bool endedSuccessfuly = airlinelanguageComponent.InsertNewAirLineLanguage( ref autonumber, airlinelanguage.Name, airlinelanguage.LanguageID, airlinelanguage.AirLineParentID); if(endedSuccessfuly) { airlinelanguage.ID = autonumber; } return endedSuccessfuly; }