public MeetingActionCompleteRequest UpdateActionCompleted(MeetingActionCompleteRequest meetingActionCompleteRequest)
{
var completedFlag = meetingActionCompleteRequest.Completed.ToString(); //meetingActionCompleteRequest.Completed ?? meetingActionCompleteRequest.Completed;
string sql = @"UPDATE [dbo].[meeting_actions] SET
completed = @completed
,completed_by_id = @completedbyid
,completed_date = @completeddate
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", meetingActionCompleteRequest.Id, DbType.Int32, ParameterDirection.Input);
dp.Add("completed", completedFlag, DbType.String, ParameterDirection.Input);
dp.Add("completedbyid", meetingActionCompleteRequest.CompletedById, DbType.Int32, ParameterDirection.Input);
dp.Add("completeddate", meetingActionCompleteRequest.CompletedDate, DbType.String, ParameterDirection.Input);
DynamicParameters dpCmts = new DynamicParameters();
dpCmts.Add("meetingactionid", meetingActionCompleteRequest.Id, DbType.Int32, ParameterDirection.Input);
dpCmts.Add("commenttype", ACTION_COMMENT_TYPE.Owner.ToString(), DbType.String, ParameterDirection.Input);
dpCmts.Add("comments", meetingActionCompleteRequest.Comment, DbType.String, ParameterDirection.Input);
dpCmts.Add("createdbyid", meetingActionCompleteRequest.CompletedById, 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);
if (!string.IsNullOrEmpty(meetingActionCompleteRequest.Comment))
{
var updMeetingCmts = conn.Execute(sqlInsCmts, dpCmts, commandType: CommandType.Text, transaction: tran);
}
tran.Commit();
}
}
return(meetingActionCompleteRequest);
}
public IHttpActionResult UpdateActionCompleted(int id, MeetingActionCompleteRequest meetingActionCompleteRequest)
{
if (meetingActionCompleteRequest == null || id < 0 || meetingActionCompleteRequest.Id < 0)
{
return(BadRequest("Action id required"));
}
if (meetingActionCompleteRequest.Completed == ACTION_COMPLETED_STATUS.No && meetingActionCompleteRequest.Comment == "")
{
return(BadRequest("Comments required"));
}
var loggedInUser = HttpContext.Current.User as SecurityPrincipal;
logger.Info($"Meeting action completed by {loggedInUser.ForeName}");
meetingActionCompleteRequest.CompletedById = loggedInUser.Id;
meetingActionCompleteRequest.CompletedDate = DateTime.Now;
var completed = _meetingActionService.UpdateActionCompleted(meetingActionCompleteRequest);
return(Ok(completed));
}
public MeetingActionCompleteRequest UpdateActionCompleted(MeetingActionCompleteRequest meetingActionCompleteRequest)
{
return(_meetingActionDataProvider.UpdateActionCompleted(meetingActionCompleteRequest));
}
