protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
// Get all the sales records
public JsonResult GetAllSales()
{
db.Configuration.LazyLoadingEnabled = false; // ignore JSON errors
var result = (dynamic)null;
if (db.ProductSolds.Any())
{
result = db.ProductSolds.Select(col => new
{
Id = col.Id,
Customer = col.Customer,
Product = col.Product,
Store = col.Store,
DateSold = col.DateSold
}).ToList();
db.Dispose();
return(Json(result, JsonRequestBehavior.AllowGet));
}
return(Json("FAILED", JsonRequestBehavior.DenyGet));
}
