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 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); }
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 bool Update(ConferenceCategoryLanguage conferencecategorylanguage, int old_conferenceCategoryId) { ConferenceCategoryLanguageDAC conferencecategorylanguageComponent = new ConferenceCategoryLanguageDAC(); return(conferencecategorylanguageComponent.UpdateConferenceCategoryLanguage(conferencecategorylanguage.CategoryName, conferencecategorylanguage.ConferenceId, conferencecategorylanguage.LanguageID, conferencecategorylanguage.ConferenceCategoryParentID, old_conferenceCategoryId)); }