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 List <ConferenceSchedule> GetAll(int programId, int day)
{
ConferenceScheduleDAC _conferenceScheduleComponent = new ConferenceScheduleDAC();
IDataReader reader = _conferenceScheduleComponent.GetAllConferenceSchedule(String.Format(" ConferenceProgramId = {0} AND DAY(StartTime) = {1}", programId, day)).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"]);
}
_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 int UpdateDataset(System.Data.DataSet dataset)
{
ConferenceScheduleDAC conferenceschedulecomponent = new ConferenceScheduleDAC();
return(conferenceschedulecomponent.UpdateDataset(dataset));
}
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);
}
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));
}
