/// <summary>
        /// Search hotel on basis of city
        /// </summary>
        /// <param name="city"></param>
        /// <returns></returns>
        public static List <Hotel> SearchAllHotelBL(string city)
        {
            List <Hotel> Hlist = new List <Hotel>();

            try
            {
                Hlist = HMS_DAL.SearchHotelDAL(city);
                if (Hlist == null)
                {
                    throw new HMS_Exception("No Hotel Found");
                }
            }
            catch (HMS_Exception p)
            {
                throw p;
            }
            catch (SqlException e)
            {
                throw e;
            }
            return(Hlist); // Returns the list of Hotel
        }