コード例 #1
0
 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;
 }
コード例 #2
0
 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;
 }
コード例 #3
0
 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);
 }
コード例 #4
0
 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;
 }