public JsonResult getAll() { using (ProductsDbEntities dataContext = new ProductsDbEntities()) { var productList = dataContext.Products.ToList(); return(Json(productList, JsonRequestBehavior.AllowGet)); } }
public ActionResult IndexVM() { using (ProductsDbEntities dataContext = new ProductsDbEntities()) { var employeeList = dataContext.Products.ToList(); return(Json(employeeList, JsonRequestBehavior.AllowGet)); } }
public JsonResult getProductByNo(string ProdNo) { using (ProductsDbEntities dataContext = new ProductsDbEntities()) { int no = Convert.ToInt32(ProdNo); var productList = dataContext.Products.Find(no); return(Json(productList, JsonRequestBehavior.AllowGet)); } }
public TblOrder Add(TblOrder item) { if (item == null) { throw new ArgumentNullException("item"); } // TO DO : Code to save record into database ProductsDbEntities OrderDb = new ProductsDbEntities(); OrderDb.TblOrders.Add(item); OrderDb.SaveChanges(); return(item); }
public string AddEmployee(Product Emp) { if (Emp != null) { using (ProductsDbEntities dataContext = new ProductsDbEntities()) { dataContext.Products.Add(Emp); dataContext.SaveChanges(); return("Employee Updated"); } } else { return("Invalid Employee"); } }
public string DeleteEmployee(Product Emp) { if (Emp != null) { using (ProductsDbEntities dataContext = new ProductsDbEntities()) { int no = Convert.ToInt32(Emp.Id); var employeeList = dataContext.Products.Where(x => x.Id == no).FirstOrDefault(); dataContext.Products.Remove(employeeList); dataContext.SaveChanges(); return("Employee Deleted"); } } else { return("Invalid Employee"); } }
public string UpdateEmployee(Product Prod) { if (Prod != null) { using (ProductsDbEntities dataContext = new ProductsDbEntities()) { int no = Convert.ToInt32(Prod.Id); var productList = dataContext.Products.Where(x => x.Id == no).FirstOrDefault(); productList.Name = Prod.Name; productList.Price = Prod.Price; productList.Description = Prod.Description; productList.Image = Prod.Image; dataContext.SaveChanges(); return("Employee Updated"); } } else { return("Invalid Employee"); } }