/// <summary> /// Grid Element Exporting /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void radGridSnapshot_ElementExporting(object sender, GridViewElementExportingEventArgs e) { RadGridView_ElementExport.ElementExporting(e, isGroupFootersVisible: false, cellValueConverter: () => { object result = e.Value; if (e.Value == null && e.Element == ExportElement.Cell) { GridViewDataColumn column = (e.Context as GridViewDataColumn); if (column != null) { if (column.DisplayIndex == 0) { MarketSnapshotPerformanceData data = column.DataControl.Items[++itemIndex] as MarketSnapshotPerformanceData; if (data != null) { result = string.Format("{0}{1}{2}", data.MarketSnapshotPreferenceInfo.EntityNodeValueName , String.IsNullOrEmpty(data.MarketSnapshotPreferenceInfo.EntityNodeValueName) ? "" : " " , data.MarketSnapshotPreferenceInfo.EntityName); } } } } return(result); }); }
private object radGridSnapshot_PdfElementExporting(int rowIndex, int columnIndex, object columnCollection, object itemCollection) { IList <GridViewBoundColumnBase> columns = columnCollection as IList <GridViewBoundColumnBase>; IList items = itemCollection as IList; if (columns == null || items == null) { return(null); } object result = columns[columnIndex].GetValueForItem(items[rowIndex]); if (columns[columnIndex].DataMemberBinding.Path.Path == "Description") { MarketSnapshotPerformanceData data = items[rowIndex] as MarketSnapshotPerformanceData; if (data != null) { result = string.Format("{0}{1}{2}", data.MarketSnapshotPreferenceInfo.EntityNodeValueName , String.IsNullOrEmpty(data.MarketSnapshotPreferenceInfo.EntityNodeValueName) ? "" : " " , data.MarketSnapshotPreferenceInfo.EntityName); } } return(result); }
/// <summary> /// Gets performance data for a specific snapshot preference where entity type is benchmark /// </summary> /// <param name="entity">Dimension service entity instance</param> /// <param name="preference">MarketSnapshotPreference object</param> /// <returns>MarketSnapshotPerformanceData</returns> public static MarketSnapshotPerformanceData GetBenchmarkPerformanceData(DimensionEntities entity, MarketSnapshotPreference preference) { MarketSnapshotPerformanceData result = new MarketSnapshotPerformanceData(); try { List <GreenField.DAL.GF_PERF_DAILY_ATTRIBUTION> benchmarkRecords = entity.GF_PERF_DAILY_ATTRIBUTION .Where(record => record.NODE_NAME == (preference.EntityNodeType == "Country" ? "Country" : "GICS Level 1") && record.AGG_LVL_1 == (preference.EntityNodeType == null ? "Undefined" : preference.EntityNodeValueCode) && record.AGG_LVL_1_LONG_NAME == (preference.EntityNodeType == null ? "-" : preference.EntityNodeValueName) && record.BM == preference.EntityId.ToUpper() && record.BMNAME == preference.EntityName && record.TO_DATE != null && record.POR_INCEPTION_DATE != null) .OrderByDescending(record => record.TO_DATE).ToList(); GreenField.DAL.GF_PERF_DAILY_ATTRIBUTION lastRecord = benchmarkRecords.FirstOrDefault(); GreenField.DAL.GF_PERF_DAILY_ATTRIBUTION benchmarkRecord = lastRecord != null?GetMinInceptionDateRecord <GreenField.DAL.GF_PERF_DAILY_ATTRIBUTION>(benchmarkRecords .Where(record => record.TO_DATE == lastRecord.TO_DATE).ToList()) : null; result.DateToDateReturn = benchmarkRecord != null ? (preference.EntityNodeType == null ? benchmarkRecord.BM1_TOP_RC_TWR_1D * Convert.ToDecimal(100) : benchmarkRecord.BM1_RC_TWR_1D * Convert.ToDecimal(100)) : null; result.WeekToDateReturn = benchmarkRecord != null ? (preference.EntityNodeType == null ? benchmarkRecord.BM1_TOP_RC_TWR_1W * Convert.ToDecimal(100) : benchmarkRecord.BM1_RC_TWR_1W * Convert.ToDecimal(100)) : null; result.MonthToDateReturn = benchmarkRecord != null ? (preference.EntityNodeType == null ? benchmarkRecord.BM1_TOP_RC_TWR_MTD * Convert.ToDecimal(100) : benchmarkRecord.BM1_RC_TWR_MTD * Convert.ToDecimal(100)) : null; result.QuarterToDateReturn = benchmarkRecord != null ? (preference.EntityNodeType == null ? benchmarkRecord.BM1_TOP_RC_TWR_QTD * Convert.ToDecimal(100) : benchmarkRecord.BM1_RC_TWR_QTD * Convert.ToDecimal(100)) : null; result.YearToDateReturn = benchmarkRecord != null ? (preference.EntityNodeType == null ? benchmarkRecord.BM1_TOP_RC_TWR_YTD * Convert.ToDecimal(100) : benchmarkRecord.BM1_RC_TWR_YTD * Convert.ToDecimal(100)) : null; if (preference.EntityNodeType == null) { GreenField.DAL.GF_PERF_TOPLEVELYEAR benchmarkLastYearRecord = GetMinInceptionDateRecord <GreenField.DAL.GF_PERF_TOPLEVELYEAR>(entity.GF_PERF_TOPLEVELYEAR .Where(g => g.CURRENCY.ToUpper() == "USD" && g.RETURN_TYPE.ToUpper() == "NET" && g.TO_DATE == "31/12/" + (DateTime.Today.Year - 1).ToString() && g.BM1ID.ToUpper() == preference.EntityId.ToUpper() && g.BM1NAME.ToUpper() == preference.EntityName.ToUpper() && g.POR_INCEPTION_DATE != null) .ToList()); result.LastYearReturn = preference.EntityNodeType == null ? (benchmarkLastYearRecord != null ? benchmarkLastYearRecord.BM1_RC_TWR_YTD * Convert.ToDecimal(100) : null) : null; GreenField.DAL.GF_PERF_TOPLEVELYEAR benchmarkSecondLastYearRecord = GetMinInceptionDateRecord <GreenField.DAL.GF_PERF_TOPLEVELYEAR>(entity.GF_PERF_TOPLEVELYEAR .Where(g => g.CURRENCY.ToUpper() == "USD" && g.RETURN_TYPE.ToUpper() == "NET" && g.TO_DATE == "31/12/" + (DateTime.Today.Year - 2).ToString() && g.BM1ID.ToUpper() == preference.EntityId.ToUpper() && g.BM1NAME.ToUpper() == preference.EntityName.ToUpper() && g.POR_INCEPTION_DATE != null) .ToList()); result.SecondLastYearReturn = preference.EntityNodeType == null ? (benchmarkSecondLastYearRecord != null ? benchmarkSecondLastYearRecord.BM1_RC_TWR_YTD * Convert.ToDecimal(100) : null) : null; GreenField.DAL.GF_PERF_TOPLEVELYEAR benchmarkThirdLastYearRecord = GetMinInceptionDateRecord <GreenField.DAL.GF_PERF_TOPLEVELYEAR>(entity.GF_PERF_TOPLEVELYEAR .Where(g => g.CURRENCY.ToUpper() == "USD" && g.RETURN_TYPE.ToUpper() == "NET" && g.TO_DATE == "31/12/" + (DateTime.Today.Year - 3).ToString() && g.BM1ID.ToUpper() == preference.EntityId.ToUpper() && g.BM1NAME.ToUpper() == preference.EntityName.ToUpper() && g.POR_INCEPTION_DATE != null) .ToList()); result.ThirdLastYearReturn = preference.EntityNodeType == null ? (benchmarkThirdLastYearRecord != null ? benchmarkThirdLastYearRecord.BM1_RC_TWR_YTD * Convert.ToDecimal(100) : null) : null; } } catch (Exception) { throw; } return(result); }
/// <summary> /// ReorderBehavior Reordering Event Handler - Adjusts Entity Order and GroupPreferenceId of entities after reordering /// </summary> /// <param name="sender">Sender</param> /// <param name="e">ReorderingEventArgs</param> private void ReorderBehavior_Reordering(object sender, ReorderingEventArgs e) { //if there are no dragged Items reordering is redundant if (e.DraggedItems.Count().Equals(0)) { return; } #region Get Dragged Element //dragged Element MarketSnapshotPerformanceData draggedElement = e.DraggedItems.FirstOrDefault() as MarketSnapshotPerformanceData; //null Exception Handling if (draggedElement == null) { return; } #endregion #region Get Data Context //collection of MorningSnapshotData binded to the grid List <MarketSnapshotPerformanceData> dataContext = (e.SourceGrid.ItemsSource as ObservableCollection <MarketSnapshotPerformanceData>).ToList(); //null Exception Handling if (dataContext == null) { return; } #endregion #region Get Drag Drop Details //drag drop Indexes int dragIndex = dataContext.IndexOf(draggedElement); int dropIndex = e.DropIndex; //true if insertion is done after an element and False if it's done before the element bool isDropPositionAfter = DragDropPosition.Value == DropPosition.After; //check if the drop Index exceed the Count of List - item dropped after the last element bool isDropIndexExceedingCount = dropIndex >= dataContext.Count; #endregion #region Drag Location Parameters MarketSnapshotPreference dragBenchmarkDetails = new MarketSnapshotPreference() { EntityName = dataContext.ElementAt(dragIndex).MarketSnapshotPreferenceInfo.EntityName, EntityReturnType = dataContext.ElementAt(dragIndex).MarketSnapshotPreferenceInfo.EntityReturnType, EntityOrder = dataContext.ElementAt(dragIndex).MarketSnapshotPreferenceInfo.EntityOrder, GroupName = dataContext.ElementAt(dragIndex).MarketSnapshotPreferenceInfo.GroupName, GroupPreferenceID = dataContext.ElementAt(dragIndex).MarketSnapshotPreferenceInfo.GroupPreferenceID }; #endregion #region Drop Location Parameters MarketSnapshotPreference dropBenchmarkDetails = new MarketSnapshotPreference() { EntityName = isDropIndexExceedingCount ? null : dataContext.ElementAt(dropIndex).MarketSnapshotPreferenceInfo.EntityName, EntityReturnType = isDropIndexExceedingCount ? null : dataContext.ElementAt(e.DropIndex).MarketSnapshotPreferenceInfo.EntityReturnType, EntityOrder = isDropIndexExceedingCount ? dataContext.ElementAt(dropIndex - 1).MarketSnapshotPreferenceInfo.EntityOrder + 1 : dataContext.ElementAt(dropIndex).MarketSnapshotPreferenceInfo.EntityOrder, GroupName = isDropIndexExceedingCount ? dataContext.ElementAt(dropIndex - 1).MarketSnapshotPreferenceInfo.GroupName : dataContext.ElementAt(dropIndex).MarketSnapshotPreferenceInfo.GroupName, GroupPreferenceID = isDropIndexExceedingCount ? dataContext.ElementAt(dropIndex - 1).MarketSnapshotPreferenceInfo.GroupPreferenceID : dataContext.ElementAt(dropIndex).MarketSnapshotPreferenceInfo.GroupPreferenceID }; #endregion #region Managing discrepancies in drop location //if drop location is after the last element of same or another group the behavior picks the next element nevertheless bool isDragdropGroupSame = dragBenchmarkDetails.GroupPreferenceID == dropBenchmarkDetails.GroupPreferenceID; bool isDropEntityMisread = dropBenchmarkDetails.EntityOrder == 1 && isDropPositionAfter; bool isDropLastOfSameGroup = GetLastGroupPreferenceId(dataContext, dropBenchmarkDetails.GroupPreferenceID) == dragBenchmarkDetails.GroupPreferenceID && isDropEntityMisread; bool isDropLastOfOtherGroup = (!isDropLastOfSameGroup) && isDropEntityMisread; #endregion bool isDragWithinGroup = isDragdropGroupSame ? (!isDropLastOfOtherGroup) : isDropLastOfSameGroup; if (isDragWithinGroup) { UpdateParametersForSameGroupReordering(dataContext, dragBenchmarkDetails, dropBenchmarkDetails, isDropLastOfSameGroup); } else { UpdateParametersForDiffGroupReordering(dataContext, dragBenchmarkDetails, dropBenchmarkDetails, isDropLastOfOtherGroup); } }
/// <summary> /// Gets performance data for a specific snapshot preference where entity type is security, index or commodity /// </summary> /// <param name="entity">Dimension service entity instance</param> /// <param name="preference">MarketSnapshotPreference object</param> /// <returns>MarketSnapshotPerformanceData</returns> public static MarketSnapshotPerformanceData GetSecurityCommodityIndexPerformanceData(DimensionEntities entity, MarketSnapshotPreference preference) { MarketSnapshotPerformanceData result = new MarketSnapshotPerformanceData(); try { DateTime TrackDate = DateTime.Today; GreenField.DAL.GF_PRICING_BASEVIEW lastDateToDateRecord = entity.GF_PRICING_BASEVIEW .Where(record => record.INSTRUMENT_ID == preference.EntityId && record.TYPE == preference.EntityType && record.ISSUE_NAME == preference.EntityName && record.FROMDATE != null) .OrderByDescending(record => record.FROMDATE) .Take(1).FirstOrDefault(); if (lastDateToDateRecord == null) { return(result); } GreenField.DAL.GF_PRICING_BASEVIEW firstRecord = entity.GF_PRICING_BASEVIEW .Where(record => record.INSTRUMENT_ID == preference.EntityId && record.TYPE == preference.EntityType && record.ISSUE_NAME == preference.EntityName && record.FROMDATE != null) .OrderBy(record => record.FROMDATE) .Take(1).FirstOrDefault(); DateTime firstRecordDateTime = DateTime.Today.AddYears(-5); if (firstRecord != null) { firstRecordDateTime = Convert.ToDateTime(firstRecord.FROMDATE); } DateTime lastBusinessDateTime = TrackDate = Convert.ToDateTime(lastDateToDateRecord.FROMDATE); result.DateToDateReturn = lastDateToDateRecord != null ? (preference.EntityReturnType == "Price" ? lastDateToDateRecord.DAILY_PRICE_RETURN != null ? lastDateToDateRecord.DAILY_PRICE_RETURN : 0 : lastDateToDateRecord.DAILY_GROSS_RETURN != null ? lastDateToDateRecord.DAILY_GROSS_RETURN : 0) : null; result.WeekToDateReturn = GetReturn(entity, preference, lastBusinessDateTime.AddDays(-6) > firstRecordDateTime ? lastBusinessDateTime.AddDays(-6) : firstRecordDateTime, lastBusinessDateTime); result.MonthToDateReturn = GetReturn(entity, preference, new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1) > firstRecordDateTime ? new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1) : firstRecordDateTime, lastBusinessDateTime); result.QuarterToDateReturn = GetReturn(entity, preference , new DateTime(DateTime.Today.Year, (DateTime.Today.Month - ((DateTime.Today.Month - 1) % 3)), 1) > firstRecordDateTime ? new DateTime(DateTime.Today.Year, (DateTime.Today.Month - ((DateTime.Today.Month - 1) % 3)), 1) : firstRecordDateTime, lastBusinessDateTime); result.YearToDateReturn = GetReturn(entity, preference, new DateTime(DateTime.Today.Year, 1, 1) > firstRecordDateTime ? new DateTime(DateTime.Today.Year, 1, 1) : firstRecordDateTime, lastBusinessDateTime); result.LastYearReturn = GetReturn(entity, preference, new DateTime(DateTime.Today.Year - 1, 1, 1) > firstRecordDateTime ? new DateTime(DateTime.Today.Year - 1, 1, 1) : firstRecordDateTime, new DateTime(DateTime.Today.Year - 1, 12, 31)); result.SecondLastYearReturn = GetReturn(entity, preference, new DateTime(DateTime.Today.Year - 2, 1, 1) > firstRecordDateTime ? new DateTime(DateTime.Today.Year - 2, 1, 1) : firstRecordDateTime, new DateTime(DateTime.Today.Year - 2, 12, 31)); result.ThirdLastYearReturn = GetReturn(entity, preference, new DateTime(DateTime.Today.Year - 3, 1, 1) > firstRecordDateTime ? new DateTime(DateTime.Today.Year - 3, 1, 1) : firstRecordDateTime, new DateTime(DateTime.Today.Year - 3, 12, 31)); } catch (Exception) { throw; } return(result); }