public JsonResult UpdateAssessmentResults(long groupId, long matrixId, bool referralStatus, bool fpaStatus, string Description, long resultID) { int returnResult = 0; bool isResult = false; try { string querycomand = "CHECKUPDATE"; AssessmentResults results = new FingerprintsModel.AssessmentResults(); results.UserId = new Guid(Session["UserID"].ToString()); results.AgencyId = (Session["AgencyId"] != null) ? new Guid(Session["AgencyId"].ToString()) : (Guid?)null; results.MatrixId = matrixId; results.AssessmentGroupId = groupId; results.ReferralSuggested = referralStatus; results.FPASuggested = fpaStatus; results.Description = Description; results.AssessmentResultId = resultID; isResult = new MatrixData().checkAssessmentResult(results, querycomand); if (isResult) { returnResult = 2; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } isResult = new MatrixData().UpdateAssessmentResult(results); if (isResult) { returnResult = 1; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { clsError.WriteException(ex); //return Json("Error occured please try again."); } return(Json(returnResult, JsonRequestBehavior.AllowGet)); }
public JsonResult InsertAssessmentResults(long groupID, long matrixID, string Description, bool referralSuggested, bool FPASuggessted) { int returnResult = 0; bool isResult = false; try { string querycomand = "CHECKRESULT"; AssessmentResults results = new FingerprintsModel.AssessmentResults(); results.UserId = new Guid(Session["UserID"].ToString()); results.AgencyId = (Session["AgencyId"] != null) ? new Guid(Session["AgencyId"].ToString()) : (Guid?)null; results.MatrixId = matrixID; results.AssessmentGroupId = groupID; results.ReferralSuggested = referralSuggested; results.FPASuggested = FPASuggessted; results.Description = Description; isResult = new MatrixData().checkAssessmentResult(results, querycomand); if (isResult) { returnResult = 2; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } isResult = new MatrixData().InsertAssessmentResult(results); if (isResult) { returnResult = 1; return(Json(returnResult, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { clsError.WriteException(ex); } return(Json(returnResult, JsonRequestBehavior.AllowGet)); }