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 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 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 bool Update(ConferenceHalls conferencehalls, int old_conferenceHallsId) { ConferenceHallsDAC conferencehallsComponent = new ConferenceHallsDAC(); return(conferencehallsComponent.UpdateConferenceHalls(conferencehalls.Name, conferencehalls.ConferenceId, conferencehalls.MapPath, old_conferenceHallsId)); }