public bool Insert(string Name, string Description, string Location, int Star, string URL, string Phone, string Fax, string Email, int LanguageID, int ParentID)
{
HotelLanguageDAC hotellanguageComponent = new HotelLanguageDAC();
int ID = 0;
return(hotellanguageComponent.InsertNewHotelLanguage(ref ID, Name, Description, Location, Star, URL, Phone, Fax, Email, LanguageID, ParentID));
}
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);
}
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);
}
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);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
HotelLanguageDAC hotellanguagecomponent = new HotelLanguageDAC();
return(hotellanguagecomponent.UpdateDataset(dataset));
}
public void Delete(int Original_ID)
{
HotelLanguageDAC hotellanguageComponent = new HotelLanguageDAC();
hotellanguageComponent.DeleteHotelLanguage(Original_ID);
}
public bool Update(string Name, string Description, string Location, int Star, string URL, string Phone, string Fax, string Email, int LanguageID, int ParentID, int Original_ID)
{
HotelLanguageDAC hotellanguageComponent = new HotelLanguageDAC();
return(hotellanguageComponent.UpdateHotelLanguage(Name, Description, Location, Star, URL, Phone, Fax, Email, LanguageID, ParentID, Original_ID));
}
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));
}
