public void UpdateBI() { DateTime dt = DateTime.Now; DateTime dt2 = DateTime.Now.AddDays(1); parameters.Clear(); parameters.Add("@startDate", dt.Year + "-" + dt.Month + "-" + dt.Day); parameters.Add("@endDate", dt2.Year + "-" + dt2.Month + "-" + dt2.Day); dataset = csConnection.ExecutePA("[dbo].[spBIFeedJFallas2]", parameters); csData data = null; if (dataset.Tables[0].Rows.Count > 0) { foreach (DataRow fila in dataset.Tables[0].Rows) { data = new csData(); data.IdWager = Convert.ToInt32(fila["IdWager"]); data.IdWagerDetail = Convert.ToInt32(fila["IdWagerDetail"]); data.IdAgent = Convert.ToInt32(fila["IdAgent"]); data.Agent = Convert.ToString(fila["Agent"]); data.IdPlayer = Convert.ToInt32(fila["IdPlayer"]); data.Player = Convert.ToString(fila["Player"]); data.IdLineType = Convert.ToInt32(fila["IdLineType"]); data.IdLineTypeName = Convert.ToString(fila["LineType"]); data.LoginName = Convert.ToString(fila["LoginName"]); data.WinAmount = Convert.ToDouble(fila["WinAmount"]); data.RiskAmount = Convert.ToDouble(fila["RiskAmount"]); data.Result = Convert.ToString(fila["Result"]); data.Net = Convert.ToDouble(fila["Neto"]); data.GamePeriod = Convert.ToString(fila["GamePeriod"]); data.League = Convert.ToString(fila["LEAGUE"]); data.CompleteDescription = Convert.ToString(fila["CompleteDescription"]); data.DetailDescription = Convert.ToString(fila["DetailDescription"]); data.Team = Convert.ToString(fila["TEAM"]); data.IdGame = Convert.ToInt32(fila["IdGame"]); data.IdLeague = Convert.ToInt32(fila["IdLeague"]); data.Period = Convert.ToInt32(fila["Period"]); data.Play = Convert.ToInt32(fila["Play"]); data.WagerPlay = Convert.ToString(fila["WagerPlay"]); data.FavDog = Convert.ToString(fila["FAV_DOG"]); data.IdSport = Convert.ToString(fila["IdSport"]); data.PlacedDate = Convert.ToDateTime(fila["PlacedDate"]); data.SeattledDate = Convert.ToDateTime(fila["SettledDate"]); data.Odds = Convert.ToInt32(fila["Odds"]); data.Points = Convert.ToDouble(fila["Points"]); data.Score = Convert.ToString(fila["Score"]); data.IP = Convert.ToString(fila["IP"]); data.BeatLine = Convert.ToString(fila["BeatLine"]); if (!String.IsNullOrWhiteSpace(fila["OpeningPoints"].ToString())) { data.OpeningPoints = Convert.ToDouble(fila["OpeningPoints"]); } else { data.OpeningPoints = null; } if (!String.IsNullOrWhiteSpace(fila["OpeningMoneyLine"].ToString())) { data.OpeningOdds = Convert.ToInt32(fila["OpeningMoneyLine"]); } else { data.OpeningOdds = null; } if (!String.IsNullOrWhiteSpace(fila["ClosingPoints"].ToString())) { data.ClosingPoints = Convert.ToDouble(fila["ClosingPoints"]); } else { data.ClosingPoints = null; } if (!String.IsNullOrWhiteSpace(fila["ClosingMoneyLine"].ToString())) { data.ClosingOdds = Convert.ToInt32(fila["ClosingMoneyLine"]); } else { data.ClosingOdds = null; } spInsertWL(data); } } }
public void spInsertWL(csData data) { parameters.Clear(); parameters.Add("@IdWager", data.IdWager); parameters.Add("@IdWagerDetail", data.IdWagerDetail); parameters.Add("@IdAgent", data.IdAgent); parameters.Add("@Agent", data.Agent); parameters.Add("@IdPlayer", data.IdPlayer); parameters.Add("@Player", data.Player); parameters.Add("@IdLineType", data.IdLineType); parameters.Add("@LineType", data.IdLineTypeName); parameters.Add("@LoginName", data.LoginName); parameters.Add("@WinAmount", data.WinAmount); parameters.Add("@RiskAmount", data.RiskAmount); parameters.Add("@Result", data.Result); parameters.Add("@Neto", data.Net); parameters.Add("@GamePeriod", data.GamePeriod); parameters.Add("@LEAGUE", data.League); parameters.Add("@CompleteDescription", data.CompleteDescription); parameters.Add("@DetailDescription", data.DetailDescription); parameters.Add("@TEAM", data.Team); parameters.Add("@IdGame", data.IdGame); parameters.Add("@IdLeague", data.IdLeague); parameters.Add("@Period", data.Period); parameters.Add("@Play", data.Play); parameters.Add("@WagerPlay", data.WagerPlay); parameters.Add("@FAV_DOG", data.FavDog); parameters.Add("@IdSport", data.IdSport); parameters.Add("@PlacedDate", data.PlacedDate); parameters.Add("@SettledDate", data.SeattledDate); parameters.Add("@Odds", data.Odds); parameters.Add("@Points", data.Points); parameters.Add("@Score", data.Score); parameters.Add("@IP", data.IP); if (data.OpeningPoints == null) { parameters.Add("@OpeningPoints", -10000); } else { parameters.Add("@OpeningPoints", data.OpeningPoints); } if (data.OpeningOdds == null) { parameters.Add("@OpeningMoneyLine", -10000); } else { parameters.Add("@OpeningMoneyLine", data.OpeningOdds); } if (data.ClosingPoints == null) { parameters.Add("@ClosingPoints", -10000); } else { parameters.Add("@ClosingPoints", data.ClosingPoints); } if (data.ClosingOdds == null) { parameters.Add("@ClosingMoneyLine", -10000); } else { parameters.Add("@ClosingMoneyLine", data.ClosingOdds); } parameters.Add("@BeatLine", data.BeatLine); if (csG8Apps.ExecutePAConfimation("[dbo].[spInsertDataBIWL_Second]", parameters)) { parameters.Clear(); } }