public List<ConferenceHallsLanguage> GetAll(int ParentID) { ConferenceHallsLanguageDAC _conferenceHallsLanguageComponent = new ConferenceHallsLanguageDAC(); IDataReader reader = _conferenceHallsLanguageComponent.GetAllConferenceHallsLanguage("ConferenceHallsParentID="+ParentID).CreateDataReader(); List<ConferenceHallsLanguage> _conferenceHallsLanguageList = new List<ConferenceHallsLanguage>(); while (reader.Read()) { if (_conferenceHallsLanguageList == null) _conferenceHallsLanguageList = new List<ConferenceHallsLanguage>(); ConferenceHallsLanguage _conferenceHallsLanguage = new ConferenceHallsLanguage(); if (reader["ConferenceHallsId"] != DBNull.Value) _conferenceHallsLanguage.ConferenceHallsId = Convert.ToInt32(reader["ConferenceHallsId"]); if (reader["Name"] != DBNull.Value) _conferenceHallsLanguage.Name = Convert.ToString(reader["Name"]); if (reader["ConferenceId"] != DBNull.Value) _conferenceHallsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if (reader["MapPath"] != DBNull.Value) _conferenceHallsLanguage.MapPath = Convert.ToString(reader["MapPath"]); if (reader["LanguageID"] != DBNull.Value) _conferenceHallsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["ConferenceHallsParentID"] != DBNull.Value) _conferenceHallsLanguage.ConferenceHallsParentID = Convert.ToInt32(reader["ConferenceHallsParentID"]); _conferenceHallsLanguage.NewRecord = false; _conferenceHallsLanguageList.Add(_conferenceHallsLanguage); } reader.Close(); return _conferenceHallsLanguageList; }
public ConferenceHallsLanguage GetByID(int _conferenceHallsId) { ConferenceHallsLanguageDAC _conferenceHallsLanguageComponent = new ConferenceHallsLanguageDAC(); IDataReader reader = _conferenceHallsLanguageComponent.GetByIDConferenceHallsLanguage(_conferenceHallsId); ConferenceHallsLanguage _conferenceHallsLanguage = null; while(reader.Read()) { _conferenceHallsLanguage = new ConferenceHallsLanguage(); if(reader["ConferenceHallsId"] != DBNull.Value) _conferenceHallsLanguage.ConferenceHallsId = Convert.ToInt32(reader["ConferenceHallsId"]); if(reader["Name"] != DBNull.Value) _conferenceHallsLanguage.Name = Convert.ToString(reader["Name"]); if(reader["ConferenceId"] != DBNull.Value) _conferenceHallsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if(reader["MapPath"] != DBNull.Value) _conferenceHallsLanguage.MapPath = Convert.ToString(reader["MapPath"]); if(reader["LanguageID"] != DBNull.Value) _conferenceHallsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if(reader["ConferenceHallsParentID"] != DBNull.Value) _conferenceHallsLanguage.ConferenceHallsParentID = Convert.ToInt32(reader["ConferenceHallsParentID"]); _conferenceHallsLanguage.NewRecord = false; } reader.Close(); return _conferenceHallsLanguage; }
public bool Update(ConferenceHallsLanguage conferencehallslanguage ,int old_conferenceHallsId) { ConferenceHallsLanguageDAC conferencehallslanguageComponent = new ConferenceHallsLanguageDAC(); return conferencehallslanguageComponent.UpdateConferenceHallsLanguage( conferencehallslanguage.Name, conferencehallslanguage.ConferenceId, conferencehallslanguage.MapPath, conferencehallslanguage.LanguageID, conferencehallslanguage.ConferenceHallsParentID, old_conferenceHallsId); }
public bool Insert(ConferenceHallsLanguage conferencehallslanguage) { int autonumber = 0; ConferenceHallsLanguageDAC conferencehallslanguageComponent = new ConferenceHallsLanguageDAC(); bool endedSuccessfuly = conferencehallslanguageComponent.InsertNewConferenceHallsLanguage( ref autonumber, conferencehallslanguage.Name, conferencehallslanguage.ConferenceId, conferencehallslanguage.MapPath, conferencehallslanguage.LanguageID, conferencehallslanguage.ConferenceHallsParentID); if(endedSuccessfuly) { conferencehallslanguage.ConferenceHallsId = autonumber; } return endedSuccessfuly; }