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