public bool Insert(ConferenceHalls conferencehalls)
{
int autonumber = 0;
ConferenceHallsDAC conferencehallsComponent = new ConferenceHallsDAC();
bool endedSuccessfuly = conferencehallsComponent.InsertNewConferenceHalls( ref autonumber, conferencehalls.Name, conferencehalls.ConferenceId, conferencehalls.MapPath);
if(endedSuccessfuly)
{
conferencehalls.ConferenceHallsId = autonumber;
}
return endedSuccessfuly;
}
public ConferenceHalls GetByID(int _conferenceHallsId)
{
ConferenceHallsDAC _conferenceHallsComponent = new ConferenceHallsDAC();
IDataReader reader = _conferenceHallsComponent.GetByIDConferenceHalls(_conferenceHallsId);
ConferenceHalls _conferenceHalls = null;
while(reader.Read())
{
_conferenceHalls = new ConferenceHalls();
if(reader["ConferenceHallsId"] != DBNull.Value)
_conferenceHalls.ConferenceHallsId = Convert.ToInt32(reader["ConferenceHallsId"]);
if(reader["Name"] != DBNull.Value)
_conferenceHalls.Name = Convert.ToString(reader["Name"]);
if(reader["ConferenceId"] != DBNull.Value)
_conferenceHalls.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
if(reader["MapPath"] != DBNull.Value)
_conferenceHalls.MapPath = Convert.ToString(reader["MapPath"]);
_conferenceHalls.NewRecord = false; } reader.Close();
return _conferenceHalls;
}
public List<ConferenceHalls> GetAll()
{
ConferenceHallsDAC _conferenceHallsComponent = new ConferenceHallsDAC();
IDataReader reader = _conferenceHallsComponent.GetAllConferenceHalls().CreateDataReader();
List<ConferenceHalls> _conferenceHallsList = new List<ConferenceHalls>();
while(reader.Read())
{
if(_conferenceHallsList == null)
_conferenceHallsList = new List<ConferenceHalls>();
ConferenceHalls _conferenceHalls = new ConferenceHalls();
if(reader["ConferenceHallsId"] != DBNull.Value)
_conferenceHalls.ConferenceHallsId = Convert.ToInt32(reader["ConferenceHallsId"]);
if(reader["Name"] != DBNull.Value)
_conferenceHalls.Name = Convert.ToString(reader["Name"]);
if(reader["ConferenceId"] != DBNull.Value)
_conferenceHalls.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
if(reader["MapPath"] != DBNull.Value)
_conferenceHalls.MapPath = Convert.ToString(reader["MapPath"]);
_conferenceHalls.NewRecord = false;
_conferenceHallsList.Add(_conferenceHalls);
} reader.Close();
return _conferenceHallsList;
}
public bool Update(ConferenceHalls conferencehalls ,int old_conferenceHallsId)
{
ConferenceHallsDAC conferencehallsComponent = new ConferenceHallsDAC();
return conferencehallsComponent.UpdateConferenceHalls( conferencehalls.Name, conferencehalls.ConferenceId, conferencehalls.MapPath, old_conferenceHallsId);
}