internal static void UpdateMonthAndYearForSymbols(List <string> selectedSymbols)
{
new Thread(
() =>
{
for (int i = 0; i < selectedSymbols.Count; i++)
{
var listOfTables = ClientDatabaseManager.GetListOfBarTables(selectedSymbols[i]);
int k = 0;
var progr = 0;
var rowsMaxCount = listOfTables.Count;
var cto = (double)rowsMaxCount;
OnProgressBarChanged(2);
foreach (var table in listOfTables)
{
Console.WriteLine("table: " + table);
//try load data from TblExpiration
var listOfExpirations = ClientDatabaseManager.GetExpirationDatesForSymbol(selectedSymbols[i]);
string month, year;
if (!ClientDatabaseManager.MonthCharYearExist(table))
{
ClientDatabaseManager.AddMonthCharYearColumnsToBarTable(table);
}
if (ClientDatabaseManager.YearCharExist(table))
{
ClientDatabaseManager.DeleteWrongColumnsFromTable(table);
}
//Update table: item
if (IsNoCont(table, out month, out year))
{
ClientDatabaseManager.UpdateMonthAndYearForStandardSymbol(table, month, year);
}
else
{
UpdateTableMonthChar(table, listOfExpirations);
}
}
k++;
var newProgr = (int)Math.Round((k / cto) * 100f);
if (newProgr > progr)
{
progr = newProgr;
OnProgressBarChanged(progr);
}
}
OnProgressBarChanged(100);
})
{
Name = "UpdateMonthAndYearForSymbols"
}.Start();
}
public static void BarRequest(string symbolName)
{
try
{
if (!Cel.IsStarted)
{
FinishCollectingSymbol(symbolName, false, 0, "CQG not started");
return;
}
Cel.NewInstrument(symbolName);
var tableName = ClientDatabaseManager.GetBarTableFromSymbol(symbolName, GetTableType(_historicalPeriod));
_aHistoricalPeriod = eHistoricalPeriod.hpUndefined;
if (ClientDatabaseManager.BarTableExist(tableName))
{
if (!ClientDatabaseManager.MonthCharYearExist(tableName))
{
ClientDatabaseManager.AddMonthCharYearColumnsToBarTable(tableName);
}
if (ClientDatabaseManager.YearCharExist(tableName))
{
ClientDatabaseManager.DeleteWrongColumnsFromTable(tableName);
}
if (Settings.Default.MakeBigger)
{
ClientDatabaseManager.MakeBarTableBigger(symbolName, GetTableType(_historicalPeriod));
}
}
else
{
ClientDatabaseManager.CreateBarsTable(symbolName, GetTableType(_historicalPeriod));
}
//DatabaseManager.CreateBarsTable(symbolName, GetTableType(_historicalPeriod));
CQGTimedBarsRequest request = Cel.CreateTimedBarsRequest();
request.RangeStart = _rangeStart;
request.RangeEnd = _rangeEnd;
request.SessionsFilter = _sessionFilter;
request.Symbol = symbolName;
request.Continuation = ConvertToTsts(_continuationType);
request.IntradayPeriod = GetIntradayPeriod(_historicalPeriod);
if (_aHistoricalPeriod != eHistoricalPeriod.hpUndefined)
{
request.HistoricalPeriod = _aHistoricalPeriod;
}
var bars = Cel.RequestTimedBars(request);
var curTimedBars = Cel.AllTimedBars.ItemById[bars.Id];
if (curTimedBars.Status == eRequestStatus.rsInProgress)
{
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}