public static List<DailyValueModel> GetValue(DateTime date, string symbol, bool allDate = false) { if (allDate) return GetAllDailyValues(); var dailyValueModelList = new List<DailyValueModel>(); MySqlDataReader reader = GetReader("SELECT * FROM " + TblDailyValue + " WHERE `Date` = '" + date.ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture) + "' " + "AND " + "`Symbol`= '" + symbol + "' "); if (reader != null) { while (reader.Read()) { var variable = new DailyValueModel(); { variable.id = Convert.ToInt16(reader.GetValue(0)); variable.symbol = reader.GetValue(1).ToString(); variable.IndicativeOpen = Convert.ToDouble(reader.GetValue(2)); variable.Settlement = Convert.ToDouble(reader.GetValue(3)); variable.Marker = Convert.ToDouble(reader.GetValue(4)); variable.TodayMarker = Convert.ToDouble(reader.GetValue(5)); variable.Date = Convert.ToDateTime(reader.GetValue(6)); } dailyValueModelList.Add(variable); } return dailyValueModelList; } return null; }
public static List<DailyValueModel> GetAllDailyValues() { var dailyValueModelList = new List<DailyValueModel>(); Commit(); const string sql = "SELECT * FROM " + TblDailyValue; MySqlDataReader reader = GetReader(sql); if (reader != null) { while (reader.Read()) { var variable = new DailyValueModel { id = Convert.ToInt16(reader.GetValue(0)), symbol = reader.GetValue(1).ToString(), IndicativeOpen = Convert.ToDouble(reader.GetValue(2)), Settlement = Convert.ToDouble(reader.GetValue(3)), Marker = Convert.ToDouble(reader.GetValue(4)), TodayMarker = Convert.ToDouble(reader.GetValue(5)), Date = Convert.ToDateTime(reader.GetValue(6).ToString()) }; dailyValueModelList.Add(variable); } reader.Close(); } return dailyValueModelList; }