public ActionResult Create(Market market)
{
if (ModelState.IsValid)
{
db.Markets.Add(market);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(market);
}
public List<DailyCandle> GetHistoricalData(DateTime Beg, DateTime Endie, Market m)
{
//http://ichart.yahoo.com/table.csv?s=BAS.DE&a=0&b=1&c=2000&d=0&e=31&f=2010&g=w&ignore=.csv
List<DailyCandle> qt = new List<DailyCandle>();
string tester = "";
int a = Beg.Month - 1;
int b = Beg.Day;
int c = Beg.Year;
int d = Endie.Month - 1;
int e = Endie.Day;
int f = Endie.Year;
string yahooURL = @"http://ichart.yahoo.com/table.csv?s=" + m.Symbol + "&a=" + a.ToString() + "&b=" + b.ToString() + "&c=" + c.ToString() + "&d=" + d.ToString() + "&e=" + e.ToString() + "&f=" + f.ToString() + "&g=d&ignore=.csv";
// Initialize a new WebRequest.
HttpWebRequest webreq = (HttpWebRequest)WebRequest.Create(yahooURL);
// Get the response from the Internet resource.
HttpWebResponse webresp = (HttpWebResponse)webreq.GetResponse();
// Read the body of the response from the server.
StreamReader strm =
new StreamReader(webresp.GetResponseStream(), Encoding.ASCII);
String content = content = strm.ReadLine();
while ((content = strm.ReadLine()) != null)
{
content = content.Replace("\"", "");
string[] contents = content.ToString().Split(',');
tester = tester + contents[4] + " - ";
DailyCandle td = new DailyCandle();
td.MarketId = m.MarketId;
td.Date = DateTime.Parse(contents[0]);
td.Open = decimal.Parse(contents[1]);
td.High = decimal.Parse(contents[2]);
td.Low = decimal.Parse(contents[3]);
td.Close = decimal.Parse(contents[4]);
try
{
td.Volume = int.Parse(contents[5]);
}
catch
{
td.Volume = 0;
}
qt.Add(td);
}
strm.Close();
return qt;
}
public ActionResult Edit(Market market)
{
if (ModelState.IsValid)
{
db.Entry(market).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(market);
}