public static void UpdateMonthAndYearForSymbol(string table, ExpirationModel expirationModel1, ExpirationModel expirationModel2)
{
var sql = "UPDATE `" + table + "` SET `MonthChar`='" + expirationModel2.MonthChar + "', `Year`=" + expirationModel2.Year +
" WHERE BarTime >= '" + expirationModel1.EndDate.AddDays(1).Date.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture) + "' AND BarTime < '" + expirationModel2.EndDate.AddDays(1).Date.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture) + "' ;COMMIT;";
DoSqlBar(sql);
}
public static List<ExpirationModel> GetExpirationDatesForSymbol(string symbol)
{
var resList = new List<ExpirationModel>();
MySqlDataReader reader = null;
try
{
var str = symbol.Trim().Split('.');
var sql = "Select * from " + TblExpirationDates + " WHERE Symbol = '" + symbol + "' ORDER BY EndDate ASC";
reader = GetReader(sql);
if (reader != null)
{
while (reader.Read())
{
var re = new ExpirationModel()
{
Symbol = reader.GetString(1),
EndDate = reader.GetDateTime(2),
MonthChar = reader.GetString(3),
Year = reader.GetInt32(4)
};
resList.Add(re);
}
}
}
catch (Exception ex)
{
Console.WriteLine("GetExpirationDatesForSymbol.Error: " + ex.Message);
if (reader != null) reader.Close();
}
finally
{
if (reader != null) reader.Close();
}
return resList;
}
