Loading

Retrieving data of user transaction in MVC

Rajesh Gami

i want to display all transaction of selected user in MVC.

When i select any user in user list (in Admin panel) then display all transaction of selected user in MVC.

----------- My Models

UserMaster_Model.cs => p.k UserId

TransactionMaster_Model.cs => p.k TRId , f.k UserId

----------My Controllers

UserMasterController.cs

TransactionMasterController.cs

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajesh Gami8y ago
ok.. i got it
solve with one slq query
add this code in UserMasterController
public ActionResult ProjectReport(TransactionMaster_Model trm, int id = 0)
       {
           int userID = Convert.ToInt32(Request["UserId"].ToString());

           var projects = _transactionMaster.GetAll()
             .Where(c => c.TRMCreatedBy.Equals(userID))
             .ToList();

           return View(projects);
       }
0
rajendra singh8y ago
You have to make join in linq or you can make view in backend and access that through entiity framework.....
+1