Guest User

Untitled

a guest
Jul 18th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.04 KB | None | 0 0
  1. <table class="table table-bordered table-striped">
  2. <tr>
  3. <th>
  4. @Html.DisplayNameFor(model => model.Sale.Date)
  5. </th>
  6. <th>
  7. @Html.DisplayNameFor(model => model.Sale.Warehouse.Name)
  8. </th>
  9. <th>
  10. @Html.DisplayNameFor(model => model.Description)
  11. </th>
  12. <th>
  13. @Html.DisplayNameFor(model => model.Price)
  14. </th>
  15. <th>
  16. @Html.DisplayNameFor(model => model.Quantity)
  17. </th>
  18. </tr>
  19. @foreach (var item in Model)
  20. {
  21. <tr>
  22. <td>
  23. @Html.DisplayFor(modelItem => item.Sale.Date)
  24. </td>
  25. <td>
  26. @Html.DisplayFor(modelItem => item.Sale.Warehouse.Name)
  27. </td>
  28. <td>
  29. @Html.DisplayFor(modelItem => item.Description)
  30. </td>
  31. <td>
  32. @Html.DisplayFor(modelItem => item.Price)
  33. </td>
  34. <td>
  35. @Html.DisplayFor(modelItem => item.Quantity)
  36. </td>
  37. </tr>
  38. }
  39. <tr>
  40. <td colspan="3" align="center">
  41. <strong>Totals</strong>
  42. </td>
  43. <td align="center">
  44. <strong>Total Price</strong>
  45. </td>
  46. <td align="center">
  47. <strong>Total Quantity</strong>
  48. </td>
  49. </tr>
  50. </table>
  51.  
  52. public class SaleDetail
  53. {
  54. [Key]
  55. public int SaleDetailId { get; set; }
  56.  
  57. [Required(ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorFieldRequired")]
  58. public int SaleId { get; set; }
  59.  
  60. [Required(ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorFieldRequired")]
  61. public int ProductId { get; set; }
  62.  
  63. [Required(ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorFieldRequired")]
  64. [StringLength(50, ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorStringMaxMin", MinimumLength = 1)]
  65. [Display(ResourceType = typeof(Strings), Name = "Product")]
  66. public string Description { get; set; }
  67.  
  68. [Required(ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorFieldRequired")]
  69. [DisplayFormat(DataFormatString = "{0:C2}", ApplyFormatInEditMode = false)]
  70. [Range(0, double.MaxValue, ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorDecimal")]
  71. [Display(ResourceType = typeof(Strings), Name = "Price")]
  72. public decimal Price { get; set; }
  73.  
  74. [Required(ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorFieldRequired")]
  75. [DisplayFormat(DataFormatString = "{0:N2}", ApplyFormatInEditMode = false)]
  76. [Range(0, double.MaxValue, ErrorMessageResourceType = typeof(Strings), ErrorMessageResourceName = "ErrorDecimal")]
  77. [Display(ResourceType = typeof(Strings), Name = "Quantity")]
  78. public double Quantity { get; set; }
  79.  
  80. public virtual Sale Sale { get; set; }
  81.  
  82. public virtual Product Product { get; set; }
  83. }
  84.  
  85. public ActionResult DateSales(string value)
  86. {
  87. var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
  88. var view = db.SaleDetails.Include(s => s.Sale).Where(s => s.Sale.Warehouse.CompanyId == user.CompanyId && s.Sale.Date == DateTime.Today);
  89. return View(view.ToList());
  90. }
Add Comment
Please, Sign In to add comment