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