/// <summary>
/// Get all data for selected symbol in selected date
/// </summary>
/// <param name="symbol"></param>
/// <param name="date"></param>
/// <returns></returns>
public static List<TickDataModel> GetTickData(string symbol, DateTime date)
{
var contractModelList = new List<TickDataModel>();
var dateFrom = Convert.ToDateTime(date).ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);
var dateTo = Convert.ToDateTime(date.AddDays(1).Date).ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);
var sql = "SELECT * FROM " + GetTableNameFromContract(symbol) + " WHERE Time BETWEEN '" + dateFrom + "' AND '" + dateTo + "'";
var reader = GetReader(sql);
if (reader != null)
{
while (reader.Read())
{
var cm = new TickDataModel { Date = reader.GetDateTime(1), Price = reader.GetDouble(2) };
contractModelList.Add(cm);
}
reader.Close();
}
return contractModelList;
}
/// <summary>
/// With this function you can get all data
/// of contract
/// </summary>
/// <param name="contractName"></param>
/// <returns></returns>
public static List<TickDataModel> GetContractData(string contractName)
{
var contractModelList = new List<TickDataModel>();
var sql = "SELECT * FROM " + GetTableNameFromContract(contractName);
var reader = GetReader(sql);
if (reader != null)
{
while (reader.Read())
{
var cm = new TickDataModel { Date = reader.GetDateTime(1), Price = reader.GetDouble(2) };
contractModelList.Add(cm);
}
reader.Close();
}
return contractModelList;
}