Unable to Count Final column

Hello team ,

Please any further help will be highly appreciated 

Hello Sangeetha S

Thank you for your response, but however this code is causing the data not to even load  again, as you can see in the screenshot

// Return the JSON result
              return Json(new { bookings = modifiedData, totalAmount = total }, JsonRequestBehavior.AllowGet);

Hi, 

• Date Filtering: The filtering based on BookingFrom and BookingTo is applied before grouping the results. This ensures that only bookings within the specified date range are included in the grouping and summation.
• Total Calculation: The total amount is calculated after the filtering and grouping, ensuring that it only sums the relevant records.
• Returning Total Amount: The total amount is included in the JSON response for convenience. 

public ActionResult GetAllBookingHistoryPDF(string RoomNumber, string sDate = null, string eDate = null)
{
    // Convert the start and end dates
    DateTime? startDate = string.IsNullOrEmpty(sDate) ? (DateTime?)null : Convert.ToDateTime(sDate);
    DateTime? endDate = string.IsNullOrEmpty(eDate) ? (DateTime?)null : Convert.ToDateTime(eDate);

    // Join RoomBookings with Rooms
    var bookingList = objHotelDbEntities.RoomBookings
        .Join(objHotelDbEntities.Rooms,
            booking => booking.AssignRoomId,
            room => room.RoomId,
            (booking, room) => new { booking, room });

    // Apply date range filtering before grouping
    if (startDate.HasValue && endDate.HasValue)
    {
        bookingList = bookingList.Where(b => b.booking.BookingFrom >= startDate.Value && b.booking.BookingTo <= endDate.Value);
    }

    // Grouping and selecting the required fields
    var modifiedData = bookingList
        .GroupBy(x => new { x.booking.BookingFrom, x.booking.BookingTo, x.booking.BookingId })
        .Select(x => new AllBookingDetail
        {
            CustomerName = x.FirstOrDefault().booking.CustomerName,
            Address = x.FirstOrDefault().booking.Address,
            PhoneNo = x.FirstOrDefault().booking.PhoneNo,
            BookingFrom = x.Key.BookingFrom,
            BookingTo = x.Key.BookingTo,
            BookingId = x.FirstOrDefault().booking.BookingId,
            RoomNumber = x.FirstOrDefault().room.RoomNumber,
            NoOfMembers = x.FirstOrDefault().booking.NoOfMembers,
            numberOfDays = System.Data.Entity.DbFunctions.DiffDays(x.Key.BookingFrom, x.Key.BookingTo).Value,
            RoomPrice = x.FirstOrDefault().room.RoomPrice,
            TotalAmount = x.Sum(a => a.booking.TotalAmount)
        }).ToList();

    // Calculate the total amount for the filtered results
    decimal total = modifiedData.Sum(a => a.TotalAmount);

    // Return the JSON result
    return Json(new { bookings = modifiedData, totalAmount = total }, JsonRequestBehavior.AllowGet);
}

JS Function

$scope.DateChange = function (e) {
    $http({
        url: '/Home/GetAllBookingHistoryPDF',
        method: 'GET',
        params: { sDate: $scope.sDate, eDate: $scope.eDate }
    }).then(function (response) {
        var data = response.data;
        $scope.PrintBookingRecordList = data;
        sumOfSalesDetails($scope);

    })
}

function sumOfSalesDetails($scope) {
    $scope.FinalTotal = 0;
    $.each($scope.PrintBookingRecordList.modifiedData, function (index, val) {              
        $scope.FinalTotal += val.TotalAmount;
    })
}

HTML

    

        From:
    
    

        To:
    



    
                                        
        
Total amount Ghc:{{FinalTotal}}