public List <ConferenceCategoryLanguage> GetAll(int ParentID) { ConferenceCategoryLanguageDAC _conferenceCategoryLanguageComponent = new ConferenceCategoryLanguageDAC(); IDataReader reader = _conferenceCategoryLanguageComponent.GetAllConferenceCategoryLanguage("ConferenceCategoryParentID=" + ParentID).CreateDataReader(); List <ConferenceCategoryLanguage> _conferenceCategoryLanguageList = new List <ConferenceCategoryLanguage>(); while (reader.Read()) { if (_conferenceCategoryLanguageList == null) { _conferenceCategoryLanguageList = new List <ConferenceCategoryLanguage>(); } ConferenceCategoryLanguage _conferenceCategoryLanguage = new ConferenceCategoryLanguage(); if (reader["ConferenceCategoryId"] != DBNull.Value) { _conferenceCategoryLanguage.ConferenceCategoryId = Convert.ToInt32(reader["ConferenceCategoryId"]); } if (reader["CategoryName"] != DBNull.Value) { _conferenceCategoryLanguage.CategoryName = Convert.ToString(reader["CategoryName"]); } if (reader["ConferenceId"] != DBNull.Value) { _conferenceCategoryLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } if (reader["LanguageID"] != DBNull.Value) { _conferenceCategoryLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } if (reader["ConferenceCategoryParentID"] != DBNull.Value) { _conferenceCategoryLanguage.ConferenceCategoryParentID = Convert.ToInt32(reader["ConferenceCategoryParentID"]); } _conferenceCategoryLanguage.NewRecord = false; _conferenceCategoryLanguageList.Add(_conferenceCategoryLanguage); } reader.Close(); return(_conferenceCategoryLanguageList); }