public int insert(TradeDTO oTrade)
{
int iReturn = 0;
SqlConnection sqlCon = DBLibrary.OpenConnection();
try
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "sp_trade_insert";
sqlCmd.Parameters.AddWithValue("@IdCliente", oTrade.idCliente.ToString());
sqlCmd.Parameters.AddWithValue("@TradeValue", oTrade.tradeValue);
sqlCmd.Parameters.AddWithValue("@IdSector", oTrade.idSector.ToString());
iReturn = sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlCon.Close();
}
return(iReturn);
}
public bool update(TradeDTO oTrade)
{
bool bReturn = false;
SqlConnection sqlCon = DBLibrary.OpenConnection();
try
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "sp_trade_update";
sqlCmd.Parameters.AddWithValue("@IdTrade", oTrade.idTrade);
sqlCmd.Parameters.AddWithValue("@TradeValue", oTrade.tradeValue);
sqlCmd.Parameters.AddWithValue("@IdSector", oTrade.idSector.ToString());
sqlCmd.ExecuteNonQuery();
bReturn = true;
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlCon.Close();
}
return(bReturn);
}
static void Main(string[] args)
{
TradeBS obj = new TradeBS();
string sReturn = "";
List <TradeDTO> oListTrade = new List <TradeDTO>();
TradeDTO Trade1 = new TradeDTO();
TradeDTO Trade2 = new TradeDTO();
TradeDTO Trade3 = new TradeDTO();
TradeDTO Trade4 = new TradeDTO();
Trade1.tradeValue = 2000000; Trade1.dsSector = "Private";
Trade2.tradeValue = 400000; Trade2.dsSector = "Public";
Trade3.tradeValue = 500000; Trade3.dsSector = "Public";
Trade4.tradeValue = 3000000; Trade4.dsSector = "Public";
oListTrade.Add(Trade1);
oListTrade.Add(Trade2);
oListTrade.Add(Trade3);
oListTrade.Add(Trade4);
sReturn = obj.getSectorTrade(oListTrade);
Console.WriteLine(sReturn);
}
private static List <TradeDTO> GetExecutionsScenario3()
{
List <TradeDTO> trades = new List <TradeDTO>();
TradeDTO trade1 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_BUY, Symbol = "xxx", ExecutionSize = 20, ExecutionPrice = 8100
};
TradeDTO trade2 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_BUY, Symbol = "xxx", ExecutionSize = 10, ExecutionPrice = 8200
};
TradeDTO trade3 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 5, ExecutionPrice = 8300
};
TradeDTO trade4 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 35, ExecutionPrice = 8400
};
trades.Add(trade1);
trades.Add(trade2);
trades.Add(trade3);
trades.Add(trade4);
return(trades);
}
public List <TradeCategoryDTO> getSectorTrade(TradeDTO pTrade)
{
List <TradeCategoryDTO> oReturn = new List <TradeCategoryDTO>();
//SqlConnection sqlCon = DBLibrary.OpenConnection();
try
{
//SqlCommand sqlCmd = new SqlCommand();
//sqlCmd.Connection = sqlCon;
//sqlCmd.CommandType = CommandType.StoredProcedure;
//sqlCmd.CommandText = "sp_tradeCategory_sector";
//sqlCmd.Parameters.AddWithValue("@TradeValue", pTrade.tradeValue);
//sqlCmd.Parameters.AddWithValue("@DsSector", pTrade.dsSector);
//var oData = sqlCmd.ExecuteReader();
//while (oData.Read() == true)
//{
// TradeCategoryDTO oTrade = new TradeCategoryDTO();
// oTrade.dsCategory = oData["dsCategory"].ToString();
// oReturn.Add(oTrade);
//}
string[,] aTrade = new string[3, 4] {
{ "1000001", "3000000", "Private", "HIGHRISK" },
{ "1000001", "3000000", "Public", "MEDIUMRISK" },
{ "300001", "500000", "Public", "LOWRISK" }
};
int i = 0;
for (i = 0; i < aTrade.GetLength(0); i++)
{
if ((pTrade.tradeValue > int.Parse(aTrade[i, 0].ToString()) && pTrade.tradeValue <= int.Parse(aTrade[i, 1].ToString())) &&
(pTrade.dsSector == aTrade[i, 2].ToString()))
{
TradeCategoryDTO oTrade = new TradeCategoryDTO();
oTrade.dsCategory = aTrade[i, 3].ToString();
oReturn.Add(oTrade);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
//sqlCon.Close();
}
return(oReturn);
}
public static Trade FromDTO(TradeDTO trade)
=> new Trade
{
Id = trade.Id,
Name = trade.Name,
Description = trade.Description,
ImageUrl = trade.ImageUrl,
Address = trade.Address,
Town = trade.Town
};
public void TestNotAddingInvalidTrade()
{
TradeDTO trade = new TradeDTO("Trade1", "Card1", "spell", 10);
_tradeService.Setup(s => s.AddTrade(trade, "user-token")).Returns("POST ERR - Trade already exists");
string result = _tradeController.AddTrade(trade, "user-token");
Assert.AreEqual("POST ERR - Trade already exists", result);
}
public string AddTrade(TradeDTO trade, string usertoken)
{
using NpgsqlConnection con = new NpgsqlConnection(_cs);
try
{
con.Open();
}
catch (PostgresException e)
{
return("POST ERR - No DB connection");
}
using NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = con;
cmd.CommandText = @"CREATE TABLE IF NOT EXISTS trades(id VARCHAR(255), cardToTrade VARCHAR(255), type VARCHAR(255), minimumDamage DOUBLE PRECISION, usertoken VARCHAR(255))";
cmd.ExecuteNonQuery();
string sqlGetTrades = "SELECT * FROM trades";
using NpgsqlCommand cmdGetTrades = new NpgsqlCommand(sqlGetTrades, con);
using NpgsqlDataReader reader = cmdGetTrades.ExecuteReader();
while (reader.Read())
{
if (reader.GetString(0) == trade.Id)
{
return("POST ERR - TradeID already exists");
}
}
reader.Close();
User user = null;
ClientSingleton.GetInstance.ClientMap.TryGetValue(usertoken, out user);
Card card = user.Stack.GetCard(trade.CardToTrade);
if (card == null)
{
return("POST ERR - Card to trade not in Stack");
}
var sql = "INSERT INTO trades (id, cardToTrade, type, minimumDamage, usertoken) VALUES (@id, @cardToTrade, @type, @minimumDamage, @usertoken)";
using (NpgsqlCommand cmdPrepared = new NpgsqlCommand(sql, con))
{
cmdPrepared.Parameters.AddWithValue("id", trade.Id);
cmdPrepared.Parameters.AddWithValue("cardToTrade", trade.CardToTrade);
cmdPrepared.Parameters.AddWithValue("type", trade.Type);
cmdPrepared.Parameters.AddWithValue("minimumDamage", trade.MinimumDamage);
cmdPrepared.Parameters.AddWithValue("usertoken", usertoken);
cmdPrepared.ExecuteNonQuery();
}
con.Close();
return("POST OK - Trade added");
}
public async Task <IActionResult> GetAsync(int id)
{
TradeDTO trade = await _tradeDAO.FindById(id);
if (trade == null)
{
return(new NotFoundResult());
}
return(new ObjectResult(trade));
}
private NetPositionDTO BuildNewPosition(TradeDTO execution)
{
NetPositionDTO position = new NetPositionDTO()
{
Symbol = execution.Symbol,
NetContracts = execution.Side == TradeDTO._TRADE_BUY ? execution.ExecutionSize : -1 * execution.ExecutionSize,
PositionExposure = execution.Side == TradeDTO._TRADE_BUY ? NetPositionDTO._LONG : NetPositionDTO._SHORT,
OpenPrice = execution.ExecutionPrice
};
return(position);
}
public void TestNotTradingWhenRequestedTypeNoMatched()
{
Card wizard = new Wizard("wizhar", "Harry Potter", 75, ElementType.Normal);
TradeDTO trade = new TradeDTO("Trade1", "wizhar", "knight", 80);
Card dragon = new Dragon("dravis", "Viserion", 90, ElementType.Water);
_tradeService.Setup(s => s.TradeCards("Trade1", "dravis", "user-token")).Returns("POST ERR - Wrong type or too low damage for trade");
string result = _tradeController.TradeCards("Trade1", "dravis", "user-token");
Assert.AreEqual("POST ERR - Wrong type or too low damage for trade", result);
}
public void TestTradingWhenRequestedMatched()
{
Card wizard = new Wizard("wizhar", "Harry Potter", 75, ElementType.Normal);
TradeDTO trade = new TradeDTO("Trade1", "wizhar", "dragon", 70);
Card dragon = new Dragon("dravis", "Viserion", 90, ElementType.Fire);
_tradeService.Setup(s => s.TradeCards("Trade1", "dravis", "user-token")).Returns("POST OK - cards traded");
string result = _tradeController.TradeCards("Trade1", "dravis", "user-token");
Assert.AreEqual("POST OK - cards traded", result);
}
public TradeApi(RequestContext request)
{
_request = request;
try
{
_trade = JsonSerializer.Deserialize <TradeDTO>(_request.Content);
}
catch (Exception e)
{
_trade = null;
}
ITradeService tradeService = new TradeService();
_tradeController = new TradeController(tradeService);
}
public async Task <TradeDTO> Insert(TradeDTO dto)
{
Counter counter = await _counterDAO.GetCountersAsync();
int id = counter.Trades++;
await _counterDAO.UpdateCountersAsync(counter);
Trade trade = Trade.FromDTO(dto);
trade.Id = id;
await _context.Trades.InsertOneAsync(trade);
return(TradeDTO.FromTrade(trade));
}
public async Task <TradeDTO> FindById(int id)
{
Trade trade = await _context.Trades
.Find(Builders <Trade> .Filter.Eq(t => t.Id, id))
.FirstOrDefaultAsync();
if (trade == null)
{
return(null);
}
TradeDTO dto = TradeDTO.FromTrade(trade);
return(dto);
}
private static List <TradeDTO> GetSimplePAndLScenarios()
{
List <TradeDTO> trades = new List <TradeDTO>();
TradeDTO trade1 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 10, ExecutionPrice = 21000
};
//TradeDTO trade2 = new TradeDTO() { Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 10, ExecutionPrice = 21000 };
trades.Add(trade1);
//trades.Add(trade2);
return(trades);
}
public static bool Insert(TradeDTO person)
{
try
{
string query = "INSERT INTO tb_troca(ds_tipo, vl_compra, ds_moeda_compra, " +
"vl_venda, ds_moeda_venda, vl_taxa, ds_moeda_taxa, ds_comentario, dt_troca, cd_usuario) VALUES " +
$"('{person.Tipo}','{person.ValorCompra}','{person.MoedaCompra}','{person.ValorVenda}','{person.MoedaVenda}'," +
$"'{person.ValorTaxa}','{person.MoedaTaxa}','{person.Comentario}','{person.DataTroca.Date}','{person.UserId}')";
new Commands().ExecuteCommand(query);
return(true);
}
catch
{
return(false);
}
}
public JsonResult CreateTrade(TradeDTO trade)
{
var coin = TradeCoinBLL.ListAll();
var type = OperationBLL.ListAll();
var cookie_info = CookiesControll.UserAuthenticationInfo().Name;
trade.Tipo = type.Where(t => t.Id == trade.Tipo).FirstOrDefault().Tipo;
trade.UserId = cookie_info;
if (!string.IsNullOrEmpty(trade.MoedaCompra) && !string.IsNullOrWhiteSpace(trade.MoedaCompra))
{
trade.MoedaCompra = coin.Where(c => c.Id == trade.MoedaCompra).FirstOrDefault().Sigla;
}
if (!string.IsNullOrEmpty(trade.MoedaVenda) && !string.IsNullOrWhiteSpace(trade.MoedaVenda))
{
trade.MoedaVenda = coin.Where(c => c.Id == trade.MoedaVenda).FirstOrDefault().Sigla;
}
if (!string.IsNullOrEmpty(trade.MoedaTaxa) && !string.IsNullOrWhiteSpace(trade.MoedaTaxa))
{
trade.MoedaTaxa = coin.Where(c => c.Id == trade.MoedaTaxa).FirstOrDefault().Sigla;
}
bool inserts_ok = false;
if (TradeBLL.RegisterUser(trade))
{
inserts_ok = true;
HistoricDTO hist = new HistoricDTO
{
Data = DateTime.Now.Date,
UserId = cookie_info,
Descricao = $"Adicionado uma nova {trade.Tipo}"
};
inserts_ok = HistoricBLL.RegisterHistoric(hist);
}
var url = Url.Action("Trocas", "Trocas");
return(Json(new { insert = inserts_ok, url }, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> PostAsync([FromForm(Name = "image")] IFormFile imageFile, [FromForm] PostTradeRequest request)
{
System.Diagnostics.Trace.WriteLine("fooo");
var storageConnectionString = _configuration["ConnectionStrings:AzureStorageConnectionString"];
if (CloudStorageAccount.TryParse(storageConnectionString, out CloudStorageAccount storageAccount))
{
CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();
CloudBlobContainer container = blobClient.GetContainerReference("tradeimages");
await container.CreateIfNotExistsAsync();
var permissions = container.GetPermissions();
if (permissions.PublicAccess == BlobContainerPublicAccessType.Off)
{
permissions.PublicAccess = BlobContainerPublicAccessType.Blob;
container.SetPermissions(permissions);
}
var blob = container.GetBlockBlobReference(imageFile.FileName);
await blob.UploadFromStreamAsync(imageFile.OpenReadStream());
string uri = blob.Uri.ToString();
TradeDTO trade = new TradeDTO
{
OwnerId = request.OwnerId,
Name = request.Name,
Description = request.Description,
ImageUrl = uri,
Address = request.Address,
Town = request.Town
};
TradeDTO insertedTrade = await _tradeDAO.Insert(trade);
return(new OkObjectResult(insertedTrade));
}
return(new StatusCodeResult(StatusCodes.Status500InternalServerError));
}
public List <TradeDTO> getTradeByID(int pIdTrade)
{
List <TradeDTO> oReturn = new List <TradeDTO>();
SqlConnection sqlCon = DBLibrary.OpenConnection();
try
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlCon;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "sp_trade_consultar";
sqlCmd.Parameters.AddWithValue("@IdTrade", pIdTrade);
var oData = sqlCmd.ExecuteReader();
while (oData.Read() == true)
{
TradeDTO oTrade = new TradeDTO();
oTrade.idTrade = int.Parse(oData["idTrade"].ToString());
oTrade.idCliente = int.Parse(oData["idCliente"].ToString());
oTrade.tradeValue = decimal.Parse(oData["tradeValue"].ToString());
oTrade.idSector = int.Parse(oData["idSector"].ToString());
oTrade.dsSector = oData["dsSector"].ToString();
oReturn.Add(oTrade);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
sqlCon.Close();
}
return(oReturn);
}
public static List <TradeDTO> ListAll(string clause = "")
{
string query = "select cd_troca as 'Id', ds_tipo as 'Tipo', vl_compra as 'ValorCompra', ds_moeda_compra as 'MoedaCompra', vl_venda as 'ValorVenda', " +
"ds_moeda_venda as 'MoedaVenda', vl_taxa as 'ValorTaxa', ds_moeda_taxa as 'MoedaTaxa', ds_comentario as 'Comentario', dt_troca as 'Data', " +
$"cd_usuario as 'UsuarioId' from tb_troca {clause}";
Commands bd = new Commands();
var Trade = new List <TradeDTO>();
string selectProducts = query;
SqlDataReader datareader = bd.ExecuteCommandReader(selectProducts);
while (datareader.Read())
{
var trade = new TradeDTO
{
Id = datareader["Id"].ToString(),
Tipo = datareader["Tipo"].ToString(),
ValorCompra = datareader["ValorCompra"].ToString(),
MoedaCompra = datareader["MoedaCompra"].ToString(),
ValorVenda = datareader["ValorVenda"].ToString(),
MoedaVenda = datareader["MoedaVenda"].ToString(),
ValorTaxa = datareader["ValorTaxa"].ToString(),
MoedaTaxa = datareader["MoedaTaxa"].ToString(),
Comentario = datareader["Comentario"].ToString(),
DataTroca = (DateTime)datareader["Data"],
UserId = datareader["UsuarioId"].ToString()
};
Trade.Add(trade);
}
datareader.Close();
return(Trade);
}
public static List <TradeDTO> GetTrades(string csvFile)
{
List <TradeDTO> trades = new List <TradeDTO>();
using (var reader = new StreamReader(csvFile))
{
List <string> listA = new List <string>();
int i = 0;
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
var values = line.Split(',');
if (i == 0)
{
i++;
continue;
}
TradeDTO trade = new TradeDTO()
{
Date = GetDate(values[0].Replace("\"", "")),
Symbol = values[2].Replace("\"", ""),
Side = values[1].Replace("\"", "") == _BUY_LABEL ? TradeDTO._TRADE_BUY : TradeDTO._TRADE_SELL,
ExecutionSize = Convert.ToDouble(values[4].Replace("\"", "")),
ExecutionPrice = Convert.ToDouble(values[5].Replace("\"", "")),
FirmId = values[11]
};
trades.Add(trade);
}
}
return(trades);
}
private static List <TradeDTO> GetExecutionsScenario1()
{
List <TradeDTO> trades = new List <TradeDTO>();
TradeDTO tradexx = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_BUY, Symbol = "xxx", ExecutionSize = 20, ExecutionPrice = 8100
};
TradeDTO trade2 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_BUY, Symbol = "xxx", ExecutionSize = 10, ExecutionPrice = 8200
};
TradeDTO trade3 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 5, ExecutionPrice = 8300
};
TradeDTO trade4 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 10, ExecutionPrice = 8400
};
TradeDTO trade5 = new TradeDTO()
{
Date = DateTime.Now, Side = TradeDTO._TRADE_SELL, Symbol = "xxx", ExecutionSize = 10, ExecutionPrice = 8500
};
//P&L=5*(8300-8100) +10*(8400-8100) + 5 (8500-8100) + 5 (8500-8200) +5 (9100-8200)
trades.Add(tradexx);
trades.Add(trade2);
trades.Add(trade3);
trades.Add(trade4);
trades.Add(trade5);
return(trades);
}
public string AddTrade(TradeDTO trade, string usertoken)
{
return(_tradeService.AddTrade(trade, usertoken));
}
public void AddToTrades(TradeDTO tradeDTO)
{
base.AddObject("Trades", tradeDTO);
}
public static TradeDTO CreateTradeDTO(int ID, int supplierId, int suppierCompanyId, global::System.DateTime startDate, bool isClosed, int status)
{
TradeDTO tradeDTO = new TradeDTO();
tradeDTO.Id = ID;
tradeDTO.SupplierId = supplierId;
tradeDTO.SuppierCompanyId = suppierCompanyId;
tradeDTO.StartDate = startDate;
tradeDTO.IsClosed = isClosed;
tradeDTO.Status = status;
return tradeDTO;
}
public static bool RegisterUser(TradeDTO person) => TradeDAO.Insert(person);
