public MeetingActionAuditRequest UpdateActionAudited(MeetingActionAuditRequest meetingActionAuditRequest)
{
var auditedFlag = meetingActionAuditRequest.Audited.ToString(); // .Inspected ?? meetingActionAuditRequest.Inspected;
string sql = @"UPDATE [dbo].[meeting_actions] SET
audited = @audited
,audited_by_id = @auditedbyid
,audited_date = @auditeddate
WHERE id = @id";
string sqlInsCmts = @"INSERT INTO [dbo].[meeting_action_comments]
([meeting_action_id]
,[comment_type]
,[comments]
,[created_by_id])
VALUES(
@meetingactionid
,@commenttype
,@comments
,@createdbyid);";
DynamicParameters dp = new DynamicParameters();
dp.Add("id", meetingActionAuditRequest.Id, DbType.Int32, ParameterDirection.Input);
dp.Add("audited", auditedFlag, DbType.String, ParameterDirection.Input);
dp.Add("auditedbyid", meetingActionAuditRequest.AuditedById, DbType.Int32, ParameterDirection.Input);
dp.Add("auditeddate", meetingActionAuditRequest.AuditedDate, DbType.String, ParameterDirection.Input);
DynamicParameters dpCmts = new DynamicParameters();
dpCmts.Add("meetingactionid", meetingActionAuditRequest.Id, DbType.Int32, ParameterDirection.Input);
dpCmts.Add("commenttype", ACTION_COMMENT_TYPE.Auditor.ToString(), DbType.String, ParameterDirection.Input);
dpCmts.Add("comments", meetingActionAuditRequest.Comment, DbType.String, ParameterDirection.Input);
dpCmts.Add("createdbyid", meetingActionAuditRequest.AuditedById, DbType.Int32, ParameterDirection.Input);
using (IDbConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (var tran = conn.BeginTransaction())
{
var updMeetingAction = conn.Execute(sql, dp, commandType: CommandType.Text, transaction: tran);
var updMeetingCmts = conn.Execute(sqlInsCmts, dpCmts, commandType: CommandType.Text, transaction: tran);
tran.Commit();
}
}
return(meetingActionAuditRequest);
}
public IHttpActionResult UpdateActionAudited(int id, MeetingActionAuditRequest meetingActionAuditRequest)
{
if (meetingActionAuditRequest == null || id < 0 || meetingActionAuditRequest.Id < 0)
{
return(BadRequest("Action id not found"));
}
if (meetingActionAuditRequest.Audited == ACTION_AUDITED_STATUS.Fail && meetingActionAuditRequest.Comment == "")
{
return(BadRequest("Comments required"));
}
var loggedInUser = HttpContext.Current.User as SecurityPrincipal;
logger.Info($"Meeting action audited by {loggedInUser.ForeName}");
meetingActionAuditRequest.AuditedById = loggedInUser.Id;
meetingActionAuditRequest.AuditedDate = DateTime.Now;
var audited = _meetingActionService.UpdateActionAudited(meetingActionAuditRequest);
return(Ok(audited));
}
public MeetingActionAuditRequest UpdateActionAudited(MeetingActionAuditRequest meetingActionAuditRequest)
{
return(_meetingActionDataProvider.UpdateActionAudited(meetingActionAuditRequest));
}
