public string InsertCancellaion(string provisionalId)
 {
     try
     {
         string strReturn = "";
         HotelBAL obj = new HotelBAL();
         obj.ProvisionalId = Convert.ToInt32(provisionalId);
         bool b = obj.AddHotelCancellation();
         if (b) { strReturn = "Success"; } else { strReturn = ""; }
         return strReturn;
     }
     catch (Exception ex)
     {
         lblMsg.Text = ex.Message;
         throw;
     }
 }
    public string InsertCancellaion(string provisionalId, string bookingId, double refundAmount, double cancellationCharges, int createdBy, string hotelCancellationId)
    {
        try
        {
            string strReturn = "";
            HotelBAL obj = new HotelBAL();
            obj.ProvisionalId = Convert.ToInt32(provisionalId);
            obj.BookingId = Convert.ToInt32(bookingId);
            obj.RefundAmount = refundAmount;
            obj.CancellationCharges = cancellationCharges;
            obj.CreatedBy = createdBy;
            obj.HotelCancellationId = hotelCancellationId;

            bool b = obj.AddHotelCancellation();
            if (b) { strReturn = "Success"; } else { strReturn = ""; }
            return strReturn;
        }
        catch (Exception ex)
        {
            lblMsg.Text = ex.Message;
            throw;
        }
    }