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
});
}
public JsonResult GetProducts()
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
var productData = db.Products.Select(p => new { Id = p.ProductId, ProductName = p.Name }).ToList();
return(new JsonResult {
Data = productData, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetStores()
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
var storeData = db.Stores.Select(s => new { Id = s.StoreId, StoreName = s.Name }).ToList();
return(new JsonResult {
Data = storeData, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetCustomers()
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
var customerData = db.Customers.Select(c => new { Id = c.CustomerId, CustomerName = c.Name }).ToList();
return(new JsonResult {
Data = customerData, 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
});
}
//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
});
}
public JsonResult CreateSale(Sale sale)
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
db.Sales.Add(sale);
db.SaveChanges();
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetProductsDetails()
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
db.Configuration.ProxyCreationEnabled = false;
var productList = db.Products.ToList();
return(new JsonResult {
Data = productList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetEdit(int id)
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
Customer customer = db.Customers.Where(x => x.CustomerId == id).SingleOrDefault();
string val = JsonConvert.SerializeObject(customer, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(val, JsonRequestBehavior.AllowGet));
}
//Display Customer
public JsonResult GetCustomersData()
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
db.Configuration.ProxyCreationEnabled = false;
var customerList = db.Customers.ToList();
return(new JsonResult {
Data = customerList, 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 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 GetEdit(int id)
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
Sale sale = db.Sales.Where(x => x.SalesId == id).SingleOrDefault();
string val = JsonConvert.SerializeObject(sale, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(new JsonResult {
Data = val, 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
});
}
//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
});
}
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
});
}
public JsonResult GetSalesDetails()
{
StoreDatabaseEntities db = new StoreDatabaseEntities();
var salesList = db.Sales.Select(s => new
{
Id = s.SalesId,
CustomerName = s.Customer.Name,
ProductName = s.Product.Name,
StoreName = s.Store.Name,
DateSold = s.DateSold
}).ToList();
return(new JsonResult {
Data = salesList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
