Hello,
While testing the edit operations of the code in the grid, I found that when I am complete the Grid row edit ended event, I get the exception as shown below.This exception gets thrown after the code successfully completes its execution of the RowEditEnded or CellEditEnded or any other such Events.I added try and catch blocks within the code for all such events to verify this.
I am using RadControls for Silverlight Q1 2010 SP2.
Please let me know how I can resolve this issue
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; .NET4.0C; .NET4.0E)
Timestamp: Wed, 11 Aug 2010 14:19:32 UTC
Message: Sys.InvalidOperationException: ManagedRuntimeError error #4004 in control 'Xaml1': System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.ThrowHelper.ThrowArgumentOutOfRangeException()
at System.Collections.Generic.List`1.get_Item(Int32 index)
at Telerik.Windows.Controls.GridView.GridViewDataControl.GetRowForItem(Object item, Boolean forceGroupExpand)
at Telerik.Windows.Controls.GridView.GridViewDataControl.OnCurrentCellInfoChanged(GridViewCellInfo currentCell)
at Telerik.Windows.Controls.GridView.GridViewDataControl.set_CurrentCellInfo(GridViewCellInfo value)
at Telerik.Windows.Controls.GridView.GridViewCell.OnGotFocus(RoutedEventArgs e)
at System.Windows.Controls.Control.OnGotFocus(Control ctrl, EventArgs e)
at MS.Internal.JoltHelper.FireEvent(IntPtr unmanagedObj, IntPtr unmanagedObjArgs, Int32 argsTypeIndex, String eventName)
Line: 453
Char: 17
Code: 0
URI: http://localhost:5555/rpt/ScriptResource.axd?d=lsm9ZkpLxZCQkQFlNGkKDcRJQJjx9ZiO44TgICWlFv3ITicGoPAQjBmDOf7Hoiv2Iedm-yC8FIGmjX_NthpccA2&t=26f981c1
5 Answers, 1 is accepted
Please give us more specifics about your project, its settings and the logic implemented during the RowEditEnded or CellEditEnded events. It would be great if you could send us a sample project illustrating the issue or at least provide us with some code-snippets from your application.
Maya
the Telerik team

Thank you for your response.
The idea that I am trying to implement is that certain columns in the grid have been kept as edtiable and the user edits the cells in such columns and clicks on a submit button to save the data in some application.
However, I find that when the cell edit event completes, it shows the exception mentioned above.
Given below is my xaml page and my XAML page code behind:
=============================XAML PAGE CODE==========================================
<UserControl xmlns:my="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Documents"
xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"
x:Class="Avanade.Crm.Sam.RPT.MainPage"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="d" d:DesignHeight="750" d:DesignWidth="12750"
xmlns:telerik="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls"
xmlns:telerikInput="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Input"
xmlns:grid="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.GridView"
xmlns:gridView="clr-namespace:Telerik.Windows.Controls.GridView;assembly=Telerik.Windows.Controls.GridView"
xmlns:data="clr-namespace:Telerik.Windows.Data;assembly=Telerik.Windows.Data"
xmlns:i="clr-namespace:System.Windows.Interactivity;assembly=System.Windows.Interactivity"
xmlns:local="clr-namespace:Avanade.Crm.Sam.RPT"
xmlns:telerik1="http://schemas.telerik.com/2008/xaml/presentation">
<!--
<UserControl.Resources>
<local:RegionViewModel x:Key="RegionViewModel"></local:RegionViewModel>
</UserControl.Resources>
-->
<UserControl.Resources>
<Style TargetType="gridView:GridViewHeaderCell" x:Key="MyHeaderCellStyle">
<Setter Property="Background" Value="LightBlue" />
<Setter Property="Foreground" Value="Black" />
<Setter Property="BorderBrush" Value="Black"/>
<Setter Property="FontWeight" Value="Bold"/>
</Style>
<Style x:Key="MyCustomGroupRowStyle" TargetType="gridView:GridViewGroupRow">
<Setter Property="ShowHeaderAggregates" Value="True"/>
<Setter Property="IsExpanded" Value="True"/>
</Style>
</UserControl.Resources>
<ScrollViewer HorizontalScrollBarVisibility="Visible">
<Grid x:Name="LayoutRoot" Background="White">
<Grid.Resources>
<local:CalculatingConverter x:Key="CalculatingConverter" />
</Grid.Resources>
<StackPanel Orientation="Vertical">
<StackPanel Orientation="Horizontal" Margin="0,0,0,5">
<Image Source="/Avanade.Crm.Sam.RPT;component/Images/logo.png" Width="162" Height="44" HorizontalAlignment="Left" />
<sdk:Label Height="28" Name="label1" Width="575" HorizontalAlignment="Left" Content="Revenue Projection Tool" FontSize="20" Padding="50,0,0,0" FontWeight="Normal" FontFamily="Portable User Interface" />
</StackPanel>
<telerik:RadExpander x:Name="radExpander" ExpandDirection="Down" VerticalAlignment="Top" HorizontalAlignment="Stretch" IsExpanded="True" FlowDirection="LeftToRight">
<telerik:RadExpander.Header>
<TextBlock x:Name="expanderCaption" Visibility="Visible" Text="Menu" />
</telerik:RadExpander.Header>
<telerik:RadExpander.Content>
<telerik:RadWrapPanel x:Name="imageContainer" IsAnimated="False" Orientation="Horizontal" VerticalAlignment="Bottom" HorizontalAlignment="Stretch">
<StackPanel Orientation="Vertical">
<StackPanel Orientation="Horizontal" Margin="0,0,0,0">
<!--
<telerikInput:RadComboBox Name="radRegionComboBox" Width="250" SelectedIndex="0">
<telerikInput:RadComboBox.ItemTemplate>
<DataTemplate>
<CheckBox IsChecked="False" Content="{Binding BindsDirectlyToSource=True}" ></CheckBox>
</DataTemplate>
</telerikInput:RadComboBox.ItemTemplate>
</telerikInput:RadComboBox>
-->
<telerikInput:RadComboBox Name="radRegion2ComboBox" Width="327" EmptyText=" Select one or more Regions " Margin="60,0,0,0" Height="24" Background="White" BorderBrush="White" OpacityMask="#E8000800" Foreground="#AF000001" IsHighlighted="False" IsHitTestVisible="True">
<telerikInput:RadComboBox.ItemTemplate>
<DataTemplate x:Name="Rad_Region_2_Combo_Box_Data_Template">
<CheckBox ClickMode="Press" Content="{Binding BindsDirectlyToSource=True}" IsChecked="False" Checked="RegionCheckBox_Checked" Unchecked="RegionCheckBox_UnChecked" x:Name="Rad_Region_2_Combo_Box_Check_Box">
</CheckBox>
</DataTemplate>
</telerikInput:RadComboBox.ItemTemplate>
</telerikInput:RadComboBox>
<TextBlock Height="23" Name="AccountTextBlock" Text="Account" FontWeight="Bold" Width="72" Margin="20,0,0,0" FontStyle="Normal" TextAlignment="Center" FontSize="12" VerticalAlignment="Stretch" HorizontalAlignment="Stretch"><TextBlock.OpacityMask><LinearGradientBrush EndPoint="1,0.5" StartPoint="0,0.5"><GradientStop Color="Black" Offset="0" /><GradientStop Color="SkyBlue" Offset="1" /></LinearGradientBrush></TextBlock.OpacityMask></TextBlock>
<sdk:AutoCompleteBox x:Name="AccountAutoCompleteBox" IsTextCompletionEnabled="True" Width="208" Margin="20,0,0,0" ValueMemberBinding="{Binding}" />
<TextBlock Height="23" Name="BDOwnerTextBlock" Text="BD Owner" FontWeight="Bold" Width="72" Margin="20,0,0,0" TextAlignment="Center" FontSize="12" />
<sdk:AutoCompleteBox x:Name="BDOwnerAutoCompleteBox" IsTextCompletionEnabled="True" Width="170" Margin="20,0,0,0" MaxWidth="200" MaxHeight="25" MinWidth="30" FlowDirection="LeftToRight" HorizontalContentAlignment="Left" VerticalContentAlignment="Top" />
<Button Content="Show Data" HorizontalAlignment="Left" Name="ShowDataButton" VerticalAlignment="Top" Click="ShowDataButton_Click" Margin="5,0,0,0" />
<Button Content="Submit" HorizontalAlignment="Left" Name="SaveButton" VerticalAlignment="Top" Click="btn_Save" Margin="5,0,0,0" />
<!--
<Button Content="Revenue Totals" HorizontalAlignment="Left" Name="RevTotalButton" VerticalAlignment="Top" Click="RevTotalButton_Click" Margin="5,0,0,0" />
<Button Content="Hide Columns" HorizontalAlignment="Left" Name="HideColumns" VerticalAlignment="Top" Click="ShowHideColumnsOptions" Margin="5,0,0,0" />
<Button Content="Export" HorizontalAlignment="Left" Name="Export" VerticalAlignment="Top" Click="ExportToExcel" Margin="5,0,0,0" />
-->
<Button Content="Show Revenue in USD" HorizontalAlignment="Left" Name="DisplayRevenueInUSDAndLCY" VerticalAlignment="Top" Click="DisplayRevenueInUSDAndLCY_Click" Margin="5,0,0,0" />
</StackPanel>
</StackPanel>
</telerik:RadWrapPanel>
</telerik:RadExpander.Content>
</telerik:RadExpander>
</StackPanel>
<grid:RadGridView Name="radGridView" ShowColumnFooters="True" AutoGenerateColumns="False"
AlternateRowBackground="Coral" Margin="0,110,328,0" HorizontalGridLinesBrush="Black" VerticalGridLinesBrush="Black" BorderBrush="Black" FontWeight="Bold"
FontFamily="Arial" FontSize="11" VerticalAlignment="Top" HorizontalAlignment="Stretch" MaxColumnWidth="500"
DataLoadMode="Asynchronous" Height="620" RowHeight="15" ScrollMode="RealTime" Width="12700" GroupRowStyle="{StaticResource MyCustomGroupRowStyle}">
<i:Interaction.Behaviors>
<local:ColumnGroupsBehavior>
<local:ColumnGroupsBehavior.CommonHeaders>
<local:CommonHeader StartColumnIndex="0" Caption="Opportunity Details" ColumnSpan="30"/>
<local:CommonHeader StartColumnIndex="27" Caption="FY UNWEIGHTED REVENUE" ColumnSpan="17" />
<local:CommonHeader StartColumnIndex="44" Caption="(FY+1) UNWEIGHTED REVENUE" ColumnSpan="17" />
<local:CommonHeader StartColumnIndex="62" Caption="(FY) WEIGHTED REVENUE" ColumnSpan="17" />
<local:CommonHeader StartColumnIndex="80" Caption="(FY+1) WEIGHTED REVENUE" ColumnSpan="17" />
</local:ColumnGroupsBehavior.CommonHeaders>
</local:ColumnGroupsBehavior>
</i:Interaction.Behaviors>
<grid:RadGridView.Columns>
<!--
<grid:GridViewBoundColumnBase Header="Submit">
<grid:GridViewBoundColumnBase.CellTemplate>
<DataTemplate>
<Button x:Name="UpdateRow" Height="20" Width="40" Content="Submit" Click="UpdateRow_Click" />
</DataTemplate>
</grid:GridViewBoundColumnBase.CellTemplate>
</grid:GridViewBoundColumnBase>
-->
<grid:GridViewDynamicHyperlinkColumn Header="Opportunity Name" DataMemberBinding="{Binding OpportunityName}"
NavigateUrlMemberPaths="OpportunityGUID"
NavigateUrlFormatString=" "
TargetName="_blank" IsReadOnly="True" UniqueName="OpportunityName" Background="White" HeaderTextAlignment="Center" DisplayIndex="0" x:Name="OpportunityName">
</grid:GridViewDynamicHyperlinkColumn>
<grid:GridViewDataColumn Header="ID" DataMemberBinding="{Binding OpportunityID}" Width="100" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="1"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Owned By" DataMemberBinding="{Binding Region}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="2"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Duration" DataMemberBinding="{Binding Duration}" IsReadOnly="True" Width="75" HeaderTextAlignment="Center" TextAlignment="Center" DisplayIndex="3"></grid:GridViewDataColumn>
<grid:GridViewDynamicHyperlinkColumn Header="Account" DataMemberBinding="{Binding Account}"
NavigateUrlMemberPaths="AccountGUID"
NavigateUrlFormatString=" "
TargetName="_blank" IsReadOnly="True" Width="200" HeaderTextAlignment="Center" Background="White" x:Name="Account" DisplayIndex="4"/>
<grid:GridViewDataColumn Header="Industry" DataMemberBinding="{Binding Industry}" IsReadOnly="True" Width="150" HeaderTextAlignment="Center" DisplayIndex="5">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Operating Unit" DataMemberBinding="{Binding OpUnitClientGroup}" IsReadOnly="True" Width="150" HeaderTextAlignment="Center" DisplayIndex="6">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="GDN Person Days" DataMemberBinding="{Binding GDNPersonDays}" IsReadOnly="True" Width="95" HeaderTextAlignment="Center" TextAlignment="Center" DisplayIndex="7">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Created On" DataMemberBinding="{Binding CreatedOn}" IsReadOnly="True" DataFormatString="{} {0:dd-MMM-yyyy}" UniqueName="CreatedOn" HeaderTextAlignment="Center" TextAlignment="Center" DisplayIndex="8" Width="95">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Parent Opportunity ID" DataMemberBinding="{Binding ParentOpportunityID}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="9" Width="75">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Probability" DataMemberBinding="{Binding Probability}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="10" Width="75">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Sales Stage" DataMemberBinding="{Binding SalesStage}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="11" Width="100">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Margin %" DataMemberBinding="{Binding MarginPercent}" IsReadOnly="True" TextAlignment="Center" HeaderTextAlignment="Center" DisplayIndex="12">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Effort Days" DataMemberBinding="{Binding EffortDays}" IsReadOnly="False" HeaderTextAlignment="Center" UniqueName="EffortDays" DisplayIndex="13">
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Est Proj Start Date" DataMemberBinding="{Binding EstimatedProjStDt}" IsReadOnly="True" DataFormatString="{} {0:dd-MMM-yyyy}" UniqueName="EstimatedProjStDt" HeaderTextAlignment="Center" DisplayIndex="14" TextAlignment="Center"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="OffShore/Nearshore" DataMemberBinding="{Binding OffShoreLocationName}" IsReadOnly="True" UniqueName="OffShoreLocationName" HeaderTextAlignment="Center" DisplayIndex="15"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Transaction Currency" DataMemberBinding="{Binding TransactionCurrency}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="16" Width="70"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Share" DataMemberBinding="{Binding DoNotShareFlag}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="17"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="SAP Contract ID" DataMemberBinding="{Binding SAPContractID}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="18"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Contract Number" DataMemberBinding="{Binding ContractNumber}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="19"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Deal Type" DataMemberBinding="{Binding DealTypeName}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="20"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Customer Segment" DataMemberBinding="{Binding CustomerSegment}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="21"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Revenue Type" DataMemberBinding="{Binding REVENUE_TYPE}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="22"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Prime Contracting Party" DataMemberBinding="{Binding PrimeContractingParty}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="23"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Solution" DataMemberBinding="{Binding Solution}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="24"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="BD Owner" DataMemberBinding="{Binding BDOwner}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="25"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Sales Revenue" DataMemberBinding="{Binding SALES_REVENUE}" IsReadOnly="False" HeaderTextAlignment="Center" UniqueName="SALES_REVENUE" DisplayIndex="26">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="SALES_REVENUE" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Yield Revenue" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter}, ConverterParameter=YIELD_REVENUE}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="YIELD_REVENUE" DisplayIndex="27">
<grid:GridViewDataColumn.Footer >
<StackPanel x:Name="YieldRevenue_StackPanel">
<TextBlock x:Name="YIELD_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY" />
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_September}" IsReadOnly="False" UniqueName="FY_September" HeaderTextAlignment="Center" DisplayIndex="28">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_September" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_October}" IsReadOnly="False" UniqueName="FY_October" HeaderTextAlignment="Center" DisplayIndex="29">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_October" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_November}" IsReadOnly="False" UniqueName="FY_November" HeaderTextAlignment="Center" DisplayIndex="30">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_November" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q1'}" HeaderTextAlignment="Center" UniqueName="FY_Q1" DisplayIndex="31">
<grid:GridViewDataColumn.Footer >
<StackPanel x:Name="FYQ1RevenueStackPanel">
<TextBlock x:Name="FYQ1_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_December}" IsReadOnly="False" UniqueName="FY_December" HeaderTextAlignment="Center" DisplayIndex="32">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_December" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_January}" IsReadOnly="False" UniqueName="FY_January" HeaderTextAlignment="Center" DisplayIndex="33">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_January" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_February}" IsReadOnly="False" UniqueName="FY_February" HeaderTextAlignment="Center" DisplayIndex="34">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_February" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q2'}" HeaderTextAlignment="Center" UniqueName="FY_Q2" DisplayIndex="35">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FYQ2RevenueStackPanel">
<TextBlock x:Name="FYQ2_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_March}" IsReadOnly="False" UniqueName="FY_March" HeaderTextAlignment="Center" DisplayIndex="36">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_March" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_April}" IsReadOnly="False" UniqueName="FY_April" HeaderTextAlignment="Center" DisplayIndex="37">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_April" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_May}" IsReadOnly="False" UniqueName="FY_May" HeaderTextAlignment="Center" DisplayIndex="38">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_May" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q3'}" HeaderTextAlignment="Center" UniqueName="FY_Q3" DisplayIndex="39">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FYQ3RevenueStackPanel">
<TextBlock x:Name="FYQ3_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_June}" IsReadOnly="False" UniqueName="FY_June" HeaderTextAlignment="Center" DisplayIndex="40">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_June" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_July}" IsReadOnly="False" UniqueName="FY_July" HeaderTextAlignment="Center" DisplayIndex="41">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_July" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_August}" IsReadOnly="False" UniqueName="FY_August" HeaderTextAlignment="Center" DisplayIndex="42">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_August" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q4'}" UniqueName="FY_Q4" HeaderTextAlignment="Center" DisplayIndex="43">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FYQ4RevenueStackPanel">
<TextBlock x:Name="FYQ4_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Total'}" HeaderTextAlignment="Center" UniqueName="FY_Total" DisplayIndex="44">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_Total_Revenue_StackPanel">
<TextBlock x:Name="FYTotal_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_September}" IsReadOnly="False" UniqueName="FY_1_September" HeaderTextAlignment="Center" DisplayIndex="45">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_September" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_October}" IsReadOnly="False" UniqueName="FY_1_October" HeaderTextAlignment="Center" DisplayIndex="46">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_October" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_November}" IsReadOnly="False" UniqueName="FY_1_November" HeaderTextAlignment="Center" DisplayIndex="47">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_November" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q1'}" UniqueName="FY_1_Q1" HeaderTextAlignment="Center" DisplayIndex="48">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q1RevenueStackPanel">
<TextBlock x:Name="FY_1_Q1_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_December}" IsReadOnly="False" UniqueName="FY_1_December" HeaderTextAlignment="Center" DisplayIndex="49">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_December" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_January}" IsReadOnly="False" UniqueName="FY_1_January" HeaderTextAlignment="Center" DisplayIndex="50">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_January" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_February}" IsReadOnly="False" UniqueName="FY_1_February" HeaderTextAlignment="Center" DisplayIndex="51">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_February" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q2'}" HeaderTextAlignment="Center" UniqueName="FY_1_Q2" DisplayIndex="52">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q2RevenueStackPanel">
<TextBlock x:Name="FY_1_Q2_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_March}" IsReadOnly="False" UniqueName="FY_1_March" HeaderTextAlignment="Center" DisplayIndex="53">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_March" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_April}" IsReadOnly="False" UniqueName="FY_1_April" HeaderTextAlignment="Center" DisplayIndex="54">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_April" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_May}" IsReadOnly="False" UniqueName="FY_1_May" HeaderTextAlignment="Center" DisplayIndex="55">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_May" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q3'}" HeaderTextAlignment="Center" UniqueName="FY_1_Q3" DisplayIndex="56">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q3RevenueStackPanel">
<TextBlock x:Name="FY_1_Q3_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_June}" IsReadOnly="False" UniqueName="FY_1_June" HeaderTextAlignment="Center" DisplayIndex="57">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_June" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_July}" IsReadOnly="False" UniqueName="FY_1_July" HeaderTextAlignment="Center" DisplayIndex="58">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_July" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_August}" IsReadOnly="False" UniqueName="FY_1_August" HeaderTextAlignment="Center" DisplayIndex="59">
<grid:GridViewDataColumn.AggregateFunctions>
<data:SumFunction Caption="Sum (In LCY): " SourceField="FY_1_August" ResultFormatString="{}{0:N}"/>
</grid:GridViewDataColumn.AggregateFunctions>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q4'}" HeaderTextAlignment="Center" UniqueName="FY_1_Q4" DisplayIndex="60">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q4RevenueStackPanel">
<TextBlock x:Name="FY_1_Q4_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Total'}" HeaderTextAlignment="Center" UniqueName="FY_1_Total" DisplayIndex="61">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_TotalRevenueStackPanel">
<TextBlock x:Name="FY_1_Total_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_September'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_September" DisplayIndex="62" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_SeptemberStackPanel">
<TextBlock x:Name="W_FY_September_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_October'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_October" DisplayIndex="63" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_OctoberStackPanel">
<TextBlock x:Name="W_FY_October_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_November'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_November" DisplayIndex="64" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_NovemberStackPanel">
<TextBlock x:Name="W_FY_November_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q1'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q1" DisplayIndex="65" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q1_StackPanel">
<TextBlock x:Name="W_FY_Q1_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_December'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_December" DisplayIndex="66" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_December_StackPanel">
<TextBlock x:Name="W_FY_December_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_January'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_January" DisplayIndex="67" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_January_StackPanel">
<TextBlock x:Name="W_FY_January_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_February'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_February" DisplayIndex="68" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_February_StackPanel">
<TextBlock x:Name="W_FY_February_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q2'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q2" DisplayIndex="69" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q2StackPanel">
<TextBlock x:Name="W_FY_Q2_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_March'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_March" DisplayIndex="70" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_MarchStackPanel">
<TextBlock x:Name="W_FY_March_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_April'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_April" DisplayIndex="71" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_AprilStackPanel">
<TextBlock x:Name="W_FY_April_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_May'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_May" DisplayIndex="72" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_MayStackPanel">
<TextBlock x:Name="W_FY_May_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q3'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q3" DisplayIndex="73" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q3StackPanel">
<TextBlock x:Name="W_FY_Q3_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_June'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_June" DisplayIndex="74" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_JuneStackPanel">
<TextBlock x:Name="W_FY_June_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_July'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_July" DisplayIndex="75" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_JulyStackPanel">
<TextBlock x:Name="W_FY_July_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_August'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_August" DisplayIndex="76" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_AugustStackPanel">
<TextBlock x:Name="W_FY_August_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q4'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q4" DisplayIndex="77" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q4StackPanel">
<TextBlock x:Name="W_FY_Q4_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Total'}" HeaderTextAlignment="Center" UniqueName="W_FY_Total" DisplayIndex="78" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_TotalStackPanel">
<TextBlock x:Name="W_FY_Total_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_September'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_September" DisplayIndex="79" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_SeptemberStackPanel">
<TextBlock x:Name="W_FY_1_September_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_October'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_October" DisplayIndex="80" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_OctoberStackPanel">
<TextBlock x:Name="W_FY_1_October_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_November'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_November" DisplayIndex="81" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_NovemberStackPanel">
<TextBlock x:Name="W_FY_1_November_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q1'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q1" DisplayIndex="82" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q1StackPanel">
<TextBlock x:Name="W_FY_1_Q1_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_December'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_December" DisplayIndex="83" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_DecemberStackPanel">
<TextBlock x:Name="W_FY_1_December_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_January'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_January" DisplayIndex="84" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_JanuaryStackPanel">
<TextBlock x:Name="W_FY_1_January_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_February'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_February" DisplayIndex="85" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_FebruaryStackPanel">
<TextBlock x:Name="W_FY_1_February_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q2'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q2" DisplayIndex="86" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q2StackPanel">
<TextBlock x:Name="W_FY_1_Q2_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_March'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_March" DisplayIndex="87" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_MarchStackPanel">
<TextBlock x:Name="W_FY_1_March_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_April'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_April" DisplayIndex="88" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_AprilStackPanel">
<TextBlock x:Name="W_FY_1_April_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_May'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_May" DisplayIndex="89" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_MayStackPanel">
<TextBlock x:Name="W_FY_1_May_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q3'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q3" DisplayIndex="90" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q3StackPanel">
<TextBlock x:Name="W_FY_1_Q3_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_June'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_June" DisplayIndex="91" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_JuneStackPanel">
<TextBlock x:Name="W_FY_1_June_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_July'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_July" DisplayIndex="92" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_JulyStackPanel">
<TextBlock x:Name="W_FY_1_July_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_August'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_August" DisplayIndex="93" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_AugustStackPanel">
<TextBlock x:Name="W_FY_1_August_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q4'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q4" DisplayIndex="94" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q4StackPanel">
<TextBlock x:Name="W_FY_1_Q4_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Total'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Total" DisplayIndex="95" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_TotalStackPanel">
<TextBlock x:Name="W_FY_1_Total_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Opportunity GUID" DataMemberBinding="{Binding OpportunityGUID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Account GUID" DataMemberBinding="{Binding AccountGUID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Forecast GUID" DataMemberBinding="{Binding ForecastGUID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<!--
<grid:GridViewDataColumn Header="FY September ID" DataMemberBinding="{Binding FY_September_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY October ID" DataMemberBinding="{Binding FY_October_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY November ID" DataMemberBinding="{Binding FY_November_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY December ID" DataMemberBinding="{Binding FY_December_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY January ID" DataMemberBinding="{Binding FY_January_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY February ID" DataMemberBinding="{Binding FY_February_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY March ID" DataMemberBinding="{Binding FY_March_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY April ID" DataMemberBinding="{Binding FY_April_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY May ID" DataMemberBinding="{Binding FY_May_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY June ID" DataMemberBinding="{Binding FY_June_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY July ID" DataMemberBinding="{Binding FY_July_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY August ID" DataMemberBinding="{Binding FY_August_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 September ID" DataMemberBinding="{Binding FY_1_September_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 October ID" DataMemberBinding="{Binding FY_1_October_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 November ID" DataMemberBinding="{Binding FY_1_November_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 December ID" DataMemberBinding="{Binding FY_1_December_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 January ID" DataMemberBinding="{Binding FY_1_January_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 February ID" DataMemberBinding="{Binding FY_1_February_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 March ID" DataMemberBinding="{Binding FY_1_March_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 April ID" DataMemberBinding="{Binding FY_1_April_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 May ID" DataMemberBinding="{Binding FY_1_May_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 June ID" DataMemberBinding="{Binding FY_1_June_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 July ID" DataMemberBinding="{Binding FY_1_July_ID}" IsReadOnly="True" IsVisible="False"></grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY 1 August ID" DataMemberBinding="{Binding FY_1_August_ID}" IsReadOnly="True" IsVisible="False"></grid:GridViewDataColumn>
-->
<grid:GridViewDataColumn Header="Sales Revenue (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='SALES_REVENUE_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="SALES_REVENUE_BASE" DisplayIndex="96">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="SALES_REVENUE_BASE_StackPanel">
<TextBlock x:Name="SALES_REVENUE_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="Yield Revenue (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='YIELD_REVENUE_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="YIELD_REVENUE_BASE" DisplayIndex="97">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="YIELD_REVENUE_BASE_StackPanel">
<TextBlock x:Name="YIELD_REVENUE_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY September (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_September_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_September_BASE" DisplayIndex="98">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_September_BASE_StackPanel">
<TextBlock x:Name="FY_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY October (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_October_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_October_BASE" DisplayIndex="99">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_October_BASE_StackPanel">
<TextBlock x:Name="FY_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY November (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_November_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_November_BASE" DisplayIndex="100">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_November_BASE_StackPanel">
<TextBlock x:Name="FY_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q1_BASE'}" IsVisible="False" HeaderTextAlignment="Center" UniqueName="FY_Q1_BASE" DisplayIndex="101">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_Q1_BASE_StackPanel">
<TextBlock x:Name="FY_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY December (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_December_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_December_BASE" DisplayIndex="102">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_December_BASE_StackPanel">
<TextBlock x:Name="FY_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY January (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_January_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_January_BASE" DisplayIndex="103">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_January_BASEStackPanel">
<TextBlock x:Name="FY_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY February (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_February_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_February_BASE" DisplayIndex="104">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_February_BASEStackPanel">
<TextBlock x:Name="FY_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q2_BASE'}" IsVisible="False" HeaderTextAlignment="Center" UniqueName="FY_Q2_BASE" DisplayIndex="105">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_Q2_BASEStackPanel">
<TextBlock x:Name="FY_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY March (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_March_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_March_BASE" DisplayIndex="106">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_March_BASEStackPanel">
<TextBlock x:Name="FY_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY April (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_April_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_April_BASE" DisplayIndex="107">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_April_BASEStackPanel">
<TextBlock x:Name="FY_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY May (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_May_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_May_BASE" DisplayIndex="108">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_May_BASEStackPanel">
<TextBlock x:Name="FY_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_Q3_BASE" DisplayIndex="109">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_Q3_BASEStackPanel">
<TextBlock x:Name="FY_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY June (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_June_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_June_BASE" DisplayIndex="110">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_June_BASEStackPanel">
<TextBlock x:Name="FY_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY July (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_July_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_July_BASE" DisplayIndex="111">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_July_BASEStackPanel">
<TextBlock x:Name="FY_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY August (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_August_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_August_BASE" DisplayIndex="112">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_August_BASEStackPanel">
<TextBlock x:Name="FY_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q4_BASE'}" UniqueName="FY_Q4_BASE" IsVisible="False" HeaderTextAlignment="Center" DisplayIndex="113">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_Q4_BASEStackPanel">
<TextBlock x:Name="FY_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="FY Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_Total_BASE" DisplayIndex="114">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_Total_BASEStackPanel">
<TextBlock x:Name="FY_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) September (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_September_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_September_BASE" DisplayIndex="115">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_September_BASEStackPanel">
<TextBlock x:Name="FY_1_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) October (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_October_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_October_BASE" DisplayIndex="116">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_October_BASEStackPanel">
<TextBlock x:Name="FY_1_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) November (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_November_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_November_BASE" DisplayIndex="117">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_November_BASEStackPanel">
<TextBlock x:Name="FY_1_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q1_BASE'}" UniqueName="FY_1_Q1_BASE" IsVisible="False" HeaderTextAlignment="Center" DisplayIndex="118">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q1_BASEStackPanel">
<TextBlock x:Name="FY_1_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) December (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_December_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_December_BASE" DisplayIndex="119">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_December_BASEStackPanel">
<TextBlock x:Name="FY_1_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) January (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_January_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_January_BASE" DisplayIndex="120">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_January_BASEStackPanel">
<TextBlock x:Name="FY_1_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) February (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_February_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_February_BASE" DisplayIndex="121">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_February_BASEStackPanel">
<TextBlock x:Name="FY_1_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q2_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Q2_BASE" DisplayIndex="122">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q2_BASEStackPanel">
<TextBlock x:Name="FY_1_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) March (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_March_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_March_BASE" DisplayIndex="123">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_March_BASEStackPanel">
<TextBlock x:Name="FY_1_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) April (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_April_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_April_BASE" DisplayIndex="124">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_April_BASEStackPanel">
<TextBlock x:Name="FY_1_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) May (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_May_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_May_BASE" DisplayIndex="125">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_May_BASEStackPanel">
<TextBlock x:Name="FY_1_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Q3_BASE" DisplayIndex="126">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q3_BASEStackPanel">
<TextBlock x:Name="FY_1_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) June (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_June_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_June_BASE" DisplayIndex="127">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_June_BASEStackPanel">
<TextBlock x:Name="FY_1_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) July (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_July_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_July_BASE" DisplayIndex="128">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_July_BASE_StackPanel">
<TextBlock x:Name="FY_1_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) August (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_August_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_August_BASE" DisplayIndex="129">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_August_BASE_StackPanel">
<TextBlock x:Name="FY_1_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q4_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Q4_BASE" DisplayIndex="130">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Q4_BASEStackPanel">
<TextBlock x:Name="FY_1_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="(FY+1) Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Total_BASE" DisplayIndex="131">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="FY_1_Total_BASEStackPanel">
<TextBlock x:Name="FY_1_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-SEP (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_September_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_September_BASE" DisplayIndex="132" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_September_BASE_StackPanel">
<TextBlock x:Name="W_FY_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-OCT (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_October_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_October_BASE" DisplayIndex="133" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_October_BASE_StackPanel">
<TextBlock x:Name="W_FY_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-NOV (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_November_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_November_BASE" DisplayIndex="134" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_November_BASE_StackPanel">
<TextBlock x:Name="W_FY_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q1_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q1_BASE" DisplayIndex="135" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q1_BASE_StackPanel">
<TextBlock x:Name="W_FY_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-DEC (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_December_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_December_BASE" DisplayIndex="136" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_December_BASE_StackPanel">
<TextBlock x:Name="W_FY_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-JAN (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_January_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_January_BASE" DisplayIndex="137" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_January_BASE_StackPanel">
<TextBlock x:Name="W_FY_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-FEB (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_February_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_February_BASE" DisplayIndex="138" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_February_BASE_StackPanel">
<TextBlock x:Name="W_FY_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q2_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q2_BASE" DisplayIndex="139" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q2_BASE_StackPanel">
<TextBlock x:Name="W_FY_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-MAR (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_March_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_March_BASE" DisplayIndex="140" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_March_BASE_StackPanel">
<TextBlock x:Name="W_FY_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-APR (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_April_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_April_BASE" DisplayIndex="141" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_April_BASE_StackPanel">
<TextBlock x:Name="W_FY_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-MAY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_May_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_May_BASE" DisplayIndex="142" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_May_BASE_StackPanel">
<TextBlock x:Name="W_FY_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q3_BASE" DisplayIndex="143" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q3_BASE_StackPanel">
<TextBlock x:Name="W_FY_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-JUNE (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_June_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_June_BASE" DisplayIndex="144" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_June_BASE_StackPanel">
<TextBlock x:Name="W_FY_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-JULY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_July_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_July_BASE" DisplayIndex="145" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_July_BASE_StackPanel">
<TextBlock x:Name="W_FY_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-AUG (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_August_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_August_BASE" DisplayIndex="146" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_August_BASE_StackPanel">
<TextBlock x:Name="W_FY_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q4_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q4_BASE" DisplayIndex="147" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Q4_BASE_StackPanel">
<TextBlock x:Name="W_FY_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED FY-Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Total_BASE" DisplayIndex="148" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_Total_BASE_StackPanel">
<TextBlock x:Name="W_FY_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-SEP (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_September_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_September_BASE" DisplayIndex="149" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_September_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-OCT (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_October_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_October_BASE" DisplayIndex="150" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_October_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-NOV (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_November_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_November_BASE" DisplayIndex="151" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_November_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q1_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q1_BASE" DisplayIndex="152" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q1_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-DEC (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_December_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_December_BASE" DisplayIndex="153" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_December_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-JAN (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_January_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_January_BASE" DisplayIndex="154" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_January_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-FEB (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_February_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_February_BASE" DisplayIndex="155" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_February_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q2_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q2_BASE" DisplayIndex="156" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q2_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-MAR (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_March_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_March_BASE" DisplayIndex="157" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_March_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-APR (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_April_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_April_BASE" DisplayIndex="158" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_April_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-MAY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_May_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_May_BASE" DisplayIndex="159" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_May_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q3_BASE" DisplayIndex="160" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q3_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-JUNE (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_June_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_June_BASE" DisplayIndex="161" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_June_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-JULY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_July_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_July_BASE" DisplayIndex="162" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_July_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-AUG (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_August_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_August_BASE" DisplayIndex="163" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_August_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q4_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q4_BASE" DisplayIndex="164" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Q4_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
<grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Total_BASE" DisplayIndex="165" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">
<grid:GridViewDataColumn.Footer>
<StackPanel x:Name="W_FY_1_Total_BASE_StackPanel">
<TextBlock x:Name="W_FY_1_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>
</StackPanel>
</grid:GridViewDataColumn.Footer>
</grid:GridViewDataColumn>
</grid:RadGridView.Columns>
</grid:RadGridView>
<!--
<ListBox ItemsSource="{Binding Columns, ElementName=radGridView}" Width="220" HorizontalAlignment="Left" Margin="-2,82,0,34">
<ListBox.ItemTemplate>
<DataTemplate>
<CheckBox Content="{Binding Header}" IsChecked="{Binding IsVisible, Mode=TwoWay}" />
</DataTemplate>
</ListBox.ItemTemplate>
</ListBox>
<ScrollBar Height="607" HorizontalAlignment="Left" Margin="243,82,0,0" Name="scrollBar2" VerticalAlignment="Top" Width="17" ValueChanged="scrollBar1_ValueChanged" />
-->
</Grid>
</ScrollViewer>
</UserControl>
=================================================== XAML PAGE CODE BEHIND================================
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Net.NetworkInformation;
using System.ServiceModel;
using System.Threading;
using System.Windows;
using System.Windows.Browser;
using System.Windows.Controls;
using System.Windows.Controls.Primitives;
using System.Windows.Data;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Threading;
using System.Data.Services.Client;
using Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService;
using Telerik.Windows.Controls;
using Telerik.Windows.Controls.GridView;
using Telerik.Windows.Data;
using System.Text.RegularExpressions;
namespace Avanade.Crm.Sam.RPT
{
[ScriptableType]
public partial class MainPage : UserControl
{
private RevenueProjectionToolServiceClient CommService { get; set; }
int InitialPageSize = 50;
int InitialStartingRow = 0;
int PageSize = 50;
int StartingRow = 0;
int CurrentYear = System.DateTime.Now.Year;
int CurrentMonth = System.DateTime.Now.Month;
int CurrentDay = System.DateTime.Now.Day;
Stack<GridViewRow> EditedRowData = new Stack<GridViewRow>();
string[] EditableColumnUniqueNames = { "FY_September","FY_October","FY_November","FY_December","FY_January","FY_February","FY_March","FY_April","FY_May","FY_June","FY_July","FY_August","FY_1_September","FY_1_October","FY_1_November","FY_1_December","FY_1_January","FY_1_February","FY_1_March","FY_1_April","FY_1_May","FY_1_June","FY_1_July","FY_1_August","SALES_REVENUE", "EffortDays"};
List<string> RegionNames = new List<string>();
IGroupDescriptor[] IGrpDescArr;
string SERVER_NAME;
GetRevenueProjection_Result[] RPTDataArray;
public MainPage()
{
InitializeComponent();
this.CommService = new RevenueProjectionToolServiceClient();
Loaded += new RoutedEventHandler(Page_Loaded);
HtmlPage.RegisterScriptableObject("Page", this);
}
public void Page_Loaded(object sender, RoutedEventArgs e)
{
try
{
RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient ws = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();
ws.GetRevenueProjectionFilterDataCompleted += new EventHandler<GetRevenueProjectionFilterDataCompletedEventArgs>(ws_GetRevenueProjectionFilterDataCompleted);
ws.GetRevenueProjectionFilterDataAsync();
ws.GetSystemInformationCompleted += new EventHandler<GetSystemInformationCompletedEventArgs>(ws_GetSystemInformationCompleted);
ws.GetSystemInformationAsync();
}
catch (Exception Excep)
{
MessageBox.Show(Excep.InnerException + Excep.Message + Excep.StackTrace.ToString());
}
}
public void ws_GetSystemInformationCompleted(object sender, Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetSystemInformationCompletedEventArgs e)
{
SERVER_NAME = e.Result.ToString();
}
public void ws_GetRevenueProjectionFilterDataCompleted(object sender, Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjectionFilterDataCompletedEventArgs e)
{
var accquery = (from p in e.Result select p.Account).Distinct();
this.AccountAutoCompleteBox.ItemsSource = accquery.ToArray();
this.AccountAutoCompleteBox.PopulateComplete();
var bdownerquery = (from p in e.Result select p.BDOwner).Distinct();
this.BDOwnerAutoCompleteBox.ItemsSource = bdownerquery.ToArray();
this.BDOwnerAutoCompleteBox.PopulateComplete();
var regionquery = (from p in e.Result select p.Region).Distinct();
this.radRegion2ComboBox.ItemsSource = regionquery.ToArray();
}
public void ws_RevenueProjectionToolDataPageWiseCompleted(object sender, Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjectionToolDataPageWiseCompletedEventArgs e)
{
try
{
RPTDataArray = new GetRevenueProjection_Result[e.Result.ToArray().Length];
radGridView.Visibility = Visibility.Visible;
ToolUtilities.GenerateReportHeaders(radGridView);
ToolUtilities DataList = new ToolUtilities();
RPTDataArray = DataList.CalculateRevenueSpread(e.Result.ToArray());
this.radGridView.ItemsSource = RPTDataArray;
decimal[] CalculatedColumnFooterTotals = CalculatedColumnsFooterTotals.CalculateTotalsForCalculatedColumns(RPTDataArray);
System.Windows.Controls.UIElementCollection oyieldRev = ((System.Windows.Controls.Panel)(this.radGridView.Columns["YIELD_REVENUE"].Footer)).Children;
UIElement[] oyieldRevArr = oyieldRev.ToArray();
((System.Windows.Controls.TextBlock)(oyieldRevArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[0],2).ToString();
System.Windows.Controls.UIElementCollection oFYQ1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q1"].Footer)).Children;
UIElement[] oFYQ1Arr = oFYQ1.ToArray();
((System.Windows.Controls.TextBlock)(oFYQ1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[1], 2).ToString();
System.Windows.Controls.UIElementCollection oFYQ2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q2"].Footer)).Children;
UIElement[] oFYQ2Arr = oFYQ2.ToArray();
((System.Windows.Controls.TextBlock)(oFYQ2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[2], 2).ToString();
System.Windows.Controls.UIElementCollection oFYQ3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q3"].Footer)).Children;
UIElement[] oFYQ3Arr = oFYQ3.ToArray();
((System.Windows.Controls.TextBlock)(oFYQ3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[3], 2).ToString();
System.Windows.Controls.UIElementCollection oFYQ4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q4"].Footer)).Children;
UIElement[] oFYQ4Arr = oFYQ4.ToArray();
((System.Windows.Controls.TextBlock)(oFYQ4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[4], 2).ToString();
System.Windows.Controls.UIElementCollection oFYTotal = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Total"].Footer)).Children;
UIElement[] oFYTotalArr = oFYTotal.ToArray();
((System.Windows.Controls.TextBlock)(oFYTotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[5], 2).ToString();
System.Windows.Controls.UIElementCollection oFY_1_Q1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q1"].Footer)).Children;
UIElement[] oFY_1_Q1Arr = oFY_1_Q1.ToArray();
((System.Windows.Controls.TextBlock)(oFY_1_Q1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[6], 2).ToString();
System.Windows.Controls.UIElementCollection oFY_1_Q2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q2"].Footer)).Children;
UIElement[] oFY_1_Q2Arr = oFY_1_Q2.ToArray();
((System.Windows.Controls.TextBlock)(oFY_1_Q2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[7], 2).ToString();
System.Windows.Controls.UIElementCollection oFY_1_Q3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q3"].Footer)).Children;
UIElement[] oFY_1_Q3Arr = oFY_1_Q3.ToArray();
((System.Windows.Controls.TextBlock)(oFY_1_Q3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[8], 2).ToString();
System.Windows.Controls.UIElementCollection oFY_1_Q4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q4"].Footer)).Children;
UIElement[] oFY_1_Q4Arr = oFY_1_Q4.ToArray();
((System.Windows.Controls.TextBlock)(oFY_1_Q4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[9], 2).ToString();
System.Windows.Controls.UIElementCollection oFY_1_Total = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Total"].Footer)).Children;
UIElement[] oFY_1_TotalArr = oFY_1_Total.ToArray();
((System.Windows.Controls.TextBlock)(oFY_1_TotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[10], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Sep = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_September"].Footer)).Children;
UIElement[] oW_FY_SepArr = oW_FY_Sep.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_SepArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[11], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Oct = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_October"].Footer)).Children;
UIElement[] oW_FY_OctArr = oW_FY_Oct.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_OctArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[12], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Nov = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_November"].Footer)).Children;
UIElement[] oW_FY_NovArr = oW_FY_Nov.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_NovArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[13], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Q1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q1"].Footer)).Children;
UIElement[] oW_FY_Q1Arr = oW_FY_Q1.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_Q1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[14], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Dec = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_December"].Footer)).Children;
UIElement[] oW_FY_DecArr = oW_FY_Dec.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_DecArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[15], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Jan = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_January"].Footer)).Children;
UIElement[] oW_FY_JanArr = oW_FY_Jan.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_JanArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[16], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Feb = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_February"].Footer)).Children;
UIElement[] oW_FY_FebArr = oW_FY_Feb.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_FebArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[17], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Q2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q2"].Footer)).Children;
UIElement[] oW_FY_Q2Arr = oW_FY_Q2.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_Q2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[18], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Mar = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_March"].Footer)).Children;
UIElement[] oW_FY_MarArr = oW_FY_Mar.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_MarArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[19], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Apr = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_April"].Footer)).Children;
UIElement[] oW_FY_AprArr = oW_FY_Apr.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_AprArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[20], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_May = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_May"].Footer)).Children;
UIElement[] oW_FY_MayArr = oW_FY_May.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_MayArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[21], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Q3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q3"].Footer)).Children;
UIElement[] oW_FY_Q3Arr = oW_FY_Q3.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_Q3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[22], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_June = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_June"].Footer)).Children;
UIElement[] oW_FY_JuneArr = oW_FY_June.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_JuneArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[23], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_July = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_July"].Footer)).Children;
UIElement[] oW_FY_JulyArr = oW_FY_July.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_JulyArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[24], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Aug = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_August"].Footer)).Children;
UIElement[] oW_FY_AugArr = oW_FY_Aug.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_AugArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[25], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Q4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q4"].Footer)).Children;
UIElement[] oW_FY_Q4Arr = oW_FY_Q4.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_Q4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[26], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_Total = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Total"].Footer)).Children;
UIElement[] oW_FY_TotalArr = oW_FY_Total.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_TotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[27], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Sep = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_September"].Footer)).Children;
UIElement[] oW_FY_1_SepArr = oW_FY_1_Sep.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_SepArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[28], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Oct = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_October"].Footer)).Children;
UIElement[] oW_FY_1_OctArr = oW_FY_1_Oct.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_OctArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[29], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Nov = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_November"].Footer)).Children;
UIElement[] oW_FY_1_NovArr = oW_FY_1_Nov.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_NovArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[30], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Q1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q1"].Footer)).Children;
UIElement[] oW_FY_1_Q1Arr = oW_FY_1_Q1.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_Q1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[31], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Dec = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_December"].Footer)).Children;
UIElement[] oW_FY_1_DecArr = oW_FY_1_Dec.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_DecArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[32], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Jan = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_January"].Footer)).Children;
UIElement[] oW_FY_1_JanArr = oW_FY_1_Jan.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_JanArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[33], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Feb = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_February"].Footer)).Children;
UIElement[] oW_FY_1_FebArr = oW_FY_1_Feb.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_FebArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[34], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Q2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q2"].Footer)).Children;
UIElement[] oW_FY_1_Q2Arr = oW_FY_1_Q2.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_Q2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[35], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Mar = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_March"].Footer)).Children;
UIElement[] oW_FY_1_MarArr = oW_FY_1_Mar.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_MarArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[36], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Apr = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_April"].Footer)).Children;
UIElement[] oW_FY_1_AprArr = oW_FY_1_Apr.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_AprArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[37], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_May = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_May"].Footer)).Children;
UIElement[] oW_FY_1_MayArr = oW_FY_1_May.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_MayArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[38], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Q3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q3"].Footer)).Children;
UIElement[] oW_FY_1_Q3Arr = oW_FY_1_Q3.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_Q3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[39], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_June = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_June"].Footer)).Children;
UIElement[] oW_FY_1_JuneArr = oW_FY_1_June.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_JuneArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[40], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_July = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_July"].Footer)).Children;
UIElement[] oW_FY_1_JulyArr = oW_FY_1_July.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_JulyArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[41], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Aug = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_August"].Footer)).Children;
UIElement[] oW_FY_1_AugArr = oW_FY_1_Aug.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_AugArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[42], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Q4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q4"].Footer)).Children;
UIElement[] oW_FY_1_Q4Arr = oW_FY_1_Q4.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_Q4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[43], 2).ToString();
System.Windows.Controls.UIElementCollection oW_FY_1_Total = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Total"].Footer)).Children;
UIElement[] oW_FY_1_TotalArr = oW_FY_1_Total.ToArray();
((System.Windows.Controls.TextBlock)(oW_FY_1_TotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[44], 2).ToString();
ShowDataButton.IsEnabled = true;
GroupRevenueBySalesStage GrpBySalesStage = new GroupRevenueBySalesStage();
GrpBySalesStage.ShowRevenueBySalesStageGroupingLCY(radGridView);
IGrpDescArr = this.radGridView.GroupDescriptors.ToArray();
//In Dev environments replace SERVER_NAME with SERVER_NAME + ":5555"
// Need To replace http with https for production
GridViewColumn OppColumn = this.radGridView.Columns["OpportunityName"];
((Telerik.Windows.Controls.GridViewDynamicHyperlinkColumn)(OppColumn)).NavigateUrlFormatString = " http://" + SERVER_NAME + "/Avanade/sfa/opps/RBUIedit.aspx?id={0}";
GridViewColumn AccColumn = this.radGridView.Columns["Account"];
((Telerik.Windows.Controls.GridViewDynamicHyperlinkColumn)(AccColumn)).NavigateUrlFormatString = " http://" + SERVER_NAME + "/Avanade/sfa/accts/RBUIedit.aspx?id={0}";
}
catch (Exception Excep)
{
MessageBox.Show(Excep.InnerException.StackTrace.ToString() + Excep.Message.ToString());
}
}
/*
private void radGridView_RowEditEnded(object sender, GridViewRowEditEndedEventArgs e)
{
try
{
if (e.EditAction == GridViewEditAction.Cancel)
{
return;
}
if (e.EditOperationType == GridViewEditOperationType.Edit)
{
EditedRowData.Push(e.Row);
}
}
catch (Exception Excep)
{
MessageBox.Show(Excep.Message.ToString() + " " + Excep.StackTrace.ToString());
}
}
private void radGridView_CellEditEnded(object sender, GridViewCellEditEndedEventArgs e)
{
try
{
decimal Weighted_FY_Sep = 0, Weighted_FY_Oct = 0, Weighted_FY_Nov = 0, Weighted_FY_Dec = 0, Weighted_FY_Jan = 0, Weighted_FY_Feb = 0, Weighted_FY_Mar = 0, Weighted_FY_April = 0, Weighted_FY_May = 0, Weighted_FY_June = 0, Weighted_FY_July = 0, Weighted_FY_Aug = 0, Weighted_FY_1_Sep = 0, Weighted_FY_1_Oct = 0, Weighted_FY_1_Nov = 0, Weighted_FY_1_Dec = 0, Weighted_FY_1_Jan = 0, Weighted_FY_1_Feb = 0, Weighted_FY_1_Mar = 0, Weighted_FY_1_Apr = 0, Weighted_FY_1_May = 0, Weighted_FY_1_June = 0, Weighted_FY_1_July = 0, Weighted_FY_1_Aug = 0;
decimal _FY_Sep = 0, _FY_Oct = 0, _FY_Nov = 0, _FY_Dec = 0, _FY_Jan = 0, _FY_Feb = 0, _FY_Mar = 0, _FY_April = 0, _FY_May = 0, _FY_June = 0, _FY_July = 0, _FY_Aug = 0, _FY_1_Sep = 0, _FY_1_Oct = 0, _FY_1_Nov = 0, _FY_1_Dec = 0, _FY_1_Jan = 0, _FY_1_Feb = 0, _FY_1_Mar = 0, _FY_1_Apr = 0, _FY_1_May = 0, _FY_1_June = 0, _FY_1_July = 0, _FY_1_Aug = 0;
for (int p = 0; p < EditableColumnUniqueNames.Length; p++)
{
if (e.Cell.Column.UniqueName == EditableColumnUniqueNames[p])
{
e.Cell.Background = new SolidColorBrush(Colors.Green);
break;
}
}
int Probability = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(e.Cell.ParentRow.GridViewDataControl.CurrentCellInfo.Item)).Probability.Value;
// Reflect totaling changes in the following types of columns when the data in the Forecast Revenue Columns Change:
// 1. Weighted Revenue
// 2. Q1/Q2/Q3/Q4
// 3. Weighted Q1/Q2/Q3/Q4
// 4. Total
// 5. Weighted Total
// 6. Yield Revenue
if (e.Cell.Column.UniqueName == "SALES_REVENUE")
{
//e.Cell.ParentRow.Cells[e.Cell.Column.DisplayIndex].Content = e.NewData.ToString();
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "YIELD_REVENUE")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "YIELD_REVENUE")].Content)).Text = (Convert.ToDecimal(e.NewData) * Probability / (100)).ToString();
}
}
if ((e.Cell.Column.UniqueName == "FY_September") || (e.Cell.Column.UniqueName == "FY_October") || (e.Cell.Column.UniqueName == "FY_November"))
{
if (e.Cell.Column.UniqueName == "FY_September")
{
_FY_Sep = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content = Weighted_FY_Sep = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q1")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q1")].Content = _FY_Sep + _FY_Oct + _FY_Nov;
}
else if (e.Cell.Column.UniqueName == "FY_October")
{
_FY_Oct = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content = Weighted_FY_Oct = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q1")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q1")].Content = _FY_Sep + _FY_Oct + _FY_Nov;
}
else if (e.Cell.Column.UniqueName == "FY_November")
{
_FY_Nov = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content = Weighted_FY_Nov = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q1")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q1")].Content = _FY_Sep + _FY_Oct + _FY_Nov;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_December") || (e.Cell.Column.UniqueName == "FY_January") || (e.Cell.Column.UniqueName == "FY_February"))
{
if (e.Cell.Column.UniqueName == "FY_December")
{
_FY_Dec = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content = Weighted_FY_Dec = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q2")].Content = Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q2")].Content = _FY_Dec + _FY_Jan + _FY_Feb;
}
else if (e.Cell.Column.UniqueName == "FY_January")
{
_FY_Jan = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content = Weighted_FY_Jan = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q2")].Content = Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q2")].Content = _FY_Dec + _FY_Jan + _FY_Feb;
}
else if (e.Cell.Column.UniqueName == "FY_February")
{
_FY_Feb = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content = Weighted_FY_Feb = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q2")].Content = Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q2")].Content = _FY_Dec + _FY_Jan + _FY_Feb;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_March") || (e.Cell.Column.UniqueName == "FY_April") || (e.Cell.Column.UniqueName == "FY_May"))
{
if (e.Cell.Column.UniqueName == "FY_March")
{
_FY_Mar = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content = Weighted_FY_Mar = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q3")].Content = Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q3")].Content = _FY_Mar + _FY_April + _FY_May;
}
else if (e.Cell.Column.UniqueName == "FY_April")
{
_FY_April = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content = Weighted_FY_April = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q3")].Content = Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q3")].Content = _FY_Mar + _FY_April + _FY_May;
}
else if (e.Cell.Column.UniqueName == "FY_May")
{
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
}
_FY_May = Convert.ToDecimal(e.NewData);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content = Weighted_FY_May = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q3")].Content = Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q3")].Content = _FY_Mar + _FY_April + _FY_May;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_June") || (e.Cell.Column.UniqueName == "FY_July") || (e.Cell.Column.UniqueName == "FY_August"))
{
if (e.Cell.Column.UniqueName == "FY_June")
{
_FY_June = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content = Weighted_FY_June = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q4")].Content = Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q4")].Content = _FY_June + _FY_July + _FY_Aug;
}
else if (e.Cell.Column.UniqueName == "FY_July")
{
_FY_July = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content = Weighted_FY_July = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q4")].Content = Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q4")].Content = _FY_June + _FY_July + _FY_Aug;
}
else if (e.Cell.Column.UniqueName == "FY_August")
{
_FY_Aug = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content = Weighted_FY_Aug = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q4")].Content = Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q4")].Content = _FY_June + _FY_July + _FY_Aug;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_1_September") || (e.Cell.Column.UniqueName == "FY_1_October") || (e.Cell.Column.UniqueName == "FY_1_November"))
{
if (e.Cell.Column.UniqueName == "FY_1_September")
{
_FY_1_Sep = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content = Weighted_FY_1_Sep = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q1")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q1")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov;
}
else if (e.Cell.Column.UniqueName == "FY_1_October")
{
_FY_1_Oct = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content = Weighted_FY_1_Oct = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q1")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q1")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov;
}
else if (e.Cell.Column.UniqueName == "FY_1_November")
{
_FY_1_Nov = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content = Weighted_FY_1_Nov = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q1")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q1")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_1_December") || (e.Cell.Column.UniqueName == "FY_1_January") || (e.Cell.Column.UniqueName == "FY_1_February"))
{
if (e.Cell.Column.UniqueName == "FY_1_December")
{
_FY_1_Dec = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content = Weighted_FY_1_Dec = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q2")].Content = Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q2")].Content = _FY_1_Dec + _FY_1_Jan + _FY_1_Feb;
}
else if (e.Cell.Column.UniqueName == "FY_1_January")
{
_FY_1_Jan = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content = Weighted_FY_1_Jan = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q2")].Content = Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q2")].Content = _FY_1_Dec + _FY_1_Jan + _FY_1_Feb;
}
else if (e.Cell.Column.UniqueName == "FY_1_February")
{
_FY_1_Feb = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content = Weighted_FY_1_Feb = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q2")].Content = Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q2")].Content = _FY_1_Dec + _FY_1_Jan + _FY_1_Feb;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_1_March") || (e.Cell.Column.UniqueName == "FY_1_April") || (e.Cell.Column.UniqueName == "FY_1_May"))
{
if (e.Cell.Column.UniqueName == "FY_1_March")
{
_FY_1_Mar = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content = Weighted_FY_1_Mar = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q3")].Content = Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q3")].Content = _FY_1_Mar + _FY_1_Apr + _FY_1_May;
}
else if (e.Cell.Column.UniqueName == "FY_1_April")
{
_FY_1_Apr = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content = Weighted_FY_1_Apr = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q3")].Content = Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q3")].Content = _FY_1_Mar + _FY_1_Apr + _FY_1_May;
}
else if (e.Cell.Column.UniqueName == "FY_1_May")
{
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
}
_FY_1_May = Convert.ToDecimal(e.NewData);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content = Weighted_FY_1_May = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q3")].Content = Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q3")].Content = _FY_1_Mar + _FY_1_Apr + _FY_1_May;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
}
else if ((e.Cell.Column.UniqueName == "FY_1_June") || (e.Cell.Column.UniqueName == "FY_1_July") || (e.Cell.Column.UniqueName == "FY_1_August"))
{
if (e.Cell.Column.UniqueName == "FY_1_June")
{
_FY_1_June = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content = Weighted_FY_1_June = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q4")].Content = Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q4")].Content = _FY_1_June + _FY_1_July + _FY_1_Aug;
}
else if (e.Cell.Column.UniqueName == "FY_1_July")
{
_FY_1_July = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content = Weighted_FY_1_July = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q4")].Content = Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q4")].Content = _FY_1_June + _FY_1_July + _FY_1_Aug;
}
else if (e.Cell.Column.UniqueName == "FY_1_August")
{
_FY_1_Aug = Convert.ToDecimal(e.NewData);
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content = Weighted_FY_1_Aug = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q4")].Content = Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q4")].Content = _FY_1_June + _FY_1_July + _FY_1_Aug; ;
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
}
if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
{
Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
}
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;
e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message.ToString());
}
}
*/
/*
private void UpdateRow_Click(object sender, RoutedEventArgs e)
{
SaveButton.IsEnabled = false;
RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient WcfSvc = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();
string oppId = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).OpportunityGUID.Value.ToString();
string RevType = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).REVENUE_TYPE;
decimal RevAmt = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).SALES_REVENUE.Value;
long EffortDays = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).EffortDays.Value;
string EstimatedPrjStDt = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).EstimatedProjStDt.Value.ToString("o").Replace('-', '/');
string oppName = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).OpportunityName;
string forecastId = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).ForecastGUID.Value.ToString();
int Duration = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).Duration.Value;
int Revenue_Type_N = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).REVENUE_TYPE_N.Value;
WcfSvc.UpdateOpportunityInCRMAsync(oppId, RevType, RevAmt, EffortDays, EstimatedPrjStDt);
decimal fy_sep = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_September.Value;
if (fy_sep > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "September";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "September";
}
string fy_sep_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_September_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_sep, Forecast_Detail_Record_Name, Duration, RevAmt, fy_sep_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_oct = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_October.Value;
if (fy_oct > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "October";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "October";
}
string fy_oct_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_October_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_sep, Forecast_Detail_Record_Name, Duration, RevAmt, fy_oct_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_nov = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_November.Value;
if (fy_nov > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "November";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "November";
}
string fy_nov_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_November_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_nov, Forecast_Detail_Record_Name, Duration, RevAmt, fy_nov_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_dec = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_December.Value;
if (fy_dec > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "December";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "December";
}
string fy_dec_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_December_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_dec, Forecast_Detail_Record_Name, Duration, RevAmt, fy_dec_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_jan = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_January.Value;
if (fy_jan > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "January";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "January";
}
string fy_jan_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_January_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_jan, Forecast_Detail_Record_Name, Duration, RevAmt, fy_jan_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_feb = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_February.Value;
if (fy_feb > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "February";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "February";
}
string fy_feb_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_February_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_feb, Forecast_Detail_Record_Name, Duration, RevAmt, fy_feb_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_mar = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_March.Value;
if (fy_mar > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "March";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "March";
}
string fy_mar_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_March_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_mar, Forecast_Detail_Record_Name, Duration, RevAmt, fy_mar_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_apr = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_April.Value;
if (fy_apr > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "April";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "April";
}
string fy_apr_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_April_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_apr, Forecast_Detail_Record_Name, Duration, RevAmt, fy_apr_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_may = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_May.Value;
if (fy_may > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "May";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "May";
}
string fy_may_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_May_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_may, Forecast_Detail_Record_Name, Duration, RevAmt, fy_may_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_june = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_June.Value;
if (fy_june > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "June";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "June";
}
string fy_june_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_June_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_june, Forecast_Detail_Record_Name, Duration, RevAmt, fy_june_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_July = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_July.Value;
if (fy_July > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "July";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "July";
}
string fy_july_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_July_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_July, Forecast_Detail_Record_Name, Duration, RevAmt, fy_july_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_aug = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_August.Value;
if (fy_aug > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "August";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "August";
}
string fy_aug_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_August_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_aug, Forecast_Detail_Record_Name, Duration, RevAmt, fy_aug_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_sep = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_September.Value;
if (fy_1_sep > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "September";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "September";
}
string fy_1_sep_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_September_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_sep, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_sep_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_oct = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_October.Value;
if (fy_1_oct > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "October";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "October";
}
string fy_1_oct_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_October_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_oct, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_oct_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_nov = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_November.Value;
if (fy_1_nov > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "November";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "November";
}
string fy_1_nov_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_November_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_nov, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_nov_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_dec = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_December.Value;
if (fy_1_dec > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "December";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "December";
}
string fy_1_dec_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_December_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_dec, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_dec_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_jan = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_January.Value;
if (fy_1_jan > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "January";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "January";
}
string fy_1_jan_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_January_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_jan, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_jan_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_feb = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_February.Value;
if (fy_1_feb > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "February";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "February";
}
string fy_1_feb_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_February_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_feb, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_feb_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_mar = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_March.Value;
if (fy_1_mar > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "March";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "March";
}
string fy_1_mar_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_March_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_mar, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_mar_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_apr = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_April.Value;
if (fy_1_apr > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "April";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "April";
}
string fy_1_apr_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_April_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_apr, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_apr_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_may = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_May.Value;
if (fy_1_may > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "May";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "May";
}
string fy_1_may_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_May_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_may, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_may_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_june = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_June.Value;
if (fy_1_june > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "June";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "June";
}
string fy_1_june_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_June_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_june, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_june_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_july = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_July.Value;
if (fy_1_july > 0)
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "July";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "July";
}
string fy_1_july_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_July_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_july, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_july_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
decimal fy_1_aug = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_August.Value;
if (fy_1_aug > 0 )
{
string Forecast_Detail_Record_Name = "";
if (CurrentMonth < 9)
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "August";
}
else
{
Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "August";
}
string fy_1_aug_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_August_ID;
WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_aug, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_aug_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
}
}
*/
[ScriptableMember]
public string ToHtml()
{
return radGridView.ToHtml(true, true);
}
[ScriptableMember]
public string ToCsv()
{
return radGridView.ToCsv(true, true);
}
[ScriptableMember]
public string ToExcelXML()
{
return radGridView.ToExcelML(true, true);
}
private void btn_Save(object sender, RoutedEventArgs e)
{
GridViewRow[] EditedRowToArray = EditedRowData.ToArray();
RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient WcfSvc = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();
WcfSvc.UpdateCRMDataAsync(EditedRowToArray as object);
}
private void ShowDataButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (RegionNames.Count == 0)
{
// Show an alert message to the User
RadWindow radWin = new RadWindow();
radWin.Top = 350;
radWin.Left = 550;
radWin.Width = 370;
radWin.Height = 50;
radWin.Header = "No Region Selected";
radWin.Content = "Please select atleast 1 Region from which data must be fetched";
radWin.Show();
}
else
{
StartingRow = InitialStartingRow;
PageSize = InitialPageSize;
ShowDataButton.IsEnabled = false;
if(IGrpDescArr != null)
{
radGridView.GroupDescriptors.Remove(IGrpDescArr[0]);
}
GetData();
}
}
catch (Exception Excep)
{
MessageBox.Show(Excep.InnerException.StackTrace.ToString() + Excep.Message.ToString());
}
}
private void GetData()
{
RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient ws = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();
ws.GetRevenueProjectionToolDataPageWiseCompleted += new EventHandler<GetRevenueProjectionToolDataPageWiseCompletedEventArgs>(ws_RevenueProjectionToolDataPageWiseCompleted);
ws.GetRevenueProjectionToolDataPageWiseAsync(true, StartingRow, PageSize, RegionNames,this.AccountAutoCompleteBox.Text.ToString(), this.BDOwnerAutoCompleteBox.Text.ToString());
}
private void ShowHideColumnsOptions(object sender, RoutedEventArgs e)
{
}
private void ExportToExcel(object sender, RoutedEventArgs e)
{
ExportFormat format = ExportFormat.Html;
string extension = "xlsx";
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = extension;
dialog.Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension);
dialog.FilterIndex = 1;
if (dialog.ShowDialog() == true)
{
using (Stream stream = dialog.OpenFile())
{
GridViewExportOptions exportOptions = new GridViewExportOptions();
exportOptions.Format = format;
exportOptions.ShowColumnFooters = true;
exportOptions.ShowColumnHeaders = true;
exportOptions.ShowGroupFooters = true;
radGridView.Export(stream, exportOptions);
}
}
}
private void DisplayRevenueInUSDAndLCY_Click(object sender, RoutedEventArgs e)
{
DisplayRevenueInUSDAndLCY.IsEnabled = false;
ShowOrHideUSDColumns ShowColumns = new ShowOrHideUSDColumns();
if (DisplayRevenueInUSDAndLCY.Content.ToString() == "Show Revenue in USD")
{
ShowOrHideUSDColumns.ShowUSDColumns(radGridView);
ToolUtilities.GenerateColumnHeadersUSDColumns(radGridView);
ShowOrHideUSDColumns.HideLCYColumns(radGridView);
decimal[] CalculatedColumnFooterTotals = CalculatedColumnsFooterTotals.CalculateTotalsForCalculatedColumnsUSD(RPTDataArray);
this.SetValueInColumnFooter("YIELD_REVENUE_BASE", decimal.Round(CalculatedColumnFooterTotals[0], 2));
this.SetValueInColumnFooter("FY_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[1], 2));
this.SetValueInColumnFooter("FY_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[2], 2));
this.SetValueInColumnFooter("FY_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[3], 2));
this.SetValueInColumnFooter("FY_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[4], 2));
this.SetValueInColumnFooter("FY_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[5], 2));
this.SetValueInColumnFooter("FY_1_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[6], 2));
this.SetValueInColumnFooter("FY_1_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[7], 2));
this.SetValueInColumnFooter("FY_1_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[8], 2));
this.SetValueInColumnFooter("FY_1_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[9], 2));
this.SetValueInColumnFooter("FY_1_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[10], 2));
this.SetValueInColumnFooter("W_FY_September_BASE", decimal.Round(CalculatedColumnFooterTotals[11], 2));
this.SetValueInColumnFooter("W_FY_October_BASE", decimal.Round(CalculatedColumnFooterTotals[12], 2));
this.SetValueInColumnFooter("W_FY_November_BASE", decimal.Round(CalculatedColumnFooterTotals[13], 2));
this.SetValueInColumnFooter("W_FY_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[14], 2));
this.SetValueInColumnFooter("W_FY_December_BASE", decimal.Round(CalculatedColumnFooterTotals[15], 2));
this.SetValueInColumnFooter("W_FY_January_BASE", decimal.Round(CalculatedColumnFooterTotals[16], 2));
this.SetValueInColumnFooter("W_FY_February_BASE", decimal.Round(CalculatedColumnFooterTotals[17], 2));
this.SetValueInColumnFooter("W_FY_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[18], 2));
this.SetValueInColumnFooter("W_FY_March_BASE", decimal.Round(CalculatedColumnFooterTotals[19], 2));
this.SetValueInColumnFooter("W_FY_April_BASE", decimal.Round(CalculatedColumnFooterTotals[20], 2));
this.SetValueInColumnFooter("W_FY_May_BASE", decimal.Round(CalculatedColumnFooterTotals[21], 2));
this.SetValueInColumnFooter("W_FY_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[22], 2));
this.SetValueInColumnFooter("W_FY_June_BASE", decimal.Round(CalculatedColumnFooterTotals[23], 2));
this.SetValueInColumnFooter("W_FY_July_BASE", decimal.Round(CalculatedColumnFooterTotals[24], 2));
this.SetValueInColumnFooter("W_FY_August_BASE", decimal.Round(CalculatedColumnFooterTotals[25], 2));
this.SetValueInColumnFooter("W_FY_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[26], 2));
this.SetValueInColumnFooter("W_FY_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[27], 2));
this.SetValueInColumnFooter("W_FY_1_September_BASE", decimal.Round(CalculatedColumnFooterTotals[28], 2));
this.SetValueInColumnFooter("W_FY_1_October_BASE", decimal.Round(CalculatedColumnFooterTotals[29], 2));
this.SetValueInColumnFooter("W_FY_1_November_BASE", decimal.Round(CalculatedColumnFooterTotals[30], 2));
this.SetValueInColumnFooter("W_FY_1_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[31], 2));
this.SetValueInColumnFooter("W_FY_1_December_BASE", decimal.Round(CalculatedColumnFooterTotals[32], 2));
this.SetValueInColumnFooter("W_FY_1_January_BASE", decimal.Round(CalculatedColumnFooterTotals[33], 2));
this.SetValueInColumnFooter("W_FY_1_February_BASE", decimal.Round(CalculatedColumnFooterTotals[34], 2));
this.SetValueInColumnFooter("W_FY_1_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[35], 2));
this.SetValueInColumnFooter("W_FY_1_March_BASE", decimal.Round(CalculatedColumnFooterTotals[36], 2));
this.SetValueInColumnFooter("W_FY_1_April_BASE", decimal.Round(CalculatedColumnFooterTotals[37], 2));
this.SetValueInColumnFooter("W_FY_1_May_BASE", decimal.Round(CalculatedColumnFooterTotals[38], 2));
this.SetValueInColumnFooter("W_FY_1_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[39], 2));
this.SetValueInColumnFooter("W_FY_1_June_BASE", decimal.Round(CalculatedColumnFooterTotals[40], 2));
this.SetValueInColumnFooter("W_FY_1_July_BASE", decimal.Round(CalculatedColumnFooterTotals[41], 2));
this.SetValueInColumnFooter("W_FY_1_August_BASE", decimal.Round(CalculatedColumnFooterTotals[42], 2));
this.SetValueInColumnFooter("W_FY_1_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[43], 2));
this.SetValueInColumnFooter("W_FY_1_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[44], 2));
this.SetValueInColumnFooter("FY_September_BASE", decimal.Round(CalculatedColumnFooterTotals[45], 2));
this.SetValueInColumnFooter("FY_October_BASE", decimal.Round(CalculatedColumnFooterTotals[46], 2));
this.SetValueInColumnFooter("FY_November_BASE", decimal.Round(CalculatedColumnFooterTotals[47], 2));
this.SetValueInColumnFooter("FY_December_BASE", decimal.Round(CalculatedColumnFooterTotals[48], 2));
this.SetValueInColumnFooter("FY_January_BASE", decimal.Round(CalculatedColumnFooterTotals[49], 2));
this.SetValueInColumnFooter("FY_February_BASE", decimal.Round(CalculatedColumnFooterTotals[50], 2));
this.SetValueInColumnFooter("FY_March_BASE", decimal.Round(CalculatedColumnFooterTotals[51], 2));
this.SetValueInColumnFooter("FY_April_BASE", decimal.Round(CalculatedColumnFooterTotals[52], 2));
this.SetValueInColumnFooter("FY_May_BASE", decimal.Round(CalculatedColumnFooterTotals[53], 2));
this.SetValueInColumnFooter("FY_June_BASE", decimal.Round(CalculatedColumnFooterTotals[54], 2));
this.SetValueInColumnFooter("FY_July_BASE", decimal.Round(CalculatedColumnFooterTotals[55], 2));
this.SetValueInColumnFooter("FY_August_BASE", decimal.Round(CalculatedColumnFooterTotals[56], 2));
this.SetValueInColumnFooter("FY_1_September_BASE", decimal.Round(CalculatedColumnFooterTotals[57], 2));
this.SetValueInColumnFooter("FY_1_October_BASE", decimal.Round(CalculatedColumnFooterTotals[58], 2));
this.SetValueInColumnFooter("FY_1_November_BASE", decimal.Round(CalculatedColumnFooterTotals[59], 2));
this.SetValueInColumnFooter("FY_1_December_BASE", decimal.Round(CalculatedColumnFooterTotals[60], 2));
this.SetValueInColumnFooter("FY_1_January_BASE", decimal.Round(CalculatedColumnFooterTotals[61], 2));
this.SetValueInColumnFooter("FY_1_February_BASE", decimal.Round(CalculatedColumnFooterTotals[62], 2));
this.SetValueInColumnFooter("FY_1_March_BASE", decimal.Round(CalculatedColumnFooterTotals[63], 2));
this.SetValueInColumnFooter("FY_1_April_BASE", decimal.Round(CalculatedColumnFooterTotals[64], 2));
this.SetValueInColumnFooter("FY_1_May_BASE", decimal.Round(CalculatedColumnFooterTotals[65], 2));
this.SetValueInColumnFooter("FY_1_June_BASE", decimal.Round(CalculatedColumnFooterTotals[66], 2));
this.SetValueInColumnFooter("FY_1_July_BASE", decimal.Round(CalculatedColumnFooterTotals[67], 2));
this.SetValueInColumnFooter("FY_1_August_BASE", decimal.Round(CalculatedColumnFooterTotals[68], 2));
this.SetValueInColumnFooter("SALES_REVENUE_BASE", decimal.Round(CalculatedColumnFooterTotals[69], 2));
radGridView.GroupDescriptors.Remove(IGrpDescArr[0]);
DisplayRevenueInUSDAndLCY.Content = "Show Revenue in LCY";
}
else if (DisplayRevenueInUSDAndLCY.Content.ToString() == "Show Revenue in LCY")
{
ShowOrHideUSDColumns.HideUSDColumns(radGridView);
ShowOrHideUSDColumns.ShowLCYColumns(radGridView);
radGridView.GroupDescriptors.Add(IGrpDescArr[0]);
DisplayRevenueInUSDAndLCY.Content = "Show Revenue in USD";
}
DisplayRevenueInUSDAndLCY.IsEnabled = true;
}
private void RegionCheckBox_Checked(object sender, RoutedEventArgs e)
{
RegionNames.Add(((System.Windows.Controls.ContentControl)(sender)).Content.ToString());
}
private void RegionCheckBox_UnChecked(object sender, RoutedEventArgs e)
{
RegionNames.Remove(((System.Windows.Controls.ContentControl)(sender)).Content.ToString());
}
private void radGridView_CellValidating(object sender, GridViewCellValidatingEventArgs e)
{
for (int p = 0; p < EditableColumnUniqueNames.Length; p++)
{
if (e.Cell.Column.UniqueName == EditableColumnUniqueNames[p])
{
if (Regex.IsMatch(e.NewValue.ToString(), "[0-9]+"))
{
if (Convert.ToDecimal(e.NewValue) < 0)
{
e.IsValid = false;
e.ErrorMessage = "Please enter a positive value.";
}
}
else
{
e.IsValid = false;
e.ErrorMessage = "Please enter a numeric value.";
}
}
}
}
private void SetValueInColumnFooter(string UniqueColumnName,decimal TotalValue)
{
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-us");
System.Windows.Controls.UIElementCollection ElementCollectn = ((System.Windows.Controls.Panel)(this.radGridView.Columns[UniqueColumnName].Footer)).Children;
UIElement[] ElementArr = ElementCollectn.ToArray();
((System.Windows.Controls.TextBlock)(ElementArr[0])).Text = "Sum (In USD) : " + TotalValue.ToString("C", ci);
}
}
}
Unfortunately it will be impossible to replicate the issue using your pasted code. Please open support ticket and send us small running example where we can reproduce and debug this.
Kind regards,Vlad
the Telerik team

I had already created a support ticket for this with Support ID : 338291.
Can you please let me know if an update on this is available?
Thanks.
We are currently looking into this issue. Thank you for your patience.
Best wishes,
Milan
the Telerik team