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 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);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
ConferenceRegistrationItemsDAC conferenceregistrationitemscomponent = new ConferenceRegistrationItemsDAC();
return(conferenceregistrationitemscomponent.UpdateDataset(dataset));
}
public void DeleteByRegitrationID(int id)
{
ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC();
conferenceregistrationitemsComponent.DeleteConferenceRegistrationItemsByConferenceRegistererId(id);
}
public void Delete(int Original_ConferenceRegistrationItemID)
{
ConferenceRegistrationItemsDAC conferenceregistrationitemsComponent = new ConferenceRegistrationItemsDAC();
conferenceregistrationitemsComponent.DeleteConferenceRegistrationItems(Original_ConferenceRegistrationItemID);
}
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));
}
