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 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 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)); }