good morning,
I have a strange behavior in the comboboxes of the grid, I have a framework
entity connected with postgre, I am going to focus on only one of the
comboboxes, but I have the main object:
public class Transactions
{
public
virtual long id { set; get; }
public
virtual DateTime date { set; get; }
public
virtual Accounts? account { set; get; }
public
virtual Persons? person { set; get; }
public
virtual Categories? category { set; get; }
public
virtual Decimal? amount { set; get; }
public
virtual Double? orden { set; get; }
[NotMapped]
public
virtual Decimal? balance { set; get; }
}
Then I have the person object that belongs to the above:
public class Persons
{
[Key]
public
virtual long id { set; get; }
public
virtual String? name { set; get; }
}
The grid would be this:
<GridSplitter Grid.Column="1" Width="5"
HorizontalAlignment="Stretch"
DragDelta="GridSplitter_DragDelta" />
<syncfusion:SfDataGrid
Grid.Column="2" x:Name="gvMovimientos"
AutoGenerateColumns="False"
AllowFiltering="true" AllowEditing="True" AllowSorting="False"
AllowResizingColumns="True"
AddNewRowPosition="FixedTop" AllowDeleting="True"
RowValidated="gvMovimientos_RowValidated"
CurrentCellDropDownSelectionChanged="gvMovimientos_CurrentCellDropDownSelectionChanged"
EditTrigger="OnTap" ScrollMode="Async">
<syncfusion:SfDataGrid.SortColumnDescriptions>
<syncfusion:SortColumnDescription
ColumnName="orden" SortDirection="Descending"/>
</syncfusion:SfDataGrid.SortColumnDescriptions>
<syncfusion:SfDataGrid.Columns>
<syncfusion:GridTextColumn
MappingName="id" IsHidden="True" />
<syncfusion:GridDateTimeColumn
MappingName="date" HeaderText="Fecha"/>
<syncfusion:GridComboBoxColumn HeaderText="Cuenta"
AllowFiltering="True"
IsEditable="True" IsCaseSensitiveFilterRow="False"
x:Name="cbAccounts"
MappingName="account.id"
DisplayMemberPath="description"
SelectedValuePath="id"/>
<syncfusion:GridComboBoxColumn HeaderText="Persona"
AllowFiltering="True"
IsEditable="True" IsCaseSensitiveFilterRow="False"
x:Name="cbPersons"
MappingName="person.id"
DisplayMemberPath="name"
SelectedValuePath="id" />
<syncfusion:GridComboBoxColumn HeaderText="Categoría"
AllowFiltering="True"
IsEditable="True" IsCaseSensitiveFilterRow="False"
x:Name="cbCategories"
MappingName="category.id"
DisplayMemberPath="description"
SelectedValuePath="id" />
<syncfusion:GridCurrencyColumn
MappingName="amount" HeaderText="Cantidad"/>
<syncfusion:GridCurrencyColumn
MappingName="balance" HeaderText="Saldo"/>
<syncfusion:GridTextColumn
MappingName="orden" IsHidden="True" />
</syncfusion:SfDataGrid.Columns>
</syncfusion:SfDataGrid>
And in the code of the page I have this:
private ObservableCollection<Transactions>?
viewTransaction;
.
.
.
private void loadContext()
{
AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior",
true);
rycContext
= new RYCContext();
rycContext.categories?.Load();
rycContext.persons?.Load();
rycContext.accountsTypes?.Load();
rycContext.accounts?.Load();
rycContext.transactions?.Load();
}
private void frmInicio_Loaded(object sender, RoutedEventArgs
e)
{
if (rycContext?.transactions != null)
{
viewTransaction
= new ObservableCollection<Transactions>(from x in
rycContext.transactions
select
x);
gvMovimientos.ItemsSource
= CollectionViewSource.GetDefaultView(rycContext.transactions.ToList());
}
gvMovimientos.ItemsSource
= viewTransaction;
cbAccounts.ItemsSource = rycContext?.accounts?.ToList();
if
(rycContext?.persons != null)
{
cbPersons.ItemsSource
= new ObservableCollection<Persons>(rycContext.persons);
}
cbCategories.ItemsSource
= rycContext?.categories?.ToList();
}
private void gvMovimientos_RowValidated(object sender,
Syncfusion.UI.Xaml.Grid.RowValidatedEventArgs e)
{
Transactions
tr = (Transactions)e.RowData;
Transactions
t = rycContext.transactions.Single(x => x.id ==
tr.id);
t.orden
= Double.Parse(t.date.Year.ToString("0000")
+
t.date.Month.ToString("00")
+
t.date.Day.ToString("00")
+
t.id.ToString("000000")
+
(t.amount < 0 ? "1" : "0"));
rycContext.Entry(t).State
= EntityState.Modified;
rycContext?.SaveChanges();
Task.Factory.StartNew(refreshBalance);
}
I have tried to have = rycContext?.person?.ToList() in the
data load but it is the same, what it does is that when I change the value of
the combo it changes the value of the text of persons.name for the id that it
has in database that row, the entire object does not change, so when saving I
get the error:
The property 'Persons.id' is part of a key and so cannot be
modified or marked as modified....
It must be that I have something wrong configured, I also
attach some images if necessary.
