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));
}
