Exemplo n.º 1
0
 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;
 }
Exemplo n.º 2
0
 public int UpdateDataset(System.Data.DataSet dataset)
 {
     HotelDAC hotelcomponent = new HotelDAC();
     return hotelcomponent.UpdateDataset(dataset);
 }
Exemplo n.º 3
0
 public void Delete(int Original_ID)
 {
     HotelDAC hotelComponent = new HotelDAC();
     hotelComponent.DeleteHotel(Original_ID);
 }
Exemplo n.º 4
0
 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);
 }
Exemplo n.º 5
0
 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);
 }
Exemplo n.º 6
0
        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);
        }
Exemplo n.º 7
0
 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;
 }
Exemplo n.º 8
0
 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;
 }