Guest User

Untitled

a guest
Jan 29th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. public ActionResult GetproductDetails(string id)
  2. {
  3. List<tbl_Orders_Details> ODList = null;
  4.  
  5. var OD = (from D in db.tbl_Orders_Details
  6. join O in db.tbl_Orders
  7. on D.Order_ref_No equals O.Refrence_No
  8. where D.Order_ref_No == id
  9. select new
  10. {
  11. D.Price,
  12. D.product,
  13. D.Note,
  14. D.Qty,
  15. D.Tax_Pkr,
  16. D.Discount,
  17. D.Subtotal
  18.  
  19. }).ToList();
  20.  
  21.  
  22. ODList = new List<tbl_Orders_Details>();
  23. foreach (var i in OD)
  24. {
  25. tbl_Orders_Details SOD = new tbl_Orders_Details();
  26.  
  27. SOD.Price = i.Price;
  28. SOD.product = i.product;
  29. SOD.Note = i.Note;
  30. SOD.Qty = i.Qty;
  31. SOD.Tax_Pkr = i.Tax_Pkr;
  32. SOD.Discount = i.Discount;
  33. SOD.Subtotal = i.Subtotal;
  34. ODList.Add(SOD);
  35. }
  36.  
  37. return PartialView("GetproductDetails", ODList);
  38.  
  39. }
  40.  
  41. @foreach (var item in Model)
  42. {
  43. <tr>
  44. <td class="text-center">@item.product</td>
  45. <td class="text-center">@item.Note</td>
  46. <td class="text-center">@item.Price</td>
  47. <td class="text-center">@item.Qty</td>
  48. <td class="text-center">@item.Discount</td>
  49. <td class="text-center">@item.Tax_Pkr</td>
  50. <td class="text-center">@item.Subtotal</td>
  51. </tr>
  52. }
  53.  
  54. <tr>
  55. //Here i want Grand total of all Products
  56. <td colspan="6" class="text-center"><b>GRAND TOTAL</b></td>
  57. </tr>
Add Comment
Please, Sign In to add comment