public static ArrayList SearchHotelByCityName(string city)
{
DatabaseProviderFactory dbPFactory = new DatabaseProviderFactory();
Database defaultDb = dbPFactory.CreateDefault();
Database database = dbPFactory.Create(DBName);
DbCommand dbcommand = database.GetStoredProcCommand("spSearchHotelByCityName");
database.AddInParameter(dbcommand, "cityName", System.Data.DbType.String, city);
DataSet dataset = database.ExecuteDataSet(dbcommand);
return(TranslateHotel.ConvertDataSetToArrayList(dataset));
}
public Hotel SelectHotel(int id)
{
DatabaseProviderFactory dbPFactory = new DatabaseProviderFactory();
Database defaultDb = dbPFactory.CreateDefault();
Database database = dbPFactory.Create(DBName);
DbCommand dbcommand = database.GetStoredProcCommand("spSelectHotel");
database.AddInParameter(dbcommand, "HotelId", System.Data.DbType.Int32, id);
DataSet dataset = database.ExecuteDataSet(dbcommand);
return(TranslateHotel.PaserHotel(dataset));
}
