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; }
public ConferenceCategoryLanguage GetByID(int _conferenceCategoryId) { ConferenceCategoryLanguageDAC _conferenceCategoryLanguageComponent = new ConferenceCategoryLanguageDAC(); IDataReader reader = _conferenceCategoryLanguageComponent.GetByIDConferenceCategoryLanguage(_conferenceCategoryId); ConferenceCategoryLanguage _conferenceCategoryLanguage = null; while(reader.Read()) { _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; } reader.Close(); return _conferenceCategoryLanguage; }
public bool Update(ConferenceCategoryLanguage conferencecategorylanguage ,int old_conferenceCategoryId) { ConferenceCategoryLanguageDAC conferencecategorylanguageComponent = new ConferenceCategoryLanguageDAC(); return conferencecategorylanguageComponent.UpdateConferenceCategoryLanguage( conferencecategorylanguage.CategoryName, conferencecategorylanguage.ConferenceId, conferencecategorylanguage.LanguageID, conferencecategorylanguage.ConferenceCategoryParentID, old_conferenceCategoryId); }
public bool Insert(ConferenceCategoryLanguage conferencecategorylanguage) { int autonumber = 0; ConferenceCategoryLanguageDAC conferencecategorylanguageComponent = new ConferenceCategoryLanguageDAC(); bool endedSuccessfuly = conferencecategorylanguageComponent.InsertNewConferenceCategoryLanguage( ref autonumber, conferencecategorylanguage.CategoryName, conferencecategorylanguage.ConferenceId, conferencecategorylanguage.LanguageID, conferencecategorylanguage.ConferenceCategoryParentID); if(endedSuccessfuly) { conferencecategorylanguage.ConferenceCategoryId = autonumber; } return endedSuccessfuly; }