1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
| <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource3"
ForeColor="#333333" GridLines="None" DataKeyNames="idrole">
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />
<asp:BoundField DataField="nom" HeaderText="nom" SortExpression="nom" />
<asp:BoundField DataField="prenom" HeaderText="prenom" SortExpression="prenom" />
<asp:BoundField DataField="adresse1" HeaderText="adresse1" SortExpression="adresse1" />
<asp:BoundField DataField="adresse2" HeaderText="adresse2" SortExpression="adresse2" />
<asp:BoundField DataField="codepost" HeaderText="codepost" SortExpression="codepost" />
<asp:BoundField DataField="ville" HeaderText="ville" SortExpression="ville" />
<asp:BoundField DataField="telfixe" HeaderText="telfixe" SortExpression="telfixe" />
<asp:BoundField DataField="telport" HeaderText="telport" SortExpression="telport" />
<asp:BoundField DataField="telpro" HeaderText="telpro" SortExpression="telpro" />
<asp:BoundField DataField="mail" HeaderText="mail" SortExpression="mail" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:intranet2ConnectionString %>" DeleteCommand="DELETE FROM [salarie] WHERE [idsalarie] = @original_idsalarie AND [nom] = @original_nom AND [prenom] = @original_prenom AND [adresse1] = @original_adresse1 AND [adresse2] = @original_adresse2 AND [codepost] = @original_codepost AND [ville] = @original_ville AND [telfixe] = @original_telfixe AND [telport] = @original_telport AND [telpro] = @original_telpro AND [mail] = @original_mail AND [idrole] = @original_idrole"
InsertCommand="INSERT INTO [salarie] ([nom], [prenom], [adresse1], [adresse2], [codepost], [ville], [telfixe], [telport], [telpro], [mail], [idrole]) VALUES (@nom, @prenom, @adresse1, @adresse2, @codepost, @ville, @telfixe, @telport, @telpro, @mail, @idrole)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [nom], [idsalarie], [prenom], [adresse1], [adresse2], [codepost], [ville], [telfixe], [telport], [telpro], [mail], [idrole] FROM [salarie]"
UpdateCommand="UPDATE [salarie] SET [nom] = @nom, [prenom] = @prenom, [adresse1] = @adresse1, [adresse2] = @adresse2, [codepost] = @codepost, [ville] = @ville, [telfixe] = @telfixe, [telport] = @telport, [telpro] = @telpro, [mail] = @mail, [idrole] = @idrole WHERE [idsalarie] = @original_idsalarie AND [nom] = @original_nom AND [prenom] = @original_prenom AND [adresse1] = @original_adresse1 AND [adresse2] = @original_adresse2 AND [codepost] = @original_codepost AND [ville] = @original_ville AND [telfixe] = @original_telfixe AND [telport] = @original_telport AND [telpro] = @original_telpro AND [mail] = @original_mail AND [idrole] = @original_idrole">
<DeleteParameters>
<asp:Parameter Name="original_idsalarie" Type="Int32" />
<asp:Parameter Name="original_nom" Type="String" />
<asp:Parameter Name="original_prenom" Type="String" />
<asp:Parameter Name="original_adresse1" Type="String" />
<asp:Parameter Name="original_adresse2" Type="String" />
<asp:Parameter Name="original_codepost" Type="String" />
<asp:Parameter Name="original_ville" Type="String" />
<asp:Parameter Name="original_telfixe" Type="String" />
<asp:Parameter Name="original_telport" Type="String" />
<asp:Parameter Name="original_telpro" Type="String" />
<asp:Parameter Name="original_mail" Type="String" />
<asp:Parameter Name="original_idrole" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="nom" Type="String" />
<asp:Parameter Name="prenom" Type="String" />
<asp:Parameter Name="adresse1" Type="String" />
<asp:Parameter Name="adresse2" Type="String" />
<asp:Parameter Name="codepost" Type="String" />
<asp:Parameter Name="ville" Type="String" />
<asp:Parameter Name="telfixe" Type="String" />
<asp:Parameter Name="telport" Type="String" />
<asp:Parameter Name="telpro" Type="String" />
<asp:Parameter Name="mail" Type="String" />
<asp:Parameter Name="idrole" Type="Int32" />
<asp:Parameter Name="original_idsalarie" Type="Int32" />
<asp:Parameter Name="original_nom" Type="String" />
<asp:Parameter Name="original_prenom" Type="String" />
<asp:Parameter Name="original_adresse1" Type="String" />
<asp:Parameter Name="original_adresse2" Type="String" />
<asp:Parameter Name="original_codepost" Type="String" />
<asp:Parameter Name="original_ville" Type="String" />
<asp:Parameter Name="original_telfixe" Type="String" />
<asp:Parameter Name="original_telport" Type="String" />
<asp:Parameter Name="original_telpro" Type="String" />
<asp:Parameter Name="original_mail" Type="String" />
<asp:Parameter Name="original_idrole" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="nom" Type="String" />
<asp:Parameter Name="prenom" Type="String" />
<asp:Parameter Name="adresse1" Type="String" />
<asp:Parameter Name="adresse2" Type="String" />
<asp:Parameter Name="codepost" Type="String" />
<asp:Parameter Name="ville" Type="String" />
<asp:Parameter Name="telfixe" Type="String" />
<asp:Parameter Name="telport" Type="String" />
<asp:Parameter Name="telpro" Type="String" />
<asp:Parameter Name="mail" Type="String" />
<asp:Parameter Name="idrole" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:TemplateField HeaderText="Rôle du salarié" SortExpression="libel_role">
<EditItemTemplate>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:intranet2ConnectionString %>"
SelectCommand="SELECT libel_role FROM [role]"></asp:SqlDataSource>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="libel_role"
DataValueField="libel_role" SelectedValue='<%# Bind("libel_role") %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("libel_role") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:intranet2ConnectionString %>"
SelectCommand="SELECT idrole, libel_role FROM [role] where ([idrole]=@idrole)" DeleteCommand="DELETE FROM [role] WHERE [idrole] = @idrole" InsertCommand="INSERT INTO [role] ([libel_role]) VALUES (@libel_role)" UpdateCommand="UPDATE [salarie] SET [idrole] = idrole WHERE [idrole] = @idrole">
<DeleteParameters>
<asp:Parameter Name="idrole" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="libel_role" Type="String" />
<asp:Parameter Name="idrole" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="libel_role" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" Name="idrole"
PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</asp:Content> |
Partager