<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="InvoicePreviewException.aspx.cs" Inherits="SalesManagementWebApplication.Executive.Report.PreviewBacklog.InvoicePreviewException" MasterPageFile="~/SalesManagementMaster.Master" %> |
|
<asp:Content ID="ContentPlaceHolderHead" ContentPlaceHolderID="ContentPlaceHolderHead" runat="server"> |
<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxyPage" runat="server"> |
<AjaxSettings> |
<telerik:AjaxSetting AjaxControlID="RadGridSearch"> |
<UpdatedControls> |
<telerik:AjaxUpdatedControl ControlID="RadSplitterPageContent" LoadingPanelID="RadAjaxLoadingPanelReport" /> |
</UpdatedControls> |
</telerik:AjaxSetting> |
<telerik:AjaxSetting AjaxControlID="ButtonSearch"> |
<UpdatedControls> |
<telerik:AjaxUpdatedControl ControlID="RadGridSearch" LoadingPanelID="RadAjaxLoadingPanelReport" /> |
</UpdatedControls> |
</telerik:AjaxSetting> |
<telerik:AjaxSetting AjaxControlID="PanelEmailSales"> |
<UpdatedControls> |
<telerik:AjaxUpdatedControl ControlID="RadSplitterPageContent" LoadingPanelID="RadAjaxLoadingPanelReport" /> |
</UpdatedControls> |
</telerik:AjaxSetting> |
</AjaxSettings> |
</telerik:RadAjaxManagerProxy> |
</asp:Content> |
|
<asp:Content ID="ContentPlaceHolderBody" ContentPlaceHolderID="ContentPlaceHolderBody" runat="server"> |
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanelReport" runat="server" Skin="Simple" /> |
<telerik:RadSplitter ID="RadSplitterPageContent" runat="server" Orientation="Horizontal" BorderSize="0" BorderStyle="None" BorderWidth="0"> |
<telerik:RadPane ID="RadPaneWebSearchForm" runat="server" Scrolling="None" Height="30"> |
<table class="searchTable"> |
<tr> |
<th title="Select the starting date."> |
<asp:Label ID="LabelFromDate" runat="server" Text="From:" AssociatedControlID="RadDatePickerFrom" /> |
</th> |
<td title="Select the starting date."> |
<telerik:RadDatePicker ID="RadDatePickerFrom" runat="server" Width="90px" /> |
</td> |
<th title="Select the ending date."> |
<asp:Label ID="LabelToDate" runat="server" Text="To:" AssociatedControlID="RadDatePickerTo" /> |
</th> |
<td title="Select the ending date."> |
<telerik:RadDatePicker ID="RadDatePickerTo" runat="server" Width="90px" /> |
</td> |
<th title="Enter an Invoice Number, or partial Invoice Number here to limit the results by Invoice Number, seperate multiple Invoice Number's by commas." nowrap> |
<asp:Label ID="LabelInvoiceNumber" runat="server" Text="Invoice #:" AssociatedControlID="RadTextBoxInvoiceNumber" /> |
</th> |
<td title="Enter an Invoice Number, or partial Invoice Number here to limit the results by Invoice Number, seperate multiple Invoice Number's by commas."> |
<telerik:RadTextBox ID="RadTextBoxInvoiceNumber" runat="server" Width="150px" /> |
</td> |
<th title="When 'Show' is 'All' all invoices will be displayed, when either 'Gold Standard Exceptions' or 'Replacement Cost Exceptions' is selected ONLY invoices with line items with a GM% less than the PL threshold will be displayed."> |
<telerik:RadComboBox ID="RadComboBoxShowExceptions" runat="server" Width="150px" Label="Show:"> |
<Items> |
<telerik:RadComboBoxItem Value="all" Text="All" Selected="true" /> |
<telerik:RadComboBoxItem Value="gs" Text="Gold Standard Exceptions" /> |
<telerik:RadComboBoxItem Value="rc" Text="Replacement Cost Exceptions" /> |
</Items> |
</telerik:RadComboBox> |
</th> |
<th> |
<telerik:RadComboBox ID="RadComboBoxExpanded" runat="server" CssClass="smallMargin" Label="Expanded:" Width="50px" Text="Test:"> |
<Items> |
<telerik:RadComboBoxItem Value="true" Text="Yes" Selected="true" /> |
<telerik:RadComboBoxItem Value="false" Text="No" /> |
</Items> |
</telerik:RadComboBox> |
</th> |
<td title="Click the search button to execute a new search."> |
<asp:Button ID="ButtonSearch" runat="server" Text="Search" OnClick="ButtonSearch_Click" /> |
</td> |
</tr> |
</table> |
</telerik:RadPane> |
<telerik:RadPane ID="RadPaneWebSearchResult" runat="server" Scrolling="None" CssClass="RadPaneScrollingPane"> |
<telerik:RadGrid SkinId="noCommandItemTemplate" |
ID="RadGridSearch" |
runat="server" |
DataSourceID="ObjectDataSourceSearch" |
OnItemCommand="RadGridSearch_ItemCommand" |
AllowMultiRowSelection="true" onitemdatabound="RadGridSearch_ItemDataBound"> |
<MasterTableView DataKeyNames="InvoiceNumber" Name="MainTable"> |
<Columns> |
<telerik:GridButtonColumn ButtonType="ImageButton" DataTextField="InvoiceNumber" CommandName="Email" HeaderStyle-Width="20" ImageUrl="~/Image/i_email.gif" /> |
<telerik:GridBoundColumn HeaderText="Invoice Date" DataField="InvoiceDate" UniqueName="InvoiceDate" SortExpression="InvoiceDate" ShowFilterIcon="true" ItemStyle-Wrap="false" DataFormatString="{0:d}" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Sales Order Number" DataField="SalesOrderNumber" UniqueName="SalesOrderNumber" SortExpression="SalesOrderNumber" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Invoice Number" DataField="InvoiceNumber" UniqueName="InvoiceNumber" SortExpression="InvoiceNumber" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Territory" DataField="SalesmanId" UniqueName="SalesmanId" SortExpression="SalesmanId" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="AR" DataField="AR" UniqueName="AR" SortExpression="AR" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Customer Name" DataField="CustomerName" UniqueName="CustomerName" SortExpression="CustomerName" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="250" /> |
<telerik:GridBoundColumn HeaderText="Bill To State" DataField="State" UniqueName="State" SortExpression="State" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Total Sale" DataField="TotalSaleAmount" UniqueName="TotalSaleAmount" SortExpression="TotalSaleAmount" ShowFilterIcon="true" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Freight Paid" DataField="FreightPaid" UniqueName="FreightPaid" SortExpression="FreightPaid" ShowFilterIcon="true" ItemStyle-Wrap="false" HeaderStyle-Width="110" DataType="System.Boolean" /> |
<telerik:GridCalculatedColumn HeaderText="GM after Freight" UniqueName="GmAfterFreight" DataType="System.Decimal" DataFields="TotalCost, TotalSaleAmount, FreightAmount" Expression="iif({1}=0,0,({1}-{0}-{2})/{1})" SortExpression="GmAfterFreight" ShowFilterIcon="true" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:p2}" HeaderStyle-Width="110" /> |
<%-- |
<telerik:GridBoundColumn HeaderText="TotalCost" DataField="TotalCost" UniqueName="TotalCost" SortExpression="TotalCost" ShowFilterIcon="true" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" HeaderStyle-Width="110" /> |
<telerik:GridBoundColumn HeaderText="Freight" DataField="FreightAmount" UniqueName="FreightAmount" SortExpression="FreightAmount" ShowFilterIcon="true" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" HeaderStyle-Width="110" /> |
--%> |
</Columns> |
<DetailTables> |
<telerik:GridTableView runat="server" Name="LineItems" DataSourceID="ObjectDataSourceLineItems" DataKeyNames="InvoiceNumber" Height="100%" EnableHeaderContextFilterMenu="true"> |
<ParentTableRelation> |
<telerik:GridRelationFields DetailKeyField="InvoiceNumber" MasterKeyField="InvoiceNumber" /> |
</ParentTableRelation> |
<Columns> |
<telerik:GridBoundColumn HeaderText="PartNumber" DataField="PartNumber" UniqueName="PartNumber" SortExpression="PartNumber" ItemStyle-Wrap="false" /> |
<telerik:GridBoundColumn HeaderText="Product Line" DataField="ProductLineId" UniqueName="ProductLineId" SortExpression="ProductLineId" ItemStyle-Wrap="false" /> |
<telerik:GridBoundColumn HeaderText="Description" DataField="Description" UniqueName="Description" SortExpression="Description" ItemStyle-Wrap="false" /> |
<telerik:GridBoundColumn HeaderText="Qty Ordered" DataField="QuantityOrdered" UniqueName="QuantityOrdered" SortExpression="QuantityOrdered" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" /> |
<telerik:GridBoundColumn HeaderText="Qty Shipped" DataField="QuantityShipped" UniqueName="QuantityShipped" SortExpression="QuantityShipped" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" /> |
<telerik:GridBoundColumn HeaderText="Sales Price" DataField="SalesPrice" UniqueName="SalesPrice" SortExpression="SalesPrice" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" /> |
<telerik:GridBoundColumn HeaderText="Extended Sales Amount" DataField="ExtendedSalesAmount" UniqueName="ExtendedSalesAmount" SortExpression="ExtendedSalesAmount" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" /> |
<telerik:GridBoundColumn HeaderText="Gold Standard" DataField="GoldStandard" UniqueName="GoldStandard" SortExpression="GoldStandard" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" /> |
<telerik:GridBoundColumn HeaderText="Replacement Cost" DataField="ReplacementCost" UniqueName="ReplacementCost" SortExpression="ReplacementCost" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:c}" /> |
<telerik:GridCalculatedColumn HeaderText="GM% @ GS" UniqueName="GmPercentAtGoldStandard" DataType="System.Decimal" DataFields="GoldStandard, SalesPrice" Expression="iif({1}=0,0,({1}-{0})/{1})" SortExpression="GmPercentAtGoldStandard" ShowFilterIcon="true" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:p2}" /> |
<telerik:GridBoundColumn HeaderText="GM% @ GS Threshold" DataField="GoldStandardThreshold" UniqueName="GoldStandardThreshold" SortExpression="GoldStandardThreshold" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:p}" Visible="false" /> |
<telerik:GridCalculatedColumn HeaderText="GM% @ RC" UniqueName="GmPercentAtRC" DataType="System.Decimal" DataFields="ReplacementCost, SalesPrice" Expression="iif({1}=0,0,({1}-{0})/{1})" SortExpression="GmPercentAtRC" ShowFilterIcon="true" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:p2}" /> |
<telerik:GridBoundColumn HeaderText="GM% @ RC Threshold" DataField="ReplacementCostThreshold" UniqueName="ReplacementCostThreshold" SortExpression="ReplacementCostThreshold" ItemStyle-Wrap="false" ItemStyle-HorizontalAlign="Right" DataFormatString="{0:p}" Visible="false" /> |
</Columns> |
</telerik:GridTableView> |
</DetailTables> |
<CommandItemTemplate> |
<table class="layout" cellpadding="0" cellspacing="0"> |
<tr> |
<td valign="middle" style="padding-top: 3px;"> |
<asp:ImageButton ID="ImageButtonExcelExport" runat="server" ImageUrl="~/Image/i_excel.gif" OnClick="ImageButtonExcelExport_Click" CssClass="smallMargin" /> |
</td> |
<td valign="middle"> |
<asp:Button ID="ButtonViewSelected" runat="server" Text="View Selected" OnClick="ButtonViewSelected_Click" /> |
</td> |
</tr> |
</table> |
</CommandItemTemplate> |
<SortExpressions> |
<telerik:GridSortExpression FieldName="InvoiceDate" SortOrder="Ascending" /> |
</SortExpressions> |
</MasterTableView> |
<ClientSettings EnableRowHoverStyle="true"> |
<Selecting AllowRowSelect="True" /> |
</ClientSettings> |
</telerik:RadGrid> |
|
<asp:Panel ID="PanelEmailSales" runat="server" Visible="false" DefaultButton="ButtonEmailSalesCancel"> |
<asp:HiddenField ID="HiddenFieldInvoiceNumber" runat="server" /> |
<table class="inlineFormTable"> |
<caption> |
Send |
<asp:Label ID="LabelMailSalespersonName" runat="server" Text="" /> |
email concerning invoice number |
<asp:Label ID="LabelMailInvoiceNumber" runat="server" Text="" /> |
</caption> |
<tr> |
<td style="padding: 2px;"> |
<telerik:RadEditor ID="RadEditorEmailBody" runat="server" Height="400" width="600" EditModes="Design" EnableResize="false" CssClass=""> |
<Tools> |
<telerik:EditorToolGroup> |
<telerik:EditorTool Name="Bold" /> |
<telerik:EditorTool Name="Italic" /> |
<telerik:EditorTool Name="Underline" /> |
<telerik:EditorTool Name="StrikeThrough" /> |
<telerik:EditorSplitButton Name="SplitCell" /> |
<telerik:EditorTool Name="JustifyLeft" /> |
<telerik:EditorTool Name="JustifyCenter" /> |
<telerik:EditorTool Name="JustifyRight" /> |
<telerik:EditorTool Name="JustifyFull" /> |
<telerik:EditorTool Name="JustifyNone" /> |
<telerik:EditorSplitButton Name="SplitCell" /> |
<telerik:EditorTool Name="Indent" /> |
<telerik:EditorTool Name="Outdent" /> |
<telerik:EditorSplitButton Name="SplitCell" /> |
<telerik:EditorTool Name="InsertOrderedList" /> |
<telerik:EditorTool Name="InsertUnorderedList" /> |
</telerik:EditorToolGroup> |
</Tools> |
</telerik:RadEditor> |
</td> |
</tr> |
<tr class="buttonRow"> |
<td> |
<asp:Button ID="ButtonEmailSend" runat="server" Text="Send" onclick="ButtonEmailSend_Click" /> |
<asp:Button ID="ButtonEmailSalesCancel" runat="server" Text="Cancel" onclick="ButtonEmailSalesCancel_Click" /> |
</td> |
</tr> |
</table> |
</asp:Panel> |
</telerik:RadPane> |
</telerik:RadSplitter> |
|
<asp:ObjectDataSource |
ID="ObjectDataSourceSearch" |
runat="server" |
TypeName="ServiceWebClassLibrary.MARCOMV.MVFILE.INVFTServiceWeb" |
SelectMethod="LoadExecutiveInvoicePreviewException" |
EnableCaching="false" |
CacheDuration="42000"> |
<SelectParameters> |
<asp:ControlParameter ControlID="RadDatePickerFrom" Name="from" Type="DateTime" /> |
<asp:ControlParameter ControlID="RadDatePickerTo" Name="to" Type="DateTime" /> |
<asp:ControlParameter ControlID="RadTextBoxInvoiceNumber" Name="InvoiceNumber" Type="String" /> |
<asp:ControlParameter ControlID="RadComboBoxShowExceptions" Name="ShowExceptions" Type="String" PropertyName="SelectedValue" /> |
</SelectParameters> |
</asp:ObjectDataSource> |
<asp:ObjectDataSource |
ID="ObjectDataSourceLineItems" |
runat="server" |
TypeName="ServiceWebClassLibrary.MARCOMV.MVFILE.INVFTServiceWeb" |
SelectMethod="LoadExecutiveInvoicePreviewExceptionLineItems" |
EnableCaching="true" |
CacheDuration="42000"> |
<SelectParameters> |
<asp:SessionParameter Name="InvoiceNumber" SessionField="InvoiceNumber" Type="string" /> |
</SelectParameters> |
</asp:ObjectDataSource> |
</asp:Content> |