public bool InserirBet(Models.ukBetsHistory Bet)
{
// Limpa os parâmetros existente
query.LimparParametros();
string SQL = @"INSERT INTO ukBetsHistory
([Exchange], [MarketId], [SelectionId], [Handicap],[Name],[Status],[Matched],[Unmatched],[Cancelled],[AvgPrice],[PriceRequested],[BetType],
[BetId],[PlacedDate],[StartTime],[StrategyName],[ProfitLoss],[LossRecovery],[Currency],[FullMarketName],[CompetitionName],[CompetitionId],
[SelectionName],[MarketName],[EventTypeName],[EventTypeId],[MarketType],[MarketTypeVariant],[SimulatedBet],[TotalMatchedOnMarket],
[TotalMatchedOnRunner],[NumberOfRunners],[FavoriteByPosition],[StrategyID],[SelectionUniqueID],[RunnerByPosition],[MatchedDate],[SettledDate],
[LossRecoveryAmount],[PriceReduced],[PersistenceType],[OrderType],[Commission],[SizeCancelled],[SizeSettled],[SizeLapsed],[BSP])
VALUES
(@Exchange,@MarketId,@SelectionId,@Handicap,@Name,@Status,@Matched,@Unmatched,@Cancelled,@AvgPrice,@PriceRequested,@BetType,
@BetId,@PlacedDate,@StartTime,@StrategyName,@ProfitLoss,@LossRecovery,@Currency,@FullMarketName,@CompetitionName,@CompetitionId,
@SelectionName,@MarketName,@EventTypeName,@EventTypeId,@MarketType,@MarketTypeVariant,@SimulatedBet,@TotalMatchedOnMarket,
@TotalMatchedOnRunner,@NumberOfRunners,@FavoriteByPosition,@StrategyID,@SelectionUniqueID,@RunnerByPosition,@MatchedDate,@SettledDate,
@LossRecoveryAmount,@PriceReduced,@PersistenceType,@OrderType,@Commission,@SizeCancelled,@SizeSettled,@SizeLapsed,@BSP)";
// Adiciona os parâmetros da instrução SQL
query.AdicionarParametro("@Exchange", SqlDbType.VarChar, "UK");
query.AdicionarParametro("@MarketId", SqlDbType.VarChar, Bet.MarketId);
query.AdicionarParametro("@SelectionId", SqlDbType.VarChar, Bet.SelectionId);
query.AdicionarParametro("@Handicap", SqlDbType.VarChar, Bet.Handicap);
query.AdicionarParametro("@Name", SqlDbType.VarChar, Bet.Name);
query.AdicionarParametro("@Status", SqlDbType.VarChar, Bet.Status);
query.AdicionarParametro("@Matched", SqlDbType.Decimal, Math.Round(Bet.Matched, 2));
query.AdicionarParametro("@Unmatched", SqlDbType.Decimal, Bet.Unmatched);
query.AdicionarParametro("@Cancelled", SqlDbType.VarChar, Bet.Cancelled);
query.AdicionarParametro("@AvgPrice", SqlDbType.Decimal, Bet.AvgPrice);
query.AdicionarParametro("@PriceRequested", SqlDbType.Decimal, Bet.PriceRequested);
query.AdicionarParametro("@BetType", SqlDbType.VarChar, Bet.BetType);
query.AdicionarParametro("@BetId", SqlDbType.VarChar, Bet.BetId);
query.AdicionarParametro("@PlacedDate", SqlDbType.DateTime, Bet.PlacedDate);
query.AdicionarParametro("@StartTime", SqlDbType.DateTime, Bet.StartTime);
query.AdicionarParametro("@StrategyName", SqlDbType.VarChar, Bet.StrategyName);
query.AdicionarParametro("@ProfitLoss", SqlDbType.Decimal, Bet.ProfitLoss);
query.AdicionarParametro("@LossRecovery", SqlDbType.Decimal, Bet.LossRecovery);
query.AdicionarParametro("@Currency", SqlDbType.VarChar, Bet.Currency);
query.AdicionarParametro("@FullMarketName", SqlDbType.VarChar, Bet.FullMarketName);
query.AdicionarParametro("@CompetitionName", SqlDbType.VarChar, Bet.CompetitionName);
query.AdicionarParametro("@CompetitionId", SqlDbType.VarChar, Bet.CompetitionId);
query.AdicionarParametro("@SelectionName", SqlDbType.VarChar, Bet.SelectionId);
query.AdicionarParametro("@MarketName", SqlDbType.VarChar, Bet.MarketName);
query.AdicionarParametro("@EventTypeName", SqlDbType.VarChar, Bet.EventTypeName);
query.AdicionarParametro("@EventTypeId", SqlDbType.VarChar, Bet.EventTypeId);
query.AdicionarParametro("@MarketType", SqlDbType.VarChar, Bet.MarketType);
query.AdicionarParametro("@MarketTypeVariant", SqlDbType.VarChar, Bet.MarketTypeVariant);
query.AdicionarParametro("@SimulatedBet", SqlDbType.VarChar, Bet.SimulatedBet);
query.AdicionarParametro("@TotalMatchedOnMarket", SqlDbType.Decimal, Bet.TotalMatchedOnMarket);
query.AdicionarParametro("@TotalMatchedOnRunner", SqlDbType.Decimal, Bet.TotalMatchedOnRunner);
query.AdicionarParametro("@NumberOfRunners", SqlDbType.VarChar, Bet.NumberOfRunners);
query.AdicionarParametro("@FavoriteByPosition", SqlDbType.VarChar, Bet.FavoriteByPosition);
query.AdicionarParametro("@StrategyID", SqlDbType.VarChar, Bet.StrategyID);
query.AdicionarParametro("@SelectionUniqueID", SqlDbType.VarChar, Bet.SelectionUniqueID);
query.AdicionarParametro("@RunnerByPosition", SqlDbType.VarChar, Bet.RunnerByPosition);
query.AdicionarParametro("@MatchedDate", SqlDbType.DateTime, Bet.MatchedDate);
query.AdicionarParametro("@SettledDate", SqlDbType.DateTime, Bet.SettledDate);
query.AdicionarParametro("@LossRecoveryAmount", SqlDbType.Decimal, Bet.LossRecoveryAmount);
query.AdicionarParametro("@PriceReduced", SqlDbType.VarChar, Bet.PriceReduced);
query.AdicionarParametro("@PersistenceType", SqlDbType.VarChar, Bet.PersistenceType);
query.AdicionarParametro("@OrderType", SqlDbType.VarChar, Bet.OrderType);
query.AdicionarParametro("@Commission", SqlDbType.Decimal, Bet.Commission);
query.AdicionarParametro("@SizeCancelled", SqlDbType.Decimal, Math.Round(Bet.SizeCancelled, 2));
query.AdicionarParametro("@SizeSettled", SqlDbType.Decimal, Math.Round(Bet.SizeSettled, 2));
query.AdicionarParametro("@SizeLapsed", SqlDbType.Decimal, Bet.SizeLapsed);
query.AdicionarParametro("@BSP", SqlDbType.Decimal, Bet.BSP);
// Retorna a quantidade de linhas afetadas
return(query.ExecutaAtualizacao(SQL) > 0);
}
public List <ukBetsHistory> PopulaObjetoukBetsHistory(XmlDocument pXml, string pMonitor)
{
List <ukBetsHistory> BetsList = new List <ukBetsHistory>();
try
{
XmlNodeList xnList = pXml.GetElementsByTagName("BetHistoryItem");
for (int i = 0; i < xnList.Count; i++)
{
if (xnList[i]["Status"].InnerText == "SETTLED")
{
Models.ukBetsHistory Bet = new Models.ukBetsHistory()
{
//Exchange = xnList[i]["Exchange"].InnerText,
MarketId = xnList[i]["MarketId"].InnerText,
SelectionId = xnList[i]["SelectionId"].InnerText,
Handicap = xnList[i]["Handicap"].InnerText,
Name = xnList[i]["Name"].InnerText,
Status = xnList[i]["Status"].InnerText,
Matched = Convert.ToDecimal(xnList[i]["Matched"].InnerText), //.Replace(".",",")),
Unmatched = Convert.ToDecimal(xnList[i]["Unmatched"].InnerText), //.InnerText.Replace(".",",")),
Cancelled = xnList[i]["Cancelled"].InnerText,
AvgPrice = Convert.ToDecimal(xnList[i]["AvgPrice"].InnerText), //.InnerText.Replace(".",",")),
PriceRequested = Convert.ToDecimal(xnList[i]["PriceRequested"].InnerText), //.InnerText.Replace(".",",")),
BetType = xnList[i]["BetType"].InnerText,
BetId = xnList[i]["BetId"].InnerText,
PlacedDate = Convert.ToDateTime(xnList[i]["PlacedDate"].InnerText),
StartTime = Convert.ToDateTime(xnList[i]["StartTime"].InnerText),
StrategyName = xnList[i]["StrategyName"].InnerText,
ProfitLoss = Convert.ToDouble(xnList[i]["ProfitLoss"].InnerText), //.Replace(".",",")),
//ShortDescription = xnList[i]["ShortDescription"].InnerText,
LossRecovery = Convert.ToDecimal(xnList[i]["LossRecovery"].InnerText), //.Replace(".",",")),
Currency = xnList[i]["Currency"].InnerText,
//CountryCode = xnList[i]["CountryCode"].InnerText,
FullMarketName = xnList[i]["FullMarketName"].InnerText,
CompetitionName = xnList[i]["CompetitionName"].InnerText,
CompetitionId = xnList[i]["CompetitionId"].InnerText,
SelectionName = xnList[i]["SelectionName"].InnerText,
MarketName = xnList[i]["MarketName"].InnerText,
EventTypeName = xnList[i]["EventTypeName"].InnerText,
EventTypeId = xnList[i]["EventTypeId"].InnerText,
MarketType = xnList[i]["MarketType"].InnerText,
MarketTypeVariant = xnList[i]["MarketTypeVariant"].InnerText,
SimulatedBet = xnList[i]["SimulatedBet"].InnerText,
TotalMatchedOnMarket = Convert.ToDecimal(xnList[i]["TotalMatchedOnMarket"].InnerText), //.Replace(".",",")),
TotalMatchedOnRunner = Convert.ToDecimal(xnList[i]["TotalMatchedOnRunner"].InnerText), //.Replace(".",",")),
NumberOfRunners = xnList[i]["NumberOfRunners"].InnerText,
FavoriteByPosition = xnList[i]["FavoriteByPosition"].InnerText,
StrategyID = xnList[i]["StrategyID"].InnerText,
SelectionUniqueID = xnList[i]["SelectionUniqueID"].InnerText,
RunnerByPosition = xnList[i]["RunnerByPosition"].InnerText,
MatchedDate = Convert.ToDateTime(xnList[i]["MatchedDate"].InnerText),
SettledDate = Convert.ToDateTime(xnList[i]["SettledDate"].InnerText),
LossRecoveryAmount = Convert.ToDecimal(xnList[i]["LossRecoveryAmount"].InnerText),//.Replace(".",",")),
PriceReduced = xnList[i]["PriceReduced"].InnerText,
PersistenceType = xnList[i]["PersistenceType"].InnerText,
OrderType = xnList[i]["OrderType"].InnerText,
Commission = Convert.ToDecimal(xnList[i]["Commission"].InnerText), //.Replace(".",",")),
SizeCancelled = Convert.ToDecimal(xnList[i]["SizeCancelled"].InnerText), //.Replace(".",",")),
SizeSettled = Convert.ToDecimal(xnList[i]["SizeSettled"].InnerText), //.Replace(".",",")),
SizeLapsed = Convert.ToDecimal(xnList[i]["SizeLapsed"].InnerText), //.Replace(".",",")),
BSP = Convert.ToDecimal(xnList[i]["BSP"].InnerText), //.Replace(".",","))
Monitor = pMonitor,
};
BetsList.Add(Bet);
}
}
return(BetsList);
}
catch (Exception e)
{
throw new Exception(e.Message + " " + BetsList.Count.ToString());
}
}