public bool Insert(string Name, string Description, string Location, int Star, string URL, string Phone, string Fax, string Email, int ConferenceID) { HotelDAC hotelComponent = new HotelDAC(); int ID = 0; return(hotelComponent.InsertNewHotel(ref ID, Name, Description, Location, Star, URL, Phone, Fax, Email, ConferenceID)); }
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 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); }
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 int UpdateDataset(System.Data.DataSet dataset) { HotelDAC hotelcomponent = new HotelDAC(); return(hotelcomponent.UpdateDataset(dataset)); }
public void Delete(int Original_ID) { HotelDAC hotelComponent = new HotelDAC(); hotelComponent.DeleteHotel(Original_ID); }
public bool Update(string Name, string Description, string Location, int Star, string URL, string Phone, string Fax, string Email, int ConferenceID, int Original_ID) { HotelDAC hotelComponent = new HotelDAC(); return(hotelComponent.UpdateHotel(Name, Description, Location, Star, URL, Phone, Fax, Email, ConferenceID, Original_ID)); }
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)); }