public List<ConferenceRegistrationItems> GetAllByConferenceRegistererId(int ConferenceRegistererId) { ConferenceRegistrationItemsDAC _conferenceRegistrationItemsComponent = new ConferenceRegistrationItemsDAC(); IDataReader reader = _conferenceRegistrationItemsComponent.GetAllConferenceRegistrationItems("ConferenceRegistererId = " + ConferenceRegistererId).CreateDataReader(); List<ConferenceRegistrationItems> _conferenceRegistrationItemsList = new List<ConferenceRegistrationItems>(); while (reader.Read()) { if (_conferenceRegistrationItemsList == null) _conferenceRegistrationItemsList = new List<ConferenceRegistrationItems>(); ConferenceRegistrationItems _conferenceRegistrationItems = new ConferenceRegistrationItems(); if (reader["ConferenceRegistrationItemID"] != DBNull.Value) _conferenceRegistrationItems.ConferenceRegistrationItemID = Convert.ToInt32(reader["ConferenceRegistrationItemID"]); if (reader["ConferenceRegistrationTypeID"] != DBNull.Value) _conferenceRegistrationItems.ConferenceRegistrationTypeID = Convert.ToInt32(reader["ConferenceRegistrationTypeID"]); if (reader["ConferenceRegistererId"] != DBNull.Value) _conferenceRegistrationItems.ConferenceRegistererId = Convert.ToInt32(reader["ConferenceRegistererId"]); if (reader["CreatedDate"] != DBNull.Value) _conferenceRegistrationItems.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); _conferenceRegistrationItems.NewRecord = false; _conferenceRegistrationItemsList.Add(_conferenceRegistrationItems); } reader.Close(); return _conferenceRegistrationItemsList; }
public ConferenceRegistrationItems GetByID(int _conferenceRegistrationItemID) { ConferenceRegistrationItemsDAC _conferenceRegistrationItemsComponent = new ConferenceRegistrationItemsDAC(); IDataReader reader = _conferenceRegistrationItemsComponent.GetByIDConferenceRegistrationItems(_conferenceRegistrationItemID); ConferenceRegistrationItems _conferenceRegistrationItems = null; while(reader.Read()) { _conferenceRegistrationItems = new ConferenceRegistrationItems(); if(reader["ConferenceRegistrationItemID"] != DBNull.Value) _conferenceRegistrationItems.ConferenceRegistrationItemID = Convert.ToInt32(reader["ConferenceRegistrationItemID"]); if(reader["ConferenceRegistrationTypeID"] != DBNull.Value) _conferenceRegistrationItems.ConferenceRegistrationTypeID = Convert.ToInt32(reader["ConferenceRegistrationTypeID"]); if(reader["ConferenceRegistererId"] != DBNull.Value) _conferenceRegistrationItems.ConferenceRegistererId = Convert.ToInt32(reader["ConferenceRegistererId"]); if(reader["CreatedDate"] != DBNull.Value) _conferenceRegistrationItems.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); _conferenceRegistrationItems.NewRecord = false; } reader.Close(); return _conferenceRegistrationItems; }
public bool Update(ConferenceRegistrationItems conferenceregistrationitems ,int old_conferenceRegistrationItemID) { ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC(); return conferenceregistrationitemsComponent.UpdateConferenceRegistrationItems( conferenceregistrationitems.ConferenceRegistrationTypeID, conferenceregistrationitems.ConferenceRegistererId, conferenceregistrationitems.CreatedDate, old_conferenceRegistrationItemID); }
public bool Insert(ConferenceRegistrationItems conferenceregistrationitems) { int autonumber = 0; ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC(); bool endedSuccessfuly = conferenceregistrationitemsComponent.InsertNewConferenceRegistrationItems( ref autonumber, conferenceregistrationitems.ConferenceRegistrationTypeID, conferenceregistrationitems.ConferenceRegistererId, conferenceregistrationitems.CreatedDate); if(endedSuccessfuly) { conferenceregistrationitems.ConferenceRegistrationItemID = autonumber; } return endedSuccessfuly; }