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