//read Customer
public JsonResult getCustomer()
{
using (var db = new OnboardingEntities())
{
var get = db.People.ToList();
db.Configuration.LazyLoadingEnabled = false;
return(Json(get, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddCustomer(Customer customer)
{
using (var db = new OnboardingEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
return(this.Json(customer));
}
}
public ActionResult DeleteCustomer(int Id)
{
using (var db = new OnboardingEntities())
{
var delete = db.Customers.Find(Id);
db.Customers.Remove(delete);
db.SaveChanges();
return(Json(new { success = true }));
}
}
public ActionResult DeleteSale(int Id)
{
using (var db = new OnboardingEntities())
{
var deleteSale = db.ProductSolds.Find(Id);
db.ProductSolds.Remove(deleteSale);
db.SaveChanges();
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DropDownProductName()
{
using (var db = new OnboardingEntities())
{
var productInfo = db.Products.Select(x => new
{
Name = x.Name,
Id = x.Id
}).ToList();
return(this.Json(productInfo, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DropDownCustomerName()
{
using (var db = new OnboardingEntities())
{
var customerInfo = db.Customers.Select(x => new
{
Name = x.Name,
Id = x.Id
}).ToList();
return(this.Json(customerInfo, JsonRequestBehavior.AllowGet));
}
}
//delete Customer
public JsonResult deleteCustomer(int Id)
{
using (var db = new OnboardingEntities())
{
var delPerson = db.People.SingleOrDefault(id => id.Id == Id);
db.People.Remove(delPerson);
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CustomerList()
{
using (var db = new OnboardingEntities())
{
var customerList = db.Customers.Select(x => new
{
Id = x.Id,
Name = x.Name,
Address = x.Address
}).ToList();
return(Json(customerList, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateSales(ProductSold sales)
{
using (var db = new OnboardingEntities())
{
var editSales = db.ProductSolds.SingleOrDefault(x => x.Id == sales.Id);
editSales.CustomerId = sales.CustomerId;
editSales.ProductId = sales.ProductId;
editSales.StoreId = sales.StoreId;
editSales.DateSold = sales.DateSold;
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddProductSold(ProductSold productSold)
{
using (var db = new OnboardingEntities())
{
var proSold = new ProductSold
{
CustomerId = productSold.CustomerId,
ProductId = productSold.ProductId,
StoreId = productSold.StoreId,
DateSold = productSold.DateSold,
};
db.ProductSolds.Add(proSold);
db.SaveChanges();
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditCustomer(Customer customer)
{
using (var db = new OnboardingEntities())
{
var editCustomer = db.Customers.SingleOrDefault(x => x.Id == customer.Id);
editCustomer.Name = customer.Name;
editCustomer.Address = customer.Address;
try
{
db.SaveChanges();
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(Json(new { success = false }));
}
}
}
public ActionResult ProductSoldList()
{
using (var db = new OnboardingEntities())
{
var productSoldList = db.ProductSolds.Select(x => new
{
Id = x.Id,
CustomerId = x.Customer.Id,
CustomerName = x.Customer.Name,
StoreId = x.Store.Id,
StoreName = x.Store.Name,
ProductId = x.Product.Id,
ProductName = x.Product.Name,
DateSold = x.DateSold.Day + "-" + x.DateSold.Month + "-" + x.DateSold.Year
}).ToList();
return(Json(productSoldList, JsonRequestBehavior.AllowGet));
}
}
//edit Customer
public JsonResult editCustomer(CustomerModel model)
{
using (var db = new OnboardingEntities())
{
var getPeople = db.People.Find(model.Id);
// db.Configuration.LazyLoadingEnabled = false;
getPeople.Name = model.Name;
getPeople.Address1 = model.Address1;
getPeople.Address2 = model.Address2;
getPeople.Town_City = model.Town_City;
try
{
db.SaveChanges();
} catch (Exception e)
{
return(Json(new { Success = false, ErrorMsg = e.InnerException.InnerException.Message }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Success = true }, JsonRequestBehavior.AllowGet));
}
}