public async Task <int> AddCommentByTrainTaskId(int taskId, string text, User user) { using (var conn = new SqlConnection(AppSettings.ConnectionString)) { var item = new TrainTaskComment { TrainTaskId = taskId, Text = text, UserId = user.Id, Date = DateTime.Now }; var sql = Sql.SqlQueryCach["Comment.Add"]; var id = await conn.QueryFirstOrDefaultAsync <int>(sql, new { date = item.Date, text = item.Text, trainTaskId = item.TrainTaskId, userId = item.UserId }); return(id); } }
private static UpdateUserDateDto GetTaskLastUpdate(TrainTaskComment lastComment, TrainTaskExecutor lastExecutor, TrainTaskStatus lastStatus) { var items = new List <UpdateUserDateDto>(); if (lastComment != null) { items.Add(new UpdateUserDateDto { Date = lastComment.Date, User = lastComment.User }); } if (lastExecutor != null) { items.Add(new UpdateUserDateDto { Date = lastExecutor.Date, User = lastExecutor.User }); } if (lastStatus != null) { items.Add(new UpdateUserDateDto { Date = lastStatus.Date, User = lastStatus.User }); } return(items.Any() ? items.OrderBy(o => o.Date).Last() : null); }