Get selected row from grid when multiple selection enabled

[curtic00]

Hi.
Is it possible to determine which row has had it's selection changed in a grid with multiple selection enabled?

My use case is that my grid displays a list of users. those users who are members of a group are shown as selected.

When I select a user, I want to run code that adds the user to the group. When I un-select a user, it removes the user from the group.

At the moment, it seems to me that one can only retrieve the full list of selected users.

Thanks in advance, charlie

[olufemioyedepo]

Hi @curtic00,

Can you share some snippet as per how you arrived at the UI in the screenshot?

[curtic00]

Hi: code here

@using Simpson.Data.Models;
@using Simpson.Data.Interfaces;
@using Simpson.Data.Enums;
@using Microsoft.Extensions.Caching.Memory;
@using Simpson.Data.Models.Params
@using Simpson.Data.Models.Query
@Inject IJobData data
@Inject ILogger logger
@Inject NavigationManager NavMan
@Inject IMemoryCache _memoryCache
@Inject IRefData refData

Tagged Engineers

Tagged engineers will recieve notifications on Job Updates/Edits

<Grid TItem="StaffMemberModel"
Class="table table-hover table-bordered"
DataProvider="TaggingDataProvider"
AllowSelection="true"
SelectionMode="GridSelectionMode.Multiple"
Responsive="true"
SelectedItemsChanged="OnSelectedEngineersChanged"
SelectedItems="selectedEngineers"
@ref="taggedEngineers">

<GridColumns>
    <GridColumn TItem="StaffMemberModel" HeaderText="Engineer" PropertyName="StaffMail">
        @context.StaffMail
    </GridColumn>
</GridColumns>

@code {

[Parameter]
public int jobId { get; set; }

[Parameter]
public string userName { get; set; }

Grid<StaffMemberModel> taggedEngineers;

string errorMsg = string.Empty;
string infoMsg = string.Empty;

public List<StaffMemberModel> Staff = default!;

private HashSet<StaffMemberModel> selectedEngineers = new();

private List<JobDetailsTagging> taggedEngList = new();


private async Task<GridDataProviderResult<StaffMemberModel>> TaggingDataProvider(GridDataProviderRequest<StaffMemberModel> request)
{

    if (Staff == null)
    {
        Shared.Code.StaffCode staffCode = new Shared.Code.StaffCode(_memoryCache, refData);
        Staff = await staffCode.GetStaffList();
    }

    GetJobDetailsTaggingParams getJobDetailsTaggingParams = new GetJobDetailsTaggingParams
    {
        JobID = jobId
    };

    taggedEngList = await data.GetJobDetailsTaggingAsync(getJobDetailsTaggingParams);

    if (taggedEngList != null)
    {
        foreach (var item in taggedEngList)
        {
            StaffMemberModel result = Staff.First<StaffMemberModel>(x => x.StaffMail == item.Engineer);
            if (result != null)
            {
                selectedEngineers.Add(result);
            }

        }
    }
    else
    {
        logger.LogInformation($" No tagged engineers found for job");
    }
    Console.WriteLine("TaggingDataProvider");
    return await Task.FromResult(request.ApplyTo(Staff));
}

private void OnSelectedEngineersChanged(HashSet<StaffMemberModel> checkedEngineers)
{
    errorMsg = string.Empty;
    infoMsg = string.Empty;

    Console.WriteLine($"checked engineers: {checkedEngineers.Count} , Selected engineers: {selectedEngineers.Count}");

    if (checkedEngineers != null)
    {
        foreach (var eng in checkedEngineers!)
        {
            // Check if checkedEngineer is in SelectedEngineers
            if (!selectedEngineers.Contains(eng))
            {
                // Create tagging record...
                JobDetailsTagging jobDetailsTagging = new JobDetailsTagging
                {
                    CreatedBy = userName,
                    Engineer = eng.StaffMail,
                    JobID = jobId
                };
                CreateRecordParams createRecordParams = new CreateRecordParams
                {
                    JobDetailsTagging = jobDetailsTagging,
                    RecordType = Data.Enums.RecordTypes.JobDetailsTagging
                };
                try
                {
                    var newRecd = data.CreateRecordAsync(createRecordParams).GetAwaiter().GetResult();
                    if (newRecd.HasErrors)
                    {
                        errorMsg = newRecd.ErrorMessage;
                    }
                    else
                    {
                        infoMsg = $"{createRecordParams.JobDetailsTagging.Engineer} was added to job tagging list";
                        selectedEngineers.Add(Staff.First(x => x.StaffMail == eng.StaffMail));
                    }
                }
                catch (Exception addErr)
                {
                    errorMsg = addErr.Message;
                }

            }

        }
        /// Loop through the currently selected engineers
        /// and if a record is not in the checked engineers list
        /// then remove it from the selected engineers list.
        foreach (var eng in selectedEngineers!)
        {
            if (!checkedEngineers.Contains(eng))
            {
                var engTaggingRecd = taggedEngList.FirstOrDefault(x => x.Engineer == eng.StaffMail);
                if (engTaggingRecd != null)
                {
                    Console.WriteLine("JobTagId {0}", engTaggingRecd.JobTagId);
                    // then delete it
                    DeleteRecordParams deleteRecordParams = new DeleteRecordParams
                    {
                        Recordid = engTaggingRecd.JobTagId,
                        RecordType = Data.Enums.RecordTypes.JobDetailsTagging
                    };
                    try
                    {
                        var delID = data.DeleteRecordAsync(deleteRecordParams).GetAwaiter().GetResult();
                        Console.WriteLine("DeleteRecordAsync result {0}", delID.Value);
                        if (delID.HasErrors)
                        {
                            errorMsg = delID.ErrorMessage;
                        }
                        else
                        {
                            infoMsg = $"{deleteRecordParams.Recordid} was removed from job tagging list";
                            selectedEngineers.Remove(eng);
                        }
                    }
                    catch (Exception remErr)
                    {
                        errorMsg = remErr.Message;
                        Console.WriteLine("DeleteRecordAsync has exception {0}", errorMsg);

                    }

                }
            }
            else
            {
                Console.WriteLine("Selected Eng {0} not found in checkedEngineers", eng.StaffMail);
            }

        }
        //    await taggedEngineers.RefreshDataAsync();
        Console.WriteLine($"checked engineers: {checkedEngineers.Count} , Selected engineers: {selectedEngineers.Count}");
    }
}

}

[curtic00]

I have tried the row click event, but that does not fire when you click the check box.
Hope the above can help.

Thanks Charlie

[curtic00]

With a bit of artful coding, managed to get a working solution.. Not the best code in the world, but one that works.

[curtic00]

BTW: if upgrading to 3.5.0, do you need to make any changes to the App.razor file, i.e. the CSS references or the script references.
No details as such seen in the Docs / getting started pages...
TIA,
Charlie