public void AddApprovalAudit(TravelAndTrainingRequest assignedTo, Approval approval)
{
using (SqlConnection cn = new SqlConnection(SqlHelper.TTRConnectionString))
{
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandText = "dbo.swn_sp_Approval_Audit_Insert";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@Request_Id", assignedTo.Id);
cm.Parameters.AddWithValue("@Reviewed_By", approval.ReviewedBy);
cm.Parameters.AddWithValue("@Reviewed_On", approval.ReviewedOn);
cm.Parameters.AddWithValue("@Reviewal_Status_Id", SqlHelper.ConvertToApprovalStatus(approval.Status));
cm.Parameters.AddWithValue("@Comments", approval.Comments);
cn.Open();
cm.ExecuteNonQuery();
}
}
}
private void AddApprovalAudit(ApprovalStatus status, string comments)
{
Approval approval = new Approval();
approval.Status = status;
approval.ReviewedBy = this.applicationContext.Identity.Name;
approval.ReviewedOn = DateTime.Now;
approval.Comments = comments;
ttrProvider.AddApprovalAudit(this, approval);
}
