public JsonResult UpdateStore(Store s)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.Entry(s).State = EntityState.Modified;
dbobj.SaveChanges();
return(Json(new { success = true, message = "saved" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddStore(Store s)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.Stores.Add(s);
dbobj.SaveChanges();
return(RedirectToAction("GetStore"));
}
}
//to get product by id
public ActionResult GetStoreById(int id)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.Configuration.ProxyCreationEnabled = false;
var s = dbobj.Stores.Where(x => x.SId == id).FirstOrDefault();
return(Json(s, JsonRequestBehavior.AllowGet));
}
}
public JsonResult RemoveProduct(int ID)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
ProductSold psold = dbobj.ProductSolds.Find(ID);
dbobj.ProductSolds.Remove(psold);
return(Json(dbobj.SaveChanges(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddCustomer(Customer c)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.Customers.Add(c);
dbobj.SaveChanges();
return(RedirectToAction("GetCustomer"));
}
}
public JsonResult Update(ProductSold psold)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.Entry(psold).State = EntityState.Modified;
dbobj.SaveChanges();
return(Json(dbobj.SaveChanges(), JsonRequestBehavior.AllowGet));
}
}
// to add
public JsonResult Add(ProductSold psold)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.ProductSolds.Add(psold);
return(Json(dbobj.SaveChanges(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddProduct(Product p)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
dbobj.Products.Add(p);
dbobj.SaveChanges();
return(RedirectToAction("GetProduct"));
}
}
public ActionResult DeleteStore(int id)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
var store = dbobj.Stores.Where(x => x.SId == id).FirstOrDefault();
dbobj.Stores.Remove(store);
dbobj.SaveChanges();
return(Json(new { success = true, message = "deleted" }, JsonRequestBehavior.AllowGet));
}
}
// GET: ProductSold
public ActionResult PSIndex()
{
ProductSoldEntities dbobj = new ProductSoldEntities();
var psold = new ProductSold();
ViewBag.CustomerId = new SelectList(dbobj.Customers, "CId", "CustomerName", psold.CustomerId);
ViewBag.ProductId = new SelectList(dbobj.Products, "PId", "ProductName", psold.ProductId);
ViewBag.StoreId = new SelectList(dbobj.Stores, "SId", "StoreName", psold.StoreId);
return(View());
}
//get list of store
public JsonResult GetStore()
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
//dbobj.Configuration.ProxyCreationEnabled = false;
var s = dbobj.Stores.Select(x => new
{
SId = x.SId,
StoreName = x.StoreName,
StoreAddress = x.StoreAddress,
}).ToList();
return(Json(new { data = s }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetbyID(int id)
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
var ProductSold = dbobj.ProductSolds.Where(x => x.PSId == id).Select(x => new ProductSoldViewModel
{
PSId = x.PSId,
CustomerId = x.CustomerId,
StoreId = x.StoreId,
ProductId = x.ProductId
}).FirstOrDefault();
return(Json(ProductSold, JsonRequestBehavior.AllowGet));
}
}
//list of all customers
public JsonResult GetCustomer()
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
//dbobj.Configuration.ProxyCreationEnabled = false;
var c = dbobj.Customers.Select(x => new
{
CId = x.CId,
CustomerName = x.CustomerName,
CustomerAddress = x.CustomerAddress,
}).ToList();
return(Json(new { data = c }, JsonRequestBehavior.AllowGet));
}
}
//get list of product
public JsonResult GetProduct()
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
// dbobj.Configuration.ProxyCreationEnabled = false;
var p = dbobj.Products.Select(x => new
{
PId = x.PId,
ProductName = x.ProductName,
ProductPrice = x.ProductPrice,
}).ToList();
return(Json(new { data = p }, JsonRequestBehavior.AllowGet));
}
}
// to get list
public JsonResult GetProductSold()
{
using (ProductSoldEntities dbobj = new ProductSoldEntities())
{
var productsold = dbobj.ProductSolds.Include(s => s.Customer).Include(s => s.Product).Include(s => s.Store).Select(x => new
{
PSId = x.PSId,
ProductId = x.Product.ProductName,
CustomerId = x.Customer.CustomerName,
StoreId = x.Store.StoreName
}).ToList();
return(Json(productsold, JsonRequestBehavior.AllowGet));
}
}