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;
}