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