public List<ConferenceScheduleLanguage> GetAll()
{
ConferenceScheduleLanguageDAC _conferenceScheduleLanguageComponent = new ConferenceScheduleLanguageDAC();
IDataReader reader = _conferenceScheduleLanguageComponent.GetAllConferenceScheduleLanguage().CreateDataReader();
List<ConferenceScheduleLanguage> _conferenceScheduleLanguageList = new List<ConferenceScheduleLanguage>();
while(reader.Read())
{
if(_conferenceScheduleLanguageList == null)
_conferenceScheduleLanguageList = new List<ConferenceScheduleLanguage>();
ConferenceScheduleLanguage _conferenceScheduleLanguage = new ConferenceScheduleLanguage();
if(reader["ScheduleId"] != DBNull.Value)
_conferenceScheduleLanguage.ScheduleId = Convert.ToInt32(reader["ScheduleId"]);
if(reader["ConferenceProgramId"] != DBNull.Value)
_conferenceScheduleLanguage.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]);
if(reader["Title"] != DBNull.Value)
_conferenceScheduleLanguage.Title = Convert.ToString(reader["Title"]);
if(reader["ScheduleSessionTypeId"] != DBNull.Value)
_conferenceScheduleLanguage.ScheduleSessionTypeId = Convert.ToInt32(reader["ScheduleSessionTypeId"]);
if(reader["StartTime"] != DBNull.Value)
_conferenceScheduleLanguage.StartTime = Convert.ToDateTime(reader["StartTime"]);
if(reader["EndTime"] != DBNull.Value)
_conferenceScheduleLanguage.EndTime = Convert.ToDateTime(reader["EndTime"]);
if(reader["SpeakerName"] != DBNull.Value)
_conferenceScheduleLanguage.SpeakerName = Convert.ToString(reader["SpeakerName"]);
if(reader["ConferenceHallId"] != DBNull.Value)
_conferenceScheduleLanguage.ConferenceHallId = Convert.ToInt32(reader["ConferenceHallId"]);
if(reader["Description"] != DBNull.Value)
_conferenceScheduleLanguage.Description = Convert.ToString(reader["Description"]);
if(reader["AllDescription"] != DBNull.Value)
_conferenceScheduleLanguage.AllDescription = Convert.ToString(reader["AllDescription"]);
if(reader["SpeakerID"] != DBNull.Value)
_conferenceScheduleLanguage.SpeakerID = Convert.ToInt32(reader["SpeakerID"]);
if(reader["DocPath"] != DBNull.Value)
_conferenceScheduleLanguage.DocPath = Convert.ToString(reader["DocPath"]);
if(reader["ScheduleparentID"] != DBNull.Value)
_conferenceScheduleLanguage.ScheduleparentID = Convert.ToInt32(reader["ScheduleparentID"]);
if(reader["LanguageID"] != DBNull.Value)
_conferenceScheduleLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
_conferenceScheduleLanguage.NewRecord = false;
_conferenceScheduleLanguageList.Add(_conferenceScheduleLanguage);
} reader.Close();
return _conferenceScheduleLanguageList;
}
public bool Insert(ConferenceScheduleLanguage conferenceschedulelanguage)
{
int autonumber = 0;
ConferenceScheduleLanguageDAC conferenceschedulelanguageComponent = new ConferenceScheduleLanguageDAC();
bool endedSuccessfuly = conferenceschedulelanguageComponent.InsertNewConferenceScheduleLanguage( ref autonumber, conferenceschedulelanguage.ConferenceProgramId, conferenceschedulelanguage.Title, conferenceschedulelanguage.ScheduleSessionTypeId, conferenceschedulelanguage.StartTime, conferenceschedulelanguage.EndTime, conferenceschedulelanguage.SpeakerName, conferenceschedulelanguage.ConferenceHallId, conferenceschedulelanguage.Description, conferenceschedulelanguage.AllDescription, conferenceschedulelanguage.SpeakerID, conferenceschedulelanguage.DocPath, conferenceschedulelanguage.ScheduleparentID, conferenceschedulelanguage.LanguageID);
if(endedSuccessfuly)
{
conferenceschedulelanguage.ScheduleId = autonumber;
}
return endedSuccessfuly;
}
public bool Update(ConferenceScheduleLanguage conferenceschedulelanguage ,int old_scheduleId)
{
ConferenceScheduleLanguageDAC conferenceschedulelanguageComponent = new ConferenceScheduleLanguageDAC();
return conferenceschedulelanguageComponent.UpdateConferenceScheduleLanguage( conferenceschedulelanguage.ConferenceProgramId, conferenceschedulelanguage.Title, conferenceschedulelanguage.ScheduleSessionTypeId, conferenceschedulelanguage.StartTime, conferenceschedulelanguage.EndTime, conferenceschedulelanguage.SpeakerName, conferenceschedulelanguage.ConferenceHallId, conferenceschedulelanguage.Description, conferenceschedulelanguage.AllDescription, conferenceschedulelanguage.SpeakerID, conferenceschedulelanguage.DocPath, conferenceschedulelanguage.ScheduleparentID, conferenceschedulelanguage.LanguageID, old_scheduleId);
}
public ConferenceScheduleLanguage GetByID(int _scheduleId)
{
ConferenceScheduleLanguageDAC _conferenceScheduleLanguageComponent = new ConferenceScheduleLanguageDAC();
IDataReader reader = _conferenceScheduleLanguageComponent.GetByIDConferenceScheduleLanguage(_scheduleId);
ConferenceScheduleLanguage _conferenceScheduleLanguage = null;
while(reader.Read())
{
_conferenceScheduleLanguage = new ConferenceScheduleLanguage();
if(reader["ScheduleId"] != DBNull.Value)
_conferenceScheduleLanguage.ScheduleId = Convert.ToInt32(reader["ScheduleId"]);
if(reader["ConferenceProgramId"] != DBNull.Value)
_conferenceScheduleLanguage.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]);
if(reader["Title"] != DBNull.Value)
_conferenceScheduleLanguage.Title = Convert.ToString(reader["Title"]);
if(reader["ScheduleSessionTypeId"] != DBNull.Value)
_conferenceScheduleLanguage.ScheduleSessionTypeId = Convert.ToInt32(reader["ScheduleSessionTypeId"]);
if(reader["StartTime"] != DBNull.Value)
_conferenceScheduleLanguage.StartTime = Convert.ToDateTime(reader["StartTime"]);
if(reader["EndTime"] != DBNull.Value)
_conferenceScheduleLanguage.EndTime = Convert.ToDateTime(reader["EndTime"]);
if(reader["SpeakerName"] != DBNull.Value)
_conferenceScheduleLanguage.SpeakerName = Convert.ToString(reader["SpeakerName"]);
if(reader["ConferenceHallId"] != DBNull.Value)
_conferenceScheduleLanguage.ConferenceHallId = Convert.ToInt32(reader["ConferenceHallId"]);
if(reader["Description"] != DBNull.Value)
_conferenceScheduleLanguage.Description = Convert.ToString(reader["Description"]);
if(reader["AllDescription"] != DBNull.Value)
_conferenceScheduleLanguage.AllDescription = Convert.ToString(reader["AllDescription"]);
if(reader["SpeakerID"] != DBNull.Value)
_conferenceScheduleLanguage.SpeakerID = Convert.ToInt32(reader["SpeakerID"]);
if(reader["DocPath"] != DBNull.Value)
_conferenceScheduleLanguage.DocPath = Convert.ToString(reader["DocPath"]);
if(reader["ScheduleparentID"] != DBNull.Value)
_conferenceScheduleLanguage.ScheduleparentID = Convert.ToInt32(reader["ScheduleparentID"]);
if(reader["LanguageID"] != DBNull.Value)
_conferenceScheduleLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
_conferenceScheduleLanguage.NewRecord = false; } reader.Close();
return _conferenceScheduleLanguage;
}
