public ActionResult GetStoreName() { using (var db = new ProductSoldContext()) { var StoreNameList = db.Stores.Select(x => new { storeID = x.Id, storeName = x.Name, }).ToList(); return(Json(StoreNameList, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetProductName() { using (var db = new ProductSoldContext()) { var ProductNameList = db.Products.Select(x => new { productID = x.Id, productName = x.Name, }).ToList(); return(Json(ProductNameList, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetCustomerName() { using (var db = new ProductSoldContext()) { var customerNameList = db.Customers.Select(x => new { customerID = x.Id, customerName = x.Name, }).ToList(); return(Json(customerNameList, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetCustomerList() { using (var db = new ProductSoldContext()) { var CustList = db.Customers.Select(x => new { CustomerID = x.Id, Name = x.Name, Address = x.Address }).ToList(); return(Json(CustList, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetProductSoldList() { using (var db = new ProductSoldContext()) { var productSolds = db.ProductSolds.Include(p => p.Customer).Include(p => p.Product).Include(p => p.Store); var CustList = db.ProductSolds.Select(x => new { ProductSoldID = x.Id, customerName = x.Customer.Name, productName = x.Product.Name, storeName = x.Store.Name, dateSold = x.DateSold }).ToList(); return(Json(CustList, JsonRequestBehavior.AllowGet)); } }