public List<Hotel> GetAllByConferenceID(int ConferenceID) { HotelDAC _hotelComponent = new HotelDAC(); IDataReader reader = _hotelComponent.GetAllHotel("ConferenceID = " + ConferenceID).CreateDataReader(); List<Hotel> _hotelList = new List<Hotel>(); while (reader.Read()) { if (_hotelList == null) _hotelList = new List<Hotel>(); Hotel _hotel = new Hotel(); if (reader["ID"] != DBNull.Value) _hotel.ID = Convert.ToInt32(reader["ID"]); if (reader["Name"] != DBNull.Value) _hotel.Name = Convert.ToString(reader["Name"]); if (reader["Description"] != DBNull.Value) _hotel.Description = Convert.ToString(reader["Description"]); if (reader["Location"] != DBNull.Value) _hotel.Location = Convert.ToString(reader["Location"]); if (reader["Star"] != DBNull.Value) _hotel.Star = Convert.ToInt32(reader["Star"]); if (reader["URL"] != DBNull.Value) _hotel.URL = Convert.ToString(reader["URL"]); if (reader["Phone"] != DBNull.Value) _hotel.Phone = Convert.ToString(reader["Phone"]); if (reader["Fax"] != DBNull.Value) _hotel.Fax = Convert.ToString(reader["Fax"]); if (reader["Email"] != DBNull.Value) _hotel.Email = Convert.ToString(reader["Email"]); if (reader["ConferenceID"] != DBNull.Value) _hotel.ConferenceID = Convert.ToInt32(reader["ConferenceID"]); _hotel.NewRecord = false; _hotelList.Add(_hotel); } reader.Close(); return _hotelList; }
public bool Insert(Hotel hotel) { int autonumber = 0; HotelDAC hotelComponent = new HotelDAC(); bool endedSuccessfuly = hotelComponent.InsertNewHotel(ref autonumber, hotel.Name, hotel.Description, hotel.Location, hotel.Star, hotel.URL, hotel.Phone, hotel.Fax, hotel.Email,hotel.ConferenceID); if (endedSuccessfuly) { hotel.ID = autonumber; } return endedSuccessfuly; }
public bool Update(Hotel hotel, int old_iD) { HotelDAC hotelComponent = new HotelDAC(); return hotelComponent.UpdateHotel(hotel.Name, hotel.Description, hotel.Location, hotel.Star, hotel.URL, hotel.Phone, hotel.Fax, hotel.Email,hotel.ConferenceID, old_iD); }
public Hotel GetByID(int _iD) { HotelDAC _hotelComponent = new HotelDAC(); IDataReader reader = _hotelComponent.GetByIDHotel(_iD); Hotel _hotel = null; while (reader.Read()) { _hotel = new Hotel(); if (reader["ID"] != DBNull.Value) _hotel.ID = Convert.ToInt32(reader["ID"]); if (reader["Name"] != DBNull.Value) _hotel.Name = Convert.ToString(reader["Name"]); if (reader["Description"] != DBNull.Value) _hotel.Description = Convert.ToString(reader["Description"]); if (reader["Location"] != DBNull.Value) _hotel.Location = Convert.ToString(reader["Location"]); if (reader["Star"] != DBNull.Value) _hotel.Star = Convert.ToInt32(reader["Star"]); if (reader["URL"] != DBNull.Value) _hotel.URL = Convert.ToString(reader["URL"]); if (reader["Phone"] != DBNull.Value) _hotel.Phone = Convert.ToString(reader["Phone"]); if (reader["Fax"] != DBNull.Value) _hotel.Fax = Convert.ToString(reader["Fax"]); if (reader["Email"] != DBNull.Value) _hotel.Email = Convert.ToString(reader["Email"]); if (reader["ConferenceID"] != DBNull.Value) _hotel.ConferenceID = Convert.ToInt32(reader["ConferenceID"]); _hotel.NewRecord = false; } reader.Close(); return _hotel; }