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)); }