void LoadAlreadyRegisteredEvent()
{
// Load data from global_event table
string query = String.Format(
"select * from global_event where EventDate > '{0}'",
_dtStart.AddYears(-2));
DataRowCollection rows = DBUtil.SelectFromDB(query, Config_DB.kDatabase);
foreach (DataRow row in rows)
{
string country = Convert.ToString(row["Country"]);
string eventType = Convert.ToString(row["EventType"]);
DateTime eventDate = Convert.ToDateTime(row["EventDate"]);
string eventDesc = Convert.ToString(row["Event"]);
eventDesc = eventDesc.Substring(eventDesc.IndexOf("]"));
string key = GlobalEventKey.CreateKey(country, eventType, eventDate);
GlobalEventDatum datum = new GlobalEventDatum();
datum.Key = key;
datum.Country = country;
datum.EventType = eventType;
datum.EventDate = eventDate;
datum.Event = eventDesc;
_registeredEvents.Add(key, datum);
}
}
void Load_Rate()
{
List<Tuple<DateTime, string>> events = new List<Tuple<DateTime, string>>();
List<Tuple<DateTime, double>> marketData = MarketDataUtil.GetMarketData(
_datum.RateCode, _dtStart, _dtEnd);
string eventType = EventType.TargetRate.ToString();
for (int i = 0; i < marketData.Count - 1; ++i)
{
Tuple<DateTime, double> prev = marketData[i];
Tuple<DateTime, double> cur = marketData[i + 1];
if (!DoubleUtil.IsSameDouble(prev.Item2, cur.Item2, 2))
{
string upDown = "up";
if (prev.Item2 > cur.Item2)
{
upDown = "down";
}
string desc = String.Format("[{4}] {0}, {1}, {2:n2} -> {3:n2} {5}", cur.Item1.ToString("yyyy-MM-dd"),
_datum.CountryCode, prev.Item2, cur.Item2, eventType, upDown);
string key =
GlobalEventKey.CreateKey(_datum.CountryCode, eventType, cur.Item1);
if (_registeredEvents.ContainsKey(key))
{
//pass
continue;
}
GlobalEventDatum datum = new GlobalEventDatum();
datum.Key = key;
datum.Country = _datum.CountryCode;
datum.EventType = eventType;
datum.EventDate = cur.Item1;
datum.Event = desc;
_newEvents.Add(key, datum);
}
}
}