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 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 Update(ConferenceProgramsLanguage conferenceprogramslanguage ,int old_conferenceProgramId)
{
ConferenceProgramsLanguageDAC conferenceprogramslanguageComponent = new ConferenceProgramsLanguageDAC();
return conferenceprogramslanguageComponent.UpdateConferenceProgramsLanguage( conferenceprogramslanguage.ProgramName, conferenceprogramslanguage.ConferenceId, conferenceprogramslanguage.LanguageID, conferenceprogramslanguage.ConferenceProgramParentID, old_conferenceProgramId);
}
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;
}
