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