public ActionResult Edit(CategoryMiddle cate)
{
db.Entry(cate).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { page = TempData["savepage"] }));
}
public IHttpActionResult PutMiddle(int id, CategoryMiddle _categoryMiddle)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != _categoryMiddle.CategoryMID)
{
return(BadRequest());
}
db.Entry(_categoryMiddle).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryMiddleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Delete(int id = 1)
{
CategoryMiddle cate = db.CategoryMiddles.Find(id);
db.CategoryMiddles.Remove(cate);
db.SaveChanges();
return(RedirectToAction("Index", new { page = TempData["savepage"] }));
}
// GET: api/MiddelClass_WebAPI/5
public IHttpActionResult GetMiddle(int id)
{
CategoryMiddle _categoryMiddle = db.CategoryMiddles.Find(id);
if (_categoryMiddle == null)
{
return(NotFound());
}
return(Ok(_categoryMiddle));
}
public ActionResult Create(CategoryMiddle categoryM)
{
CategoryMiddle cate = new CategoryMiddle()
{
CategoryMName = categoryM.CategoryMName
};
db.CategoryMiddles.Add(cate);
db.SaveChanges();
return(RedirectToAction("Index", new { page = TempData["savepage"] }));
}
public IHttpActionResult PostMiddle(CategoryMiddle _categoryMiddle)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CategoryMiddles.Add(_categoryMiddle);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = _categoryMiddle.CategoryMID }, _categoryMiddle));
}
public IHttpActionResult DeleteMiddle(int id)
{
CategoryMiddle _categoryMiddle = db.CategoryMiddles.Find(id);
if (_categoryMiddle == null)
{
return(NotFound());
}
db.CategoryMiddles.Remove(_categoryMiddle);
db.SaveChanges();
return(Ok(_categoryMiddle));
}
public ActionResult CatsgoryMSelectPartialView()
{
var _CMPV = db.CategoryMiddles.ToList();
List <CategoryMiddle> _Listcm = new List <CategoryMiddle>();
foreach (var _data in _CMPV)
{
CategoryMiddle _cm = new CategoryMiddle();
_cm.CategoryMID = _data.CategoryMID;
_cm.CategoryMName = _data.CategoryMName;
_Listcm.Add(_cm);
}
return(PartialView(_Listcm.ToList()));
}
private void categoryMiddleDataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
CategoryMiddle cm = new CategoryMiddle();
int currentIdx = categoryMiddleBindingSource.Position;
cm.CategoryMID = ((CategoryMiddle)categoryMiddleBindingSource.Current).CategoryMID;
switch (e.ColumnIndex)
{
case 1: //存檔
try
{
cm.CategoryMName = ((CategoryMiddle)categoryMiddleBindingSource.Current).CategoryMName;
cm.CategoryLID = cl.CategoryLID;
//新增
if (cm.CategoryMID == 0)
{
dbContext.CategoryMiddles.Add(cm);
}
else //修改
{
var q = dbContext.CategoryMiddles.Find(cm.CategoryMID);
q.CategoryMName = cm.CategoryMName;
}
this.dbContext.SaveChanges();
ResetData(cl.CategoryLID);
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
break;
case 3: //刪除
if (cm.CategoryMID == 0)
{
MessageBox.Show("尚未存檔, 無法刪除 !");
return;
}
DialogResult result = MessageBox.Show("確定刪除 ?", "刪除作業", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return;
}
try
{
var q = dbContext.CategoryMiddles.Find(cm.CategoryMID);
dbContext.CategoryMiddles.Remove(q);
this.dbContext.SaveChanges();
ResetData(cl.CategoryLID);
}
catch (Exception ex)
{ Debug.WriteLine(ex); }
break;
}
}
