public ActionResult Add(tb_category_model model)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_category_dal dal = new tb_category_dal();
dal.Add(PubConn, model.categoryname);
return RedirectToAction("index");
}
});
}
public JsonResult Update(tb_category_model model)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_category_dal dal = new tb_category_dal();
dal.Update(PubConn, model);
return Json(new { code = 1, msg = "Success" });
}
});
}
//
// GET: /Category/
public ActionResult Index(string keyword)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
tb_category_dal dal = new tb_category_dal();
List<tb_category_model> model = dal.GetList(PubConn, keyword);
return View(model);
}
});
}
public JsonResult Delete(int id)
{
return this.Visit(Core.EnumUserRole.Admin, () =>
{
try
{
tb_category_dal dal = new tb_category_dal();
using (DbConn PubConn = DbConfig.CreateConn(Config.TaskConnectString))
{
PubConn.Open();
bool state = dal.DeleteOneNode(PubConn, id);
return Json(new { code = 1, state = state });
}
}
catch (Exception ex)
{
return Json(new { code = -1, msg = ex.Message });
}
});
}
