Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ActionResult GetproductDetails(string id)
- {
- List<tbl_Orders_Details> ODList = null;
- var OD = (from D in db.tbl_Orders_Details
- join O in db.tbl_Orders
- on D.Order_ref_No equals O.Refrence_No
- where D.Order_ref_No == id
- select new
- {
- D.Price,
- D.product,
- D.Note,
- D.Qty,
- D.Tax_Pkr,
- D.Discount,
- D.Subtotal
- }).ToList();
- ODList = new List<tbl_Orders_Details>();
- foreach (var i in OD)
- {
- tbl_Orders_Details SOD = new tbl_Orders_Details();
- SOD.Price = i.Price;
- SOD.product = i.product;
- SOD.Note = i.Note;
- SOD.Qty = i.Qty;
- SOD.Tax_Pkr = i.Tax_Pkr;
- SOD.Discount = i.Discount;
- SOD.Subtotal = i.Subtotal;
- ODList.Add(SOD);
- }
- return PartialView("GetproductDetails", ODList);
- }
- @foreach (var item in Model)
- {
- <tr>
- <td class="text-center">@item.product</td>
- <td class="text-center">@item.Note</td>
- <td class="text-center">@item.Price</td>
- <td class="text-center">@item.Qty</td>
- <td class="text-center">@item.Discount</td>
- <td class="text-center">@item.Tax_Pkr</td>
- <td class="text-center">@item.Subtotal</td>
- </tr>
- }
- <tr>
- //Here i want Grand total of all Products
- <td colspan="6" class="text-center"><b>GRAND TOTAL</b></td>
- </tr>
Add Comment
Please, Sign In to add comment