public IHttpActionResult InsertActionItem(MeetingActionItem meetingActionItem)
{
if (meetingActionItem == null)
{
return(BadRequest("meeting action item not found"));
}
var loggedInUser = HttpContext.Current.User as SecurityPrincipal;
logger.Info($"Meeting Category created by {loggedInUser.ForeName}");
meetingActionItem.CreatedById = loggedInUser.Id;
meetingActionItem.IsAdhoc = (meetingActionItem.IsAdhoc == "true") ? "Y" : "N";
var result = _meetingCategoryLookupService.InsertActionItem(meetingActionItem);
return(Ok(result));
}
public MeetingActionItem InsertActionItem(MeetingActionItem meetingActionItem)
{
string sqlSelLastIdActItems = "SELECT MAX(id) FROM [dbo].[meeting_action_items]";
string sqlInsActItems = @"INSERT INTO [dbo].[meeting_action_items]
([id]
,[meeting_category_id]
,[name]
,[description]
,[is_adhoc]
,[created_by_id])
VALUES
(@id
,@meetingcategoryid
,@name
,@description
,@isadhoc
,@createdbyid);";
using (IDbConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (var tran = conn.BeginTransaction())
{
int nextId = 1;
var lastId = conn.QuerySingle <int?>(sqlSelLastIdActItems, commandType: CommandType.Text, transaction: tran);
nextId = (lastId == null) ? nextId : (int)lastId + 1;
DynamicParameters dp = new DynamicParameters();
dp.Add("id", nextId, DbType.Int32, ParameterDirection.Input);
dp.Add("meetingcategoryid", meetingActionItem.MeetingCategoryId, DbType.Int32, ParameterDirection.Input);
dp.Add("name", meetingActionItem.Name, DbType.String, ParameterDirection.Input);
dp.Add("description", meetingActionItem.Description, DbType.String, ParameterDirection.Input);
dp.Add("isadhoc", meetingActionItem.IsAdhoc, DbType.String, ParameterDirection.Input);
dp.Add("createdbyid", meetingActionItem.CreatedById, DbType.Int32, ParameterDirection.Input);
var affRows = conn.Execute(sqlInsActItems, dp, transaction: tran);
tran.Commit();
meetingActionItem.Id = nextId;
}
return(meetingActionItem);
}
}
public MeetingActionItem UpdateActionItem(MeetingActionItem meetingActionItem)
{
string sql = @"UPDATE [dbo].[meeting_action_items] SET
name = @name
,description = @description
,is_adhoc = @isadhoc
WHERE id = @id";
DynamicParameters dp = new DynamicParameters();
dp.Add("id", meetingActionItem.Id, DbType.Int32, ParameterDirection.Input);
dp.Add("name", meetingActionItem.Name, DbType.String, ParameterDirection.Input);
dp.Add("description", meetingActionItem.Description, DbType.String, ParameterDirection.Input);
dp.Add("isadhoc", meetingActionItem.IsAdhoc, DbType.String, ParameterDirection.Input);
using (IDbConnection conn = new SqlConnection(_connectionString))
{
conn.Execute(sql, dp);
return(meetingActionItem);
}
}
public MeetingActionItem InsertActionItem(MeetingActionItem meetingActionItem)
{
return(_meetingCategoryLookupDataProvider.InsertActionItem(meetingActionItem));
}
public MeetingActionItem UpdateActionItem(MeetingActionItem meetingActionItem)
{
return(_meetingCategoryLookupDataProvider.UpdateActionItem(meetingActionItem));
}
