//--------------------------------------------------------------------------
public List <Tour> init(SqlCommand cmd)
{
SqlConnection con = db.getConnection();
cmd.Connection = con;
List <Tour> l_Tour = new List <Tour>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Tour m_Tour = new Tour();
m_Tour.Tour_ID = smartReader.GetInt32("Tour_ID");
m_Tour.Tour_Name = smartReader.GetString("Tour_Name");
m_Tour.Tour_Location = smartReader.GetInt32("Tour_Location");
m_Tour.Tour_Topic = smartReader.GetString("Tour_Topic");
m_Tour.Tour_OrganizationalUnit = smartReader.GetString("Tour_OrganizationalUnit");
m_Tour.Tour_DepartureDate = smartReader.GetDateTime("Tour_DepartureDate");
m_Tour.Tour_TimeZone = smartReader.GetInt32("Tour_TimeZone");
m_Tour.Tour_Price = smartReader.GetInt32("Tour_Price");
m_Tour.Tour_PriceSale = smartReader.GetInt32("Tour_PriceSale");
m_Tour.Tour_Qty = smartReader.GetInt32("Tour_Qty");
m_Tour.Tour_Score = smartReader.GetFloat("Tour_Score");
m_Tour.Tour_Description = smartReader.GetString("Tour_Description");
m_Tour.Tour_Content = smartReader.GetString("Tour_Content");
m_Tour.Tour_Itinerary = smartReader.GetString("Tour_Itinerary");
m_Tour.Tour_Schedule = smartReader.GetString("Tour_Schedule");
m_Tour.Tour_Rules = smartReader.GetString("Tour_Rules");
m_Tour.Tour_ListImage = smartReader.GetString("Tour_ListImage");
m_Tour.Tour_Image = smartReader.GetString("Tour_Image");
m_Tour.Product_ID = smartReader.GetInt32("Product_ID");
m_Tour.Tour_Fixed = smartReader.GetBoolean("Tour_Fixed");
m_Tour.UserCreate = smartReader.GetInt32("UserCreate");
m_Tour.CreateDate = smartReader.GetDateTime("CreateDate");
m_Tour.Tour_Active = smartReader.GetBoolean("Tour_Active");
m_Tour.Tour_StarRate = smartReader.GetFloat("Tour_StarRate");
m_Tour.Hotel_ID = smartReader.GetInt32("Hotel_ID");
l_Tour.Add(m_Tour);
}
smartReader.disposeReader(reader);
return(l_Tour);
}
catch (SqlException err)
{
throw err;
}
finally
{
db.closeConnection(con);
}
}
//--------------------------------------------------------------------------
public List <Hotel_Evaluate> init(SqlCommand cmd)
{
SqlConnection con = db.getConnection();
cmd.Connection = con;
List <Hotel_Evaluate> l_ContactPersons = new List <Hotel_Evaluate>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Hotel_Evaluate m_ContactPersons = new Hotel_Evaluate();
m_ContactPersons.Hotel_Evaluate_ID = smartReader.GetInt32("Hotel_Evaluate_ID");
m_ContactPersons.Hotel_ID = smartReader.GetInt32("Hotel_ID");
m_ContactPersons.CreateBy = smartReader.GetString("CreateBy");
m_ContactPersons.Created = smartReader.GetDateTime("Created");
m_ContactPersons.Score = smartReader.GetFloat("Score");
m_ContactPersons.Content = smartReader.GetString("Content");
l_ContactPersons.Add(m_ContactPersons);
}
smartReader.disposeReader(reader);
return(l_ContactPersons);
}
catch (SqlException err)
{
throw err;
}
finally
{
db.closeConnection(con);
}
}
public List <RoomHotel> init(SqlCommand cmd)
{
SqlConnection con = db.getConnection();
cmd.Connection = con;
List <RoomHotel> l_RoomHotel = new List <RoomHotel>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
RoomHotel m_RoomHotel = new RoomHotel();
m_RoomHotel.RoomHotel_ID = smartReader.GetInt32("RoomHotel_ID");
m_RoomHotel.RoomHotel_Title = smartReader.GetString("RoomHotel_Title");
m_RoomHotel.RoomHotel_Image = smartReader.GetString("RoomHotel_Image");
m_RoomHotel.RoomHotel_ListImage = smartReader.GetString("RoomHotel_ListImage");
m_RoomHotel.Hotel_ID = smartReader.GetInt32("Hotel_ID");
m_RoomHotel.RoomHotel_Type = smartReader.GetInt32("RoomHotel_Type");
m_RoomHotel.RoomHotel_Content = smartReader.GetString("RoomHotel_Content");
m_RoomHotel.RoomHotel_Extensions = smartReader.GetString("RoomHotel_Extensions");
m_RoomHotel.RoomHotel_View = smartReader.GetString("RoomHotel_View");
m_RoomHotel.RoomHotel_Bed = smartReader.GetString("RoomHotel_Bed");
m_RoomHotel.RoomHotel_Adutls = smartReader.GetInt32("RoomHotel_Adutls");
m_RoomHotel.RoomHotel_Infants = smartReader.GetInt32("RoomHotel_Infants");
m_RoomHotel.RoomHotel_Acreage = smartReader.GetFloat("RoomHotel_Acreage");
m_RoomHotel.RoomHotel_TotalPrice = smartReader.GetInt64("RoomHotel_TotalPrice");
m_RoomHotel.RoomHotel_DateStart = smartReader.GetDateTime("RoomHotel_DateStart");
m_RoomHotel.RoomHotel_DateEndArray = smartReader.GetDateTime("RoomHotel_DateEndArray");
m_RoomHotel.Hotel_TimeZone = smartReader.GetInt32("Hotel_TimeZone");
m_RoomHotel.Hotel_Price = smartReader.GetInt32("Hotel_Price");
m_RoomHotel.Hotel_PriceSale = smartReader.GetInt32("Hotel_PriceSale");
m_RoomHotel.Hotel_Qty = smartReader.GetInt32("Hotel_Qty");
l_RoomHotel.Add(m_RoomHotel);
}
smartReader.disposeReader(reader);
return(l_RoomHotel);
}
catch (SqlException err)
{
throw err;
}
finally
{
db.closeConnection(con);
}
}
//--------------------------------------------------------------------------
public List <Hotel> init(SqlCommand cmd)
{
SqlConnection con = db.getConnection();
cmd.Connection = con;
List <Hotel> l_Hotel = new List <Hotel>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
Hotel m_Hotel = new Hotel();
m_Hotel.Hotel_ID = smartReader.GetInt32("Hotel_ID");
m_Hotel.Hotel_Name = smartReader.GetString("Hotel_Name");
m_Hotel.Hotel_Location = smartReader.GetInt32("Hotel_Location");
m_Hotel.Hotel_Address = smartReader.GetString("Hotel_Address");
m_Hotel.Hotel_Content = smartReader.GetString("Hotel_Content");
m_Hotel.HotelImage = smartReader.GetString("HotelImage");
m_Hotel.Hotel_StarRate = smartReader.GetFloat("Hotel_StarRate");
m_Hotel.Hotel_ListImage = smartReader.GetString("Hotel_ListImage");
m_Hotel.Product_ID = smartReader.GetInt32("Product_ID");
m_Hotel.UserCreate = smartReader.GetInt32("UserCreate");
m_Hotel.Hotel_CreateDate = smartReader.GetDateTime("Hotel_CreateDate");
m_Hotel.Hotel_RulesRefund = smartReader.GetString("Hotel_RulesRefund");
m_Hotel.Hotel_Facilities_ID = smartReader.GetString("Hotel_Facilities_ID");
m_Hotel.Tag_ID = smartReader.GetString("Tag_ID");
l_Hotel.Add(m_Hotel);
}
smartReader.disposeReader(reader);
return(l_Hotel);
}
catch (SqlException err)
{
throw err;
}
finally
{
db.closeConnection(con);
}
}
