public List<ConferenceRegistrationSettings> GetAllByConferenceID(int ConferenceID)
{
ConferenceRegistrationSettingsDAC _conferenceRegistrationSettingsComponent = new ConferenceRegistrationSettingsDAC();
IDataReader reader = _conferenceRegistrationSettingsComponent.GetAllConferenceRegistrationSettings("ConferenceID = " + ConferenceID).CreateDataReader();
List<ConferenceRegistrationSettings> _conferenceRegistrationSettingsList = new List<ConferenceRegistrationSettings>();
while (reader.Read())
{
if (_conferenceRegistrationSettingsList == null)
_conferenceRegistrationSettingsList = new List<ConferenceRegistrationSettings>();
ConferenceRegistrationSettings _conferenceRegistrationSettings = new ConferenceRegistrationSettings();
if (reader["ConferenceRegistrationSettingID"] != DBNull.Value)
_conferenceRegistrationSettings.ConferenceRegistrationSettingID = Convert.ToInt32(reader["ConferenceRegistrationSettingID"]);
if (reader["ConferenceID"] != DBNull.Value)
_conferenceRegistrationSettings.ConferenceID = Convert.ToInt32(reader["ConferenceID"]);
if (reader["RegistrationEndDate"] != DBNull.Value)
_conferenceRegistrationSettings.RegistrationEndDate = Convert.ToDateTime(reader["RegistrationEndDate"]);
if (reader["RegistrationStartDate"] != DBNull.Value)
_conferenceRegistrationSettings.RegistrationStartDate = Convert.ToDateTime(reader["RegistrationStartDate"]);
if (reader["IsActive"] != DBNull.Value)
_conferenceRegistrationSettings.IsActive = Convert.ToBoolean(reader["IsActive"]);
_conferenceRegistrationSettings.NewRecord = false;
_conferenceRegistrationSettingsList.Add(_conferenceRegistrationSettings);
} reader.Close();
return _conferenceRegistrationSettingsList;
}
public ConferenceRegistrationSettings GetByID(int _conferenceRegistrationSettingID)
{
ConferenceRegistrationSettingsDAC _conferenceRegistrationSettingsComponent = new ConferenceRegistrationSettingsDAC();
IDataReader reader = _conferenceRegistrationSettingsComponent.GetByIDConferenceRegistrationSettings(_conferenceRegistrationSettingID);
ConferenceRegistrationSettings _conferenceRegistrationSettings = null;
while(reader.Read())
{
_conferenceRegistrationSettings = new ConferenceRegistrationSettings();
if(reader["ConferenceRegistrationSettingID"] != DBNull.Value)
_conferenceRegistrationSettings.ConferenceRegistrationSettingID = Convert.ToInt32(reader["ConferenceRegistrationSettingID"]);
if(reader["ConferenceID"] != DBNull.Value)
_conferenceRegistrationSettings.ConferenceID = Convert.ToInt32(reader["ConferenceID"]);
if(reader["RegistrationEndDate"] != DBNull.Value)
_conferenceRegistrationSettings.RegistrationEndDate = Convert.ToDateTime(reader["RegistrationEndDate"]);
if(reader["RegistrationStartDate"] != DBNull.Value)
_conferenceRegistrationSettings.RegistrationStartDate = Convert.ToDateTime(reader["RegistrationStartDate"]);
if(reader["IsActive"] != DBNull.Value)
_conferenceRegistrationSettings.IsActive = Convert.ToBoolean(reader["IsActive"]);
_conferenceRegistrationSettings.NewRecord = false; } reader.Close();
return _conferenceRegistrationSettings;
}
public bool Update(ConferenceRegistrationSettings conferenceregistrationsettings ,int old_conferenceRegistrationSettingID)
{
ConferenceRegistrationSettingsDAC conferenceregistrationsettingsComponent = new ConferenceRegistrationSettingsDAC();
return conferenceregistrationsettingsComponent.UpdateConferenceRegistrationSettings( conferenceregistrationsettings.ConferenceID, conferenceregistrationsettings.RegistrationEndDate, conferenceregistrationsettings.RegistrationStartDate, conferenceregistrationsettings.IsActive, old_conferenceRegistrationSettingID);
}
public bool Insert(ConferenceRegistrationSettings conferenceregistrationsettings)
{
int autonumber = 0;
ConferenceRegistrationSettingsDAC conferenceregistrationsettingsComponent = new ConferenceRegistrationSettingsDAC();
bool endedSuccessfuly = conferenceregistrationsettingsComponent.InsertNewConferenceRegistrationSettings( ref autonumber, conferenceregistrationsettings.ConferenceID, conferenceregistrationsettings.RegistrationEndDate, conferenceregistrationsettings.RegistrationStartDate, conferenceregistrationsettings.IsActive);
if(endedSuccessfuly)
{
conferenceregistrationsettings.ConferenceRegistrationSettingID = autonumber;
}
return endedSuccessfuly;
}