Guest User

Untitled

a guest
Jan 29th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.94 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. <table class="table">
  42. <tr>
  43. <td colspan="8" class="text-center"><b>CUSTOMER NAME</b></td>
  44. </tr>
  45. <tr>
  46. <td colspan="4" class="text-left">ORDER DATE</td>
  47. <td colspan="4" class="text-right">REFERENCE NUMBER</td>
  48. </tr>
  49. <tr>
  50. <td colspan="2" class="text-left">CONTACT NUMBER</td>
  51. <td colspan="4" class="text-right">BILLING ADDRESS</td>
  52. </tr>
  53. </table>
  54.  
  55. @foreach (var item in Model)
  56. {
  57. <tr>
  58. <td class="text-center">@item.product</td>
  59. <td class="text-center">@item.Note</td>
  60. <td class="text-center">@item.Price</td>
  61. <td class="text-center">@item.Qty</td>
  62. <td class="text-center">@item.Discount</td>
  63. <td class="text-center">@item.Tax_Pkr</td>
  64. <td class="text-center">@item.Subtotal</td>
  65. </tr>
  66. }
  67.  
  68. <tr>
  69.  
  70. <td colspan="6" class="text-center"><b>@Model.AsEnumerable().Sum(o=>o.Subtotal)</b></td>
  71. </tr>
  72.  
  73. [MetadataType(typeof(OrdersDetailsMeta))]
  74. public partial class tbl_Orders_Details
  75. {
  76. public string customer { get; set; }
  77. public string contact { get; set; }
  78. }
  79.  
  80. public class OrdersDetailsMeta
  81. {
  82. public int Order_Detail_ID { get; set; }
  83. public string Order_ref_No { get; set; }
  84. public string product { get; set; }
  85. public string Note { get; set; }
  86. public decimal Price { get; set; }
  87. public decimal Qty { get; set; }
  88. public decimal Tax_Pkr { get; set; }
  89. public decimal Discount { get; set; }
  90. public decimal Subtotal { get; set; }
  91. }
  92.  
  93. Model.AsEnumerable().Sum(o=>o.Subtotal);
Add Comment
Please, Sign In to add comment