public ComponentDTOModel GetComponent(ComponentDTOModel componentDTOModel)
{
try
{
componentDTOModel = _repository.GetComponent(componentDTOModel);
return(componentDTOModel);
}
catch (Exception e)
{
LogCritical("|" + MethodBase.GetCurrentMethod() + "|" + e.Message);
return(new ComponentDTOModel()
{
ErrorMessage = e.Message,
});
}
}
/// <summary>
/// Retrieve a ComponentDTOModel
/// <para>Returns ComponentDTOModel</para>
/// </summary>
/// <returns>ComponentDTOModel</returns>
public ComponentDTOModel GetComponent(ComponentDTOModel componentDTOModel)
{
Component component = componentDTOModel.Item;
using IDatabase db = Conn();
try
{
try
{
List <ColumnMapping> cols = db.Fetch <ColumnMapping>("exec rpt.GetReportComponentMetadata @ComponentGUID",
new
{
ComponentID = component.ComponentGUID,
}
);
List <Column> columns = new List <Column>();
foreach (ColumnMapping col in cols)
{
columns.Add(col.GetColumn());
}
component.ColumnMetaData = new ColumnMetaData();
component.ColumnMetaData.AvailableColumns = columns;
component.ColumnMetaData.SelectedColumns = columns;
//ColumnMetaData columnMetaData = db.Single<ReportMetaData>("exec rpt.GetReportMetaData");
//reportDTOModel.ColumnMetaData = columnMetaData;
//reportDTOModel.Items = employeeString;
//reportDTOModel.TotalItems = 2;
return(componentDTOModel);
}
catch (Exception e)
{
LogCritical("|" + MethodBase.GetCurrentMethod() + "|" + e.Message);
throw new Exception(e.Message);
}
}
catch (Exception e)
{
LogCritical("|" + MethodBase.GetCurrentMethod() + "|" + e.Message);
throw new Exception(e.Message);
}
}
private void GetComponent(string id)
{
ComponentDTOModel componentDTOModel = new ComponentDTOModel()
{
Item = new Component()
{
ComponentGUID = id
}
};
componentDTOModel = _service.GetComponent(componentDTOModel);
if (componentDTOModel.HasError)
{
this.ErrorMessage = componentDTOModel.ErrorMessage;
}
else
{
Component = componentDTOModel.Item;
}
}
private Component GetComponent(string id)
{
ComponentDTOModel componentDTOModel = new ComponentDTOModel()
{
Item = new Component()
{
ComponentGUID = id
}
};
componentDTOModel = _service.GetComponent(componentDTOModel);
if (componentDTOModel.HasError)
{
this.ErrorMessage = componentDTOModel.ErrorMessage;
return(null);
}
else
{
return(componentDTOModel.Item);
}
}
public ComponentDTOModel GetComponent(ComponentDTOModel componentDTOModel)
{
Component component = componentDTOModel.Item;
switch (component.ComponentGUID)
{
//Data table
case "111111-22222-33333":
component.ComponentMetaData = new ComponentMetaData()
{
GUID = "111111-22222-33333",
Name = "Test Component 1",
Description = "Test Component 1 Description",
ComponentType = ComponentMetaData.ComponentTypeValue.Table,
ComponentTitle = "Full UVIMCO Portfolio Review - Performance",
ComponentHeader = "",
ComponentFootNote = "",
};
component.ColumnMetaData = new ColumnMetaData()
{
AvailableColumns = new List <Column>()
{
new Column("Year", "eg 1900", "yr", Column.DataTypeValue.String, false, false, true),
new Column("Jan", "", "Jan", Column.DataTypeValue.Decimal, false, false, true),
new Column("Feb", "", "Feb", Column.DataTypeValue.Decimal, false, false, true),
new Column("Mar", "", "Mar", Column.DataTypeValue.Decimal, false, false, true),
new Column("Apr", "", "Apr", Column.DataTypeValue.Decimal, false, false, true),
new Column("May", "", "May", Column.DataTypeValue.Decimal, false, false, true),
new Column("Jun", "", "Jun", Column.DataTypeValue.Decimal, false, false, true),
new Column("Jul", "", "Jul", Column.DataTypeValue.Decimal, false, false, true),
new Column("Aug", "", "Aug", Column.DataTypeValue.Decimal, false, false, true),
new Column("Sep", "", "Sep", Column.DataTypeValue.Decimal, false, false, true),
new Column("Oct", "", "Oct", Column.DataTypeValue.Decimal, false, false, true),
new Column("Nov", "", "Nov", Column.DataTypeValue.Decimal, false, false, true),
new Column("Dec", "", "Dec", Column.DataTypeValue.Decimal, false, false, true),
new Column("Jan_mv", "", "Jan_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Feb_mv", "", "Feb_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Mar_mv", "", "Mar_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Apr_mv", "", "Apr_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("May_mv", "", "May_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Jun_mv", "", "Jun_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Jul_mv", "", "Jul_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Aug_mv", "", "Aug_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Sep_mv", "", "Sep_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Oct_mv", "", "Oct_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Nov_mv", "", "Nov_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Dec_mv", "", "Dec_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Jan_src", "", "Jan_src", Column.DataTypeValue.String, false, false, false),
new Column("Feb_src", "", "Feb_src", Column.DataTypeValue.String, false, false, false),
new Column("Mar_src", "", "Mar_src", Column.DataTypeValue.String, false, false, false),
new Column("Apr_src", "", "Apr_src", Column.DataTypeValue.String, false, false, false),
new Column("May_src", "", "May_src", Column.DataTypeValue.String, false, false, false),
new Column("Jun_src", "", "Jun_src", Column.DataTypeValue.String, false, false, false),
new Column("Jul_src", "", "Jul_src", Column.DataTypeValue.String, false, false, false),
new Column("Aug_src", "", "Aug_src", Column.DataTypeValue.String, false, false, false),
new Column("Sep_src", "", "Sep_src", Column.DataTypeValue.String, false, false, false),
new Column("Oct_src", "", "Oct_src", Column.DataTypeValue.String, false, false, false),
new Column("Nov_src", "", "Nov_src", Column.DataTypeValue.String, false, false, false),
new Column("Dec_src", "", "Dec_src", Column.DataTypeValue.String, false, false, false),
new Column("CCYR", "", "CCYR", Column.DataTypeValue.Currency, false, false, false),
new Column("CYR", "", "ACCYR", Column.DataTypeValue.Currency, false, false, true),
new Column("CCYR_count", "", "CCYR_count", Column.DataTypeValue.Currency, false, false, false),
new Column("CFYR", "", "CFYR", Column.DataTypeValue.Currency, false, false, false),
new Column("FYR", "", "ACFYR", Column.DataTypeValue.Currency, false, false, true),
new Column("CFYR_count", "", "CFYR_count", Column.DataTypeValue.Currency, false, false, false),
new Column("UVIMCO Strategy", "", "bmk_uvimco_strategy", Column.DataTypeValue.Currency, false, false, true),
new Column("MSCI ACWI", "", "bmk_msci_acwi", Column.DataTypeValue.Currency, false, false, false),
},
SelectedColumns = new List <Column>()
{
new Column("Year", "eg 1900", "yr", Column.DataTypeValue.String, false, false, true),
new Column("Jan", "", "Jan", Column.DataTypeValue.Decimal, false, false, true),
new Column("Feb", "", "Feb", Column.DataTypeValue.Decimal, false, false, true),
new Column("Mar", "", "Mar", Column.DataTypeValue.Decimal, false, false, true),
new Column("Apr", "", "Apr", Column.DataTypeValue.Decimal, false, false, true),
new Column("May", "", "May", Column.DataTypeValue.Decimal, false, false, true),
new Column("Jun", "", "Jun", Column.DataTypeValue.Decimal, false, false, true),
new Column("Jul", "", "Jul", Column.DataTypeValue.Decimal, false, false, true),
new Column("Aug", "", "Aug", Column.DataTypeValue.Decimal, false, false, true),
new Column("Sep", "", "Sep", Column.DataTypeValue.Decimal, false, false, true),
new Column("Oct", "", "Oct", Column.DataTypeValue.Decimal, false, false, true),
new Column("Nov", "", "Nov", Column.DataTypeValue.Decimal, false, false, true),
new Column("Dec", "", "Dec", Column.DataTypeValue.Decimal, false, false, true),
new Column("Jan_mv", "", "Jan_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Feb_mv", "", "Feb_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Mar_mv", "", "Mar_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Apr_mv", "", "Apr_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("May_mv", "", "May_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Jun_mv", "", "Jun_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Jul_mv", "", "Jul_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Aug_mv", "", "Aug_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Sep_mv", "", "Sep_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Oct_mv", "", "Oct_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Nov_mv", "", "Nov_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Dec_mv", "", "Dec_mv", Column.DataTypeValue.Decimal, false, false, false),
new Column("Jan_src", "", "Jan_src", Column.DataTypeValue.String, false, false, false),
new Column("Feb_src", "", "Feb_src", Column.DataTypeValue.String, false, false, false),
new Column("Mar_src", "", "Mar_src", Column.DataTypeValue.String, false, false, false),
new Column("Apr_src", "", "Apr_src", Column.DataTypeValue.String, false, false, false),
new Column("May_src", "", "May_src", Column.DataTypeValue.String, false, false, false),
new Column("Jun_src", "", "Jun_src", Column.DataTypeValue.String, false, false, false),
new Column("Jul_src", "", "Jul_src", Column.DataTypeValue.String, false, false, false),
new Column("Aug_src", "", "Aug_src", Column.DataTypeValue.String, false, false, false),
new Column("Sep_src", "", "Sep_src", Column.DataTypeValue.String, false, false, false),
new Column("Oct_src", "", "Oct_src", Column.DataTypeValue.String, false, false, false),
new Column("Nov_src", "", "Nov_src", Column.DataTypeValue.String, false, false, false),
new Column("Dec_src", "", "Dec_src", Column.DataTypeValue.String, false, false, false),
new Column("CCYR", "", "CCYR", Column.DataTypeValue.Decimal, false, false, false),
new Column("CYR", "", "ACCYR", Column.DataTypeValue.Decimal, false, false, true),
new Column("CCYR_count", "", "CCYR_count", Column.DataTypeValue.Decimal, false, false, false),
new Column("CFYR", "", "CFYR", Column.DataTypeValue.Decimal, false, false, false),
new Column("FYR", "", "ACFYR", Column.DataTypeValue.Decimal, false, false, true),
new Column("CFYR_count", "", "CFYR_count", Column.DataTypeValue.Decimal, false, false, false),
new Column("UVIMCO Strategy", "", "bmk_uvimco_strategy", Column.DataTypeValue.String, false, false, true),
new Column("MSCI ACWI", "", "bmk_msci_acwi", Column.DataTypeValue.String, false, false, true),
},
};
DataSet dataSet = new DataSet();
DataTable dataTable = new DataTable();
dataTable.Columns.Add("yr", typeof(String));
dataTable.Columns.Add("Jan", typeof(decimal));
dataTable.Columns.Add("Feb", typeof(decimal));
dataTable.Columns.Add("Mar", typeof(decimal));
dataTable.Columns.Add("Apr", typeof(decimal));
dataTable.Columns.Add("May", typeof(decimal));
dataTable.Columns.Add("Jun", typeof(decimal));
dataTable.Columns.Add("Jul", typeof(decimal));
dataTable.Columns.Add("Aug", typeof(decimal));
dataTable.Columns.Add("Sep", typeof(decimal));
dataTable.Columns.Add("Oct", typeof(decimal));
dataTable.Columns.Add("Nov", typeof(decimal));
dataTable.Columns.Add("Dec", typeof(decimal));
dataTable.Columns.Add("Jan_mv", typeof(decimal));
dataTable.Columns.Add("Feb_mv", typeof(decimal));
dataTable.Columns.Add("Mar_mv", typeof(decimal));
dataTable.Columns.Add("Apr_mv", typeof(decimal));
dataTable.Columns.Add("May_mv", typeof(decimal));
dataTable.Columns.Add("Jun_mv", typeof(decimal));
dataTable.Columns.Add("Jul_mv", typeof(decimal));
dataTable.Columns.Add("Aug_mv", typeof(decimal));
dataTable.Columns.Add("Sep_mv", typeof(decimal));
dataTable.Columns.Add("Oct_mv", typeof(decimal));
dataTable.Columns.Add("Nov_mv", typeof(decimal));
dataTable.Columns.Add("Dec_mv", typeof(decimal));
dataTable.Columns.Add("Jan_src", typeof(String));
dataTable.Columns.Add("Feb_src", typeof(String));
dataTable.Columns.Add("Mar_src", typeof(String));
dataTable.Columns.Add("Apr_src", typeof(String));
dataTable.Columns.Add("May_src", typeof(String));
dataTable.Columns.Add("Jun_src", typeof(String));
dataTable.Columns.Add("Jul_src", typeof(String));
dataTable.Columns.Add("Aug_src", typeof(String));
dataTable.Columns.Add("Sep_src", typeof(String));
dataTable.Columns.Add("Oct_src", typeof(String));
dataTable.Columns.Add("Nov_src", typeof(String));
dataTable.Columns.Add("Dec_src", typeof(String));
dataTable.Columns.Add("CCYR", typeof(long));
dataTable.Columns.Add("ACCYR", typeof(long));
dataTable.Columns.Add("CCYR_count", typeof(int));
dataTable.Columns.Add("CFYR", typeof(long));
dataTable.Columns.Add("ACFYR", typeof(long));
dataTable.Columns.Add("CFYR_count", typeof(int));
dataTable.Columns.Add("bmk_uvimco_strategy", typeof(String));
dataTable.Columns.Add("bmk_msci_acwi", typeof(String));
DataRow row = dataTable.NewRow();
row["yr"] = "2011";
row["Jan"] = 0.003517;
row["Feb"] = 0.018995;
row["Mar"] = 0.016337;
row["Apr"] = 0.024354;
row["May"] = 0.012683;
row["Jun"] = 0.024106;
row["Jul"] = 0.006856;
row["Aug"] = -0.020131;
row["Sep"] = -0.030129;
row["Oct"] = 0.022629;
row["Nov"] = -0.00848;
row["Dec"] = -0.003181;
row["Jan_mv"] = 4931604312.4000000000;
row["Feb_mv"] = 5028110625.8000000000;
row["Mar_mv"] = 5109422325.7000000000;
row["Apr_mv"] = 5236504158.8000000000;
row["May_mv"] = 5229364442.5000000000;
row["Jun_mv"] = 5346502216.2000000000;
row["Jul_mv"] = 5380438937.4000000000;
row["Aug_mv"] = 5264985707.4000000000;
row["Sep_mv"] = 5099811060.0000000000;
row["Oct_mv"] = 5212256142.2000000000;
row["Nov_mv"] = 5087746371.0000000000;
row["Dec_mv"] = 5067346468.3000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.067795942;
row["ACCYR"] = 0.067795942;
row["CCYR_count"] = 12;
row["CFYR"] = 0.242928896;
row["ACFYR"] = 0.242928896;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2012";
row["Jan"] = 0.025296;
row["Feb"] = 0.029299;
row["Mar"] = 0.014897;
row["Apr"] = 0.011438;
row["May"] = -0.012664;
row["Jun"] = 0.016105;
row["Jul"] = 0.005692;
row["Aug"] = 0.012281;
row["Sep"] = 0.011941;
row["Oct"] = -0.000295;
row["Nov"] = 0.015646;
row["Dec"] = 0.008332;
row["Jan_mv"] = 5193700725.5000000000;
row["Feb_mv"] = 5354121923.5000000000;
row["Mar_mv"] = 5432895854.6000000000;
row["Apr_mv"] = 5491140264.3000000000;
row["May_mv"] = 5347885328.4000000000;
row["Jun_mv"] = 5430017096.8000000000;
row["Jul_mv"] = 5462607474.1000000000;
row["Aug_mv"] = 5526763015.5000000000;
row["Sep_mv"] = 5591491234.1000000000;
row["Oct_mv"] = 5596209869.7000000000;
row["Nov_mv"] = 5678151725.7000000000;
row["Dec_mv"] = 5723390524.8000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.146290411;
row["ACCYR"] = 0.146290411;
row["CCYR_count"] = 12;
row["CFYR"] = 0.0510923;
row["ACFYR"] = 0.0510923;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2013";
row["Jan"] = 0.022026;
row["Feb"] = 0.008012;
row["Mar"] = 0.019731;
row["Apr"] = 0.014331;
row["May"] = 0.013904;
row["Jun"] = -0.004737;
row["Jul"] = 0.008999;
row["Aug"] = -0.004985;
row["Sep"] = 0.025306;
row["Oct"] = 0.019063;
row["Nov"] = 0.014232;
row["Dec"] = 0.019459;
row["Jan_mv"] = 5787055973.9000000000;
row["Feb_mv"] = 5830067337.9000000000;
row["Mar_mv"] = 5942287572.6000000000;
row["Apr_mv"] = 5983104069.2000000000;
row["May_mv"] = 5985505188.4000000000;
row["Jun_mv"] = 5959541292.1000000000;
row["Jul_mv"] = 6012975867.4000000000;
row["Aug_mv"] = 5980762658.8000000000;
row["Sep_mv"] = 6123544630.8000000000;
row["Oct_mv"] = 6239957412.3000000000;
row["Nov_mv"] = 6306371255.2000000000;
row["Dec_mv"] = 6393780257.9000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.166298271;
row["ACCYR"] = 0.166298271;
row["CCYR_count"] = 12;
row["CFYR"] = 0.134140116;
row["ACFYR"] = 0.134140116;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2014";
row["Jan"] = -0.007889;
row["Feb"] = 0.027473;
row["Mar"] = -0.001486;
row["Apr"] = 0.000354;
row["May"] = 0.038469;
row["Jun"] = 0.037634;
row["Jul"] = -0.005104;
row["Aug"] = 0.013587;
row["Sep"] = -0.010838;
row["Oct"] = 0.001197;
row["Nov"] = 0.015392;
row["Dec"] = -0.004807;
row["Jan_mv"] = 6340720750.5000000000;
row["Feb_mv"] = 6514315139.7000000000;
row["Mar_mv"] = 6514219163.2000000000;
row["Apr_mv"] = 6514840100.3000000000;
row["May_mv"] = 6702267377.9000000000;
row["Jun_mv"] = 6949542818.8000000000;
row["Jul_mv"] = 6908137170.2000000000;
row["Aug_mv"] = 7002139163.1000000000;
row["Sep_mv"] = 6956596587.7000000000;
row["Oct_mv"] = 6937116067.5000000000;
row["Nov_mv"] = 7036899958.9000000000;
row["Dec_mv"] = 7037249106.6000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.107243183;
row["ACCYR"] = 0.107243183;
row["CCYR_count"] = 12;
row["CFYR"] = 0.190030944;
row["ACFYR"] = 0.190030944;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2015";
row["Jan"] = -0.001805;
row["Feb"] = 0.027337;
row["Mar"] = 0.01356;
row["Apr"] = -0.000938;
row["May"] = 0.02276;
row["Jun"] = 0.005166;
row["Jul"] = 0.010623;
row["Aug"] = -0.015402;
row["Sep"] = -0.015377;
row["Oct"] = 0.015156;
row["Nov"] = 0.002278;
row["Dec"] = -0.004134;
row["Jan_mv"] = 7020049706.7000000000;
row["Feb_mv"] = 7205947474.1000000000;
row["Mar_mv"] = 7261936214.6000000000;
row["Apr_mv"] = 7233395719.0000000000;
row["May_mv"] = 7375556639.0000000000;
row["Jun_mv"] = 7528349543.0000000000;
row["Jul_mv"] = 7604289028.4000000000;
row["Aug_mv"] = 7478583214.6000000000;
row["Sep_mv"] = 7365517627.5000000000;
row["Oct_mv"] = 7474660522.7000000000;
row["Nov_mv"] = 7482526048.8000000000;
row["Dec_mv"] = 7448191686.4000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.059794692;
row["ACCYR"] = 0.059794692;
row["CCYR_count"] = 12;
row["CFYR"] = 0.077329316;
row["ACFYR"] = 0.077329316;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2016";
row["Jan"] = -0.028572;
row["Feb"] = -0.013852;
row["Mar"] = 0.026261;
row["Apr"] = 0.00967;
row["May"] = 0.000467;
row["Jun"] = -0.001342;
row["Jul"] = 0.015747;
row["Aug"] = 0.012127;
row["Sep"] = 0.013548;
row["Oct"] = -0.002676;
row["Nov"] = 0.008402;
row["Dec"] = 0.004985;
row["Jan_mv"] = 7280665449.5000000000;
row["Feb_mv"] = 7227557673.1000000000;
row["Mar_mv"] = 7460938065.3000000000;
row["Apr_mv"] = 7583868782.4000000000;
row["May_mv"] = 7632304588.5000000000;
row["Jun_mv"] = 7619353872.2000000000;
row["Jul_mv"] = 7738798411.3000000000;
row["Aug_mv"] = 7835699998.1000000000;
row["Sep_mv"] = 7939035088.8000000000;
row["Oct_mv"] = 7935138084.1000000000;
row["Nov_mv"] = 7995204448.3000000000;
row["Dec_mv"] = 8035026499.6000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.04448925;
row["ACCYR"] = 0.04448925;
row["CCYR_count"] = 12;
row["CFYR"] = -0.015423334;
row["ACFYR"] = -0.015423334;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2017";
row["Jan"] = 0.025296;
row["Feb"] = 0.029299;
row["Mar"] = 0.014897;
row["Apr"] = 0.011438;
row["May"] = -0.012664;
row["Jun"] = 0.016105;
row["Jul"] = 0.005692;
row["Aug"] = 0.012281;
row["Sep"] = 0.011941;
row["Oct"] = -0.000295;
row["Nov"] = 0.015646;
row["Dec"] = 0.008332;
row["Jan_mv"] = 5193700725.5000000000;
row["Feb_mv"] = 5354121923.5000000000;
row["Mar_mv"] = 5432895854.6000000000;
row["Apr_mv"] = 5491140264.3000000000;
row["May_mv"] = 5347885328.4000000000;
row["Jun_mv"] = 5430017096.8000000000;
row["Jul_mv"] = 5462607474.1000000000;
row["Aug_mv"] = 5526763015.5000000000;
row["Sep_mv"] = 5591491234.1000000000;
row["Oct_mv"] = 5596209869.7000000000;
row["Nov_mv"] = 5678151725.7000000000;
row["Dec_mv"] = 5723390524.8000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.146290411;
row["ACCYR"] = 0.146290411;
row["CCYR_count"] = 12;
row["CFYR"] = 0.0510923;
row["ACFYR"] = 0.0510923;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
row = dataTable.NewRow();
row["yr"] = "2018";
row["Jan"] = 0.025296;
row["Feb"] = 0.029299;
row["Mar"] = 0.014897;
row["Apr"] = 0.011438;
row["May"] = -0.012664;
row["Jun"] = 0.016105;
row["Jul"] = 0.005692;
row["Aug"] = 0.012281;
row["Sep"] = 0.011941;
row["Oct"] = -0.000295;
row["Nov"] = 0.015646;
row["Dec"] = 0.008332;
row["Jan_mv"] = 5193700725.5000000000;
row["Feb_mv"] = 5354121923.5000000000;
row["Mar_mv"] = 5432895854.6000000000;
row["Apr_mv"] = 5491140264.3000000000;
row["May_mv"] = 5347885328.4000000000;
row["Jun_mv"] = 5430017096.8000000000;
row["Jul_mv"] = 5462607474.1000000000;
row["Aug_mv"] = 5526763015.5000000000;
row["Sep_mv"] = 5591491234.1000000000;
row["Oct_mv"] = 5596209869.7000000000;
row["Nov_mv"] = 5678151725.7000000000;
row["Dec_mv"] = 5723390524.8000000000;
row["Jan_src"] = "UVIMCO";
row["Feb_src"] = "UVIMCO";
row["Mar_src"] = "UVIMCO";
row["Apr_src"] = "UVIMCO";
row["May_src"] = "UVIMCO";
row["Jun_src"] = "UVIMCO";
row["Jul_src"] = "UVIMCO";
row["Aug_src"] = "UVIMCO";
row["Sep_src"] = "UVIMCO";
row["Oct_src"] = "UVIMCO";
row["Nov_src"] = "UVIMCO";
row["Dec_src"] = "UVIMCO";
row["CCYR"] = 0.146290411;
row["ACCYR"] = 0.146290411;
row["CCYR_count"] = 12;
row["CFYR"] = 0.0510923;
row["ACFYR"] = 0.0510923;
row["CFYR_count"] = 12;
row["bmk_uvimco_strategy"] = null;
row["bmk_msci_acwi"] = null;
dataTable.Rows.Add(row);
JArray dataString = ConvertDataTabletoJSON(dataTable);
component.Items = dataString;
break;
case "111111-22222-44444":
component.ComponentMetaData = new ComponentMetaData()
{
GUID = "111111-22222-44444",
Name = "Pie Chart Component (111111-22222-44444)",
Description = "Pie Chart Component (111111-22222-44444) Description",
ComponentType = ComponentMetaData.ComponentTypeValue.Pie,
ComponentTitle = "Pie Chart Sector",
ComponentHeader = "Pie Chart Sector Header",
ComponentFootNote = "Pie Chart Sector Footnote",
};
component.ColumnMetaData = new ColumnMetaData()
{
AvailableColumns = new List <Column>()
{
new Column("Sector", "eg Tech", "sector", Column.DataTypeValue.String, false, false, true),
new Column("Percent", "eg 10", "percent", Column.DataTypeValue.Decimal, false, false, true),
},
SelectedColumns = new List <Column>()
{
new Column("Sector", "eg Tech", "sector", Column.DataTypeValue.String, false, false, true),
new Column("Percent", "eg 10", "percent", Column.DataTypeValue.Decimal, false, false, true),
},
};
dataSet = new DataSet();
dataTable = new DataTable();
dataTable.Columns.Add("sector", typeof(String));
dataTable.Columns.Add("percent", typeof(decimal));
dataTable.Rows.Add(new Object[] { "Tech", 3 });
dataTable.Rows.Add(new Object[] { "Medical", 1 });
dataTable.Rows.Add(new Object[] { "Aerospace", 2 });
dataTable.Rows.Add(new Object[] { "Banking", 1 });
dataTable.Rows.Add(new Object[] { "Misc", 2 });
component.Items = ConvertDataTabletoJSON(dataTable);
component.ChartOptions = new ComponentPieChartOptions()
{
Title = "Holdings",
Is3D = true,
LegendAlignment = ComponentChartOptions.LegendAlignmentValue.Center,
LegendLocation = ComponentChartOptions.LegendLocationValue.Top,
LegendTextFontBold = true,
LegendTextFontItalic = true,
LegendTextColor = "red",
PieHole = 0.0M,
EnableInteractivity = true,
Width = 600,
Height = 400
};
component.TableOptions = new ComponentTableOptions();
break;
}
return(componentDTOModel);
}
public async Task <ComponentDTOModel> GetComponentAsync(CancellationToken token, ComponentDTOModel componentDTOModel)
{
return(await Task.FromResult <ComponentDTOModel>(GetComponent(componentDTOModel)));
}
/// <summary>
/// Retrieve a Component and it's Meta Data
/// <para>Returns ComponentDTOModel</para>
/// </summary>
/// <returns>ComponentDTOModel</returns>
public async Task <ComponentDTOModel> GetComponentAsync(ComponentDTOModel componentDTOModel)
{
return(await GetComponentAsync(new CancellationToken(false), componentDTOModel));
}
