public void GivenTheFixedIncomeClosePrices(Table table)
{
var rows = TableHelpers.ToEnumerableDictionary(table);
foreach (var row in rows)
{
var item = new SecurityTimeBarQuerySubResponse
{
Identifiers = new SecurityIdentifiers
{
Ric = row["_FixedIncomeSecurity"],
Isin = row["_FixedIncomeSecurity"],
Sedol = row["_FixedIncomeSecurity"],
ExternalIdentifiers = row["_FixedIncomeSecurity"]
},
Timebars =
{
new TimeBar
{
CloseAsk = double.Parse(row["ClosePrice"]),
CloseBid = double.Parse(row["ClosePrice"]),
CurrencyCode = "GBP",
EpochUtc = DateTime.Parse(row["Date"]).ToUniversalTime().ToTimestamp()
}
}
};
_ruleRunner.FixedIncomeClosePriceMock.Add(item);
}
}
/// <summary>
/// Maps a property
/// </summary>
/// <param name="expression">The expression that returns the property to map</param>
/// <returns>An helper to define the property mapping</returns>
public FluentPropertyMapping <T> Property(Expression <Func <T, object> > expression)
{
var property = TableHelpers.GetExpressionPropertyInfo(expression);
var propertyMapping = typeMapping.Columns[property.Name];
return(new FluentPropertyMapping <T>(propertyMapping));
}
public static System.Web.WebPages.HelperResult TableHeader(System.Web.Mvc.HtmlHelper helper, PropertyMetadata prop, string title, TableHelpers.SortOrder sortOrder)
{
#line default
#line hidden
return(new System.Web.WebPages.HelperResult(__razor_helper_writer => {
if (prop.Sortable)
{
WriteLiteralTo(__razor_helper_writer, " <th");
WriteLiteralTo(__razor_helper_writer, " class=\"sortable\"");
WriteLiteralTo(__razor_helper_writer, " data-name=\"");
WriteTo(__razor_helper_writer, prop.PropertyInfo.Name);
WriteLiteralTo(__razor_helper_writer, "\"");
WriteLiteralTo(__razor_helper_writer, " data-descending=\"");
WriteTo(__razor_helper_writer, TableHelpers.IsOppositeOrderDescending(sortOrder).ToString());
WriteLiteralTo(__razor_helper_writer, "\"");
WriteLiteralTo(__razor_helper_writer, ">\r\n <div");
WriteLiteralTo(__razor_helper_writer, " class=\"sortable\"");
WriteLiteralTo(__razor_helper_writer, ">\r\n");
WriteLiteralTo(__razor_helper_writer, " ");
WriteTo(__razor_helper_writer, title);
WriteLiteralTo(__razor_helper_writer, "\r\n <span");
WriteAttributeTo(__razor_helper_writer, "class", Tuple.Create(" class=\"", 3801), Tuple.Create("\"", 3848)
, Tuple.Create(Tuple.Create("", 3809), Tuple.Create("fa", 3809), true)
, Tuple.Create(Tuple.Create(" ", 3811), Tuple.Create <System.Object, System.Int32>(TableHelpers.GetSortIcon(sortOrder)
, 3812), false)
);
WriteLiteralTo(__razor_helper_writer, " style=\"margin-right: 5px\"");
WriteLiteralTo(__razor_helper_writer, "></span>\r\n </div>\r\n </th>\r\n");
}
else
{
WriteLiteralTo(__razor_helper_writer, " <th>");
WriteTo(__razor_helper_writer, title);
WriteLiteralTo(__razor_helper_writer, "</th>\r\n");
}
}));
#line default
#line hidden
}
/// <summary>
/// Defines the primary key
/// </summary>
/// <param name="expression">An expression that selects the primary key</param>
public void HasKey(Expression <Func <T, object> > expression)
{
var propertyInfo = TableHelpers.GetExpressionPropertyInfo(expression);
typeMapping.Key = typeMapping.Columns[propertyInfo.Name];
typeMapping.Key.IsKey = true;
if (propertyInfo.PropertyType == typeof(int) || propertyInfo.PropertyType == typeof(long))
{
typeMapping.Key.IsAutomatic = true;
}
}
static async Task Main(string[] args)
{
Console.WriteLine("Welcome to the Heroes Table Storage sample!");
Console.WriteLine("Let's connect to our table");
string connectionString = AppSettings.LoadAppSettings().ConnectionString;
CloudTableClient tableClient = TableHelpers.ConnectToClient(connectionString);
CloudTable cloudTable = tableClient.GetTableReference("HeroesDB");
List <HeroEntity> heroes = GenerateHeros();
try
{
foreach (var hero in heroes)
{
await OperationsHelper.InsertOrMergeHero(cloudTable, hero);
}
Console.WriteLine("Let's see if we can find Superman! Performing a read.");
var superman = await OperationsHelper.GetHero(cloudTable, "Superman", "Clark Kent");
Console.WriteLine("Wait, his hometown isn't right! Let's update it.");
superman.Hometown = "Kryptonopolis";
await OperationsHelper.InsertOrMergeHero(cloudTable, superman);
Console.WriteLine("Let's 'snap' Tony Stark out of the Universe (too soon?).");
HeroEntity tonyStark = await OperationsHelper.GetHero(cloudTable, "Iron Man", "Tony Stark");
await OperationsHelper.DeleteHero(cloudTable, tonyStark);
Console.WriteLine("Love you 3000");
Console.WriteLine("Sample over. Press any key to exit....");
Console.ReadKey();
}
catch (Exception ex)
{
Console.WriteLine($"Something went wrong. Exception thrown: {ex.Message}");
Console.ReadLine();
throw;
}
}
public void GivenTheEquityClosePrices(Table table)
{
var rows = TableHelpers.ToEnumerableDictionary(table);
foreach (var row in rows)
{
var item = new FactsetSecurityDailyResponseItem
{
Epoch = DateTime.Parse(row["Date"], null, DateTimeStyles.AssumeUniversal),
ClosePrice = Convert.ToDecimal(row["ClosePrice"]),
Figi = IdentifierHelpers.ToIsinOrFigi(row["_EquitySecurity"]),
Currency = "GBP",
DailyVolume = row.ValueOrNull("DailyVolume") != null?Convert.ToInt64(row.ValueOrNull("DailyVolume")) : 0
};
_ruleRunner.EquityClosePriceMock.Add(item);
}
}
public void GivenTheAllocations(Table table)
{
var rows = TableHelpers.ToEnumerableDictionary(table);
_ruleRunner.AllocationCsvContent = MakeCsv(rows);
}
public void GivenTheOrders(Table table)
{
var rows = TableHelpers.ToEnumerableDictionary(table);
// expand special columns
foreach (var row in rows)
{
if (row.ContainsKey("_Date"))
{
var value = row["_Date"];
row.AddIfNotExists("OrderPlacedDate", value);
row.AddIfNotExists("OrderBookedDate", value);
row.AddIfNotExists("OrderAmendedDate", value);
row.AddIfNotExists("OrderFilledDate", value);
}
if (row.ContainsKey("_Volume"))
{
var value = row["_Volume"];
row.AddIfNotExists("OrderOrderedVolume", value);
row.AddIfNotExists("OrderFilledVolume", value);
}
if (row.ContainsKey("_EquitySecurity"))
{
var value = row["_EquitySecurity"];
var identifier = IdentifierHelpers.ToIsinOrFigi(value);
row.AddIfNotExists("MarketType", "STOCKEXCHANGE");
row.AddIfNotExists("OrderCurrency", "GBP");
row.AddIfNotExists("OrderType", "MARKET");
row.AddIfNotExists("InstrumentIsin", identifier);
row.AddIfNotExists("InstrumentFigi", identifier);
row.AddIfNotExists("MarketIdentifierCode", "XLON");
row.AddIfNotExists("InstrumentCfi", "e");
}
if (row.ContainsKey("_FixedIncomeSecurity"))
{
var value = row["_FixedIncomeSecurity"];
row.AddIfNotExists("MarketType", "STOCKEXCHANGE");
row.AddIfNotExists("OrderCurrency", "GBP");
row.AddIfNotExists("OrderType", "MARKET");
row.AddIfNotExists("InstrumentRic", value);
row.AddIfNotExists("MarketIdentifierCode", "RDFI");
row.AddIfNotExists("MarketName", "RDFI");
row.AddIfNotExists("InstrumentCfi", "d");
var identifier = IdentifierHelpers.ToIsinOrFigi(value);
row.AddIfNotExists("InstrumentIsin", identifier);
}
}
_ruleRunner.TradeCsvContent = MakeCsv(rows);
// default allocations
if (_ruleRunner.AllocationCsvContent == null)
{
var allocationRows = rows.Select(x => new Dictionary <string, string>
{
["OrderId"] = x["OrderId"],
["Fund"] = "",
["Strategy"] = "",
["ClientAccountId"] = "",
["OrderFilledVolume"] = x.ValueOrNull("OrderFilledVolume")
});
_ruleRunner.AllocationCsvContent = MakeCsv(allocationRows);
}
}
