private void CheckForQuestionaireFinalOutcome(ReviewQuestionnaire q, Review review) { if (q.FinalOutcomeCode == review.OutcomeCode) { return; } if (q.Date <= review.FinalOutcomeDate) { return; } review.OutcomeCode = q.FinalOutcomeCode; review.FinalOutcomeDate = q.Date; IsDirty = true; }
private void CheckForQuestionaireAssessmentOutcome(ReviewQuestionnaire q, Review review) { if (q.AssessmentOutcomeCode == review.AssessmentCode) { return; } if (q.Date <= review.AssessmentDate) { return; } review.AssessmentCode = q.AssessmentOutcomeCode; review.AssessmentDate = q.Date; IsDirty = true; }
private void CheckForQuestionaireAssessmentAction(ReviewQuestionnaire q, Review review) { if (q.RecoveryActionCode == review.AssessmentAction) { return; } if (q.Date <= review.AssessmentActionDate) { return; } review.AssessmentAction = q.RecoveryActionCode; review.AssessmentActionDate = q.Date; IsDirty = true; }
private static List <string> SetQuestionnaireColumns(ReviewQuestionnaire e) { var cell = new List <string> { string.Format("{0}", e.QuestionnaireID), // this tabindex to make the tag able to receive tab key string.Format("<a tabindex='0'>{0}</a>", e.ReviewID), string.Format("{0}", e.UserID), string.Format("{0}", e.AssessmentOutcomeCode), string.Format("{0}", e.RecoveryReasonCode), string.Format("{0}", e.RecoveryActionCode), string.Format("{0}", e.FinalOutcomeCode), string.Format("{0}", e.Date) }; if (e.QuestionAnswers != null) { cell.AddRange(e.QuestionAnswers.Select(qa => string.Format("{0}", qa.AnswerText))); } return(cell); }
/// <summary> /// Gets the review questionnaire by review identifier. /// </summary> /// <param name="reviewId">The review identifier.</param> /// <returns></returns> public ReviewQuestionnaire GetReviewQuestionnaireByReviewId(int reviewId) { ReviewQuestionnaire reviewQuestionnaire = null; using (var connection = new SqlConnection(DbConnection)) { using (var command = new SqlCommand("PaReviewQuestionnaireGetBy", connection)) { var sqlParams = new List <SqlParameter>(); var paramReturnValue = new SqlParameter("@return_value", SqlDbType.Int) { Direction = ParameterDirection.ReturnValue }; sqlParams.Add(paramReturnValue); SqlHelper.AddIntPara(reviewId, "@ReviewId", sqlParams); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(sqlParams.ToArray()); connection.Open(); SqlDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { reviewQuestionnaire = new ReviewQuestionnaire { ProjectID = AppHelper.ToInt(reader["ProjectId"]), ProjectName = string.Format("{0}", reader["ProjectName"]), UploadID = AppHelper.ToInt(reader["UploadId"]), UploadName = string.Format("{0}", reader["UploadName"]), QuestionnaireID = AppHelper.ToInt(reader["QuestionnaireId"]), ReviewID = AppHelper.ToInt(reader["ReviewId"]), ReferenceID = AppHelper.ToLong(reader["ReferenceId"]), UserID = string.Format("{0}", reader["UserId"]), QuestionnaireCode = string.Format("{0}", reader["QuestionnaireCode"]), AssessmentOutcomeCode = string.Format("{0}", reader["AssessmentOutcomeCode"]), AssessmentOutcomeDescription = string.Format("{0}", reader["AssessmentOutcomeDescription"]), RecoveryReasonCode = string.Format("{0}", reader["RecoveryReasonCode"]), RecoveryReasonDescription = string.Format("{0}", reader["RecoveryReasonDescription"]), RecoveryActionCode = string.Format("{0}", reader["RecoveryActionCode"]), RecoveryActionDescription = string.Format("{0}", reader["RecoveryActionDescription"]), FinalOutcomeCode = string.Format("{0}", reader["FinalOutcomeCode"]), FinalOutcomeDescription = string.Format("{0}", reader["FinalOutcomeDescription"]), Date = reader["Date"] as DateTime? ?? default(DateTime), CreatedBy = string.Format("{0}", reader["CreatedBy"]), CreatedOn = reader["CreatedOn"] as DateTime? ?? default(DateTime), UpdatedBy = string.Format("{0}", reader["UpdatedBy"]), UpdatedOn = reader["UpdatedOn"] as DateTime? ?? default(DateTime) }; } } finally { if (reader != null) { reader.Close(); } } } } return(reviewQuestionnaire); }