// GET: Sales/Details/5 public ActionResult Details(int?id) { SaleTable saleTable = new SaleTable(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Sale sale = db.Sales.Find(id); saleTable.Id = sale.Id; IList <string> names = db.Customers.Where(c => c.Id == sale.CustomerId).Select(c => c.Name) .Concat(db.Products.Where(p => p.Id == sale.ProductId).Select(p => p.Name)) .Concat(db.Stores.Where(s => s.Id == sale.StoreId).Select(s => s.Name)).ToList(); saleTable.CustomerName = names[0]; saleTable.ProductName = names[1]; saleTable.StoreName = names[2]; saleTable.ProductId = sale.ProductId; saleTable.CustomerId = sale.CustomerId; saleTable.StoreId = sale.StoreId; saleTable.DateSold = sale.DateSold.ToString("dd-MM-yyyy"); return(Json(saleTable, JsonRequestBehavior.AllowGet)); }
// GET: Sales public ActionResult getAllSales() { IList <Sale> salesList = new List <Sale>(); IList <SaleTable> salesWithNavigationProperties = new List <SaleTable>(); salesList = db.Sales.ToList(); foreach (var sale in salesList) { SaleTable saleTable = new SaleTable(); saleTable.Id = sale.Id; IList <string> names = db.Customers.Where(c => c.Id == sale.CustomerId).Select(c => c.Name) .Concat(db.Products.Where(p => p.Id == sale.ProductId).Select(p => p.Name)) .Concat(db.Stores.Where(s => s.Id == sale.StoreId).Select(s => s.Name)).ToList(); saleTable.CustomerName = names[0]; saleTable.ProductName = names[1]; saleTable.StoreName = names[2]; saleTable.DateSold = sale.DateSold.ToString("dd-MM-yyyy"); salesWithNavigationProperties.Add(saleTable); } return(Json(salesWithNavigationProperties, JsonRequestBehavior.AllowGet)); }