Esempio n. 1
0
 public List<HotelLanguage> GetAll(int ParentID)
 {
     HotelLanguageDAC _hotelLanguageComponent = new HotelLanguageDAC();
     IDataReader reader = _hotelLanguageComponent.GetAllHotelLanguage("ParentID=" + ParentID).CreateDataReader();
     List<HotelLanguage> _hotelLanguageList = new List<HotelLanguage>();
     while (reader.Read())
     {
         if (_hotelLanguageList == null)
             _hotelLanguageList = new List<HotelLanguage>();
         HotelLanguage _hotelLanguage = new HotelLanguage();
         if (reader["ID"] != DBNull.Value)
             _hotelLanguage.ID = Convert.ToInt32(reader["ID"]);
         if (reader["Name"] != DBNull.Value)
             _hotelLanguage.Name = Convert.ToString(reader["Name"]);
         if (reader["Description"] != DBNull.Value)
             _hotelLanguage.Description = Convert.ToString(reader["Description"]);
         if (reader["Location"] != DBNull.Value)
             _hotelLanguage.Location = Convert.ToString(reader["Location"]);
         if (reader["Star"] != DBNull.Value)
             _hotelLanguage.Star = Convert.ToInt32(reader["Star"]);
         if (reader["URL"] != DBNull.Value)
             _hotelLanguage.URL = Convert.ToString(reader["URL"]);
         if (reader["Phone"] != DBNull.Value)
             _hotelLanguage.Phone = Convert.ToString(reader["Phone"]);
         if (reader["Fax"] != DBNull.Value)
             _hotelLanguage.Fax = Convert.ToString(reader["Fax"]);
         if (reader["Email"] != DBNull.Value)
             _hotelLanguage.Email = Convert.ToString(reader["Email"]);
         if (reader["LanguageID"] != DBNull.Value)
             _hotelLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
         if (reader["ParentID"] != DBNull.Value)
             _hotelLanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
         _hotelLanguage.NewRecord = false;
         _hotelLanguageList.Add(_hotelLanguage);
     } reader.Close();
     return _hotelLanguageList;
 }
Esempio n. 2
0
 public bool Insert(HotelLanguage hotellanguage)
 {
     int autonumber = 0;
     HotelLanguageDAC hotellanguageComponent = new HotelLanguageDAC();
     bool endedSuccessfuly = hotellanguageComponent.InsertNewHotelLanguage( ref autonumber,  hotellanguage.Name,  hotellanguage.Description,  hotellanguage.Location,  hotellanguage.Star,  hotellanguage.URL,  hotellanguage.Phone,  hotellanguage.Fax,  hotellanguage.Email,  hotellanguage.LanguageID,  hotellanguage.ParentID);
     if(endedSuccessfuly)
     {
         hotellanguage.ID = autonumber;
     }
     return endedSuccessfuly;
 }
Esempio n. 3
0
 public bool Update(HotelLanguage hotellanguage ,int old_iD)
 {
     HotelLanguageDAC hotellanguageComponent = new HotelLanguageDAC();
     return hotellanguageComponent.UpdateHotelLanguage( hotellanguage.Name,  hotellanguage.Description,  hotellanguage.Location,  hotellanguage.Star,  hotellanguage.URL,  hotellanguage.Phone,  hotellanguage.Fax,  hotellanguage.Email,  hotellanguage.LanguageID,  hotellanguage.ParentID,  old_iD);
 }
Esempio n. 4
0
 public HotelLanguage GetByID(int _iD)
 {
     HotelLanguageDAC _hotelLanguageComponent = new HotelLanguageDAC();
      IDataReader reader = _hotelLanguageComponent.GetByIDHotelLanguage(_iD);
      HotelLanguage _hotelLanguage = null;
      while(reader.Read())
      {
          _hotelLanguage = new HotelLanguage();
          if(reader["ID"] != DBNull.Value)
              _hotelLanguage.ID = Convert.ToInt32(reader["ID"]);
          if(reader["Name"] != DBNull.Value)
              _hotelLanguage.Name = Convert.ToString(reader["Name"]);
          if(reader["Description"] != DBNull.Value)
              _hotelLanguage.Description = Convert.ToString(reader["Description"]);
          if(reader["Location"] != DBNull.Value)
              _hotelLanguage.Location = Convert.ToString(reader["Location"]);
          if(reader["Star"] != DBNull.Value)
              _hotelLanguage.Star = Convert.ToInt32(reader["Star"]);
          if(reader["URL"] != DBNull.Value)
              _hotelLanguage.URL = Convert.ToString(reader["URL"]);
          if(reader["Phone"] != DBNull.Value)
              _hotelLanguage.Phone = Convert.ToString(reader["Phone"]);
          if(reader["Fax"] != DBNull.Value)
              _hotelLanguage.Fax = Convert.ToString(reader["Fax"]);
          if(reader["Email"] != DBNull.Value)
              _hotelLanguage.Email = Convert.ToString(reader["Email"]);
          if(reader["LanguageID"] != DBNull.Value)
              _hotelLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]);
          if(reader["ParentID"] != DBNull.Value)
              _hotelLanguage.ParentID = Convert.ToInt32(reader["ParentID"]);
      _hotelLanguage.NewRecord = false;             }             reader.Close();
      return _hotelLanguage;
 }