CUID DataGrid

[AlexaBuff]

Hello! I have problem with insert and save row in DataGrid and database. I use Validator in my Datagrid and EditTemplate. I tried data manually by using RowInserting or RowInserted event, but I didn't get positive result. Please, help me. My code:

 ............
<DataGrid TItem="Employee" @ref="dataGrid"
          Data="@employeeList"
          Editable="true"
          CommandMode="DataGridCommandMode.ButtonRow"
          ShowPageSizes="true"
          EditMode="DataGridEditMode.Popup"
          Bordered="true"
          Hoverable="true"
          Responsive="true"
          ShowPager="true"
        RowInserted="@OnRowInserted"
        RowUpdated="@OnRowUpdated"
          PopupSize="ModalSize.Large"
          RowDoubleClicked="@ShowModal"
          UseInternalEditing="true"
          PagerPosition="DataGridPagerPosition.Top"
          Resizable="true"
          FixedHeader="true"
          FixedHeaderDataGridHeight="80%"
          ResizeMode="TableResizeMode.Columns"
          SelectionMode="DataGridSelectionMode.Single"
          @bind-SelectedRow="@selectedEmployee">
............................
<DataGridColumn TItem="Employee" PopupFieldColumnSize="ColumnSize.IsThird.OnDesktop" Field="@nameof(Employee.FEmp)" 
                                                                        Caption="Фамилия" Editable="true">
            <SortDirectionTemplate>
                <Icon Padding="Padding.Is2" Name="@GetName(context)" />
            </SortDirectionTemplate>
            <EditTemplate>              
                <Validations ValidateOnLoad="false"  StatusChanged="@OnStatusChanged">
                    <Validation Validator="CheckCol.CheckF" @ref="valF">
                        <TextEdit Text="@((string)context.CellValue)" TextChanged="@( v => context.CellValue = v)">
                            <Feedback>
                                <ValidationError />
                            </Feedback>
                        </TextEdit>
                    </Validation>
                </Validations>
            </EditTemplate>
        </DataGridColumn>
.................................................
 protected async Task OnRowInserted(SavedRowItem<Employee, Dictionary<string, object>> e)
    {
        try
        {
            Employee newEmployee = e.Item;
            await employeeService.InsertEmployeeAsync(newEmployee);
    
        }
        catch (Exception exc)
        {

        }

    }
    protected async Task OnRowUpdated(SavedRowItem<Employee, Dictionary<string, object>> e)
    {
        try
        {
            var employee = e.Item;
            await employeeService.UpdateEmployeeAsync(employee);
          
        }
        catch (Exception exc)
        {

        }
    }
....................................................

EmployeeService.cs code:
..............
 private readonly AppDBContext _appDBContext;   
        public EmployeeService(AppDBContext appDBContext)
        {
            _appDBContext = appDBContext;
        }

        public Task<List<Employee>> GetAllEmployeesAsync()        
        {
           
            return Task.FromResult(_appDBContext.Employees.ToList());
        }      
        public async Task<string> InsertEmployeeAsync(Employee employee)
        {

            _appDBContext.Add(employee);
           await _appDBContext.SaveChangesAsync();           
            return "Success";
        }
................................

[stsrki]

Validation is not working for you? You need to enable it with UseValidation="true" on a DataGrid.

[AlexaBuff]

I seem to begin to understand what the problem. If in my code I use event protected async Task OnRowInserted, where Task but void I can not close popup after click Save, but row is additing in the datagrid and one is saving in the database. I get this:

In protected async Task OnRowUpdated(SavedRowItem<Employee, Dictionary<string, object>> e) similar problem. I don't close popup with protected async Task OnRowUpdated(SavedRowItem<Employee, Dictionary<string, object>> e) but if I use protected async void OnRowUpdated(SavedRowItem<Employee, Dictionary<string, object>> e) popup is closing

[AlexaBuff]

Validation is not working for you? You need to enable it with UseValidation="true" on a DataGrid.

Validation is working fine