public MeetingActionComment InsertActionComment(MeetingActionComment meetingActionComment)
{
string sql = @"INSERT INTO [dbo].[meeting_action_comments]
([meeting_action_id]
,[comment_type]
,[comments]
,[created_by_id])
VALUES(
@meetingactionid
,@commenttype
,@comments
,@createdbyid);";
DynamicParameters dpCmts = new DynamicParameters();
dpCmts.Add("meetingactionid", meetingActionComment.MeetingActionId, DbType.Int32, ParameterDirection.Input);
dpCmts.Add("commenttype", meetingActionComment.CommentType, DbType.String, ParameterDirection.Input);
dpCmts.Add("comments", meetingActionComment.Comment, DbType.String, ParameterDirection.Input);
dpCmts.Add("createdbyid", meetingActionComment.CreatedById, DbType.Int32, ParameterDirection.Input);
using (IDbConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (var tran = conn.BeginTransaction())
{
var insMeetingCmts = conn.Execute(sql, dpCmts, commandType: CommandType.Text, transaction: tran);
tran.Commit();
}
}
return(meetingActionComment);
}
public IHttpActionResult InsertActionComment(int id, MeetingActionComment meetingActionComment)
{
if (meetingActionComment == null || id < 0 || meetingActionComment.Comment == "")
{
return(BadRequest("Either action id or comment not found"));
}
var loggedInUser = HttpContext.Current.User as SecurityPrincipal;
logger.Info($"Meeting action commented by {loggedInUser.ForeName}");
meetingActionComment.MeetingActionId = id;
meetingActionComment.CreatedById = loggedInUser.Id;
meetingActionComment.CreatedDate = DateTime.Now;
var result = _meetingActionService.InsertActionComment(meetingActionComment);
return(Ok(result));
}
public MeetingActionComment InsertActionComment(MeetingActionComment meetingActionComment)
{
return(_meetingActionDataProvider.InsertActionComment(meetingActionComment));
}
