public void Delete(TEntity entity) { if (db.Entry(entity).State == EntityState.Detached) { dbSet.Attach(entity); } dbSet.Remove(entity); db.SaveChanges(); }
public IHttpActionResult PutUser(int id, User user) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != user.UserID) { return(BadRequest()); } db.Entry(user).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!UserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Update(IEnumerable <ProductViewModel> products) { using (var northwind = new NORTHWNDEntities()) { //Iterate all updated products which are posted by the Kendo Grid foreach (var productViewModel in products) { // Create a new Product entity and set its properties from productViewModel var product = new Product { ProductID = (int)productViewModel.ProductID, ProductName = productViewModel.ProductName, UnitPrice = productViewModel.UnitPrice, UnitsInStock = productViewModel.UnitsInStock, Discontinued = productViewModel.Discontinued }; // Attach the entity northwind.Products.Attach(product); // Change its state to Modified so Entity Framework can update the existing product instead of creating a new one //northwind.ObjectStateManager.ChangeObjectState(product, EntityState.Modified); northwind.Entry(product).State = EntityState.Modified; } // Save all updated products to the database northwind.SaveChanges(); //Return emtpy result return(Json(null)); } }
// PUT api/Product/5 public async Task <IHttpActionResult> PutProduct(int id, Product product) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product.ProductID) { return(BadRequest()); } db.Entry(product).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> PutCategories(int id, Categories categories) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != categories.CategoryID) { return(BadRequest()); } db.Entry(categories).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CategoriesExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Edit(Employee e, string btnSave) { if (btnSave == "Save") { if (!ModelState.IsValid) { return(RedirectToAction("Index")); } NORTHWNDEntities nwe = new NORTHWNDEntities(); nwe.Configuration.ProxyCreationEnabled = false; Employee original = nwe.Employees.Where(emp => emp.EmployeeID == employeeId).SingleOrDefault(); foreach (PropertyInfo propertyInfo in ((Employee)original).GetType().GetProperties()) { if (propertyInfo.GetValue(e) == null) { propertyInfo.SetValue(e, propertyInfo.GetValue(original)); } } nwe.Entry(original).CurrentValues.SetValues(e); nwe.SaveChanges(); return(View("ProfileView", e)); } else { return(View("Index")); } }
public virtual bool Update(T entity) { bool result; if (entity == null) { result = false; } else { result = true; } Context.Entry(entity).State = EntityState.Modified; return(result); }
public void Update(Customer customer) { using (NORTHWNDEntities context = new NORTHWNDEntities()) { context.Customers.Attach(customer); context.Entry(customer).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public string Update(Employee employee) { if (!ModelState.IsValid) { return("Invalid model"); } _db.Entry(employee).State = EntityState.Modified; _db.SaveChanges(); return("Updated successfully"); }
public ActionResult Edit([Bind(Include = "CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax")] Customers customers) { if (ModelState.IsValid) { db.Entry(customers).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customers)); }
public ActionResult Edit([Bind(Include = "UserID,UserName,Password")] Login login) { if (ModelState.IsValid) { db.Entry(login).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(login)); }
public ActionResult Edit([Bind(Include = "user_name,phone,email,pass,role")] User user) { if (ModelState.IsValid) { db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued")] Products products) { if (ModelState.IsValid) { db.Entry(products).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(products)); }
public ActionResult Edit([Bind(Include = "OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipVia,Freight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry")] Order order) { if (ModelState.IsValid) { db.Entry(order).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(order)); }
public ActionResult Edit([Bind(Include = "CategoryID,CategoryName,Description,Picture")] Category category) { if (ModelState.IsValid) { db.Entry(category).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
/// <summary> /// Updates existing product (only unit price and product name is modified) /// </summary> /// <param name="product">Product to be updated</param> /// <returns>Number of records updated</returns> public async Task <int> UpdateProduct(Product product) { using (var dbContext = new NORTHWNDEntities()) { Product productEntity = await dbContext.Products.FindAsync(product.ProductID); productEntity.UnitPrice = product.UnitPrice; dbContext.Entry(productEntity).State = EntityState.Modified; return(await dbContext.SaveChangesAsync()); } }
public ActionResult Edit(Employees employees) { if (ModelState.IsValid) { db.Entry(employees).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ReportsTo = new SelectList(db.Employees, "EmployeeID", "LastName", employees.ReportsTo); return(View(employees)); }
public ActionResult Edit(depart d) { if (ModelState.IsValid) { NORTHWNDEntities db = new NORTHWNDEntities(); db.Entry(d).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("index")); } return(View()); }
public ActionResult Edit([Bind(Include = "EmployeeID,LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,Photo,Notes,ReportsTo,PhotoPath")] Employees employees) { if (ModelState.IsValid) { db.Entry(employees).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ReportsTo = new SelectList(db.Employees, "EmployeeID", "LastName", employees.ReportsTo); return(View(employees)); }
// Update public ProductViewModel UpdateProduct(ProductViewModel productVM) { using (var context = new NORTHWNDEntities()) { Product product = new Product(); Mapper.Map(productVM, product); context.Entry(product).State = EntityState.Modified; context.SaveChanges(); return(productVM); } }
public ActionResult Edit(Products products) { if (ModelState.IsValid) { db.Entry(products).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", products.CategoryID); ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "CompanyName", products.SupplierID); return(View(products)); }
// Update public SupplierViewModel UpdateSupplier(SupplierViewModel supplierVM) { using (var context = new NORTHWNDEntities()) { Supplier supplier = new Supplier(); Mapper.Map(supplierVM, supplier); context.Entry(supplier).State = EntityState.Modified; context.SaveChanges(); return(supplierVM); } }
public ActionResult Edit([Bind(Include = "ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued")] Product product) { if (ModelState.IsValid) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", product.CategoryID); ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "CompanyName", product.SupplierID); return(View(product)); }
public ActionResult Edit([Bind(Include = "OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipVia,Freight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry")] Orders orders) { if (ModelState.IsValid) { db.Entry(orders).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CompanyName", orders.CustomerID); ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "LastName", orders.EmployeeID); ViewBag.ShipVia = new SelectList(db.Shippers, "ShipperID", "CompanyName", orders.ShipVia); return(View(orders)); }
public void Update(Category category) { #region I.yol //var updated = db.Categories.Find(category.CategoryID); //updated.CategoryName = category.CategoryName; //updated.Description = category.Description; //db.SaveChanges(); #endregion #region II.Yol db.Entry(category).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); #endregion }
public bool UpdateCustomer(Customer customer) { _dbContext.Entry(customer).State = System.Data.Entity.EntityState.Modified; int result = _dbContext.SaveChanges(); if (result > 0) { return(true); } else { return(false); } }
public ActionResult Edit(Order model) { if (!ModelState.IsValid) { return(View()); } using (var context = new NORTHWNDEntities()) { context.Orders.Attach(model); context.Entry(model).State = EntityState.Modified; context.SaveChanges(); } return(RedirectToAction("Edit", new { id = model.OrderID })); }
// Update public void UpdateCategory(IEnumerable <CategoryViewModel> categories) { using (var context = new NORTHWNDEntities()) { foreach (var categoryViewModel in categories) { Category category = new Category(); Mapper.Map(categoryViewModel, category); context.Categories.Attach(category); context.Entry(category).State = EntityState.Modified; } context.SaveChanges(); } }
public ActionResult Edit(Employee e, string btnSave) { if (btnSave == "Save") { if (!ModelState.IsValid) return RedirectToAction("Index"); NORTHWNDEntities nwe = new NORTHWNDEntities(); nwe.Configuration.ProxyCreationEnabled = false; Employee original = nwe.Employees.Where(emp => emp.EmployeeID == employeeId).SingleOrDefault(); foreach (PropertyInfo propertyInfo in ((Employee)original).GetType().GetProperties()) { if (propertyInfo.GetValue(e) == null) propertyInfo.SetValue(e, propertyInfo.GetValue(original)); } nwe.Entry(original).CurrentValues.SetValues(e); nwe.SaveChanges(); return View("ProfileView", e); } else return View("Index"); }
public ActionResult Guncel(Products product) { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(Json(product, JsonRequestBehavior.AllowGet)); }
public void SaveCustomer(Customers customer) { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); }