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); }
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); }
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); } }
public void UpdateRecentActivity(Core.Entities.RecentActivity recentActivity) { _recentActivityRepo.UpdateRecentActivity(recentActivity); }