// 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));
}
