public DS_Hotels.HotelsDataTable GetHotelDetail(int hotelID)
{
if (hotelID <= 0) return null;
string sql = @"
SELECT hotelID, hotelName, starRank, description, priceInfo, contactInfo,
status
FROM Hotels
WHERE hotelID=@hotelID";
SqlParameter[] para = {
new SqlParameter("@hotelID", hotelID)
};
DS_Hotels ds = new DS_Hotels();
m_dao.FillDataSet(ds, "Hotels", sql, para);
return ds.Hotels;
}
public DS_Hotels.HotelsDataTable GetHotelList(int status)
{
string sql = @"
SELECT hotelID, hotelName, starRank, description, priceInfo, contactInfo,
status
FROM Hotels
";
if (status > 0)
{
sql += " where status>0";
}
sql += " order by hotelName";
DS_Hotels ds = new DS_Hotels();
m_dao.FillDataSet(ds, "Hotels", sql, null);
return ds.Hotels;
}
