<%@ Page Language="C#" AutoEventWireup="true" CodeFile="query.aspx.cs" Inherits="query" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server" visible="True">
<div>
<table width="100%">
<tr>
<td width="550px">
<asp:Label ID="fileSQL" runat="server" Text="Nome del file sql Oracle (eliminare l'estensione del file.):"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtFileSQL" runat="server" Width="80%"></asp:TextBox>
</td>
</tr>
<tr>
<td width="550px">
<asp:Label ID="storedSQL" runat="server" Text="Nome della stored procedure SqlServer: (solo stored con unico parametro 'chiaveclientepb')"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtStoredSQL" runat="server" Width="80%"></asp:TextBox>
</td>
</tr>
</table>
</div>
<div>
<table>
<tr>
<td>
<asp:Label ID="cf" runat="server" Text="codice cliente"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtCF" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="rete" runat="server" Text="codice rete"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtRETE" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="pb" runat="server" Text="codice agente"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtPB" runat="server"></asp:TextBox>
</td>
</tr>
</table>
</div>
<br />
<table>
<tr>
<td>
<asp:Button ID="EseguiOracle" runat="server" Text="Esegui query su Oracle" OnClick="Esegui_Click" />
</td>
<td>
<asp:Button ID="EseguiSql" runat="server" Text="Esegui query su SqlServer" OnClick="EseguiSql_Click" />
</td>
<td>
</td>
<td>
<asp:Button ID="Compara" runat="server" Text="Compara Oracle e SqlServer" OnClick="Compara_Click" />
<asp:Label ID="lblRisultatoComparazione" runat="server" Text="..."></asp:Label>
</td>
</tr>
</table>
<br />
<br />
<asp:Button ID="NoSession" runat="server" Text="Cancella Sessione del Cliente corrente (per Oracle)"
OnClick="NoSession_Click" />
<asp:Button ID="LanciaProceduraCaricamentoDati" runat="server" OnClick="LanciaProceduraCaricamentoDati_Click"
Text="Lancia procedura 'avvio_report' (per Oracle)" />
<div style="height: 40px; width: 100%;">
</div>
<div style="height: 20px; width: 100%; background-color: #C0C0C0;">
Risultati su Oracle
</div>
<asp:Label ID="tempoElaborazioneOracle" runat="server"></asp:Label>
<br />
<asp:GridView ID="grigliaOracle" runat="server" AllowSorting="True" OnSorting="griglia_Sorting"
CellPadding="4" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<asp:Label ID="lblNoDatiOracle" runat="server" Text="Nessun record trovato!" Visible="False"></asp:Label>
<br />
<br />
<div style="height: 20px; width: 100%; background-color: #C0C0C0;">
Risultati su SqlServer
</div>
<asp:Label ID="tempoElaborazioneSqlServer" runat="server"></asp:Label>
<br />
<asp:GridView ID="grigliaSqlServer" runat="server" AllowSorting="True" OnSorting="griglia_Sorting"
CellPadding="4" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<asp:Label ID="lblNoDatiSqlServer" runat="server" Text="Nessun record trovato!" Visible="False"></asp:Label>
<br />
<br />
<br />
<p>
<asp:Button ID="btnMigrazioneDettaglioASUL" runat="server" Text="Migra dettaglio ASUL da ORACLE a SQL"
OnClick="btnMigrazioneDettaglioASUL_Click" />
<asp:Label ID="esitoMigrazioneFettaglioASUL" runat="server"></asp:Label>
</p>
</form>
</body>
</html>