Unable to display LINQ query output values from controller to view

Question

Controller

public ActionResult Track(string awb)

    {

        ViewBag.Title = "Track Your Shipment";

        ViewBag.ErrorMessage = string.Empty;

        ViewBag.ShipmentNo = awb;

        FLCourierDetail trackOutput = new FLCourierDetail();



        if (awb != null)

        {

            trackOutput = db.FL_CourierDetail.SingleOrDefault(fLCourierDetail => fLCourierDetail.AWBNumber == awb);

            if (trackOutput != null)

            {

                var courierId = db.FL_CourierDetail.Where(s => s.AWBNumber == awb).Select(s => s.Courier);

                var currentStatus = (from c in db.FL_CourierDetail

                                     join s in db.FL_CourierStatus

                                     on c.Courier equals s.CourierId

                                     where c.AWBNumber == awb

                                     select new { awb = c.AWBNumber, staus = s.StatusId, updated = s.StatusId, remark = s.Remark }).ToList();

                ViewBag.CurrentStatus = currentStatus;

            }

            else

            {

                ViewBag.ErrorMessage = "Shipment number not found.";

            }

        }

        else

        {

            ViewBag.ErrorMessage = "Please provide valid Shipment number.";

        }



        return View(trackOutput);

    }

View

       <div class="col-md-6">

            @{ 

                var status = ViewBag.CurrentStatus;



                foreach (var item in status)

                {

                    <p>@item</p>

                }

            }

        </div>

If I iterate using foreach or if loop I am able to see the data in debug, but I am not able to write in html.

Debug

Web Page

Error

I am not able to read each value like awb, status, date etc.

Did I miss anything here?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

The query result is an anonymous class, within the loop, each item is an object and thus the exception, object has now awb property.

One way to solve this is by defining a class:

public class Status {
    public string awb { get; set; }
    public int staus { get; set; }
    public int updated { get; set; }
    public string remark { get; set; }
}

Then your select would look like:

... select new Status { awb = c.AWBNumber, staus = s.StatusId, updated = s.StatusId, remark = s.Remark }).ToList();

Then, within the View:

var status = (List<Status>) ViewBag.CurrentStatus;