public ActionResult SaveCauseOfReductionDebt(Models.CauseOfReductionDebtModel data) { if (!ModelState.IsValid) { if (data.CNRemarkTypeID == 0) { _db = new QSoft_WUEntities(); DAL.MDCNRemarkType code = _db.MDCNRemarkType.Where(p => p.CNRemarkTypeCode == data.CNRemarkTypeCode).FirstOrDefault(); if (code != null) { return(Json(false, JsonRequestBehavior.AllowGet)); } else { System.Web.HttpContext.Current.Application.Lock(); _db = new QSoft_WUEntities(); _db.MDCNRemarkType.Add(new DAL.MDCNRemarkType { CNRemarkTypeCode = data.CNRemarkTypeCode, CNRemarkTypeName1 = data.CNRemarkTypeName1, CNRemarkTypeName2 = data.CNRemarkTypeName2, ccode = data.ccode }); _db.SaveChanges(); System.Web.HttpContext.Current.Application.UnLock(); return(Json(true, JsonRequestBehavior.AllowGet)); } } } if (ModelState.IsValid) { if (data.CNRemarkTypeID != 0) { _db = new QSoft_WUEntities(); DAL.MDCNRemarkType code = _db.MDCNRemarkType.Where(p => p.CNRemarkTypeCode == data.CNRemarkTypeCode && p.CNRemarkTypeID != data.CNRemarkTypeID).FirstOrDefault(); if (code != null) { return(Json(false, JsonRequestBehavior.AllowGet)); } else { DAL.MDCNRemarkType edit = _db.MDCNRemarkType.Where(p => p.CNRemarkTypeID == data.CNRemarkTypeID).FirstOrDefault(); edit.CNRemarkTypeCode = data.CNRemarkTypeCode; edit.CNRemarkTypeName1 = data.CNRemarkTypeName1; edit.CNRemarkTypeName2 = data.CNRemarkTypeName2; edit.ccode = data.ccode; _db.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } } } return(View(data)); }
public ActionResult DeleteCauseOfReductionDebt(int CNRemarkTypeID) { if (CNRemarkTypeID != 0) { System.Web.HttpContext.Current.Application.Lock(); DAL.MDCNRemarkType delete = _db.MDCNRemarkType.Where(p => p.CNRemarkTypeID == CNRemarkTypeID).FirstOrDefault(); _db.MDCNRemarkType.Remove(delete); _db.SaveChanges(); System.Web.HttpContext.Current.Application.UnLock(); return(Json(true, JsonRequestBehavior.AllowGet)); } return(Json(false, JsonRequestBehavior.AllowGet)); }