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 List <ConferenceScheduleLanguage> GetAll(int ParentID)
{
ConferenceScheduleLanguageDAC _conferenceScheduleLanguageComponent = new ConferenceScheduleLanguageDAC();
IDataReader reader = _conferenceScheduleLanguageComponent.GetAllConferenceScheduleLanguage("ScheduleparentID=" + ParentID).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 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);
}
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));
}
