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