public ActionResult InsertUpdateCategory(string txtAd, string txtAciklama, int?hdnKatID)
{
if (hdnKatID != null)
{
Category cselected = DB.Categories.SingleOrDefault(x => x.CategoryID == hdnKatID);
cselected.CategoryName = txtAd;
cselected.Description = txtAciklama;
DB.Categories.Attach(cselected); //Entity için update işlemi yapan method attach
DB.Entry(cselected).State = System.Data.Entity.EntityState.Modified; //ben entitye dokunulduğunu söyliycem-Modified diyince tabloda dokunulmuş veri varmı karşılaştıracak ona göre işlem yapıcak.
DB.SaveChanges();
}
else
{
Category c = new Category()
{
CategoryName = txtAd,
Description = txtAciklama
};
DB.Categories.Add(c);
DB.SaveChanges();
}
return(RedirectToAction("AllCategories", "Category"));
//hangi actionın hangi controlını çağırmak istiyorsun. //AllCategories action result'ını Category controllerından çalıştırmak istiyorum diyorum.
//return View();//Returnde view dönerse sistem patlar çünkü yeni bir kategory kaydettim ve o kategory'i çalıştıramıyoruz eski view de kaldı
//HER ActionResult view döndürmek zorunda değil.
}
public IHttpActionResult PutTerritory(string id, Territory territory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != territory.TerritoryID)
{
return(BadRequest());
}
db.Entry(territory).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TerritoryExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutShippers(int id, Shippers shippers)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != shippers.ShipperID)
{
return(BadRequest());
}
db.Entry(shippers).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ShippersExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IHttpActionResult> Put([FromODataUri] int key, [FromBody] Product entity)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (key != entity.ProductID)
{
return(BadRequest("The key from the url must match the key of the entity in the body"));
}
var originalProduct = await db.Products.FindAsync(key);
if (originalProduct == null)
{
return(NotFound());
}
else
{
db.Entry(originalProduct).CurrentValues.SetValues(entity);
await db.SaveChangesAsync();
}
return(Updated(entity));
}
// PUT api/Categories/5
public IHttpActionResult PutCategory(int id, Category category)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != category.CategoryID)
{
return(BadRequest());
}
_db.Entry(category).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryExists(id))
{
return(NotFound());
}
throw;
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT: odata/Employees(5)
public IHttpActionResult Put([FromODataUri] int key, Employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (key != employee.EmployeeID)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(employee));
}
public ActionResult Products_Update([DataSourceRequest] DataSourceRequest request, Product product)
{
if (ModelState.IsValid)
{
var entity = new Product
{
ProductID = product.ProductID,
ProductName = product.ProductName,
SupplierID = product.SupplierID,
CategoryID = product.CategoryID,
QuantityPerUnit = product.QuantityPerUnit,
UnitPrice = product.UnitPrice,
UnitsInStock = product.UnitsInStock,
UnitsOnOrder = product.UnitsOnOrder,
ReorderLevel = product.ReorderLevel,
Discontinued = product.Discontinued
};
db.Products.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(new[] { product }.ToDataSourceResult(request, ModelState)));
}
// PUT odata/Products(5)
public IHttpActionResult Put([FromODataUri] int key, Product product)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (key != product.ProductID)
{
return(BadRequest());
}
db.Entry(product).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(product));
}
public IHttpActionResult PutOrder_Detail(int id, Order_Detail order_Detail)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != order_Detail.OrderID)
{
return(BadRequest());
}
db.Entry(order_Detail).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Order_DetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutRichard(int id, Richard richard)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != richard.ID)
{
return(BadRequest());
}
db.Entry(richard).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!RichardExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT api/Products/5
public 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
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductExists(id))
{
return(NotFound());
}
throw;
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT api/Employee/5
public HttpResponseMessage PutEmployee(int id, Employee employee)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != employee.EmployeeID)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public IHttpActionResult PutEmployee(int id, Employee employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employee.EmployeeID)
{
return(BadRequest());
}
db.Entry(employee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutCustomer(string id, Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != customer.CustomerID)
{
return(BadRequest());
}
db.Entry(customer).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT: odata/Territories(5)
public IHttpActionResult Put([FromODataUri] string key, Territory territory)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (key != territory.TerritoryID)
{
return(BadRequest());
}
db.Entry(territory).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TerritoryExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(territory));
}
public ActionResult Editar(EmployeeViewModel model)
{
try
{
if (ModelState.IsValid)
{
using (NorthwindEntities db = new NorthwindEntities())
{
var oEmployee = db.Employees.Find(model.EmployeeID);
oEmployee.FirstName = model.FirstName;
oEmployee.LastName = model.LastName;
oEmployee.Title = model.Title;
oEmployee.Address = model.Address;
oEmployee.EmployeeID = model.EmployeeID;
db.Entry(oEmployee).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Redirect("~/Employees/"));
}
return(View(model));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
static void Edit2()
{
Customers _Customers = new Customers()
{
CustomerID = "A001",
Address = "南山區",
City = "基隆",
Phone = "11111111",
CompanyName = "台北電商",
ContactName = "Eddie"
};
using (NorthwindEntities db = new NorthwindEntities())
{
//物件加入EF對象裡面
DbEntityEntry <Customers> entry = db.Entry <Customers>(_Customers);
entry.State = System.Data.Entity.EntityState.Unchanged;
entry.Property("ContactName").IsModified = true;
//var u = db.Customers.Attach(_Customers);
//u.ContactName = "郭";
db.SaveChanges();
Console.WriteLine("修改成功:");
Console.WriteLine(_Customers.ContactName);
}
}
// PUT: odata/Shippers(5)
public IHttpActionResult Put([FromODataUri] int key, Shipper shipper)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (key != shipper.ShipperID)
{
return(BadRequest());
}
db.Entry(shipper).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ShipperExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(shipper));
}
public ActionResult Edit(/*[Bind(Include = "ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued")] Product product*/
FormCollection form)
{
Product product = new Product();
//使用 TryUpdateModel(或 UpdateModel 也可以)做出 Model Binding 功能([Bind(Include = "{column1}")] T model)
if (TryUpdateModel(product,
"",
form.AllKeys, // Include Properties
new[] { "SupplierID,CategoryID,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel" }) && ModelState.IsValid) //exclude Properties
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
//驗證失敗，錯誤處理
return(View(product));
}
#region 基架自動產生的程式碼
/*
* if (ModelState.IsValid)
* {
* db.Entry(product).State = EntityState.Modified;
* db.SaveChanges();
* return RedirectToAction("Index");
* }
* return View(product);
*/
#endregion
}
public ActionResult Products_Update([DataSourceRequest] DataSourceRequest request, ProductViewModel product)
{
if (ModelState.IsValid)
{
using (var northwind = new NorthwindEntities())
{
// Create a new Product entity and set its properties from the posted ProductViewModel.
var entity = new Product
{
ProductID = product.ProductID,
ProductName = product.ProductName,
UnitsInStock = product.UnitsInStock
};
// Attach the entity.
northwind.Products.Attach(entity);
// Change its state to Modified so Entity Framework can update the existing product instead of creating a new one.
northwind.Entry(entity).State = EntityState.Modified;
// Or use ObjectStateManager if using a previous version of Entity Framework.
// northwind.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified);
// Update the entity in the database.
northwind.SaveChanges();
}
}
// Return the updated product. Also return any validation errors.
return(Json(new[] { product }.ToDataSourceResult(request, ModelState)));
}
public void Update(T item)
{
T data = GetById(item.Id);
DbEntityEntry entry = db.Entry(data);
entry.CurrentValues.SetValues(item);
Save();
}
public ActionResult UpdateCategory(Category item)
{
Category guncellenecek = db.Categories.Find(item.CategoryID);
db.Entry(guncellenecek).CurrentValues.SetValues(item);
db.SaveChanges();
return(RedirectToAction("CategoryList"));
}
public ActionResult UpdateProduct([Bind(Prefix = "Item2")] Product item)
{
Product ToBeUpdated = db.Products.Find(item.ProductID);
db.Entry(ToBeUpdated).CurrentValues.SetValues(item);
db.SaveChanges();
return(RedirectToAction("ListProducts", "ListProducts"));
}
public ActionResult UpdateProduct(Product item)
{
Product guncellenecek = db.Products.Find(item.ProductID);
db.Entry(guncellenecek).CurrentValues.SetValues(item);
db.SaveChanges();
return(RedirectToAction("ProductList"));
}
public static void Delete(Customer customer)
{
using (var db = new NorthwindEntities())
{
var entry = db.Entry(customer);
entry.State = EntityState.Deleted;
db.SaveChanges();
}
}
public ActionResult Sil(int id, bool d = true)
{
Categories secCat = db.Categories.Find(id);
//db.Categories.Remove(secCat);
db.Entry(secCat).State = EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Liste"));
}
public ActionResult Edit(Personne p)
{
//*******************Version-1*************************
//new PersonneDAO().addOrUpdatePersonne(p);
//PersonneDaoDisco.addOrUpdatePersonne(p);
//Personne pers= entities.Personnes.First(pe => pe.Id == p.Id );
//pers.Nom = p.Nom;....ou bien
//*******************Version-2*************************
//entities.Entry(pers).CurrentValues.SetValues(p);
//entities.SaveChanges();.... ou bien
//*******************Version-3*************************
entities.Personnes.Attach(p);
entities.Entry(p).State = EntityState.Modified;
entities.SaveChanges();
return(Redirect("/"));
}
public ActionResult Edit(Category category)
{
//Category currentCategory = _dbContext
// .Categories
// .SingleOrDefault(c => c.CategoryID == category.CategoryID);
//currentCategory.CategoryName = category.CategoryName;
//currentCategory.Description = category.Description;
_dbContext.Entry(category).State = System.Data.Entity.EntityState.Modified;
_dbContext.Entry(category).Property("Picture").IsModified = false;
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Update(Shipper shipper)
{
//Shipper updated= db.Shippers.Find(shipper.ShipperID);
// updated.CompanyName = shipper.CompanyName;
db.Entry(shipper).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
TempData["success"] = $"{shipper.CompanyName} başarılı bir şekilde güncellendi";
return(RedirectToAction("Index"));
}
public IHttpActionResult Post(Product product)
{
Product addedProduct = new Product()
{
ProductID = product.ProductID,
CategoryID = product.CategoryID,
ProductName = product.ProductName,
UnitPrice = product.UnitPrice,
UnitsInStock = product.UnitsInStock
};
_db.Entry <Product>(addedProduct).State = System.Data.Entity.EntityState.Added;
if (_db.SaveChanges() > 0)
{
return(Ok());
}
return(BadRequest());
}
private async Task ChangeEntityStateAsync(object entity, EntityState state)
{
using (var ctx = new NorthwindEntities())
{
var entry = ctx.Entry(entity);
entry.State = state;
await ctx.SaveChangesAsync();
}
}
