public List<ConferenceSchedule> GetAll() { ConferenceScheduleDAC _conferenceScheduleComponent = new ConferenceScheduleDAC(); IDataReader reader = _conferenceScheduleComponent.GetAllConferenceSchedule().CreateDataReader(); List<ConferenceSchedule> _conferenceScheduleList = new List<ConferenceSchedule>(); while(reader.Read()) { if(_conferenceScheduleList == null) _conferenceScheduleList = new List<ConferenceSchedule>(); ConferenceSchedule _conferenceSchedule = new ConferenceSchedule(); if(reader["ScheduleId"] != DBNull.Value) _conferenceSchedule.ScheduleId = Convert.ToInt32(reader["ScheduleId"]); if(reader["ConferenceProgramId"] != DBNull.Value) _conferenceSchedule.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]); if(reader["Title"] != DBNull.Value) _conferenceSchedule.Title = Convert.ToString(reader["Title"]); if(reader["ScheduleSessionTypeId"] != DBNull.Value) _conferenceSchedule.ScheduleSessionTypeId = Convert.ToInt32(reader["ScheduleSessionTypeId"]); if(reader["StartTime"] != DBNull.Value) _conferenceSchedule.StartTime = Convert.ToDateTime(reader["StartTime"]); if(reader["EndTime"] != DBNull.Value) _conferenceSchedule.EndTime = Convert.ToDateTime(reader["EndTime"]); if(reader["SpeakerName"] != DBNull.Value) _conferenceSchedule.SpeakerName = Convert.ToString(reader["SpeakerName"]); if(reader["ConferenceHallId"] != DBNull.Value) _conferenceSchedule.ConferenceHallId = Convert.ToInt32(reader["ConferenceHallId"]); if(reader["Description"] != DBNull.Value) _conferenceSchedule.Description = Convert.ToString(reader["Description"]); if(reader["AllDescription"] != DBNull.Value) _conferenceSchedule.AllDescription = Convert.ToString(reader["AllDescription"]); if(reader["SpeakerID"] != DBNull.Value) _conferenceSchedule.SpeakerID = Convert.ToInt32(reader["SpeakerID"]); if(reader["DocPath"] != DBNull.Value) _conferenceSchedule.DocPath = Convert.ToString(reader["DocPath"]); _conferenceSchedule.NewRecord = false; _conferenceScheduleList.Add(_conferenceSchedule); } reader.Close(); return _conferenceScheduleList; }
public bool Insert(ConferenceSchedule conferenceschedule) { int autonumber = 0; ConferenceScheduleDAC conferencescheduleComponent = new ConferenceScheduleDAC(); bool endedSuccessfuly = conferencescheduleComponent.InsertNewConferenceSchedule( ref autonumber, conferenceschedule.ConferenceProgramId, conferenceschedule.Title, conferenceschedule.ScheduleSessionTypeId, conferenceschedule.StartTime, conferenceschedule.EndTime, conferenceschedule.SpeakerName, conferenceschedule.ConferenceHallId, conferenceschedule.Description, conferenceschedule.AllDescription, conferenceschedule.SpeakerID, conferenceschedule.DocPath); if(endedSuccessfuly) { conferenceschedule.ScheduleId = autonumber; } return endedSuccessfuly; }
public bool Update(ConferenceSchedule conferenceschedule ,int old_scheduleId) { ConferenceScheduleDAC conferencescheduleComponent = new ConferenceScheduleDAC(); return conferencescheduleComponent.UpdateConferenceSchedule( conferenceschedule.ConferenceProgramId, conferenceschedule.Title, conferenceschedule.ScheduleSessionTypeId, conferenceschedule.StartTime, conferenceschedule.EndTime, conferenceschedule.SpeakerName, conferenceschedule.ConferenceHallId, conferenceschedule.Description, conferenceschedule.AllDescription, conferenceschedule.SpeakerID, conferenceschedule.DocPath, old_scheduleId); }
public ConferenceSchedule GetByID(int _scheduleId) { ConferenceScheduleDAC _conferenceScheduleComponent = new ConferenceScheduleDAC(); IDataReader reader = _conferenceScheduleComponent.GetByIDConferenceSchedule(_scheduleId); ConferenceSchedule _conferenceSchedule = null; while(reader.Read()) { _conferenceSchedule = new ConferenceSchedule(); if(reader["ScheduleId"] != DBNull.Value) _conferenceSchedule.ScheduleId = Convert.ToInt32(reader["ScheduleId"]); if(reader["ConferenceProgramId"] != DBNull.Value) _conferenceSchedule.ConferenceProgramId = Convert.ToInt32(reader["ConferenceProgramId"]); if(reader["Title"] != DBNull.Value) _conferenceSchedule.Title = Convert.ToString(reader["Title"]); if(reader["ScheduleSessionTypeId"] != DBNull.Value) _conferenceSchedule.ScheduleSessionTypeId = Convert.ToInt32(reader["ScheduleSessionTypeId"]); if(reader["StartTime"] != DBNull.Value) _conferenceSchedule.StartTime = Convert.ToDateTime(reader["StartTime"]); if(reader["EndTime"] != DBNull.Value) _conferenceSchedule.EndTime = Convert.ToDateTime(reader["EndTime"]); if(reader["SpeakerName"] != DBNull.Value) _conferenceSchedule.SpeakerName = Convert.ToString(reader["SpeakerName"]); if(reader["ConferenceHallId"] != DBNull.Value) _conferenceSchedule.ConferenceHallId = Convert.ToInt32(reader["ConferenceHallId"]); if(reader["Description"] != DBNull.Value) _conferenceSchedule.Description = Convert.ToString(reader["Description"]); if(reader["AllDescription"] != DBNull.Value) _conferenceSchedule.AllDescription = Convert.ToString(reader["AllDescription"]); if(reader["SpeakerID"] != DBNull.Value) _conferenceSchedule.SpeakerID = Convert.ToInt32(reader["SpeakerID"]); if(reader["DocPath"] != DBNull.Value) _conferenceSchedule.DocPath = Convert.ToString(reader["DocPath"]); _conferenceSchedule.NewRecord = false; } reader.Close(); return _conferenceSchedule; }