public List<ConferenceRegistrationSettingLanguages> GetAllByConferenceRegistrationSettingID(int ConferenceRegistrationSettingID) { ConferenceRegistrationSettingLanguagesDAC _conferenceRegistrationSettingLanguagesComponent = new ConferenceRegistrationSettingLanguagesDAC(); IDataReader reader = _conferenceRegistrationSettingLanguagesComponent.GetAllConferenceRegistrationSettingLanguages("ConferenceRegistrationSettingID = " + ConferenceRegistrationSettingID).CreateDataReader(); List<ConferenceRegistrationSettingLanguages> _conferenceRegistrationSettingLanguagesList = new List<ConferenceRegistrationSettingLanguages>(); while (reader.Read()) { if (_conferenceRegistrationSettingLanguagesList == null) _conferenceRegistrationSettingLanguagesList = new List<ConferenceRegistrationSettingLanguages>(); ConferenceRegistrationSettingLanguages _conferenceRegistrationSettingLanguages = new ConferenceRegistrationSettingLanguages(); if (reader["ConferenceRegistrationSettingLanguageID"] != DBNull.Value) _conferenceRegistrationSettingLanguages.ConferenceRegistrationSettingLanguageID = Convert.ToInt32(reader["ConferenceRegistrationSettingLanguageID"]); if (reader["ConferenceRegistrationSettingID"] != DBNull.Value) _conferenceRegistrationSettingLanguages.ConferenceRegistrationSettingID = Convert.ToInt32(reader["ConferenceRegistrationSettingID"]); if (reader["RegistrationShorInstructions"] != DBNull.Value) _conferenceRegistrationSettingLanguages.RegistrationShorInstructions = Convert.ToString(reader["RegistrationShorInstructions"]); if (reader["RegistrationInstructionsInFormPre"] != DBNull.Value) _conferenceRegistrationSettingLanguages.RegistrationInstructionsInFormPre = Convert.ToString(reader["RegistrationInstructionsInFormPre"]); if (reader["RegistrationInstructionsInFormPost"] != DBNull.Value) _conferenceRegistrationSettingLanguages.RegistrationInstructionsInFormPost = Convert.ToString(reader["RegistrationInstructionsInFormPost"]); if (reader["PostRegistrationInstructions"] != DBNull.Value) _conferenceRegistrationSettingLanguages.PostRegistrationInstructions = Convert.ToString(reader["PostRegistrationInstructions"]); if (reader["LanguageID"] != DBNull.Value) _conferenceRegistrationSettingLanguages.LanguageID = Convert.ToInt32(reader["LanguageID"]); _conferenceRegistrationSettingLanguages.NewRecord = false; _conferenceRegistrationSettingLanguagesList.Add(_conferenceRegistrationSettingLanguages); } reader.Close(); return _conferenceRegistrationSettingLanguagesList; }
public ConferenceRegistrationSettingLanguages GetByID(int _conferenceRegistrationSettingLanguageID) { ConferenceRegistrationSettingLanguagesDAC _conferenceRegistrationSettingLanguagesComponent = new ConferenceRegistrationSettingLanguagesDAC(); IDataReader reader = _conferenceRegistrationSettingLanguagesComponent.GetByIDConferenceRegistrationSettingLanguages(_conferenceRegistrationSettingLanguageID); ConferenceRegistrationSettingLanguages _conferenceRegistrationSettingLanguages = null; while(reader.Read()) { _conferenceRegistrationSettingLanguages = new ConferenceRegistrationSettingLanguages(); if(reader["ConferenceRegistrationSettingLanguageID"] != DBNull.Value) _conferenceRegistrationSettingLanguages.ConferenceRegistrationSettingLanguageID = Convert.ToInt32(reader["ConferenceRegistrationSettingLanguageID"]); if(reader["ConferenceRegistrationSettingID"] != DBNull.Value) _conferenceRegistrationSettingLanguages.ConferenceRegistrationSettingID = Convert.ToInt32(reader["ConferenceRegistrationSettingID"]); if(reader["RegistrationShorInstructions"] != DBNull.Value) _conferenceRegistrationSettingLanguages.RegistrationShorInstructions = Convert.ToString(reader["RegistrationShorInstructions"]); if(reader["RegistrationInstructionsInFormPre"] != DBNull.Value) _conferenceRegistrationSettingLanguages.RegistrationInstructionsInFormPre = Convert.ToString(reader["RegistrationInstructionsInFormPre"]); if(reader["RegistrationInstructionsInFormPost"] != DBNull.Value) _conferenceRegistrationSettingLanguages.RegistrationInstructionsInFormPost = Convert.ToString(reader["RegistrationInstructionsInFormPost"]); if(reader["PostRegistrationInstructions"] != DBNull.Value) _conferenceRegistrationSettingLanguages.PostRegistrationInstructions = Convert.ToString(reader["PostRegistrationInstructions"]); if(reader["LanguageID"] != DBNull.Value) _conferenceRegistrationSettingLanguages.LanguageID = Convert.ToInt32(reader["LanguageID"]); _conferenceRegistrationSettingLanguages.NewRecord = false; } reader.Close(); return _conferenceRegistrationSettingLanguages; }
public bool Update(ConferenceRegistrationSettingLanguages conferenceregistrationsettinglanguages ,int old_conferenceRegistrationSettingLanguageID) { ConferenceRegistrationSettingLanguagesDAC conferenceregistrationsettinglanguagesComponent = new ConferenceRegistrationSettingLanguagesDAC(); return conferenceregistrationsettinglanguagesComponent.UpdateConferenceRegistrationSettingLanguages( conferenceregistrationsettinglanguages.ConferenceRegistrationSettingID, conferenceregistrationsettinglanguages.RegistrationShorInstructions, conferenceregistrationsettinglanguages.RegistrationInstructionsInFormPre, conferenceregistrationsettinglanguages.RegistrationInstructionsInFormPost, conferenceregistrationsettinglanguages.PostRegistrationInstructions, conferenceregistrationsettinglanguages.LanguageID, old_conferenceRegistrationSettingLanguageID); }
public bool Insert(ConferenceRegistrationSettingLanguages conferenceregistrationsettinglanguages) { int autonumber = 0; ConferenceRegistrationSettingLanguagesDAC conferenceregistrationsettinglanguagesComponent = new ConferenceRegistrationSettingLanguagesDAC(); bool endedSuccessfuly = conferenceregistrationsettinglanguagesComponent.InsertNewConferenceRegistrationSettingLanguages( ref autonumber, conferenceregistrationsettinglanguages.ConferenceRegistrationSettingID, conferenceregistrationsettinglanguages.RegistrationShorInstructions, conferenceregistrationsettinglanguages.RegistrationInstructionsInFormPre, conferenceregistrationsettinglanguages.RegistrationInstructionsInFormPost, conferenceregistrationsettinglanguages.PostRegistrationInstructions, conferenceregistrationsettinglanguages.LanguageID); if(endedSuccessfuly) { conferenceregistrationsettinglanguages.ConferenceRegistrationSettingLanguageID = autonumber; } return endedSuccessfuly; }