public List<ConferenceSchedule> GetAll(int ProgramID)
{
ConferenceScheduleDAC _conferenceScheduleComponent = new ConferenceScheduleDAC();
IDataReader reader = _conferenceScheduleComponent.GetAllConferenceSchedule("ConferenceProgramId="+ProgramID).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 int UpdateDataset(System.Data.DataSet dataset)
{
ConferenceScheduleDAC conferenceschedulecomponent = new ConferenceScheduleDAC();
return conferenceschedulecomponent.UpdateDataset(dataset);
}
public void Delete(int Original_ScheduleId)
{
ConferenceScheduleDAC conferencescheduleComponent = new ConferenceScheduleDAC();
conferencescheduleComponent.DeleteConferenceSchedule(Original_ScheduleId);
}
public bool Update( int ConferenceProgramId, string Title, int ScheduleSessionTypeId, DateTime StartTime, DateTime EndTime, string SpeakerName, int ConferenceHallId, string Description, string AllDescription, int SpeakerID, string DocPath, int Original_ScheduleId)
{
ConferenceScheduleDAC conferencescheduleComponent = new ConferenceScheduleDAC();
return conferencescheduleComponent.UpdateConferenceSchedule( ConferenceProgramId, Title, ScheduleSessionTypeId, StartTime, EndTime, SpeakerName, ConferenceHallId, Description, AllDescription, SpeakerID, DocPath, Original_ScheduleId);
}
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 bool Insert( int ConferenceProgramId, string Title, int ScheduleSessionTypeId, DateTime StartTime, DateTime EndTime, string SpeakerName, int ConferenceHallId, string Description, string AllDescription, int SpeakerID, string DocPath)
{
ConferenceScheduleDAC conferencescheduleComponent = new ConferenceScheduleDAC();
int ScheduleId = 0;
return conferencescheduleComponent.InsertNewConferenceSchedule( ref ScheduleId, ConferenceProgramId, Title, ScheduleSessionTypeId, StartTime, EndTime, SpeakerName, ConferenceHallId, Description, AllDescription, SpeakerID, DocPath);
}
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 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;
}
