Пример #1
0
        public void InsertRecentActivity(Core.Entities.RecentActivity recentActivity)
        {
            var insertSQL = @"INSERT INTO dbo.[RecentActivity](
                RecentActivityGuid,
                Entity,
                EntityGuid,
                UserGuid,
                UserAction,
                CreatedBy,
                CreatedOn,
                UpdatedBy,
                UpdatedOn,
                IsDeleted)
                VALUES(
                @RecentActivityGuid,
                @Entity,
                @EntityGuid,
                @UserGuid,
                @UserAction,
                @CreatedBy,
                @CreatedOn,
                @UpdatedBy,
                @UpdatedOn,
                @IsDeleted)";

            _context.Connection.Execute(insertSQL, recentActivity);
        }
Пример #2
0
        public void UpdateRecentActivity(Core.Entities.RecentActivity recentActivity)
        {
            var updateQuery = @"UPDATE [dbo].[RecentActivity]
                                SET UserAction = @UserAction,
                                    UpdatedBy = @UpdatedBy,
                                    UpdatedOn = @UpdatedOn,
                                    IsDeleted = @IsDeleted
                                WHERE RecentActivityGuid = @RecentActivityGuid
                                ";

            _context.Connection.Execute(updateQuery, recentActivity);
        }
Пример #3
0
        public void InsertRecentActivity(Core.Entities.RecentActivity recentActivity)
        {
            recentActivity.RecentActivityGuid = Guid.NewGuid();
            var activity = _recentActivityRepo.CheckIfExistInActivity(recentActivity.Entity, recentActivity.EntityGuid, recentActivity.UserGuid, recentActivity.UserAction);

            if (activity != null)
            {
                activity.UpdatedOn = DateTime.Now;
                activity.UpdatedBy = recentActivity.UpdatedBy;
                activity.IsDeleted = false;
                _recentActivityRepo.UpdateRecentActivity(activity);
            }
            else
            {
                _recentActivityRepo.InsertRecentActivity(recentActivity);
            }
        }
Пример #4
0
 public void UpdateRecentActivity(Core.Entities.RecentActivity recentActivity)
 {
     _recentActivityRepo.UpdateRecentActivity(recentActivity);
 }