public JsonResult ModifyUser(UpdateRegisterModel model) { if (ModelState.IsValid) { try { _db.Query(";Exec UpdateUser @UserID,@FirstName,@OtherNames,@Email,@Mobile", new { UserID = model.UserID, FirstName = model.FirstName, OtherNames = model.OtherNames, Email = model.Email, Mobile = model.Mobile }).SingleOrDefault(); return(Json(new { Result = "OK" })); } catch (Exception e) { return(Json(new { Result = "ERROR", Message = e.Message })); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); return(Json(new { Result = "ERROR", Message = message })); } }
public JsonResult SuperviseUser(UpdateRegisterModel model) { if (ModelState.IsValid) { try { string strCheckSUM = string.Concat(model.UserID, model.FirstName, model.OtherNames); strCheckSUM = string.Concat(strCheckSUM, model.Email != null ? model.Email.ToString() : String.Empty); strCheckSUM = string.Concat(strCheckSUM, model.Mobile, model.Remarks != null ? model.Remarks.ToString() : String.Empty); strCheckSUM = string.Concat(strCheckSUM, User.Identity.Name); string strCheckSumHash = SaccoChapChap.Services.DAL.GetCheckSum(strCheckSUM); List <ClientListModel> userlist = _db.Query <ClientListModel>(";Exec SuperviseUser @UserID,@Remarks,@CreatedBy,@CheckSumID", new { UserID = model.UserID, Remarks = model.Remarks, CreatedBy = User.Identity.Name, CheckSumID = strCheckSumHash }).ToList(); return(Json(new { Result = "OK" })); //return Json(new { Result = "OK", Record = userlist }); } catch (Exception e) { return(Json(new { Result = "ERROR", Message = e.Message })); } } else { var message = string.Join(" | ", ModelState.Values .SelectMany(v => v.Errors) .Select(e => e.ErrorMessage)); return(Json(new { Result = "ERROR", Message = message })); } }