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