public ConferenceProgramsLanguage GetByID(int _conferenceProgramId)
{
ConferenceProgramsLanguageDAC _conferenceProgramsLanguageComponent = new ConferenceProgramsLanguageDAC();
IDataReader reader = _conferenceProgramsLanguageComponent.GetByIDConferenceProgramsLanguage(_conferenceProgramId);
ConferenceProgramsLanguage _conferenceProgramsLanguage = null;
while (reader.Read())
{
_conferenceProgramsLanguage = new ConferenceProgramsLanguage();
if (reader["ConferenceProgramId"] != DBNull.Value)
{
_conferenceProgramsLanguage.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]);
}
if (reader["ProgramName"] != DBNull.Value)
{
_conferenceProgramsLanguage.ProgramName = Convert.ToString(reader["ProgramName"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_conferenceProgramsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_conferenceProgramsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ConferenceProgramParentID"] != DBNull.Value)
{
_conferenceProgramsLanguage.ConferenceProgramParentID = Convert.ToInt32(reader["ConferenceProgramParentID"]);
}
_conferenceProgramsLanguage.NewRecord = false;
}
reader.Close();
return(_conferenceProgramsLanguage);
}
public bool Insert(ConferenceProgramsLanguage conferenceprogramslanguage)
{
int autonumber = 0;
ConferenceProgramsLanguageDAC conferenceprogramslanguageComponent = new ConferenceProgramsLanguageDAC();
bool endedSuccessfuly = conferenceprogramslanguageComponent.InsertNewConferenceProgramsLanguage(ref autonumber, conferenceprogramslanguage.ProgramName, conferenceprogramslanguage.ConferenceId, conferenceprogramslanguage.LanguageID, conferenceprogramslanguage.ConferenceProgramParentID);
if (endedSuccessfuly)
{
conferenceprogramslanguage.ConferenceProgramId = autonumber;
}
return(endedSuccessfuly);
}
public List <ConferenceProgramsLanguage> GetAll(int parentID)
{
ConferenceProgramsLanguageDAC _conferenceProgramsLanguageComponent = new ConferenceProgramsLanguageDAC();
IDataReader reader = _conferenceProgramsLanguageComponent.GetAllConferenceProgramsLanguage("ConferenceProgramParentID=" + parentID).CreateDataReader();
List <ConferenceProgramsLanguage> _conferenceProgramsLanguageList = new List <ConferenceProgramsLanguage>();
while (reader.Read())
{
if (_conferenceProgramsLanguageList == null)
{
_conferenceProgramsLanguageList = new List <ConferenceProgramsLanguage>();
}
ConferenceProgramsLanguage _conferenceProgramsLanguage = new ConferenceProgramsLanguage();
if (reader["ConferenceProgramId"] != DBNull.Value)
{
_conferenceProgramsLanguage.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]);
}
if (reader["ProgramName"] != DBNull.Value)
{
_conferenceProgramsLanguage.ProgramName = Convert.ToString(reader["ProgramName"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_conferenceProgramsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_conferenceProgramsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["ConferenceProgramParentID"] != DBNull.Value)
{
_conferenceProgramsLanguage.ConferenceProgramParentID = Convert.ToInt32(reader["ConferenceProgramParentID"]);
}
_conferenceProgramsLanguage.NewRecord = false;
_conferenceProgramsLanguageList.Add(_conferenceProgramsLanguage);
}
reader.Close();
return(_conferenceProgramsLanguageList);
}
public bool Update(ConferenceProgramsLanguage conferenceprogramslanguage, int old_conferenceProgramId)
{
ConferenceProgramsLanguageDAC conferenceprogramslanguageComponent = new ConferenceProgramsLanguageDAC();
return(conferenceprogramslanguageComponent.UpdateConferenceProgramsLanguage(conferenceprogramslanguage.ProgramName, conferenceprogramslanguage.ConferenceId, conferenceprogramslanguage.LanguageID, conferenceprogramslanguage.ConferenceProgramParentID, old_conferenceProgramId));
}
