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; }