public List<TransportationTypeLanguage> GetAll(int ParentID) { TransportationTypeLanguageDAC _transportationTypeLanguageComponent = new TransportationTypeLanguageDAC(); IDataReader reader = _transportationTypeLanguageComponent.GetAllTransportationTypeLanguage("ParentID=" + ParentID).CreateDataReader(); List<TransportationTypeLanguage> _transportationTypeLanguageList = new List<TransportationTypeLanguage>(); while (reader.Read()) { if (_transportationTypeLanguageList == null) _transportationTypeLanguageList = new List<TransportationTypeLanguage>(); TransportationTypeLanguage _transportationTypeLanguage = new TransportationTypeLanguage(); if (reader["ID"] != DBNull.Value) _transportationTypeLanguage.ID = Convert.ToInt32(reader["ID"]); if (reader["TypeName"] != DBNull.Value) _transportationTypeLanguage.TypeName = Convert.ToString(reader["TypeName"]); if (reader["LanguageID"] != DBNull.Value) _transportationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["ParentID"] != DBNull.Value) _transportationTypeLanguage.ParentID = Convert.ToInt32(reader["ParentID"]); _transportationTypeLanguage.NewRecord = false; _transportationTypeLanguageList.Add(_transportationTypeLanguage); } reader.Close(); return _transportationTypeLanguageList; }
public TransportationTypeLanguage GetByTransportationTypeIDandLanguageId(int ParentID, int LanguageID) { TransportationTypeLanguageDAC _transportationTypeLanguageComponent = new TransportationTypeLanguageDAC(); IDataReader reader = _transportationTypeLanguageComponent.GetAllTransportationTypeLanguage(string.Format("ParentID={0} and LanguageID={1}",ParentID,LanguageID)).CreateDataReader(); TransportationTypeLanguage _transportationTypeLanguage = new TransportationTypeLanguage(); while (reader.Read()) { if (reader["ID"] != DBNull.Value) _transportationTypeLanguage.ID = Convert.ToInt32(reader["ID"]); if (reader["TypeName"] != DBNull.Value) _transportationTypeLanguage.TypeName = Convert.ToString(reader["TypeName"]); if (reader["LanguageID"] != DBNull.Value) _transportationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["ParentID"] != DBNull.Value) _transportationTypeLanguage.ParentID = Convert.ToInt32(reader["ParentID"]); _transportationTypeLanguage.NewRecord = false; } reader.Close(); return _transportationTypeLanguage; }