/// <summary>
        /// To Display Bookings according to Rooms
        /// </summary>
        /// <param name="RoomId"></param>
        /// <returns></returns>
        public static List <BookingDetails> DisplayAllRoomBookingBL(string RoomId)
        {
            List <BookingDetails> rlist = new List <BookingDetails>();

            try
            {
                rlist = HMS_DAL.ShowAllRoomBookingDetailsDAL(RoomId);
                if (rlist == null)
                {
                    throw new HMS_Exception("No Booking Found");
                }
            }
            catch (HMS_Exception p)
            {
                throw p;
            }
            catch (SqlException e)
            {
                throw e;
            }
            return(rlist); // Returns the list of Booking
        }