public bool Insert(ConferenceRegistrationTypeLanguage conferenceregistrationtypelanguage) { int autonumber = 0; ConferenceRegistrationTypeLanguageDAC conferenceregistrationtypelanguageComponent = new ConferenceRegistrationTypeLanguageDAC(); bool endedSuccessfuly = conferenceregistrationtypelanguageComponent.InsertNewConferenceRegistrationTypeLanguage(ref autonumber, conferenceregistrationtypelanguage.ConferenceId, conferenceregistrationtypelanguage.Name, conferenceregistrationtypelanguage.Fee, conferenceregistrationtypelanguage.ConferenceRegistrationTypeParentId, conferenceregistrationtypelanguage.LanguageID, conferenceregistrationtypelanguage.Description, conferenceregistrationtypelanguage.OfferMessage); if (endedSuccessfuly) { conferenceregistrationtypelanguage.ConferenceRegistrationTypeId = autonumber; } return(endedSuccessfuly); }
public List <ConferenceRegistrationTypeLanguage> GetAll(int ParentID) { ConferenceRegistrationTypeLanguageDAC _conferenceRegistrationTypeLanguageComponent = new ConferenceRegistrationTypeLanguageDAC(); IDataReader reader = _conferenceRegistrationTypeLanguageComponent.GetAllConferenceRegistrationTypeLanguage("ConferenceRegistrationTypeParentId=" + ParentID).CreateDataReader(); List <ConferenceRegistrationTypeLanguage> _conferenceRegistrationTypeLanguageList = new List <ConferenceRegistrationTypeLanguage>(); while (reader.Read()) { if (_conferenceRegistrationTypeLanguageList == null) { _conferenceRegistrationTypeLanguageList = new List <ConferenceRegistrationTypeLanguage>(); } ConferenceRegistrationTypeLanguage _conferenceRegistrationTypeLanguage = new ConferenceRegistrationTypeLanguage(); if (reader["ConferenceRegistrationTypeId"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.ConferenceRegistrationTypeId = Convert.ToInt32(reader["ConferenceRegistrationTypeId"]); } if (reader["ConferenceId"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } if (reader["Name"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.Name = Convert.ToString(reader["Name"]); } if (reader["Fee"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.Fee = Convert.ToDecimal(reader["Fee"]); } if (reader["ConferenceRegistrationTypeParentId"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.ConferenceRegistrationTypeParentId = Convert.ToInt32(reader["ConferenceRegistrationTypeParentId"]); } if (reader["LanguageID"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } if (reader["Description"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.Description = Convert.ToString(reader["Description"]); } if (reader["OfferMessage"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.OfferMessage = Convert.ToString(reader["OfferMessage"]); } _conferenceRegistrationTypeLanguage.NewRecord = false; _conferenceRegistrationTypeLanguageList.Add(_conferenceRegistrationTypeLanguage); } reader.Close(); return(_conferenceRegistrationTypeLanguageList); }
public ConferenceRegistrationTypeLanguage GetByID(int _conferenceRegistrationTypeId) { ConferenceRegistrationTypeLanguageDAC _conferenceRegistrationTypeLanguageComponent = new ConferenceRegistrationTypeLanguageDAC(); IDataReader reader = _conferenceRegistrationTypeLanguageComponent.GetByIDConferenceRegistrationTypeLanguage(_conferenceRegistrationTypeId); ConferenceRegistrationTypeLanguage _conferenceRegistrationTypeLanguage = null; while (reader.Read()) { _conferenceRegistrationTypeLanguage = new ConferenceRegistrationTypeLanguage(); if (reader["ConferenceRegistrationTypeId"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.ConferenceRegistrationTypeId = Convert.ToInt32(reader["ConferenceRegistrationTypeId"]); } if (reader["ConferenceId"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } if (reader["Name"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.Name = Convert.ToString(reader["Name"]); } if (reader["Fee"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.Fee = Convert.ToDecimal(reader["Fee"]); } if (reader["ConferenceRegistrationTypeParentId"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.ConferenceRegistrationTypeParentId = Convert.ToInt32(reader["ConferenceRegistrationTypeParentId"]); } if (reader["LanguageID"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } if (reader["Description"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.Description = Convert.ToString(reader["Description"]); } if (reader["OfferMessage"] != DBNull.Value) { _conferenceRegistrationTypeLanguage.OfferMessage = Convert.ToString(reader["OfferMessage"]); } _conferenceRegistrationTypeLanguage.NewRecord = false; } reader.Close(); return(_conferenceRegistrationTypeLanguage); }
public bool Update(ConferenceRegistrationTypeLanguage conferenceregistrationtypelanguage, int old_conferenceRegistrationTypeId) { ConferenceRegistrationTypeLanguageDAC conferenceregistrationtypelanguageComponent = new ConferenceRegistrationTypeLanguageDAC(); return(conferenceregistrationtypelanguageComponent.UpdateConferenceRegistrationTypeLanguage(conferenceregistrationtypelanguage.ConferenceId, conferenceregistrationtypelanguage.Name, conferenceregistrationtypelanguage.Fee, conferenceregistrationtypelanguage.ConferenceRegistrationTypeParentId, conferenceregistrationtypelanguage.LanguageID, conferenceregistrationtypelanguage.Description, conferenceregistrationtypelanguage.OfferMessage, old_conferenceRegistrationTypeId)); }