<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Don Beaty's Foreign Currency Tracker" Font-Bold="False" Font-Names="Calibri" Font-Size="XX-Large"></asp:Label>
<telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>
<telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0"
Width="1080px"
DataSourceID="SqlDataSource1"
GridLines="None"
AllowAutomaticInserts="True"
AllowAutomaticUpdates="True"
AllowAutomaticDeletes="True"
BorderColor="Gray"
BorderStyle="Inset" Skin="Office2010Silver" >
<MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
commanditemdisplay="None"
allowpaging="True"
EditMode="InPlace"
PageSize="30"
Name="Currency"
showgroupfooter="True" BorderColor="#E0E0E0" BorderStyle="Solid"
BorderWidth="1px" GridLines="Vertical" DataKeyNames="Currency_CountryCode">
<DetailTables>
<telerik:GridTableView runat="server" DataKeyNames="Currency_ID"
EditMode="InPlace" CommandItemDisplay="Bottom" Width="100%"
DataSourceID="SqlDataSource2" AutoGenerateColumns="False"
ShowGroupFooter="True" AllowAutomaticUpdates="False">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="Currency_CountryCode" MasterKeyField="Currency_CountryCode" />
</ParentTableRelation>
<CommandItemSettings ExportToPdfText="Export to PDF" />
<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn
FilterControlAltText="Filter EditCommandColumn column"
Groupable="False"
UniqueName="EditCommandColumn">
<ItemTemplate>
<asp:LinkButton ID="lbuEdit" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton ID="lbuUpdate" runat="server" CommandName="Update" Text="Update"></asp:LinkButton>
<asp:LinkButton ID="lbuCancelUpdate" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
<asp:LinkButton ID="lbuSaveInsert" runat="server" CommandName="Insert" Text="Save"></asp:LinkButton>
<asp:LinkButton ID="lbuCancelInsert" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</InsertItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="CurrencyTarget_ForeignDenomination"
DataType="System.Int32"
FilterControlAltText="Filter CurrencyTarget_ForeignDenomination column"
HeaderText="Foreign<br/>Currency<br/>Denomination"
SortExpression="CurrencyTarget_ForeignDenomination"
UniqueName="CurrencyTarget_ForeignDenomination">
<InsertItemTemplate>
<asp:TextBox ID="CurrencyTarget_ForeignDenomination" runat="server"
Text='<%# Bind("CurrencyTarget_ForeignDenomination") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CurrencyTarget_ForeignDenominationLabel" runat="server"
Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="CurrencyTarget_ForeignDenominationLabel2" runat="server"
Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="USDEquivalent"
HeaderText="US<br/>Dollar<br/>Equivalent" SortExpression="USDEquivalent" UniqueName="USDEquivalent" FilterControlAltText="Filter USDEquivalent column"
DataType="System.Decimal" DataFormatString="${0:#}"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn
DataField="CurrencyTarget_FCNeeded"
HeaderText="Quantity<br/>Needed For<br/>1 '500' Envelope" SortExpression="CurrencyTarget_FCNeeded" UniqueName="CurrencyTarget_FCNeeded" FilterControlAltText="Filter CurrencyTarget_FCNeeded column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
<ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green" CssClass="maximize"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TotalForeignCurrency"
HeaderText="Total<br/>Foreign<br/>Currency" SortExpression="TotalForeignCurrency" UniqueName="TotalForeignCurrency" FilterControlAltText="Filter TotalForeignCurrency column"
DataType="System.Int32" DataFormatString="{0:#}"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Right" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="USDValue"
HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue" UniqueName="USDValue" FilterControlAltText="Filter USDValue column"
DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Right" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TotalFor500Envelopes"
HeaderText="Total<br/>For '500'<br/>Envelopes" SortExpression="TotalFor500Envelopes" UniqueName="TotalFor500Envelopes" FilterControlAltText="Filter TotalFor500Envelopes column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CurrencyTarget_FCNeeded_100"
HeaderText="Quantity<br/>Needed For<br/>1 '100' Envelope" SortExpression="CurrencyTarget_FCNeeded_100" UniqueName="CurrencyTarget_FCNeeded_100" FilterControlAltText="Filter CurrencyTarget_FCNeeded_100 column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
<ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF" CssClass="maximize"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="USDValue_100"
HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue_100" UniqueName="USDValue_100" FilterControlAltText="Filter USDValue_100 column"
DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
ReadOnly="True">
<ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TotalFor100Envelopes"
HeaderText="Total<br/>For '100'<br/>Envelopes" SortExpression="TotalFor100Envelopes" UniqueName="TotalFor100Envelopes" FilterControlAltText="Filter TotalFor100Envelopes column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="TotalForAllEnvelopes"
HeaderText="Total<br/>All<br/>Envelopes" SortExpression="TotalForAllEnvelopes" UniqueName="TotalForAllEnvelopes" FilterControlAltText="Filter TotalForAllEnvelopes column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="CurrencyTarget_NativeCurrent"
HeaderText="Total<br/>On<br/>Hand" SortExpression="CurrencyTarget_NativeCurrent" UniqueName="CurrencyTarget_NativeCurrent" FilterControlAltText="Filter CurrencyTarget_NativeCurrent column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
<ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" CssClass="maximize"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ExcessCurrency"
HeaderText="Excess" SortExpression="ExcessCurrency" UniqueName="ExcessCurrency" FilterControlAltText="Filter ExcessCurrency column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
ReadOnly="True" >
<HeaderStyle VerticalAlign="Bottom"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="OrderQuantity"
HeaderText="Quantity<br/>To<br/>Order" SortExpression="OrderQuantity" UniqueName="OrderQuantity" FilterControlAltText="Filter OrderQuantity column"
DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
ReadOnly="True" >
<ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" ForeColor="Crimson" Font-Bold="true"></ItemStyle>
</telerik:GridBoundColumn>
</Columns>
<GroupByExpressions>
<telerik:GridGroupByExpression>
<SelectFields>
<telerik:GridGroupByField FieldAlias="CountryCode" FieldName="Currency_CountryCode" HeaderText="Country Code" />
</SelectFields>
<GroupByFields>
<telerik:GridGroupByField FieldAlias="Currency_CountryCode" FieldName="Currency_CountryCode" />
</GroupByFields>
</telerik:GridGroupByExpression>
</GroupByExpressions>
<FooterStyle Font-Bold="true" />
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column">
</EditColumn>
</EditFormSettings>
</telerik:GridTableView>
</DetailTables>
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn
FilterControlAltText="Filter EditCommandColumn column"
Groupable="False"
UniqueName="EditCommandColumn">
<ItemTemplate>
<asp:LinkButton ID="lbuEditP" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton ID="lbuUpdateP" runat="server" CommandName="Update" Text="Update"></asp:LinkButton>
<asp:LinkButton ID="lbuCancelUpdateP" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
<asp:LinkButton ID="lbuSaveInsertP" runat="server" CommandName="Insert" Text="Save"></asp:LinkButton>
<asp:LinkButton ID="lbuCancelInsertP" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</InsertItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="Currency_CountryDesc"
FilterControlAltText="Filter Currency_CountryDesc column"
HeaderText="Currency" SortExpression="Currency_CountryDesc"
UniqueName="Currency_CountryDesc"
ReadOnly="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ExchangeRate"
DataType="System.Decimal"
FilterControlAltText="Filter Currency_Conversion column"
HeaderText="Exchange Rate" SortExpression="ExchangeRate"
ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Center"
UniqueName="ExchangeRate"
ReadOnly="True">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Currency_EnvelopeCount500"
DataType="System.Int16"
FilterControlAltText="Filter Currency_EnvelopeCount500 column"
HeaderText="500 Env. Count"
SortExpression="Currency_EnvelopeCount500"
UniqueName="Currency_EnvelopeCount500">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Currency_EnvelopeCount100"
DataType="System.Int16"
FilterControlAltText="Filter Currency_EnvelopeCount100 column"
HeaderText="100 Env. Count"
SortExpression="Currency_EnvelopeCount100"
UniqueName="Currency_EnvelopeCount100">
<HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
</telerik:GridBoundColumn>
<telerik:GridCheckBoxColumn DataField="Currency_BriefcaseUsed"
DataType="System.Boolean"
FilterControlAltText="Filter Currency_BriefcaseUsed column"
HeaderText="Flag Briefcase" SortExpression="Currency_BriefcaseUsed"
UniqueName="Currency_BriefcaseUsed">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</telerik:GridCheckBoxColumn>
<telerik:GridCheckBoxColumn DataField="Currency_HomeOfficeUsed"
DataType="System.Boolean"
FilterControlAltText="Filter Currency_HomeOfficeUsed column"
HeaderText="Flag Home" SortExpression="Currency_HomeOfficeUsed"
UniqueName="Currency_HomeOfficeUsed">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</telerik:GridCheckBoxColumn>
<telerik:GridCheckBoxColumn DataField="Currency_OneHundUsed"
DataType="System.Boolean"
FilterControlAltText="Filter Currency_OneHundUsed column"
HeaderText="Flag 100" SortExpression="Currency_OneHundUsed"
UniqueName="Currency_OneHundUsed">
<HeaderStyle HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</telerik:GridCheckBoxColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
<PagerStyle AlwaysVisible="True" />
<HeaderStyle Font-Bold="True" />
</MasterTableView>
<FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:RadGrid>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"
SelectCommand="SELECT Currency_CountryCode, Currency_CountryDesc, Currency_EnvelopeCount500, Currency_EnvelopeCount100, 1 / Currency_Conversion AS ExchangeRate, Currency_LastUpdated, Currency_BriefcaseUsed, Currency_HomeOfficeUsed, Currency_OneHundUsed, CASE LEN(CurrencyTarget_CountryCode) WHEN 3 THEN 0 ELSE 1 END AS Existing, CurrencyTarget_CountryCode
FROM Currency_LatestConversions_TBL LEFT OUTER JOIN Currency_CurrentlyTracked ON Currency_LatestConversions_TBL.Currency_CountryCode = Currency_CurrentlyTracked.CurrencyTarget_CountryCode
ORDER BY Existing, Currency_LatestConversions_TBL.Currency_CountryDesc"
UpdateCommand="UPDATE [Currency_LatestConversions_TBL]
SET [Currency_EnvelopeCount500] = @Currency_EnvelopeCount500, [Currency_EnvelopeCount100] = @Currency_EnvelopeCount100, [Currency_BriefcaseUsed] = @Currency_BriefcaseUsed, [Currency_HomeOfficeUsed] = @Currency_HomeOfficeUsed, [Currency_OneHundUsed] = @Currency_OneHundUsed
WHERE [Currency_CountryCode]=@Currency_CountryCode">
<UpdateParameters>
<asp:Parameter Name="Currency_CountryCode" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"
SelectCommand="SELECT Currency_ID, Currency_CountryCode, Currency_CountryDesc, CurrencyTarget_ForeignDenomination, USDEquivalent, CurrencyTarget_FCNeeded, TotalForeignCurrency, ExchangeRate, USDValue, TotalFor500Envelopes, CurrencyTarget_FCNeeded_100, TotalFor100Envelopes, USDValue_100, TotalForAllEnvelopes, CurrencyTarget_NativeCurrent, CASE sign(QtyToOrder) WHEN - 1 THEN 0 ELSE QtyToOrder END AS OrderQuantity, CASE sign(Excess) WHEN - 1 THEN 0 ELSE Excess END AS ExcessCurrency
FROM Currency_Grid WHERE([Currency_CountryCode]=@Currency_CountryCode)
ORDER BY CurrencyTarget_ForeignDenomination"
UpdateCommand="UPDATE [Currency_TargetAmounts_TBL]
SET [CurrencyTarget_FCNeeded] = @CurrencyTarget_FCNeeded, [CurrencyTarget_FCNeeded_100] = @CurrencyTarget_FCNeeded_100, [CurrencyTarget_NativeCurrent] = @CurrencyTarget_NativeCurrent
WHERE [Currency_ID] = @Currency_ID"
InsertCommand="INSERT INTO Currency_TargetAmounts_TBL(Currency_Location, CurrencyTarget_CountryCode, CurrencyTarget_ForeignDenomination, CurrencyTarget_FCNeeded, CurrencyTarget_FCNeeded_100, CurrencyTarget_NativeCurrent) SELECT 'AccounTEST' AS Expr1, 'CAD' AS Expr2, @CurrencyTarget_ForeignDenomination AS Expr3, @CurrencyTarget_FCNeeded AS Expr4, @CurrencyTarget_FCNeeded_100 AS Expr5, @CurrencyTarget_NativeCurrent AS Expr6" >
<SelectParameters>
<asp:SessionParameter DefaultValue="XXX" Name="Currency_CountryCode" SessionField="@Currency_CountryCode" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="CurrencyTarget_FCNeeded" />
<asp:Parameter Name="CurrencyTarget_FCNeeded_100" />
<asp:Parameter Name="CurrencyTarget_NativeCurrent" />
<asp:Parameter Name="Currency_ID" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Type="Int32" Name="CurrencyTarget_ForeignDenomination" DefaultValue="0" />
<asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded" DefaultValue="0" />
<asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded_100" DefaultValue="0" />
<asp:Parameter Type="Int32" Name="CurrencyTarget_NativeCurrent" DefaultValue="0" />
</InsertParameters>
</asp:SqlDataSource>
</form>
</body>