public JsonResult Edit(Sale s) { try { StoreDatabaseEntities db = new StoreDatabaseEntities(); Sale sale = db.Sales.Where(x => x.SalesId == s.SalesId).SingleOrDefault(); sale.CustomerId = s.CustomerId; sale.ProductId = s.ProductId; sale.StoreId = s.StoreId; sale.DateSold = s.DateSold; db.SaveChanges(); } catch (Exception e) { Console.Write(e.Data + "Exception"); return(new JsonResult { Data = "Sale update failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//Create Store public JsonResult CreateStore(Store store) { db.Configuration.ProxyCreationEnabled = false; db.Stores.Add(store); db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult CreateSale(Sale sale) { StoreDatabaseEntities db = new StoreDatabaseEntities(); db.Sales.Add(sale); db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//Create Product public JsonResult CreateProduct(Product product) { StoreDatabaseEntities db = new StoreDatabaseEntities(); db.Products.Add(product); db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//Create Customer public JsonResult CreateCustomer(Customer customer) { StoreDatabaseEntities db = new StoreDatabaseEntities(); db.Customers.Add(customer); db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult Edit(Store s) { StoreDatabaseEntities db = new StoreDatabaseEntities(); var store = db.Stores.Where(x => x.StoreId == s.StoreId).SingleOrDefault(); store.Name = s.Name; store.Address = s.Address; db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult Edit(Product p) { StoreDatabaseEntities db = new StoreDatabaseEntities(); var product = db.Products.Where(x => x.ProductId == p.ProductId).SingleOrDefault(); product.Name = p.Name; product.Price = p.Price; db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult Edit(Customer c) { StoreDatabaseEntities db = new StoreDatabaseEntities(); Customer cust = db.Customers.Where(x => x.CustomerId == c.CustomerId).SingleOrDefault(); cust.Name = c.Name; cust.Address = c.Address; db.SaveChanges(); return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult DeleteSale(int id) { StoreDatabaseEntities db = new StoreDatabaseEntities(); var sale = db.Sales.Where(s => s.SalesId == id).SingleOrDefault(); if (sale != null) { db.Sales.Remove(sale); db.SaveChanges(); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//delete public JsonResult DeleteProduct(int id) { StoreDatabaseEntities db = new StoreDatabaseEntities(); var product = db.Products.Where(x => x.ProductId == id).SingleOrDefault(); if (product != null) { db.Products.Remove(product); db.SaveChanges(); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
//delete public JsonResult DeleteCustomer(int id) { StoreDatabaseEntities db = new StoreDatabaseEntities(); var customer = db.Customers.Where(x => x.CustomerId == id).SingleOrDefault(); if (customer != null) { db.Customers.Remove(customer); db.SaveChanges(); } return(new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }