/*private void OnSTIOrderUpdateXML(ref string strOrder)
* {
* XmlSerializer xs = new XmlSerializer(typeof(SterlingLib.structSTIOrderUpdate));
* SterlingLib.structSTIOrderUpdate structOrder = (SterlingLib.structSTIOrderUpdate)xs.Deserialize(new StringReader(strOrder));
* }
*
* private void OnSTIPositionUpdateXML(ref string strPosition)
* {
* XmlSerializer xs = new XmlSerializer(typeof(SterlingLib.structSTIPositionUpdate));
* SterlingLib.structSTIPositionUpdate structPosition = (SterlingLib.structSTIPositionUpdate)xs.Deserialize(new StringReader(strPosition));
* int netPos = (structPosition.nSharesBot - structPosition.nSharesSld);
* //AddListBoxItem("Postion (XML): " + structPosition.bstrSym + " Position = " + netPos);
* }*/
private void button1_Click(object sender, EventArgs e)
{
using (SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;New=True;Compress=True;"))
{
conn.Open();
string stm = "SELECT * FROM Algo WHERE Status='Queued'";
using (SQLiteCommand cmd = new SQLiteCommand(stm, conn))
{
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
if (DateTime.ParseExact(rdr.GetString(3), "yyyy-MM-dd HH:mm:ss.ff", null) > DateTime.ParseExact(stiApp.GetServerTime(), "yyyyMMddHHmmss", null))
{
Debug.WriteLine("---------------------");
Debug.WriteLine(rdr.GetString(1) + " : " + rdr.GetString(2) + " : " + rdr.GetString(3));
AlgoForm af = new AlgoForm(rdr.GetString(1), rdr.GetString(2), DateTime.ParseExact(rdr.GetString(3), "yyyy-MM-dd HH:mm:ss.ff", null), DateTime.ParseExact(rdr.GetString(4), "yyyy-MM-dd HH:mm:ss.ff", null),
rdr.GetInt32(5), rdr.GetDecimal(6), rdr.GetInt32(7), rdr.GetInt32(10), rdr.GetInt32(11));
af.Show();
}
}
}
}
conn.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
AlgoForm af = new AlgoForm();
af.Show();
}
