/// <summary> /// Get values for the profit chart /// </summary> /// <param name="date"></param> /// <param name="ticker"></param> /// <returns></returns> public RadObservableCollection <KeyValuePair <String, double> > GetRadarProfitData(String date, String ticker) { int id_fga = GetSectorFromTicker(ticker); Dictionary <object, object> values = connection.ProcedureStockeeDico("ACT_Radar_Growth", new List <String> { "@date", "@Pres", "@TICKER", "@FGA", "@MM" }, new List <Object> { date, "Qualite", ticker, id_fga.ToString(), "" }); RadObservableCollection <KeyValuePair <String, double> > res = new RadObservableCollection <KeyValuePair <string, double> >(); foreach (var o in values) { if (o.Value == null || o.Value.ToString() == "") { res.Add(new KeyValuePair <String, double>(o.Key.ToString(), 0)); } else { res.Add(new KeyValuePair <String, double>(o.Key.ToString(), (double)o.Value)); } } return(res); }
/// <summary> /// get all univers from the database /// </summary> /// <returns></returns> public RadObservableCollection <String> getUnivers() { RadObservableCollection <String> collection = new RadObservableCollection <String>(); collection.Add(""); collection.Add("ALL"); collection.Add("USA"); collection.Add("EUROPE"); collection.Add("EUROPE EX EMU"); collection.Add("EMU"); collection.Add("FRANCE"); collection.Add(""); collection.Add("FEDERIS NORTH AMERICA"); collection.Add("FEDERIS ISR AMERIQUE"); collection.Add("FEDERIS EUROPE ACTIONS"); collection.Add("FEDERIS EX EURO"); collection.Add("FEDERIS EURO ACTIONS"); collection.Add("AVENIR EURO"); collection.Add("FEDERIS ISR EURO"); collection.Add("FEDERIS ACTIONS"); collection.Add("FEDERIS IRC ACTIONS"); collection.Add("FEDERIS CROISSANCE EURO"); collection.Add("FEDERIS VALUE EURO"); collection.Add("FEDERIS FRANCE ACTIONS"); return(collection); }
private void Init() { #region Dates _dates = _model.GetDates(); _selectedDate = _dates[0]; _selectedDate2 = _dates[0]; #endregion #region Pays _pays = _model.GetPays(); _selectedPays1 = _pays[0]; _selectedPays2 = _pays[0]; #endregion #region Maturity _maturities = _model.GetMaturity(); _selectedMaturity = _maturities[0]; _selectedMaturity2 = _maturities[0]; #endregion #region Source _source = _model.GetSource(); _selectedSource = _source[0]; #endregion }
private void InitCollections() { this.Albums = new RadObservableCollection <FacebookAlbum>(); this.UpcomingEvents = new RadObservableCollection <FacebookUpcomingEvent>(); this.PastEvents = new RadObservableCollection <FacebookPastEvent>(); this.PublicInfos = new RadObservableCollection <FacebookPublicInfo>(); this.RecentPlaces = new RadObservableCollection <FacebookRecentPlace>(); }
/// <summary> /// Initializes a new instance of the MainViewModel class. /// </summary> public MainViewModel() { BoxesInTimeline = new ObservableCollection <BaseBox>(); NewBoxList = new RadObservableCollection <BaseBox> { NewNSRBox(), NewPVCBox(), NewPauseBox() }; BoxesInTimeline.Add(NewNSRBox()); NewBoxList.CollectionChanged += NewBoxListOnCollectionChanged; }
public RepartitionValeurViewModel() { _model = new RepartitionValeurModel(); Dates = _model.GetDates(); SelectedDate = _dates[0]; AvailableTickers = _model.GetAllTickers(); SelectedTickers = new RadObservableCollection <string>(); }
private void displayGraph() { centerAvgGraph.Clear(); centerAvgGraph = GenerateRandomSerie(10, new DateTime(2000, 1, 1)); XAxis.MajorTickInterval = 2; MaxY = MaxScale + 10.0; YAxis.Maximum = MaxY; ReferenceGraph.Series[0].ItemsSource = centerAvgGraph; ReferenceGraph.Series[1].ItemsSource = GenerateRandomSerie(5, new DateTime(2000, 1, 1)); ReferenceGraph.Series[2].ItemsSource = GenerateRandomSerie(5, new DateTime(2000, 6, 1)); }
public SimpleViewModel() { var data = new RadObservableCollection<SalesInfo>(); DateTime startDate = new DateTime(2012, 12, 15); for (int i = 0; i < 20; i += 1) { data.Add(new SalesInfo() { Time = startDate.AddDays(i), Value = i }); } this.Data = data; }
public RadObservableCollection <String> GetAllTickers() { List <object> tmp = _connection.SqlWithReturn("SELECT TICKER FROM DATA_FACTSET WHERE DATE = (SELECT MAX(DATE) FROM DATA_FACTSET)"); RadObservableCollection <String> res = new RadObservableCollection <string>(); foreach (var v in tmp) { res.Add(v.ToString()); } return(res); }
public RadObservableCollection <String> GetDates() { RadObservableCollection <String> collection = new RadObservableCollection <String>(); if (coBase.State == ConnectionState.Open) { foreach (DateTime d in SelectDistinctSimple("DATA_FACTSET", "DATE", "DESC")) { collection.Add(d.ToShortDateString()); } } return(collection); }
public void showChart4() { DataList4 = new RadObservableCollection <KeyValuePair <string, float> >(); foreach (DataRow row in _ratesDataSource4.Rows) { string date = row["Date"].ToString(); date = date.Substring(0, 10); string ratetmp = row["Valeur"].ToString(); float rate = float.Parse(ratetmp) * 10; DataList4.Add(new KeyValuePair <string, float>(date, rate)); } }
public RadObservableCollection <String> GetDates() { String sql = "select distinct DATE from TX_AGGREGATE_DATA order by Date"; RadObservableCollection <String> collection = new RadObservableCollection <String>(); if (co.IsOpen()) { foreach (DateTime d in co.SqlWithReturn(sql)) { collection.Add(d.ToShortDateString()); } } return(collection); }
public RadObservableCollection <String> GetPays() { String sql = "select distinct key2 from TX_AGGREGATE_DATA WHERE key1 = 'YTM_I' order by key2"; RadObservableCollection <String> collection = new RadObservableCollection <string>(); if (co.IsOpen()) { foreach (String d in co.SqlWithReturn(sql)) { collection.Add(d.ToString()); } } return(collection); }
public RadObservableCollection <String> GetSource() { String sql = "select distinct key5 from TX_AGGREGATE_DATA"; RadObservableCollection <String> collection = new RadObservableCollection <string>(); if (co.IsOpen()) { foreach (String s in co.SqlWithReturn(sql)) { collection.Add(s.ToString()); } } return(collection); }
public RepartitionViewModel() { _model = new RepartitionModel(); _dates = _model.GetDates(); SelectedDate = _dates[0]; _tickers = _model.GetAllTickers(); _portefeuilles = new RadObservableCollection <string> { "6100002", "6100030", "AVEURO", "6100004", "6100063", "AVEUROPE", "6100001", "6100033", "6100062", "6100026", "6100024" }; }
public RadObservableCollection <String> getIsin() { String sql = "select distinct ISINId from ref_security.PRICE where Price_Source = 'IBOXX_EUR' or Price_Source = 'BARCLAYS' order by ISINId"; RadObservableCollection <String> collection = new RadObservableCollection <String>(); if (_connection.IsOpen()) { foreach (String d in _connection.SqlWithReturn(sql)) { collection.Add(d.ToString()); } } return(collection); }
public RadObservableCollection <KeyValuePair <string, int> > GetQuintiles(String ticker, String dateMin, String dateMax) { RadObservableCollection <KeyValuePair <string, int> > res = new RadObservableCollection <KeyValuePair <string, int> >(); String request = "SELECT CONVERT(DATE, date, 103) as Date, GARPN_QUINTILE_S as Quint FROM DATA_FACTSET WHERE TICKER='" + ticker + "' AND GARPN_QUINTILE_S IS NOT NULL AND DATE <= '" + dateMin + "' AND DATE >= '" + dateMax + "' ORDER BY DATE"; List <KeyValuePair <string, int> > values = _connection.sqlToListKeyValuePair(request); foreach (var v in values) { res.Add(new KeyValuePair <string, int>(v.Key.Substring(0, 10), v.Value)); } return(res); }
public static RadObservableCollection <Club> GetClubs() { RadObservableCollection <Club> clubs = new RadObservableCollection <Club>(); Club club; for (int i = 0; i < 20; i++) { club = new Club("Liverpool" + i, new DateTime(1892, 1, 1), i); clubs.Add(club); } return(clubs); }
public PlotStats() { plots = new RadObservableCollection <plot>(); var filiere = from f in cl.filiere select f; foreach (var x in filiere) { var tmp = from e in cl.etudiant where e.id_filiere == x.id_filiere select e; plots.Add(new plot(x.nom_filiere, tmp.Count())); } }
public void showChart2() { DataList2 = new RadObservableCollection <KeyValuePair <string, float> >(); foreach (DataRow row in _ratesDataSource2.Rows) { string date = row["Date"].ToString(); int year = int.Parse(date.Substring(6, 4)); date = date.Substring(0, 6) + year.ToString(); String rateTmp = row["Rate"].ToString(); float rate = float.Parse(rateTmp); DataList2.Add(new KeyValuePair <String, float>(date, rate)); } }
public SimpleViewModel() { var data = new RadObservableCollection <SalesInfo>(); DateTime startDate = new DateTime(2012, 12, 15); for (int i = 0; i < 20; i += 1) { data.Add(new SalesInfo() { Time = startDate.AddDays(i), Value = i }); } this.Data = data; }
public void showZero() { if (containsNegative) { ZeroLine = new RadObservableCollection <KeyValuePair <string, float> >(); foreach (var v in DataList3) { ZeroLine.Add(new KeyValuePair <string, float>(v.Key, 0)); } containsNegative = false; } else { ZeroLine = null; containsNegative = false; } }
public void showChart3(ObservableCollection <KeyValuePair <string, float> > Datalist, RadObservableCollection <KeyValuePair <string, float> > Datalist2) { DataList3 = new RadObservableCollection <KeyValuePair <string, float> >(); for (int i = 0; i < ((Datalist.Count < Datalist2.Count) ? DataList.Count : Datalist2.Count); i++) { if (Datalist[i].Key == Datalist2[i].Key) { float val = Datalist[i].Value - Datalist2[i].Value; if (val < 0) { containsNegative = true; } DataList3.Add(new KeyValuePair <string, float>(Datalist[i].Key, val)); } } }
public RadObservableCollection <int> GetMaturity() { String sql = "select distinct key4 from TX_AGGREGATE_DATA order by key4"; RadObservableCollection <int> collection = new RadObservableCollection <int>(); if (co.IsOpen()) { foreach (object i in co.SqlWithReturn(sql)) { if (i.ToString() != "") { collection.Add(int.Parse(i.ToString())); } } } return(Sort(collection)); }
public void showChart6() { DataList6 = new RadObservableCollection <KeyValuePair <string, float> >(); foreach (DataRow row in _ratesDataSource6.Rows) { string date = row["Date"].ToString(); date = date.Substring(0, 10); string ratetmp = row["Valeur"].ToString(); float rate = float.Parse(ratetmp) * 10; if (rate < 0) { containsNegative = true; } DataList6.Add(new KeyValuePair <string, float>(date, rate)); } }
public void FillSectorsChart() { _sectorsChartDataSource = new RadObservableCollection <ChartSerie>(); RadObservableCollection <ChartSerie> tmpChart = new RadObservableCollection <ChartSerie>(); foreach (DataRow row in SectorsDataSource.Rows) { ChartSerie tmp = _model.GetChartDataForSector(_selectedPortefeuille, row["SECTOR GICS"].ToString()); if (tmp.Data.Count > 0) { tmpChart.Add(tmp); } } SectorsChartDataSource = tmpChart; }
/// <summary> /// Get all SuperSectors (GICS Sectors) from the database /// </summary> /// <returns></returns> public RadObservableCollection <Sector> getSuperSectors() { RadObservableCollection <Sector> collection = new RadObservableCollection <Sector>(); String sql = "SELECT CODE AS Id, LABEL AS Libelle FROM ref_security.SECTOR WHERE"; sql += " class_name = 'GICS'"; sql += " and [level] = 0 ORDER BY label"; collection.Add(new Sector(-1, "")); collection.Add(new Sector(-1, ALLSUPERSECTORS)); foreach (Sector s in co.sqlToListObject(sql, () => new Sector())) { collection.Add(s); } return(collection); }
/// <summary> /// Fill the List used for the datagrid /// </summary> public void FillStocks() { List <Dictionary <String, object> > tmp = _model.GetDoublonsData(FIND_DOUBLE_EQUITY_SQL); StockList = new RadObservableCollection <S_Stock>(); foreach (Dictionary <String, object> stock in tmp) { StockList.Add(new S_Stock(stock["date"].ToString(), stock["name"].ToString(), stock["isin"].ToString(), stock["country"].ToString(), stock["ticker"].ToString()) ); } }
public RadObservableCollection <KeyValuePair <string, int> > GetQuintile(String ticker) { RadObservableCollection <KeyValuePair <string, int> > res = new RadObservableCollection <KeyValuePair <string, int> >(); String request = "SELECT CONVERT(DATE, date, 103) as Date, GARPN_QUINTILE_S as Quint FROM DATA_FACTSET WHERE TICKER='" + ticker + "' AND GARPN_QUINTILE_S IS NOT NULL ORDER BY DATE"; List <KeyValuePair <string, int> > values = connection.sqlToListKeyValuePair(request); // VOIR DANS LE CAHIER L'ALGO. values = GetfinDeMois(values); values = GetLastDates(values, 12); foreach (var v in values) { res.Add(new KeyValuePair <string, int>(v.Key.Substring(0, 10), v.Value)); } return(res); }
public RadObservableCollection <int> Sort(RadObservableCollection <int> collection) { for (int j = 1; j < collection.Count; j++) { for (int i = j; i < collection.Count; i++) { int a = collection[i - 1]; int b = collection[i]; if (a > b) { collection[i] = a; collection[i - 1] = b; } } } return(collection); }
/// <summary> /// Get all date from the database in DESC ORDER /// </summary> /// <returns>All Dates as Collection of Strings</returns> public RadObservableCollection <String> getDates() { RadObservableCollection <String> collection = new RadObservableCollection <String>(); if (co.IsOpen()) { try { foreach (DateTime d in co.SelectDistinctSimple("DATA_FACTSET", "DATE", "DESC")) { collection.Add(d.ToShortDateString()); } } catch { } } return(collection); }
//private Random rand = new Random(); public void BindData() { if (ChartData == null) { ChartData = new RadObservableCollection<BarChartDataPoint>(); for (int i = 0; i < XAsisCategories.Length; i++) ChartData.Add(new BarChartDataPoint(YAxisValues[i], XAsisCategories[i])); NotifyOfPropertyChange(() => this.ChartData); } else { ChartData.SuspendNotifications(); var max = 0L; for (int i = 0; i < XAsisCategories.Length; i++) { // NOTE: for testing data changes //var nextRand = rand.Next(0, 2); //nextRand = nextRand == 0 ? -1 : nextRand; //var nextVal = WidgetData[i].Amount + nextRand; //nextVal = nextVal < 0 ? 0 : nextVal; //WidgetData[i].Amount = nextVal; ChartData[i].Amount = YAxisValues[i]; max = ChartData[i].Amount > max ? ChartData[i].Amount : max; } YAxisMaxValue = max + 1; ChartData.ResumeNotifications(); } NotifyOfPropertyChange(() => this.YAxisMaxValue); }
private void cmsWebServiceClient_GetIssueRelatedOverrideCompleted(object sender, GetIssueRelatedOverrideCompletedEventArgs e) { IssueRelatedOverrides = new RadObservableCollection<IssueRelatedOverride>(e.Result); mIssue.ModifiedObjects.OverridesModified = true; mDictionary = Utils.BuildDictionaryForCollection(mIssue.IssueRelatedOverrides.Select(x => x.InterlockId).ToList()); RaisePropertyChanged("IssueRelatedOverrides"); }
/// <summary> /// Initializes a new instance of the <see cref="HierarchicalNodeViewModel" /> class. /// </summary> public HierarchicalNodeViewModel() { this.children = new RadObservableCollection<HierarchicalNodeViewModel>(); }
void cmsWebServiceClient_GetIssueResponsesCompleted(object sender, GetIssueResponsesCompletedEventArgs e) { IssueResponses = new RadObservableCollection<IssueResponse>(e.Result.OrderByDescending(x => x.Date)); Loaded(); RaisePropertyChanged("IssueResponses"); }
private void LoadData() { Task.Run(() => CalendarRepository.LoadData()); CalendarRepository.GetResourceTypes(items => { this.resourceTypes = new RadObservableCollection<ResourceType>(items); this.OnPropertyChanged("ResourceTypes"); }); CalendarRepository.GetTimeMarkers(items => { this.timeMarkers = new RadObservableCollection<TimeMarker>(items); this.OnPropertyChanged("TimeMarkers"); }); }
public CustomersViewModel() { NorthwindDomainContext context = new NorthwindDomainContext(); EntityQuery<DistinctValue> contactTitlesQuery = context.GetDistinctValuesQuery("ContactTitle"); context.Load<DistinctValue>(contactTitlesQuery , LoadBehavior.RefreshCurrent , this.OnDistinctContactTitlesLoaded , this.contactTitles); EntityQuery<Customer> getCustomersQuery = context.GetCustomersQuery(); this.view = new QueryableDomainServiceCollectionView<Customer>(context, getCustomersQuery); this.view.PageSize = 10; this.view.AutoLoad = true; this.view.PropertyChanged += this.OnViewPropertyChanged; this.view.LoadedData += this.OnViewLoadedData; this.loadCommand = new DelegateCommand(this.ExecuteLoadCommand, this.LoadCommandCanExecute); this.countrySortDescriptor = new SortDescriptor() { Member = "Country" }; this.citySortDescriptor = new SortDescriptor() { Member = "City" }; this.contactTitles = new RadObservableCollection<string>(); this.contactTitles.Add(CustomersViewModel.ClearSelectionString); this.contactTitleFilterDescriptor = new FilterDescriptor("ContactTitle", FilterOperator.IsEqualTo, FilterDescriptor.UnsetValue); this.view.FilterDescriptors.Add(this.contactTitleFilterDescriptor); }
public static RadObservableCollection<Club> GetClubs() { RadObservableCollection<Club> clubs = new RadObservableCollection<Club>(); Club club; for (int i = 0; i < 20; i++) { club = new Club("Liverpool" + i, new DateTime(1892, 1, 1), i); clubs.Add(club); } return clubs; }