how to save a relation? : Hi Paolo,Have you taken a...

Mon, 09 Jul 2012 16:12:24 -700

Author: sbelini
Subject: 3526
Posted: 09-Jul-2012 at 4:12pm

Hi Paolo,

Have you taken a look at our sample using Telerik controls?

You can find it in the DevForce Resource Center.

That might help you find what you are missing.

Regards,

Silvio.

how to save a relation? : Hello,I've the following...

Mon, 09 Jul 2012 00:35:15 -700

Author: pponzano
Subject: 3526
Posted: 09-Jul-2012 at 12:35am

Hello,
I've the following tables

Dashboard

CREATE TABLE [dbo].[DBOARD](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [DESCRIZIONE] [varchar](50) NOT NULL,
CONSTRAINT [PK_DBS] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

Layout

CREATE TABLE [dbo].[LAYOUT](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [DESCRIZIONE] [varchar](50) NULL,
CONSTRAINT [PK_LAYOUT] PRIMARY KEY CLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

Dashboard_Layout

CREATE TABLE [dbo].[LAYOUT_DBOARD](
    [ID_DBOARD] [int] NOT NULL,
    [ID_LAYOUT] [int] NOT NULL,
CONSTRAINT [PK_LAYOUTDBOARD] PRIMARY KEY CLUSTERED
(
    [ID_DBOARD] ASC,
    [ID_LAYOUT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[LAYOUT_DBOARD] WITH CHECK ADD CONSTRAINT [FK_DBOARD_LAYOUT] FOREIGN KEY([ID_LAYOUT])
REFERENCES [dbo].[LAYOUT] ([ID])
GO

ALTER TABLE [dbo].[LAYOUT_DBOARD] CHECK CONSTRAINT [FK_DBOARD_LAYOUT]
GO

ALTER TABLE [dbo].[LAYOUT_DBOARD] WITH CHECK ADD CONSTRAINT [FK_LAYOUT_DBOARD] FOREIGN KEY([ID_DBOARD])
REFERENCES [dbo].[DBOARD] ([ID])
GO

ALTER TABLE [dbo].[LAYOUT_DBOARD] CHECK CONSTRAINT [FK_LAYOUT_DBOARD]
GO

I've a silverlight application that permits me to choose which layout is applied to a dashboard...

I my XAML application for getting the selected Item I do

                                                ItemsSource="{Binding DataContext.ListaLayout,Mode=OneWay,RelativeSource={RelativeSource AncestorType=UserControl}}"
                                             Style="{StaticResource RadComboBoxMetroStyle}" Width="300" HorizontalAlignment="Left" >

This loads in the dropdown the current selected item, when I choose another one and try to save I have still the old selected one...
since for saving I'm doing

public OperationResult CreateDashBoard(DBOARD dashboard, Action onSuccess = null, Action onFail = null)
        {
            entityManagerProvider.Manager.AddEntity(dashboard);

            return AlwaysCompletedOperationResult.Instance;
        }

the dashboard.LAYOUT[0] is still the old value I've set... how do I manage MxN relations when changing the selected Item?

Thanks

DevForce Community Forum : how to save a relation?

how to save a relation? : Hi Paolo,Have you taken a...

how to save a relation? : Hello,I've the following...