public IEnumerable <string> insertRoomBooking(string BookingID, string RoomID, string BookedDateFR, string BookedDateTO, string BookingStatus, string PaymentStatus, string AdvancePayed, string TotalAmountPayed)
        {
            if (BookingID == null)
            {
                BookingID = "0";
            }

            if (RoomID == null)
            {
                RoomID = "0";
            }

            if (BookedDateFR == null)
            {
                BookedDateFR = "";
            }
            else
            {
                BookedDateFR = BookedDateFR.Substring(0, 10);
            }

            if (BookedDateTO == null)
            {
                BookedDateTO = "";
            }
            else
            {
                BookedDateTO = BookedDateTO.Substring(0, 10);
            }

            if (BookingStatus == null)
            {
                BookingStatus = "";
            }

            if (PaymentStatus == null)
            {
                PaymentStatus = "";
            }

            if (AdvancePayed == null)
            {
                AdvancePayed = "";
            }

            if (TotalAmountPayed == null)
            {
                TotalAmountPayed = "";
            }

            return(db.USP_RoomBooking_Insert(BookingID, RoomID, BookedDateFR, BookedDateTO, BookingStatus, PaymentStatus, AdvancePayed, TotalAmountPayed).AsEnumerable());
        }