static void Main(string[] args)
{
SQ.StockQuote Qoute = new SQ.StockQuote();
String Price, Time, Symbol, Company = "";
XmlDocument doc = new XmlDocument();
XmlNode SelectName, SelectTotal, SelectTime, SelectDate, SelectCompany;
List<string> symbols = new List<string>();
List<string> CompanyName = new List<string>();
StreamWriter write = new StreamWriter(ConfigurationManager.AppSettings.Get("ErrorPath"));
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnString")))
{
conn.Open();
SqlCommand comm = new SqlCommand("SELECT DISTINCT SymbolName FROM Positions UNION ALL SELECT DISTINCT SymbolName from WatchListItems", conn);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
string symbol = dr.GetString(0);
if (!symbols.Contains(symbol))
{
symbols.Add(symbol);
}
}
}
using (SqlConnection cnncheck = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnString")))
{
cnncheck.Open();
SqlCommand SymCheck = new SqlCommand("Select name FROM Symbols WHERE CompanyName IS NULL", cnncheck);
SqlDataReader reader = SymCheck.ExecuteReader();
while (reader.Read())
{
CompanyName.Add(reader.GetString(0));
}
}
if (symbols.Count > 0)
{
using (SqlConnection connUpdate = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnString")))
{
connUpdate.Open();
foreach (string sym in symbols)
{
SqlCommand SymUpdate = new SqlCommand("INSERT INTO Quotes (Price, TimeStamp, SymbolName) VALUES (@Price, @Time, @Symbol)", connUpdate);
try
{
String QouteUpdate = Qoute.GetQuote(sym);
if (QouteUpdate != string.Empty)
{
doc.LoadXml(QouteUpdate);
SelectTotal = doc.DocumentElement.SelectSingleNode("//Stock/Last");
SelectName = doc.DocumentElement.SelectSingleNode("//Stock/Symbol");
SelectTime = doc.DocumentElement.SelectSingleNode("//Stock/Time");
SelectDate = doc.DocumentElement.SelectSingleNode("//Stock/Date");
SelectCompany = doc.DocumentElement.SelectSingleNode("//Stock/Name");
Company = SelectCompany.InnerText;
Price = SelectTotal.InnerText;
Symbol = SelectName.InnerText;
Time = SelectDate.InnerText + " " + SelectTime.InnerText;
SymUpdate.Parameters.AddWithValue("@Price", Price);
SymUpdate.Parameters.AddWithValue("@Time", Time);
SymUpdate.Parameters.AddWithValue("@Symbol", Symbol);
SymUpdate.ExecuteNonQuery();
}
if (CompanyName.Contains(sym))
{
SqlCommand UpdateSym = new SqlCommand("Update Symbols SET CompanyName = '" + Company + "' WHERE name = '" + sym + "'", connUpdate);
UpdateSym.ExecuteNonQuery();
}
}
catch (Exception e)
{
write.WriteLine("An error occured with symbol: " + sym);
write.WriteLine("Exception: " + e.ToString());
}
}
}
}
write.Close();
}
static void Main(string[] args)
{
SQ.StockQuote Qoute = new SQ.StockQuote();
String Price, Time, Symbol, Company = "";
XmlDocument doc = new XmlDocument();
XmlNode SelectName, SelectTotal, SelectTime, SelectDate, SelectCompany;
List <string> symbols = new List <string>();
List <string> CompanyName = new List <string>();
StreamWriter write = new StreamWriter(ConfigurationManager.AppSettings.Get("ErrorPath"));
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnString")))
{
conn.Open();
SqlCommand comm = new SqlCommand("SELECT DISTINCT SymbolName FROM Positions UNION ALL SELECT DISTINCT SymbolName from WatchListItems", conn);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
string symbol = dr.GetString(0);
if (!symbols.Contains(symbol))
{
symbols.Add(symbol);
}
}
}
using (SqlConnection cnncheck = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnString")))
{
cnncheck.Open();
SqlCommand SymCheck = new SqlCommand("Select name FROM Symbols WHERE CompanyName IS NULL", cnncheck);
SqlDataReader reader = SymCheck.ExecuteReader();
while (reader.Read())
{
CompanyName.Add(reader.GetString(0));
}
}
if (symbols.Count > 0)
{
using (SqlConnection connUpdate = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnString")))
{
connUpdate.Open();
foreach (string sym in symbols)
{
SqlCommand SymUpdate = new SqlCommand("INSERT INTO Quotes (Price, TimeStamp, SymbolName) VALUES (@Price, @Time, @Symbol)", connUpdate);
try
{
String QouteUpdate = Qoute.GetQuote(sym);
if (QouteUpdate != string.Empty)
{
doc.LoadXml(QouteUpdate);
SelectTotal = doc.DocumentElement.SelectSingleNode("//Stock/Last");
SelectName = doc.DocumentElement.SelectSingleNode("//Stock/Symbol");
SelectTime = doc.DocumentElement.SelectSingleNode("//Stock/Time");
SelectDate = doc.DocumentElement.SelectSingleNode("//Stock/Date");
SelectCompany = doc.DocumentElement.SelectSingleNode("//Stock/Name");
Company = SelectCompany.InnerText;
Price = SelectTotal.InnerText;
Symbol = SelectName.InnerText;
Time = SelectDate.InnerText + " " + SelectTime.InnerText;
SymUpdate.Parameters.AddWithValue("@Price", Price);
SymUpdate.Parameters.AddWithValue("@Time", Time);
SymUpdate.Parameters.AddWithValue("@Symbol", Symbol);
SymUpdate.ExecuteNonQuery();
}
if (CompanyName.Contains(sym))
{
SqlCommand UpdateSym = new SqlCommand("Update Symbols SET CompanyName = '" + Company + "' WHERE name = '" + sym + "'", connUpdate);
UpdateSym.ExecuteNonQuery();
}
}
catch (Exception e)
{
write.WriteLine("An error occured with symbol: " + sym);
write.WriteLine("Exception: " + e.ToString());
}
}
}
}
write.Close();
}