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 void Delete(int Original_ConferenceRegistrationItemID) { ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC(); conferenceregistrationitemsComponent.DeleteConferenceRegistrationItems(Original_ConferenceRegistrationItemID); }
public void DeleteByRegitrationID(int id) { ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC(); conferenceregistrationitemsComponent.DeleteConferenceRegistrationItemsByConferenceRegistererId(id); }
public int UpdateDataset(System.Data.DataSet dataset) { ConferenceRegistrationItemsDAC conferenceregistrationitemscomponent = new ConferenceRegistrationItemsDAC(); return conferenceregistrationitemscomponent.UpdateDataset(dataset); }
public bool Update( int ConferenceRegistrationTypeID, int ConferenceRegistererId, DateTime CreatedDate, int Original_ConferenceRegistrationItemID) { ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC(); return conferenceregistrationitemsComponent.UpdateConferenceRegistrationItems( ConferenceRegistrationTypeID, ConferenceRegistererId, CreatedDate, Original_ConferenceRegistrationItemID); }
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( int ConferenceRegistrationTypeID, int ConferenceRegistererId, DateTime CreatedDate) { ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC(); int ConferenceRegistrationItemID = 0; return conferenceregistrationitemsComponent.InsertNewConferenceRegistrationItems( ref ConferenceRegistrationItemID, ConferenceRegistrationTypeID, ConferenceRegistererId, CreatedDate); }
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; }