public List<ConferenceProgramsLanguage> GetAll(int parentID) { ConferenceProgramsLanguageDAC _conferenceProgramsLanguageComponent = new ConferenceProgramsLanguageDAC(); IDataReader reader = _conferenceProgramsLanguageComponent.GetAllConferenceProgramsLanguage("ConferenceProgramParentID="+parentID).CreateDataReader(); List<ConferenceProgramsLanguage> _conferenceProgramsLanguageList = new List<ConferenceProgramsLanguage>(); while (reader.Read()) { if (_conferenceProgramsLanguageList == null) _conferenceProgramsLanguageList = new List<ConferenceProgramsLanguage>(); ConferenceProgramsLanguage _conferenceProgramsLanguage = new ConferenceProgramsLanguage(); if (reader["ConferenceProgramId"] != DBNull.Value) _conferenceProgramsLanguage.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]); if (reader["ProgramName"] != DBNull.Value) _conferenceProgramsLanguage.ProgramName = Convert.ToString(reader["ProgramName"]); if (reader["ConferenceId"] != DBNull.Value) _conferenceProgramsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if (reader["LanguageID"] != DBNull.Value) _conferenceProgramsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["ConferenceProgramParentID"] != DBNull.Value) _conferenceProgramsLanguage.ConferenceProgramParentID = Convert.ToInt32(reader["ConferenceProgramParentID"]); _conferenceProgramsLanguage.NewRecord = false; _conferenceProgramsLanguageList.Add(_conferenceProgramsLanguage); } reader.Close(); return _conferenceProgramsLanguageList; }
public ConferenceProgramsLanguage GetByID(int _conferenceProgramId) { ConferenceProgramsLanguageDAC _conferenceProgramsLanguageComponent = new ConferenceProgramsLanguageDAC(); IDataReader reader = _conferenceProgramsLanguageComponent.GetByIDConferenceProgramsLanguage(_conferenceProgramId); ConferenceProgramsLanguage _conferenceProgramsLanguage = null; while(reader.Read()) { _conferenceProgramsLanguage = new ConferenceProgramsLanguage(); if(reader["ConferenceProgramId"] != DBNull.Value) _conferenceProgramsLanguage.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]); if(reader["ProgramName"] != DBNull.Value) _conferenceProgramsLanguage.ProgramName = Convert.ToString(reader["ProgramName"]); if(reader["ConferenceId"] != DBNull.Value) _conferenceProgramsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if(reader["LanguageID"] != DBNull.Value) _conferenceProgramsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if(reader["ConferenceProgramParentID"] != DBNull.Value) _conferenceProgramsLanguage.ConferenceProgramParentID = Convert.ToInt32(reader["ConferenceProgramParentID"]); _conferenceProgramsLanguage.NewRecord = false; } reader.Close(); return _conferenceProgramsLanguage; }
public bool Update(ConferenceProgramsLanguage conferenceprogramslanguage ,int old_conferenceProgramId) { ConferenceProgramsLanguageDAC conferenceprogramslanguageComponent = new ConferenceProgramsLanguageDAC(); return conferenceprogramslanguageComponent.UpdateConferenceProgramsLanguage( conferenceprogramslanguage.ProgramName, conferenceprogramslanguage.ConferenceId, conferenceprogramslanguage.LanguageID, conferenceprogramslanguage.ConferenceProgramParentID, old_conferenceProgramId); }
public bool Insert(ConferenceProgramsLanguage conferenceprogramslanguage) { int autonumber = 0; ConferenceProgramsLanguageDAC conferenceprogramslanguageComponent = new ConferenceProgramsLanguageDAC(); bool endedSuccessfuly = conferenceprogramslanguageComponent.InsertNewConferenceProgramsLanguage( ref autonumber, conferenceprogramslanguage.ProgramName, conferenceprogramslanguage.ConferenceId, conferenceprogramslanguage.LanguageID, conferenceprogramslanguage.ConferenceProgramParentID); if(endedSuccessfuly) { conferenceprogramslanguage.ConferenceProgramId = autonumber; } return endedSuccessfuly; }