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);
}
