public ConferencePrograms GetByID(int _conferenceProgramId) { ConferenceProgramsDAC _conferenceProgramsComponent = new ConferenceProgramsDAC(); IDataReader reader = _conferenceProgramsComponent.GetByIDConferencePrograms(_conferenceProgramId); ConferencePrograms _conferencePrograms = null; while (reader.Read()) { _conferencePrograms = new ConferencePrograms(); if (reader["ConferenceProgramId"] != DBNull.Value) { _conferencePrograms.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]); } if (reader["ProgramName"] != DBNull.Value) { _conferencePrograms.ProgramName = Convert.ToString(reader["ProgramName"]); } if (reader["ConferenceId"] != DBNull.Value) { _conferencePrograms.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } _conferencePrograms.NewRecord = false; } reader.Close(); return(_conferencePrograms); }
public List <ConferencePrograms> GetAllByConferenceId(int ConferenceId) { ConferenceProgramsDAC _conferenceProgramsComponent = new ConferenceProgramsDAC(); IDataReader reader = _conferenceProgramsComponent.GetAllConferencePrograms("ConferenceId = " + ConferenceId).CreateDataReader(); List <ConferencePrograms> _conferenceProgramsList = new List <ConferencePrograms>(); while (reader.Read()) { if (_conferenceProgramsList == null) { _conferenceProgramsList = new List <ConferencePrograms>(); } ConferencePrograms _conferencePrograms = new ConferencePrograms(); if (reader["ConferenceProgramId"] != DBNull.Value) { _conferencePrograms.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]); } if (reader["ProgramName"] != DBNull.Value) { _conferencePrograms.ProgramName = Convert.ToString(reader["ProgramName"]); } if (reader["ConferenceId"] != DBNull.Value) { _conferencePrograms.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } _conferencePrograms.NewRecord = false; _conferenceProgramsList.Add(_conferencePrograms); } reader.Close(); return(_conferenceProgramsList); }
public bool Insert(ConferencePrograms conferenceprograms) { int autonumber = 0; ConferenceProgramsDAC conferenceprogramsComponent = new ConferenceProgramsDAC(); bool endedSuccessfuly = conferenceprogramsComponent.InsertNewConferencePrograms(ref autonumber, conferenceprograms.ProgramName, conferenceprograms.ConferenceId); if (endedSuccessfuly) { conferenceprograms.ConferenceProgramId = autonumber; } return(endedSuccessfuly); }
public bool Update(ConferencePrograms conferenceprograms, int old_conferenceProgramId) { ConferenceProgramsDAC conferenceprogramsComponent = new ConferenceProgramsDAC(); return(conferenceprogramsComponent.UpdateConferencePrograms(conferenceprograms.ProgramName, conferenceprograms.ConferenceId, old_conferenceProgramId)); }