in controller
NLPEntities _Context = new NLPEntities();
List<ShipmentData> _shipData = new List<ShipmentData>();
var _shipmentdata = (from sh in _Context.Shipments
join inct in _Context.Incoterms on sh.IncotermId equals inct.Id
select new
{
sh.Piece,
sh.Height,
sh.Length,
sh.DepartureDate,
sh.PickupFrom,
sh.DeliverTo,
sh.Weight,
sh.WeightUnit,
sh.Width,
inct.Description,
sh.Unit
}).ToList();
foreach (var item in _shipmentdata)
{
_shipData.Add(new ShipmentData()
{
Piece = item.Piece,
Height = item.Height,
Description=item.Description
});
}
ViewBag.ShipmentData = _shipData;
return View(ViewBag.ShipmentData);
in view
@foreach (var item in ViewBag.ShipmentData as IEnumerable<NLP.Models.ShipmentData>)
{
NLPEntities _Context = new NLPEntities();
List<ShipmentData> _shipData = new List<ShipmentData>();
var _shipmentdata = (from sh in _Context.Shipments
join inct in _Context.Incoterms on sh.IncotermId equals inct.Id
select new
{
sh.Piece,
sh.Height,
sh.Length,
sh.DepartureDate,
sh.PickupFrom,
sh.DeliverTo,
sh.Weight,
sh.WeightUnit,
sh.Width,
inct.Description,
sh.Unit
}).ToList();
foreach (var item in _shipmentdata)
{
_shipData.Add(new ShipmentData()
{
Piece = item.Piece,
Height = item.Height,
Description=item.Description
});
}
ViewBag.ShipmentData = _shipData;
return View(ViewBag.ShipmentData);
in view
@foreach (var item in ViewBag.ShipmentData as IEnumerable<NLP.Models.ShipmentData>)
{