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 }));
}
}
