private List<PortiaTrade> getConfirmTrades(List<PortiaTrade> trades) { List<PortiaTrade> confirms = new List<PortiaTrade>(); int i = 1; foreach (PortiaTrade p in trades) { string str = p.ConfirmId.ToString(); if (str != null && str.Length > 0) { PortiaTrade pt = new PortiaTrade(); pt.Broker = "MyBroker"; pt.BrokerNum ="1"; pt.Cusip = "45678907"; pt.ParentId = Convert.ToInt32(p.Id); pt.Id = i++; confirms.Add(pt); } } //using (MySqlConnection con = new MySqlConnection(ConnStr)) //using (MySqlCommand cmd = new MySqlCommand(Constants.InsertMCMFilteredQuery, con) { CommandType = CommandType.Text }) //{ // con.Open(); // try // { // using (MySqlDataReader reader = cmd.ExecuteReader()) // { // while (reader.Read()) // { // PortiaTrade newPortiaTrade = new PortiaTrade(reader["id"].ToString(), // reader["tran_#"].ToString(), // reader["portfolio"].ToString(), // reader["security_nm"].ToString(), // reader["cusip"].ToString(), // reader["tran_type"].ToString(), // reader["trade_date"].ToString(), // reader["settle_date"].ToString(), // reader["broker"].ToString(), // reader["broker_number"].ToString(), // reader["quantity"].ToString(), // reader["price"].ToString(), // reader["net_amount"].ToString(), // reader["interest"].ToString(), // reader["principal_amount"].ToString()); // newPortiaTrade.ConfirmId = Convert.ToInt32(reader["confirm_id"].ToString()); // trades.Add(newPortiaTrade); // } // } // } // catch (Exception ex) // { // Console.WriteLine(ex); // } //} trades.AddRange(confirms); return trades; }
public List<PortiaTrade> GetTrades() { List<PortiaTrade> trades = new List<PortiaTrade>(); using (MySqlConnection con = new MySqlConnection(ConnStr)) using (MySqlCommand cmd = new MySqlCommand(Constants.InsertMCMFilteredQuery, con) { CommandType = CommandType.Text }) { con.Open(); try { using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { PortiaTrade newPortiaTrade = new PortiaTrade(reader["id"].ToString(), reader["tran_#"].ToString(), reader["portfolio"].ToString(), reader["security_nm"].ToString(), reader["cusip"].ToString(), reader["tran_type"].ToString(), reader["trade_date"].ToString(), reader["settle_date"].ToString(), reader["broker"].ToString(), reader["broker_number"].ToString(), reader["quantity"].ToString(), reader["price"].ToString(), reader["net_amount"].ToString(), reader["interest"].ToString(), reader["principal_amount"].ToString()); newPortiaTrade.ConfirmId = Convert.ToInt32(reader["confirm_id"].ToString()); trades.Add(newPortiaTrade); } } } catch (Exception ex) { Console.WriteLine(ex); } } return getConfirmTrades(trades); }