public JsonResult DeleteCustomer(int id)
{
TalentEntities db = new TalentEntities();
var customer = db.Customer_.Where(x => x.Id == id).SingleOrDefault();
if (customer != null)
{
if (customer.Sales_.Count == 0)
{
db.Customer_.Remove(customer);
db.SaveChanges();
}
else
{
var sales = db.Sales_.Where(x => x.CustomerId == id).ToList();
foreach (var sale in sales)
{
db.Sales_.Remove(sale);
db.SaveChanges();
}
db.Customer_.Remove(customer);
db.SaveChanges();
}
}
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
public JsonResult DeleteProduct(int id)
{
TalentEntities db = new TalentEntities();
var Prod = db.Product_.Where(x => x.Id == id).SingleOrDefault();
if (Prod != null)
{
if (Prod.Sales_.Count == 0)
{
db.Product_.Remove(Prod);
db.SaveChanges();
}
else
{
var sales = db.Sales_.Where(x => x.ProductId == id).ToList();
foreach (var sale in sales)
{
//deleting corresponding sales record
db.Sales_.Remove(sale);
db.SaveChanges();
}
db.Product_.Remove(Prod);
db.SaveChanges();
}
}
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
public JsonResult Edit(Sales_ s)
{
{
try
{
TalentEntities db = new TalentEntities();
Sales_ sales = db.Sales_.Where(x => x.Id == s.Id).SingleOrDefault();
sales.CustomerId = s.CustomerId;
sales.ProductId = s.ProductId;
sales.StoreId = s.StoreId;
sales.DateSold = s.DateSold;
db.SaveChanges();
}
catch (Exception e)
{
Console.Write(e.Data + "Exception Occured");
return(new JsonResult {
Data = "Sale Update Failed", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
//Create
public JsonResult CreateProduct(Product_ c)
{
TalentEntities db = new TalentEntities();
db.Product_.Add(c);
db.SaveChanges();
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//delete
public JsonResult GetDelete(int id)
{
TalentEntities db = new TalentEntities();
var customer = db.Customer_.Where(x => x.Id == id).SingleOrDefault();
return new JsonResult { Data = customer, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//Create
public JsonResult CreateStoreList(Store_ s)
{
TalentEntities db = new TalentEntities();
db.Store_.Add(s);
db.SaveChanges();
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult CustomerList()
{
TalentEntities db = new TalentEntities();
var Customerdata = db.Customer_.Select(p => new { Id = p.Id, CustomerName = p.Name }).ToList();
return(new JsonResult {
Data = Customerdata, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult StoreList()
{
TalentEntities db = new TalentEntities();
var StoresData = db.Store_.Select(p => new { Id = p.Id, StoreName = p.Name }).ToList();
return(new JsonResult {
Data = StoresData, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult ProductList()
{
TalentEntities db = new TalentEntities();
var ProductsData = db.Product_.Select(p => new { Id = p.Id, ProductName = p.Name }).ToList();
return(new JsonResult {
Data = ProductsData, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
//Create
public JsonResult CreateCustomer(Customer_ c)
{
TalentEntities db = new TalentEntities();
db.Customer_.Add(c);
db.SaveChanges();
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult Edit(Store_ s)
{
TalentEntities db = new TalentEntities();
var Store = db.Store_.Where(x => x.Id == s.Id).SingleOrDefault();
Store.Name = s.Name;
Store.Address = s.Address;
db.SaveChanges();
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult Edit(Product_ p)
{
TalentEntities db = new TalentEntities();
var Prod = db.Product_.Where(x => x.Id == p.Id).SingleOrDefault();
Prod.Name = p.Name;
Prod.Price = p.Price;
db.SaveChanges();
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//Create
public JsonResult CreateSale(Sales_ s)
{
TalentEntities db = new TalentEntities();
db.Sales_.Add(s);
db.SaveChanges();
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
//Edit
public JsonResult GetEdit(int id)
{
TalentEntities db = new TalentEntities();
Customer_ customer = db.Customer_.Where(x => x.Id == id).SingleOrDefault();
string value = JsonConvert.SerializeObject(customer, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
//return new JsonResult { Data = customer, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult GetEdit(int id)
{
TalentEntities db = new TalentEntities();
Product_ Prod= db.Product_.Where(x => x.Id == id).SingleOrDefault();
string value = JsonConvert.SerializeObject(Prod, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return new JsonResult { Data = value, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//customerList
public JsonResult ProductList()
{
TalentEntities db = new TalentEntities();
var ProductList = db.Product_.Select(x => new ProductModel {
Id = x.Id,
Name = x.Name,
Price = x.Price
}).ToList();
return Json(ProductList, JsonRequestBehavior.AllowGet);
//return new JsonResult { Data = ProductList, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//customerList
public JsonResult StoreList()
{
TalentEntities db = new TalentEntities();
var StoreList = db.Store_.Select(x => new StoreModel
{
Id = x.Id,
Name = x.Name,
Address = x.Address
}).ToList();
return(Json(StoreList, JsonRequestBehavior.AllowGet));
// return new JsonResult { Data = StoreList, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//delete
public JsonResult GetDeleteStoreList(int id)
{
TalentEntities db = new TalentEntities();
var Store = db.Store_.Where(x => x.Id == id).SingleOrDefault();
string value = JsonConvert.SerializeObject(Store, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(new JsonResult {
Data = value, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
//customerList
public JsonResult CustomerList()
{
TalentEntities db = new TalentEntities();
var customerList = db.Customer_.Select( x => new CustomerModel
{
Id = x.Id,
Name = x.Name,
Address = x.Address
}).ToList();
return Json(customerList, JsonRequestBehavior.AllowGet);
//return new JsonResult { Data = customerList, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
public JsonResult Edit(Customer_ c)
{
TalentEntities db = new TalentEntities();
Customer_ cust = db.Customer_.Where(x => x.Id == c.Id).SingleOrDefault();
cust.Name = c.Name;
cust.Address = c.Address;
db.SaveChanges();
return new JsonResult { Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
//delete
public JsonResult DeleteSale(int id)
{
TalentEntities db = new TalentEntities();
var sales = db.Sales_.Where(x => x.Id == id).SingleOrDefault();
if (sales != null)
{
db.Sales_.Remove(sales);
db.SaveChanges();
}
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult DeleteCustomer(int id)
{
TalentEntities db = new TalentEntities();
var customer = db.Customer_.Where(x => x.Id == id).SingleOrDefault();
if (customer != null)
{
db.Customer_.Remove(customer);
db.SaveChanges();
}
return(new JsonResult {
Data = "Success", JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult SalesList()
{
TalentEntities db = new TalentEntities();
var saleList = db.Sales_.Select(s => new
{
Id = s.Id,
DateSold = s.DateSold,
CustomerName = s.Customer_.Name,
ProductName = s.Product_.Name,
StoreName = s.Store_.Name
}).ToList();
return(new JsonResult {
Data = saleList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
