public IActionResult CreateOrUpdate([FromBody] CmsCategory data)
{
if (string.IsNullOrEmpty(data.Title))
{
return(Json(new JsonResponse <string> {
code = 1, message = "Title can not be empty"
}));
}
if (data.Id == null || data.Id == Guid.Empty)
{
data.Id = Guid.NewGuid();
}
using (var db = new MoneyNoteDbContext())
{
var exited = db.CmsCategories.FirstOrDefault(i => i.Id == data.Id);
if (exited == null)
{
db.CmsCategories.Add(data);
}
else
{
exited.ParentId = data.ParentId;
exited.Title = data.Title;
exited.IsDeleted = data.IsDeleted;
}
db.SaveChanges();
}
return(Json(new JsonResponse <CmsCategory> {
data = data
}));
}
public int Update(CmsCategory model)
{
return((int)SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("CmsCategory_Update")
, model.Id, CommonHelper.Null.GetNull(model.Link)
, CommonHelper.Null.GetNull(model.Name), model.Orders, model.UsedState,
model.CreatedBy, model.CreatedDate,
CommonHelper.Null.GetNull(model.ModifiedDate), CommonHelper.Null.GetNull(model.ModifiedBy)));
}
public ActionResult Edit(CmsCategory sysModel)
{
try
{
if (Request.IsAjaxRequest())
{
#region Redirect Request
int succcess = 0;
if (sysModel.Id > 0)
{
var objTemporary = _sysAction.GetById(sysModel.Id);
if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
sysModel.CreatedBy = objTemporary.CreatedBy;
sysModel.ModifiedDate = DateTime.Now;
sysModel.ModifiedBy = WebSecurity.CurrentUserId;
sysModel.CreatedDate = objTemporary.CreatedDate;
succcess = _sysAction.Update(sysModel);
}
else
{
succcess = 1;
}
}
else
{
if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
sysModel.CreatedBy = WebSecurity.CurrentUserId;
sysModel.ModifiedBy = null;
sysModel.CreatedDate = DateTime.Now;
sysModel.ModifiedDate = null;
succcess = _sysAction.Insert(sysModel);
}
else
{
succcess = 1;
}
}
if (succcess > 0)
{
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success }));
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
#endregion Redirect Request
}
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
}
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
public int Insert(CmsCategory model)
{
var deciResult = SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("CmsCategory_Insert")
, CommonHelper.Null.GetNull(model.Link)
, CommonHelper.Null.GetNull(model.Name), model.Orders, model.UsedState,
model.CreatedBy, model.CreatedDate,
CommonHelper.Null.GetNull(model.ModifiedDate), CommonHelper.Null.GetNull(model.ModifiedBy));
return(CommonHelper.Convert.ConvertToInt32(deciResult));
}
public ActionResult Edit(string id)
{
var item = new CmsCategory();
if (!string.IsNullOrEmpty(id))
{
item = _iCmsCategoryService.GetById(id);
}
return(View(item));
}
public int CompareTo(CmsCategory other)
{
if (this.CategoryID < other.CategoryID)
{
return(1);
}
else if (this.CategoryID > other.CategoryID)
{
return(-1);
}
else
{
return(0);
}
}
public IActionResult Delete([FromBody] CmsCategory data)
{
using (var db = new MoneyNoteDbContext())
{
data = db.CmsCategories.FirstOrDefault(i => i.Id == data.Id);
if (data != null)
{
db.RemoveRange(db.CmsRelations.Where(i => i.CategoryId == data.Id));
db.CmsCategories.Remove(data);
db.SaveChanges();
}
}
return(Json(new JsonResponse <CmsCategory> {
data = data
}));
}
public async Task <ActionResult> Edit(string id, CmsCategory collection)
{
var isRepeat = _iCmsCategoryService.GetAll().Any(a => a.SystemId == collection.SystemId);
if (isRepeat && string.IsNullOrEmpty(id))
{
ModelState.AddModelError("SystemId", "系统编码不可重复！");
}
if (!ModelState.IsValid)
{
Edit(id);
return(View(collection));
}
_iCmsCategoryService.Save(id, collection);
await _unitOfWork.CommitAsync();
return(new EditSuccessResult(id));
}
public ActionResult GetById(int?id)
{
var objTemporary = new CmsCategory();
try
{
int editId = id.HasValue ? id.Value : 0;
if (editId > 0)
{
objTemporary = _sysAction.GetById(editId);
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = objTemporary }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
}
