<asp:SqlDataSource ID="RicercaAspiranteSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DiscontinuiConnectionString %>"
        ProviderName="<%$ ConnectionStrings:DiscontinuiConnectionString.ProviderName %>"
        SelectCommand="SELECT aspiranti.CF, CONCAT(aspiranti.Cognome, &quot; &quot;, aspiranti.Nome) AS Nominativo FROM discontinui.aspiranti ORDER BY Nominativo">
    </asp:SqlDataSource>
    <br />
    <br />
    <asp:DropDownList ID="RicercaNominativoDropDownList" runat="server" DataSourceID="RicercaAspiranteSqlDataSource"
        DataTextField="Nominativo" DataValueField="CF" AutoPostBack="True">
    </asp:DropDownList>
    <br />
    <asp:SqlDataSource ID="StoricoSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DiscontinuiConnectionString %>"
        ProviderName="<%$ ConnectionStrings:DiscontinuiConnectionString.ProviderName %>"
        SelectCommand="SELECT aspiranti_storico.Id_storico, aspiranti_storico.Storico_CF, tipo_movimento.Descrizione, aspiranti_storico.Data_Movimento, aspiranti_storico.Idoneo, aspiranti_storico.Tipologia FROM aspiranti_storico INNER JOIN tipo_movimento ON aspiranti_storico.Tipologia = tipo_movimento.Id_movimento WHERE aspiranti_storico.Storico_CF = @CF ORDER BY aspiranti_storico.Data_Movimento"
        InsertCommand="INSERT INTO aspiranti_storico (Storico_CF, Tipologia, Data_Movimento, Idoneo) VALUES (@Storico_CF, @Tipologia, @Data_Movimento, @Idoneo)"
        UpdateCommand="UPDATE aspiranti_storico SET Tipologia = @Tipologia, Data_Movimento = @Data_Movimento, Idoneo = @Idoneo WHERE Id_storico = @Id_storico">
        <SelectParameters>
            <asp:ControlParameter ControlID="RicercaNominativoDropDownList" Name="CF" PropertyName="SelectedValue"
                Type="String" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="Tipologia" Type="Int32" />
            <asp:Parameter Name="Data_Movimento" Type="DateTime" />
            <asp:Parameter Name="Idoneo" Type="Int32" />
            <asp:Parameter Name="Id_storico" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="Storico_CF" Type="String" />
            <asp:Parameter Name="Tipologia" Type="Int32" />
            <asp:Parameter Name="Data_Movimento" Type="DateTime" />
            <asp:Parameter Name="Idoneo" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <div id="StoricoDiv" runat="server" align="center">
        <asp:SqlDataSource ID="TiplologiaSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DiscontinuiConnectionString %>"
            ProviderName="<%$ ConnectionStrings:DiscontinuiConnectionString.ProviderName %>"
            SelectCommand="SELECT Id_movimento, Descrizione FROM tipo_movimento"></asp:SqlDataSource>
        <asp:GridView ID="StoricoGridView" runat="server" AutoGenerateColumns="False" DataSourceID="StoricoSqlDataSource"
            Width="100%">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:BoundField DataField="Id_storico" HeaderText="Id_storico" InsertVisible="False"
                    SortExpression="Id_storico" Visible="False" />
                <asp:BoundField DataField="Data_Movimento" HeaderText="Data" SortExpression="Data_Movimento"
                    DataFormatString="{0:d}" />
                <asp:BoundField DataField="Storico_CF" HeaderText="Storico_CF" SortExpression="Storico_CF"
                    Visible="False" />
                <asp:TemplateField HeaderText="Descrizione" SortExpression="Descrizione">
                    <EditItemTemplate>
                        <asp:DropDownList ID="TipologiaDropDownList" runat="server" DataSourceID="TiplologiaSqlDataSource"
                            DataTextField="Descrizione" DataValueField="Id_movimento" SelectedValue='<%# Bind("Tipologia") %>'>
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("Descrizione") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:CheckBoxField DataField="Idoneo" HeaderText="Idoneo" SortExpression="Idoneo" />
                <asp:BoundField DataField="Tipologia" HeaderText="Tipologia" SortExpression="Tipologia" />
            </Columns>
        </asp:GridView>
    </div>
    <br />