public List<Travellanguage> GetAll(int ParentID) { TravellanguageDAC _travellanguageComponent = new TravellanguageDAC(); IDataReader reader = _travellanguageComponent.GetAllTravellanguage("ParentID=" + ParentID).CreateDataReader(); List<Travellanguage> _travellanguageList = new List<Travellanguage>(); while (reader.Read()) { if (_travellanguageList == null) _travellanguageList = new List<Travellanguage>(); Travellanguage _travellanguage = new Travellanguage(); if (reader["ID"] != DBNull.Value) _travellanguage.ID = Convert.ToInt32(reader["ID"]); if (reader["Name"] != DBNull.Value) _travellanguage.Name = Convert.ToString(reader["Name"]); if (reader["TransportationTypeID"] != DBNull.Value) _travellanguage.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]); if (reader["Description"] != DBNull.Value) _travellanguage.Description = Convert.ToString(reader["Description"]); if (reader["ParentID"] != DBNull.Value) _travellanguage.ParentID = Convert.ToInt32(reader["ParentID"]); if (reader["LanguageID"] != DBNull.Value) _travellanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); _travellanguage.NewRecord = false; _travellanguageList.Add(_travellanguage); } reader.Close(); return _travellanguageList; }
public Travellanguage GetByLanguageId(int id) { Travellanguage lang = new Travellanguage(); var availableLanguages = from x in CurrentTravellanguages where x.LanguageID == id select x; foreach (Travellanguage l in availableLanguages) { lang = l; } return(lang); }
public Travellanguage GetByID(int _iD) { TravellanguageDAC _travellanguageComponent = new TravellanguageDAC(); IDataReader reader = _travellanguageComponent.GetByIDTravellanguage(_iD); Travellanguage _travellanguage = null; while(reader.Read()) { _travellanguage = new Travellanguage(); if(reader["ID"] != DBNull.Value) _travellanguage.ID = Convert.ToInt32(reader["ID"]); if(reader["Name"] != DBNull.Value) _travellanguage.Name = Convert.ToString(reader["Name"]); if(reader["TransportationTypeID"] != DBNull.Value) _travellanguage.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]); if(reader["Description"] != DBNull.Value) _travellanguage.Description = Convert.ToString(reader["Description"]); if(reader["ParentID"] != DBNull.Value) _travellanguage.ParentID = Convert.ToInt32(reader["ParentID"]); if(reader["LanguageID"] != DBNull.Value) _travellanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); _travellanguage.NewRecord = false; } reader.Close(); return _travellanguage; }
public bool Update(Travellanguage travellanguage ,int old_iD) { TravellanguageDAC travellanguageComponent = new TravellanguageDAC(); return travellanguageComponent.UpdateTravellanguage( travellanguage.Name, travellanguage.TransportationTypeID, travellanguage.Description, travellanguage.ParentID, travellanguage.LanguageID, old_iD); }
public bool Insert(Travellanguage travellanguage) { int autonumber = 0; TravellanguageDAC travellanguageComponent = new TravellanguageDAC(); bool endedSuccessfuly = travellanguageComponent.InsertNewTravellanguage( ref autonumber, travellanguage.Name, travellanguage.TransportationTypeID, travellanguage.Description, travellanguage.ParentID, travellanguage.LanguageID); if(endedSuccessfuly) { travellanguage.ID = autonumber; } return endedSuccessfuly; }
public Travellanguage GetByLanguageId(int id) { Travellanguage lang = new Travellanguage(); var availableLanguages = from x in CurrentTravellanguages where x.LanguageID == id select x; foreach (Travellanguage l in availableLanguages) { lang = l; } return lang; }