public List <ClosedTradeDetail> GetClosedTradeDetails() { List <ClosedTradeDetail> result = new List <ClosedTradeDetail>(); SQLiteConnection conn = null; try { conn = new SQLiteConnection(connectionStr); conn.Open(); string sql = string.Format("SELECT * FROM ClosedTradeDetail"); SQLiteCommand cmd = new SQLiteCommand(sql, conn); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ClosedTradeDetail model = new ClosedTradeDetail(); model.Id = Guid.Parse(reader.GetString(0)); model.ActualDate = reader.GetDateTime(1); model.Item = reader.GetString(2); model.TicketForClose = reader.GetString(3); model.BS = reader.GetString(4); model.PriceForClose = reader.GetDecimal(5); model.PriceForOpen = reader.GetDecimal(6); model.Size = reader.GetInt32(7); model.YesterdaySettlementPrice = reader.GetDecimal(8); model.ClosedProfit = reader.GetDecimal(9); model.TicketForOpen = reader.GetString(10); model.AccountId = Guid.Parse(reader.GetString(11)); result.Add(model); } conn.Close(); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(result); }
public void AddClosedTradeDetail(ClosedTradeDetail model) { ClosedTradeDetails.Add(model); string sql = "INSERT INTO ClosedTradeDetail (Id,ActualDate,Item,TicketForClose,BS,PriceForClose,PriceForOpen,Size,YesterdaySettlementPrice,ClosedProfit,TicketForOpen,AccountId) " + "VALUES(@Id,@ActualDate,@Item,@TicketForClose,@BS,@PriceForClose,@PriceForOpen,@Size,@YesterdaySettlementPrice,@ClosedProfit,@TicketForOpen,@AccountId)"; SQLiteCommand cmd = new SQLiteCommand(sql); cmd.Parameters.AddWithValue("@AccountId", model.AccountId.ToString()); cmd.Parameters.AddWithValue("@ActualDate", model.ActualDate); cmd.Parameters.AddWithValue("@BS", model.BS); cmd.Parameters.AddWithValue("@ClosedProfit", model.ClosedProfit); cmd.Parameters.AddWithValue("@Id", model.Id.ToString()); cmd.Parameters.AddWithValue("@Item", model.Item); cmd.Parameters.AddWithValue("@PriceForClose", model.PriceForClose); cmd.Parameters.AddWithValue("@PriceForOpen", model.PriceForOpen); cmd.Parameters.AddWithValue("@Size", model.Size); cmd.Parameters.AddWithValue("@TicketForClose", model.TicketForClose); cmd.Parameters.AddWithValue("@TicketForOpen", model.TicketForOpen); cmd.Parameters.AddWithValue("@YesterdaySettlementPrice", model.YesterdaySettlementPrice); cmds.Add(cmd); }