Esempio n. 1
0
        public static ObservableCollection <SalesByContinet> GenerateTotalSalesVsTargetListByContinent(ObservableCollection <SalesDetail> salesDetails)
        {
            ObservableCollection <SalesByContinet> salesVsTargetList = new ObservableCollection <SalesByContinet>();
            var    query = from sales in salesDetails group sales by sales.Continent into grouping select grouping;
            Random rand  = new Random();

            foreach (IGrouping <string, SalesDetail> groupedRecord in query)
            {
                SalesByContinet salesVsTarget = new SalesByContinet();
                salesVsTarget.Continent = groupedRecord.Key;
                salesVsTarget.Sales     = groupedRecord.Sum(s => s.OrderTotal);

                salesVsTarget.Target       = ((salesVsTarget.Sales * rand.Next(-10, 30)) / 100) + salesVsTarget.Sales;
                salesVsTarget.SalesPercent = (salesVsTarget.Sales / salesVsTarget.Target) * 100;
                salesVsTargetList.Add(salesVsTarget);
            }

            return(salesVsTargetList);
        }
Esempio n. 2
0
        void Maps_ShapesSelected(object sender, SelectionEventArgs args)
        {
            SalesByContinet salesByContinent = ((args.Items as ObservableCollection <MapShape>)[0].DataContext as SalesByContinet);

            if (salesByContinent != null)
            {
                if (salesByContinent.Continent == "Africa")
                {
                    this.map.BaseMapIndex           = 6;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }
                else if (salesByContinent.Continent == "Oceania")
                {
                    this.map.BaseMapIndex           = 1;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }
                else if (salesByContinent.Continent == "South America")
                {
                    this.map.BaseMapIndex           = 2;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }
                else if (salesByContinent.Continent == "North America")
                {
                    this.map.BaseMapIndex           = 3;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }
                else if (salesByContinent.Continent == "Europe")
                {
                    this.map.BaseMapIndex           = 4;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }
                else if (salesByContinent.Continent == "Antarctica")
                {
                    this.map.BaseMapIndex           = 5;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }
                else if (salesByContinent.Continent == "Asia")
                {
                    this.map.BaseMapIndex           = 7;
                    this.DrillDownButton.Visibility = Visibility.Collapsed;
                    this.DrillUpButton.Visibility   = Visibility.Visible;
                }

                ViewModel VM = (this.DataContext as ViewModel);
                DateTime  SelectedStartDate, SelectedEndDate;
                if ((this.DataContext as ViewModel).Selectedindex == 0)
                {
                    SelectedStartDate = new DateTime(2011, 1, 1);
                    SelectedEndDate   = new DateTime(2011, 6, 30);
                }
                else
                {
                    SelectedStartDate = new DateTime(2011, 1, 7);
                    SelectedEndDate   = new DateTime(2011, 12, 31);
                }
                #region Chart Data
                VM.SalesVsTarget = (object)(SalesDetail.GenerateTotalSalesVsTargetList(SalesDetail.GenerateSalesDetails(SelectedStartDate, SelectedEndDate)));
                #endregion
                #region Maps Data
                VM.Total_Sales = SalesDetail.GenerateSalesDetails(SelectedStartDate, SelectedEndDate);
                VM.Models      = (SalesDetail.GenerateTotalSalesVsTargetListByContinent(VM.Total_Sales));


                VM.SalesByCountry = (SalesDetail.GenerateTotalSalesVsTargetListByCountry(VM.Total_Sales));
                for (int i = 0; i < VM.Models.Count; i++)
                {
                    VM.Models[i].DisplaySalesValue = String.Format("{0:C}", Convert.ToInt32(VM.Models[i].Sales.ToString()));
                }
                #endregion
                #region Gauge Data
                VM.SalesVsTarget = SalesDetail.GenerateTotalSalesVsTargetList(SalesDetail.GenerateSalesDetails(SelectedStartDate, SelectedEndDate));
                double saletotal  = (VM.SalesVsTarget as ObservableCollection <SalesVsTarget>).Sum(s => s.Sales);
                double saletarget = (VM.SalesVsTarget as ObservableCollection <SalesVsTarget>).Sum(s => s.Target);
                VM.SalesTotal      = (Math.Round(saletotal, 0)).ToString();
                VM.SalesTarget     = (Math.Round(saletarget, 0)).ToString();
                VM.SalesPercentage = (saletotal / saletarget) * 100;
                #endregion
            }
        }