public void AddCommoditySummarization(CommoditySummarization model)
{
CommoditySummarizations.Add(model);
string sql = "INSERT INTO CommoditySummarization (Id,Date,Commodity,Size,Amount,Commission,ClosedProfit,AccountId) "
+ "VALUES(@Id,@Date,@Commodity,@Size,@Amount,@Commission,@ClosedProfit,@AccountId)";
SQLiteCommand cmd = new SQLiteCommand(sql);
cmd.Parameters.AddWithValue("@AccountId", model.AccountId.ToString());
cmd.Parameters.AddWithValue("@Amount", model.Amount);
cmd.Parameters.AddWithValue("@ClosedProfit", model.ClosedProfit);
cmd.Parameters.AddWithValue("@Commission", model.Commission);
cmd.Parameters.AddWithValue("@Commodity", model.Commodity);
cmd.Parameters.AddWithValue("@Date", model.Date);
cmd.Parameters.AddWithValue("@Id", model.Id.ToString());
cmd.Parameters.AddWithValue("@Size", model.Size);
cmds.Add(cmd);
}
public List <CommoditySummarization> GetCommoditySummarizations()
{
List <CommoditySummarization> result = new List <CommoditySummarization>();
SQLiteConnection conn = null;
try
{
conn = new SQLiteConnection(connectionStr);
conn.Open();
string sql = string.Format("SELECT * FROM CommoditySummarization");
SQLiteCommand cmd = new SQLiteCommand(sql, conn);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CommoditySummarization model = new CommoditySummarization();
model.Id = Guid.Parse(reader.GetString(0));
model.Date = reader.GetDateTime(1);
model.Commodity = reader.GetString(2);
model.Size = reader.GetInt32(3);
model.Amount = reader.GetDecimal(4);
model.Commission = reader.GetDecimal(5);
model.ClosedProfit = reader.GetDecimal(6);
model.AccountId = Guid.Parse(reader.GetString(7));
result.Add(model);
}
conn.Close();
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(result);
}
