static void download_us_bond_yields(string URL, Bachlor_EssayEntities db)
{
//connect to quandl
WebClient streamUrl = new WebClient();
streamUrl.BaseAddress = URL;
string URI = URL;
Stream d = streamUrl.OpenRead(URI);
StreamReader reader = new StreamReader(d);
while (reader.Peek() > 0)
{
//download the split the returned string
string s = reader.ReadLine();
string[] data = s.Split(',');
US_Yield g = new US_Yield();
double c;
//make sure you arent getting headers, if its a number push to database
bool can = double.TryParse(data[1], out c);
if (!can)
{
continue;
}
g.Date_of_Bond = Convert.ToDateTime(data[0]);
if (!String.IsNullOrEmpty(data[1]))
{
g.one_mo = Convert.ToDouble(data[1]);
}
if (!String.IsNullOrEmpty(data[2]))
{
g.three_mo = Convert.ToDouble(data[2]);
}
if (!String.IsNullOrEmpty(data[3]))
{
g.six_mo = Convert.ToDouble(data[3]);
}
if (!String.IsNullOrEmpty(data[4]))
{
g.one_yr = Convert.ToDouble(data[4]);
}
if (!String.IsNullOrEmpty(data[5]))
{
g.two_yr = Convert.ToDouble(data[5]);
}
if (!String.IsNullOrEmpty(data[6]))
{
g.three_yr = Convert.ToDouble(data[6]);
}
if (!String.IsNullOrEmpty(data[7]))
{
g.five_yr = Convert.ToDouble(data[7]);
}
if (!String.IsNullOrEmpty(data[8]))
{
g.seven_yr = Convert.ToDouble(data[8]);
}
if (!String.IsNullOrEmpty(data[9]))
{
g.ten_yr = Convert.ToDouble(data[9]);
}
if (!String.IsNullOrEmpty(data[10]))
{
g.twenty_yr = Convert.ToDouble(data[10]);
}
if (!String.IsNullOrEmpty(data[11]))
{
g.thirty_yr = Convert.ToDouble(data[11]);
}
db.US_Yield.Add(g);
}
d.Close();
reader.Close();
db.SaveChanges();
Console.WriteLine("Us Bond Yields Done");
}
static void download_us_bond_yields(string URL, Bachlor_EssayEntities db)
{
WebClient streamUrl = new WebClient();
streamUrl.BaseAddress = URL;
string URI = URL;
Stream d = streamUrl.OpenRead(URI);
StreamReader reader = new StreamReader(d);
while (reader.Peek() > 0)
{
string s = reader.ReadLine();
Console.WriteLine(s);
Console.WriteLine();
string[] data= s.Split(',');
US_Yield g = new US_Yield();
double c;
bool can = double.TryParse(data[1], out c);
if (!can)
{
continue;
}
g.Date_ = data[0];
if(!String.IsNullOrEmpty(data[1]))
g.one_mo = Convert.ToDouble(data[1]);
if (!String.IsNullOrEmpty(data[2]))
g.three_mo = Convert.ToDouble(data[2]);
if (!String.IsNullOrEmpty(data[3]))
g.six_mo = Convert.ToDouble(data[3]);
if (!String.IsNullOrEmpty(data[4]))
g.one_yr = Convert.ToDouble(data[4]);
if (!String.IsNullOrEmpty(data[5]))
g.two_yr = Convert.ToDouble(data[5]);
if (!String.IsNullOrEmpty(data[6]))
g.three_yr = Convert.ToDouble(data[6]);
if (!String.IsNullOrEmpty(data[7]))
g.five_yr = Convert.ToDouble(data[7]);
if (!String.IsNullOrEmpty(data[8]))
g.seven_yr = Convert.ToDouble(data[8]);
if (!String.IsNullOrEmpty(data[9]))
g.ten_yr = Convert.ToDouble(data[9]);
if (!String.IsNullOrEmpty(data[10]))
g.twenty_yr = Convert.ToDouble(data[10]);
if (!String.IsNullOrEmpty(data[11]))
g.thirty_yr = Convert.ToDouble(data[11]);
db.US_Yield.Add(g);
}
db.SaveChanges();
d.Close();
reader.Close();
}
