CODEWITHSUNDEEP
c#asp.net-mvcentity-framework-5
John Paul Cirilos
John Paul Cirilos

Reputation: 137

MVC working with id's

I have this display job order action

public ActionResult jobOrderList(int id)
{
     var SelectedTruck = db.trucks.FirstOrDefault(s => s.id == id);

     List<JobOrderDetails> joList = db.joborders.Select(s => new JobOrderDetails()
     {

         id = s.id,
         DateStarted = s.date_started,
         Description = s.description,
         DateFinished = s.date_finished,
         SpareParts = s.spare_parts,
         kilometer_run = s.run,
         Quantity = s.quantity,
         truck_no = s.truck_no,
         worked_performed = s.worked_performed

     }).ToList();

     return View(joList);
}

how can i display the list of job orders of the selected truck variable.

Upvotes: 0

Views: 55

Answers (1)

jdaval
jdaval

Reputation: 640

I believe this is what you are asking. 

     var SelectedTruck = db.trucks.FirstOrDefault(s => s.id == id);

List<JobOrderDetails> joList = db.joborders.Where(jo => jo.truck_no == SelectedTruck.truck_no).Select(s => new JobOrderDetails()
                 {

                     id = s.id,
                     DateStarted = s.date_started,
                     Description = s.description,
                     DateFinished = s.date_finished,
                     SpareParts = s.spare_parts,
                     kilometer_run = s.run,
                     Quantity = s.quantity,
                     truck_no = s.truck_no,
                     worked_performed = s.worked_performed

                 }).ToList();

Upvotes: 2

Related Questions