<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Stedkoder.aspx.cs" Inherits="Stedkoder._Default" MasterPageFile="~/Stedkoder.Master" Debug="true" %>
<
asp:Content
ID
=
"Content2"
ContentPlaceHolderID
=
"CPL_Addon"
Runat
=
"Server"
>
<
asp:SqlDataSource
ID
=
"DS_Stedkoder"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:um_edw_addonConnectionString %>"
DeleteCommand="DELETE FROM [organisationsstruktur].[Sted_Dim_Staging] WHERE [StedKode] = @StedKode"
InsertCommand="INSERT INTO [organisationsstruktur].[Sted_Dim_Staging] ([StedKode], [Sted], [StedNiveau1]) VALUES (@StedKode, @Sted, @StedNiveau1)"
SelectCommand="SELECT StedKode, Sted, StedNiveau1, StedNiveau2
FROM [organisationsstruktur].[Sted_Dim_Staging] a
LEFT OUTER JOIN [organisationsstruktur].[Sted_Niveau1_dim_Staging] b
ON (a.[StedNiveau1] = b.StedNiveau1Kode)
ORDER BY [StedKode]"
UpdateCommand="UPDATE [organisationsstruktur].[Sted_Dim_Staging] SET [Sted] = @Sted, [StedNiveau1] = @StedNiveau1 WHERE [StedKode] = @StedKode">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"StedKode"
Type
=
"Int32"
/>
</
DeleteParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"Sted"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"StedNiveau1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"StedKode"
Type
=
"Int32"
/>
</
UpdateParameters
>
<
InsertParameters
>
<
asp:Parameter
Name
=
"Sted"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"StedNiveau1"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"StedKode"
Type
=
"Int32"
/>
</
InsertParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"DS_Niveau1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:um_edw_addonConnectionString %>"
SelectCommand="SELECT [StedNiveau1Kode] FROM [organisationsstruktur].[Sted_Niveau1_dim_Staging]">
</
asp:SqlDataSource
>
<
telerik:radgrid
ID
=
"Grid_Stedkode"
runat
=
"server"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
AutoGenerateDeleteColumn
=
"False"
AutoGenerateEditColumn
=
"False"
DataSourceID
=
"DS_Stedkoder"
GridLines
=
"Vertical"
AllowAutomaticDeletes
=
"True"
Font-Names
=
"Verdana"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
ForeColor
=
"#333333"
AllowCustomPaging
=
"True"
Skin
=
"Office2007"
AllowFilteringByColumn
=
"True"
>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
MasterTableView
DataSourceID
=
"DS_Stedkoder"
datakeynames
=
"StedKode"
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
/>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
/>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridEditCommandColumn
UniqueName
=
"EditColumn"
ButtonType
=
"ImageButton"
InsertImageUrl
=
"Images/Edit.gif"
>
<
HeaderStyle
Width
=
"30px"
></
HeaderStyle
>
</
telerik:GridEditCommandColumn
>
<
telerik:GridButtonColumn
UniqueName
=
"DeleteColumn"
ButtonType
=
"ImageButton"
ImageUrl
=
"Images/Delete.gif"
CommandName
=
"Delete"
>
<
HeaderStyle
Width
=
"30px"
></
HeaderStyle
>
</
telerik:GridButtonColumn
>
<
telerik:GridBoundColumn
DataField
=
"StedKode"
DataType
=
"System.Int32"
HeaderText
=
"StedKode"
ReadOnly
=
"True"
SortExpression
=
"StedKode"
UniqueName
=
"StedKode"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"EqualTo"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Sted"
HeaderText
=
"Sted"
SortExpression
=
"Sted"
UniqueName
=
"Sted"
AutoPostBackOnFilter
=
"true"
FilterControlWidth
=
"200px"
CurrentFilterFunction
=
"Contains"
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Niveau 1"
AutoPostBackOnFilter
=
"true"
FilterControlWidth
=
"200px"
CurrentFilterFunction
=
"Contains"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"Niveau1"
runat
=
"server"
text='<%# Eval("StedNiveau1") %>' />
</
ItemTemplate
>
<
EditItemTemplate
>
<
telerik:RadComboBox
ID
=
"StedNiveau1Combo"
AppendDataBoundItems
=
"true"
runat
=
"server"
DataSourceID
=
"DS_Niveau1"
Width
=
"300px"
DataTextField
=
"StedNiveau1Kode"
DataValueField
=
"StedNiveau1Kode"
Text
=
"Niveau 1"
SelectedValue='<%# Bind("StedNiveau1")%>' >
</
telerik:RadComboBox
>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"StedNiveau2"
HeaderText
=
"Niveau 2"
SortExpression
=
"StedNiveau2"
ReadOnly
=
"true"
UniqueName
=
"StedNiveau2"
AutoPostBackOnFilter
=
"true"
FilterControlWidth
=
"200px"
CurrentFilterFunction
=
"Contains"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:radgrid
>
</
asp:Content
>