Torna al Thread
<%@ Page Language="VB" MasterPageFile="~/Aui.master" AutoEventWireup="false" CodeFile="scheda_prestazioni.aspx.vb" Inherits="Prestazioni_scheda_prestazioni" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder_Main" Runat="Server">
<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="0" EnableTheming="True"
Height="273px" Width="758px" BackColor="#EFF3FB" BorderColor="#B5C7DE" BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" DisplayCancelButton="True" FinishDestinationPageUrl="~/Prestazioni/Prestazioni.aspx" CancelDestinationPageUrl="~/Prestazioni/Prestazioni.aspx">
<WizardSteps>
<asp:WizardStep runat="server" Title="Prestazione">
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" Height="252px" Width="573px">
<ItemTemplate>
<fieldset><legend>Prestazione <strong><%# Eval("codiceIDE") %></strong></legend>
<table>
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="Tipo Operazione"></asp:Label></td>
<td>
<asp:DropDownList ID="DDL_tipo_operaz" runat="server" DataSourceID="tipo_registrazione"
DataTextField="tipo" DataValueField="codice" SelectedValue='<%# Eval("tipo_registrazione") %>' AutoPostBack="True">
</asp:DropDownList></td>
<td colspan="3">
<asp:Label ID="Label4" runat="server" Text="Data incarico"></asp:Label><asp:TextBox ID="txt_data_incarico" runat="server" MaxLength="10" Text='<%# Eval("data_incarico").toShortDateString() %>' Width="70px"></asp:TextBox></td>
</tr>
<tr>
<td>
Causale</td>
<td colspan="4">
<asp:DropDownList DataTextField="codice_tipo" ID="DDL_causale" runat="server" DataSourceID="causale" DataValueField="codice" SelectedValue='<%# Eval("tipo_prestazione") %>' Font-Size="Small">
</asp:DropDownList></td>
</tr>
</table></fieldset><br />
<fieldset>
<legend>Interessati</legend>
<table>
<tr>
<td style="height: 18px">
Cliente</td>
<td style="height: 18px">
</td>
<td style="height: 18px">
<asp:DropDownList ID="DDL_cliente" runat="server" DataSourceID="pf" DataTextField="cliente" DataValueField="codiceIDE" AppendDataBoundItems="True" SelectedValue='<%# Eval("cod_cliente") %>'>
<asp:ListItem Value="">Nessuno</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="height: 18px">
Per conto di...</td>
<td style="height: 18px">
</td>
<td style="height: 18px"><asp:DropDownList ID="DDL_perconto" runat="server" DataSourceID="percontodi" DataTextField="perconto" DataValueField="codiceIDE" AppendDataBoundItems="True" SelectedValue='<%# Eval("cod_soggetto") %>'>
<asp:ListItem Value="">Nessuno</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="height: 18px">
Destinatario</td>
<td style="height: 18px">
</td>
<td style="height: 18px"><asp:DropDownList ID="DDL_destinatario" runat="server" DataSourceID="percontodi" DataTextField="perconto" DataValueField="codiceIDE" AppendDataBoundItems="True" SelectedValue='<%# Eval("cod_controparte") %>'>
<asp:ListItem Value="">Nessuno</asp:ListItem>
</asp:DropDownList></td>
</tr>
</table>
</fieldset><br />
<fieldset>
<legend>Dati finanziari</legend>
<table>
<tr>
<td style="height: 18px">
Divisa</td>
<td style="height: 18px">
</td>
<td style="height: 18px">
<asp:DropDownList ID="DDL_divisa" runat="server" DataSourceID="Divisa" DataTextField="codice_iso" DataValueField="codice_iso" AppendDataBoundItems="True" SelectedValue='<%# Eval("divisa_princ")%>'></asp:DropDownList></td>
<td style="height: 18px">
</td>
<td style="height: 18px" align="right">
Importo</td>
<td style="height: 18px" colspan="4">
<asp:TextBox ID="txt_importo" runat="server" Text='<%# Eval("importo_euro")%>'></asp:TextBox>€
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txt_importo"
ErrorMessage="- Inserire un importo valido!" ValidationExpression="/^(0|((\d{1,3})(\.\d{3})*))(,\d{1,2})?$/"></asp:RegularExpressionValidator></td>
</tr>
<tr>
<td align="right" colspan="5" style="height: 18px">
di cui in contanti</td>
<td colspan="4" style="height: 18px">
<asp:TextBox ID="txt_contanti" runat="server" Text='<%# Eval("importo_contanti")%>'></asp:TextBox>€</td>
</tr>
<tr>
<td colspan="5" style="height: 18px" align="right">
Tipologia beni oggetto dell'incarico</td>
<td colspan="4" style="height: 18px">
<asp:TextBox ID="txt_beni" runat="server" Text='<%# Eval("tipo_beni")%>' Width="380px"></asp:TextBox></td>
</tr>
<tr>
<td colspan="5" style="height: 18px" align="right">
Tipologia mezzi di pagamento</td>
<td colspan="4" style="height: 18px">
<asp:TextBox ID="txt_mezzi" runat="server" Text='<%# Eval("tipo_pagamenti")%>' Width="380px"></asp:TextBox></td>
</tr>
</table>
</fieldset>
</ItemTemplate>
</asp:FormView>
</asp:WizardStep>
<asp:WizardStep runat="server" Title="Soggetti">
</asp:WizardStep>
<asp:WizardStep runat="server" Title="Importi in €">
</asp:WizardStep>
<asp:WizardStep runat="server" StepType="Finish" Title="Connesse">
</asp:WizardStep>
</WizardSteps>
<StepStyle Font-Size="0.8em" ForeColor="#333333" />
<SideBarButtonStyle ForeColor="White" BackColor="#507CD1" Font-Names="Verdana" />
<NavigationButtonStyle BackColor="White" BorderColor="#507CD1" BorderStyle="Solid"
BorderWidth="1px" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#284E98" />
<SideBarStyle BackColor="#507CD1" Font-Size="0.9em" VerticalAlign="Top" Width="80px" Wrap="False" />
<HeaderStyle BackColor="#284E98" BorderColor="#EFF3FB" BorderStyle="Solid" BorderWidth="2px"
Font-Bold="True" Font-Size="0.9em" ForeColor="White" HorizontalAlign="Center" />
</asp:Wizard>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GfcConnectionString %>"
ProviderName="<%$ ConnectionStrings:GfcConnectionString.ProviderName %>" SelectCommand="SELECT * FROM prestazioni WHERE id_prestazione=?id_prestazione"
UpdateCommand="UPDATE prestazioni SET tipo_prestazione =?tipo_prestazione WHERE id_prestazione=?id_prestazione">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="0" Name="id_prestazione" QueryStringField="id_prestazione" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="id_prestazione" Type="int32" />
<asp:Parameter Name="tipo_prestazione" Type="String" />
<asp:Parameter Name="tipo_registrazione" Type="String" />
<asp:Parameter Name="data_reg" Type="DateTime" />
<asp:Parameter Name="divisa_princ" Type="String" />
<asp:Parameter Name="importo_contanti" Type="String" />
<asp:Parameter Name="tipo_pagamenti" Type="String" />
<asp:Parameter Name="tipo_beni" />
<asp:Parameter Name="importo_euro" />
<asp:Parameter Name="cod_cliente" />
<asp:Parameter Name="cod_soggetto" />
<asp:Parameter Name="legame" />
<asp:Parameter Name="stato_reg" />
<asp:Parameter Name="data_rettifica" />
<asp:Parameter Name="data_incarico" />
<asp:Parameter Name="nimporto" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="pf" runat="server" ConnectionString="<%$ ConnectionStrings:GfcConnectionString %>"
ProviderName="<%$ ConnectionStrings:GfcConnectionString.ProviderName %>" SelectCommand="SELECT codiceIDE, CONCAT(nome, ' ', cognome) AS cliente FROM persona_fisica ORDER BY cognome">
</asp:SqlDataSource>
<asp:SqlDataSource ID="tipo_registrazione" runat="server" ConnectionString="<%$ ConnectionStrings:GfcConnectionString %>"
ProviderName="<%$ ConnectionStrings:GfcConnectionString.ProviderName %>" SelectCommand="SELECT id_reg, tipo, codice, dm141 FROM tipi_registrazione ORDER BY codice">
</asp:SqlDataSource>
<asp:SqlDataSource ID="causale" runat="server" ConnectionString="<%$ ConnectionStrings:GfcConnectionString %>"
ProviderName="<%$ ConnectionStrings:GfcConnectionString.ProviderName %>" SelectCommand="SELECT codice,LEFT(CONCAT(codice,' ',tipo),80) AS codice_tipo FROM tipi_prestazione WHERE codice_pre = 13 OR codice_pre = 14">
</asp:SqlDataSource>
<asp:SqlDataSource ID="percontodi" runat="server" ConnectionString="<%$ ConnectionStrings:GfcConnectionString %>"
ProviderName="<%$ ConnectionStrings:GfcConnectionString.ProviderName %>" SelectCommand="SELECT codiceIDE, CONCAT(nome, ' ', cognome) AS perconto FROM persona_fisica UNION SELECT codiceIDE, ragionesociale AS perconto FROM persona_giuridica ORDER BY perconto">
</asp:SqlDataSource>
<asp:SqlDataSource ID="Divisa" runat="server" ConnectionString="<%$ ConnectionStrings:GfcConnectionString %>"
ProviderName="<%$ ConnectionStrings:GfcConnectionString.ProviderName %>" SelectCommand="SELECT codice_iso FROM valute ORDER BY codice_iso">
</asp:SqlDataSource>
</asp:Content>