Id is displaying instead of Name on product

Mahesh Reddy

7y995Learn iOS Programming

Hi,

I have 3 tables

Product

.............

ProductID ProductName

1 Apple

2 Lenovo

Orders

............

OrderId OrderName

1 aaa

2 bbb

Items

...........

Id Name OrderId ProductID

1 dd 1 2

2 frr 1 1

3 ruur 2 1

i have one form and grid view

in grid view i jave one button

after clicking of that button i have to display relevant values on form based upon OrderId

In form relevant values are dispaying properly except at product

in Product it was dispalying only Id insted of Name

Could please any body help me

I am sharing here my edit script code

Code

............................

$scope.Edit = function (OrderId) {

debugger;

$scope.invoice = true;

var id = OrderId;

//var id = $scope.employees[index].OrderId;

$.post("/invoice/Edit/", { orderID: id }, function (r) {

debugger;

$scope.OrderId = r.Orders.OrderId;

$scope.OrderName = r.Orders.OrderName;

$scope.myData = [];

for (var i = 0; i < r.Items.length; i++) {

var customer = {};

customer.OrderId = r.Items[i].Names;

customer.OrderName = r.Items[i].Name;

customer.Id = r.Items[i].Id;

customer.Product = r.Items[i].ProductID;

customer.Name = r.Items[i].Name;

$scope.myData.push(customer);

}

});

}

View

...................

5 Replies

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

Piyush Pansuriya7y ago
Accepted answer
1. List listItem = new List();
2. var items = (from i in db.Items5
3. join p in db.Products on i.ProductID equals p.ProductID
4. where i.OrderId == orderID
5. select new
6. {
7. Id = i.Id,
8. Name=i.Name,
9. ProductID =i.ProductID,
10. ProductName = p.ProductName,
11. }).ToList();
12. foreach (var item in items)
13. {
14. listItem.Add(new Items5 { Id = item.Id,Name=item.Name, ProductID=item.ProductID, ProductName=item.ProductName});
15. }
Add Property ProductName is class Item5
string ProductName {get;set;}
+1