public MeetingActionUpdateRequest UpdateAction(MeetingActionUpdateRequest meetingActionUpdateRequest)
{
string sql = @"UPDATE [dbo].[meeting_actions] SET
description = @description
,completion_date = @completiondate
,owner_id = @ownerid
,priority = @priority
,updated_by_id = @updatedbyid
,updated_date = @updateddate
WHERE id = @id";
DynamicParameters dp = new DynamicParameters();
dp.Add("id", meetingActionUpdateRequest.Id, DbType.Int32, ParameterDirection.Input);
dp.Add("description", meetingActionUpdateRequest.Description, DbType.String, ParameterDirection.Input);
dp.Add("completiondate", meetingActionUpdateRequest.CompletionDate, DbType.String, ParameterDirection.Input);
dp.Add("ownerid", meetingActionUpdateRequest.OwnerId, DbType.Int32, ParameterDirection.Input);
dp.Add("priority", meetingActionUpdateRequest.Priority, DbType.String, ParameterDirection.Input);
dp.Add("updatedbyid", meetingActionUpdateRequest.UpdatedById, DbType.Int32, ParameterDirection.Input);
dp.Add("updateddate", meetingActionUpdateRequest.UpdatedDate, DbType.String, ParameterDirection.Input);
using (IDbConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
conn.Execute(sql, dp);
return(meetingActionUpdateRequest);
}
}
public IHttpActionResult UpdateAction(int id, MeetingActionUpdateRequest meetingActionUpdateRequest)
{
if (id <= 0 || meetingActionUpdateRequest == null || meetingActionUpdateRequest.Id == 0)
{
return(BadRequest("Action id or action request is missing."));
}
var loggedInUser = HttpContext.Current.User as SecurityPrincipal;
logger.Info($"Meeting action updated by {loggedInUser.ForeName}");
meetingActionUpdateRequest.UpdatedById = loggedInUser.Id;
meetingActionUpdateRequest.UpdatedDate = DateTime.Now;
_meetingActionService.UpdateAction(meetingActionUpdateRequest);
return(Ok(meetingActionUpdateRequest));
}
public MeetingActionUpdateRequest UpdateAction(MeetingActionUpdateRequest meetingActionUpdateRequest)
{
return(_meetingActionDataProvider.UpdateAction(meetingActionUpdateRequest));
}
