// Our Lines
public csBet OurNextLine(csBet b, csGame g)
{
try
{
parameters.Add("@pDate", b.PlacedDate);
parameters.Add("@pIdGame", g.IdGame);
parameters.Add("@pPlay", b.Play);
dataset = csConnection.ExecutePA("[dbo].[web_getOurNextLine]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
b.OurNextLine = dataset.Tables[0].Rows[0]["ChangeValue"].ToString();
}
}
catch (Exception ex)
{
b.OurJuice = 0;
b.OurPoints = 0;
}
finally
{
parameters.Clear();
}
return(b);
}
public ObservableCollection <csBet> BetListFromIdGame(csGame game, string player, bool flag = true)
{
ObservableCollection <csBet> data = new ObservableCollection <csBet>();
try
{
parameters.Clear();
parameters.Add("@pIgGame", game.IdGame);
parameters.Add("@pPlayer", player);
dataset = csG8Apps.ExecutePA("[dbo].[web_GetBetsFromLeansByIdGame]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
csBet u = new csBet(
Convert.ToInt64(fila["Id_BI"]),
Convert.ToInt32(fila["IdWager"]),
Convert.ToInt32(fila["IdWagerDetail"]),
Convert.ToInt32(fila["IdAgent"]),
Convert.ToString(fila["Agent"]),
Convert.ToInt32(fila["IdPlayer"]),
Convert.ToString(fila["Player"]),
Convert.ToInt32(fila["IdLineType"]),
Convert.ToString(fila["LineTypeName"]),
Convert.ToString(fila["LoginName"]),
Convert.ToDouble(fila["WinAmount"]),
Convert.ToInt32(fila["RiskAmount"]),
Convert.ToString(fila["Result"]),
Convert.ToDouble(fila["Net"]),
Convert.ToString(fila["GamePeriod"]),
Convert.ToString(fila["League"]),
Convert.ToString(fila["CompleteDescription"]),
Convert.ToString(fila["DetailDescription"]),
Convert.ToString(fila["Team"]),
Convert.ToInt32(fila["IdGame"]),
Convert.ToInt32(fila["IdLeague"]),
Convert.ToInt32(fila["Period"]),
Convert.ToString(fila["FAV_DOG"]),
Convert.ToInt32(fila["Play"]),
Convert.ToString(fila["WagerPlay"]),
Convert.ToString(fila["IdSport"]),
Convert.ToDateTime(fila["SettledDate"]),
Convert.ToDateTime(fila["PlacedDate"]),
Convert.ToInt32(fila["Odds"]),
Convert.ToDouble(fila["Points"]),
Convert.ToString(fila["Score"]),
Convert.ToString(fila["IP"]),
Convert.ToString(fila["BeatLine"]));
if (flag)
{
u = LeansDB.OurNextLine(u, game);
u = LeansDB.CrisLines(u, game, 489);
u = LeansDB.PinniLines(u, game);
}
u.EventDate = game.EventDate;
u.EventName = game.VisitorTeam + " vs " + game.HomeTeam;
u.Pick = (game.VisitorNumber == u.Rot) ? game.VisitorTeam : game.HomeTeam;
data.Add(u);
}
}
else
{
data = null;
}
}
catch (Exception ex)
{
data = null;
MessageBox.Show("Error: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
parameters.Clear();
}
return(data);
}
public ObservableCollection <csBet> GetBetsAfterLeans(int idGame, csBet bet, string wagerPlay, string player, int caso = 1)
{
ObservableCollection <csBet> data = new ObservableCollection <csBet>();
if (!string.IsNullOrWhiteSpace(wagerPlay))
{
if (wagerPlay == "ML")
{
wagerPlay = "MONEY";
}
if (wagerPlay == "SP")
{
wagerPlay = "SPREAD";
}
if (wagerPlay == "DR")
{
wagerPlay = "DRAW";
}
if (wagerPlay == "TOT")
{
wagerPlay = "TOTAL";
}
}
string date = bet.PlacedDate.Year + "-" + bet.PlacedDate.Month + "-" + bet.PlacedDate.Day + " " + bet.PlacedDate.Hour + ":" + bet.PlacedDate.Minute + ":" + bet.PlacedDate.Second + ".000";
try
{
parameters.Clear();
parameters.Add("@pIgGame", idGame);
parameters.Add("@pPlacedDate", date);
parameters.Add("@pWagerType", wagerPlay);
parameters.Add("@pPlayer", player);
string casito = (caso == 1) ? "[dbo].[web_GetAfterLeans]" : "[dbo].[web_GetAfterLeans2]";
dataset = csG8Apps.ExecutePA(casito, parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
csBet u = new csBet(
Convert.ToInt64(fila["Id_BI"]),
Convert.ToInt32(fila["IdWager"]),
Convert.ToInt32(fila["IdWagerDetail"]),
Convert.ToInt32(fila["IdAgent"]),
Convert.ToString(fila["Agent"]),
Convert.ToInt32(fila["IdPlayer"]),
Convert.ToString(fila["Player"]),
Convert.ToInt32(fila["IdLineType"]),
Convert.ToString(fila["LineTypeName"]),
Convert.ToString(fila["LoginName"]),
Convert.ToDouble(fila["WinAmount"]),
Convert.ToInt32(fila["RiskAmount"]),
Convert.ToString(fila["Result"]),
Convert.ToDouble(fila["Net"]),
Convert.ToString(fila["GamePeriod"]),
Convert.ToString(fila["League"]),
Convert.ToString(fila["CompleteDescription"]),
Convert.ToString(fila["DetailDescription"]),
Convert.ToString(fila["Team"]),
Convert.ToInt32(fila["IdGame"]),
Convert.ToInt32(fila["IdLeague"]),
Convert.ToInt32(fila["Period"]),
Convert.ToString(fila["FAV_DOG"]),
Convert.ToInt32(fila["Play"]),
Convert.ToString(fila["WagerPlay"]),
Convert.ToString(fila["IdSport"]),
Convert.ToDateTime(fila["SettledDate"]),
Convert.ToDateTime(fila["PlacedDate"]),
Convert.ToInt32(fila["Odds"]),
Convert.ToInt32(fila["Points"]),
Convert.ToString(fila["Score"]),
Convert.ToString(fila["IP"]),
Convert.ToString(fila["BeatLine"]));
data.Add(u);
}
}
else
{
data = null;
}
}
catch (Exception ex)
{
data = null;
MessageBox.Show("Error: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
parameters.Clear();
}
return(data);
}
public csBet CrisLines(csBet b, csGame g, int sportbook)
{
try
{
parameters.Add("@pDate", b.PlacedDate);
parameters.Add("@pRot", g.HomeNumber);
parameters.Add("@pIdSportbook", sportbook);
parameters.Add("@pPeriod", b.GamePeriod);
parameters.Add("@pRot2", g.VisitorNumber);
parameters.Add("@pWagerPlay", b.WagerPlay);
dataset = csDonBest.ExecutePA("[dbo].[spGetLeansLines]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
if (b.VisHome == "H") // HOME
{
if (b.WagerPlay == "SP")
{
try { b.CrisPoints = Convert.ToDouble(fila["ps_home_spread"]); } catch (Exception) { b.CrisPoints = 0; }
try { b.CrisJuice = Convert.ToInt32(fila["ps_home_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
else if (b.WagerPlay == "ML" || b.WagerPlay == "DR")
{
b.CrisPoints = 0;
try { b.CrisJuice = Convert.ToInt32(fila["ml_home_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
else if (b.WagerPlay == "TOT")
{
if (b.OverUnder == "u")
{
try { b.CrisPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.CrisPoints = 0; }
try { b.CrisJuice = Convert.ToInt32(fila["under_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
else if (b.OverUnder == "o")
{
try { b.CrisPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.CrisPoints = 0; }
try { b.CrisJuice = Convert.ToInt32(fila["over_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
}
}
else //VISITOR
{
if (b.WagerPlay == "SP")
{
try { b.CrisPoints = Convert.ToDouble(fila["ps_away_spread"]); } catch (Exception) { b.CrisPoints = 0; }
try { b.CrisJuice = Convert.ToInt32(fila["ps_away_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
else if (b.WagerPlay == "ML" || b.WagerPlay == "DR")
{
b.CrisPoints = 0;
try { b.CrisJuice = Convert.ToInt32(fila["ml_away_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
else if (b.WagerPlay == "TOT")
{
if (b.OverUnder == "u")
{
try { b.CrisPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.CrisPoints = 0; }
try { b.CrisJuice = Convert.ToInt32(fila["under_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
else if (b.OverUnder == "o")
{
try { b.CrisPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.CrisPoints = 0; }
try { b.CrisJuice = Convert.ToInt32(fila["over_price"]); } catch (Exception) { b.CrisJuice = 0; }
}
}
}
}
}
}
catch (Exception)
{
b.CrisJuice = 0;
b.CrisPoints = 0;
}
finally
{
parameters.Clear();
}
return(b);
}
// Our Lines
public csBet OurNextLine(csBet b, csGame g)
{
try
{
parameters.Add("@pDate", b.PlacedDate);
parameters.Add("@pIdGame", g.IdGame);
parameters.Add("@pPlay", b.Play);
dataset = csG8Apps.ExecutePA("[dbo].[web_GetLeansLine]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
if (b.VisHome == "H")
{
if (b.WagerPlay == "SP")
{
try { b.OurPoints = Convert.ToDouble(fila["HomeSpread"]); } catch (Exception) { b.OurJuice = 0; }
try { b.OurJuice = Convert.ToInt32(fila["HomeJuice"]); } catch (Exception) { b.OurJuice = 0; }
}
else if (b.WagerPlay == "ML" || b.WagerPlay == "DR")
{
b.OurPoints = 0;
try { b.OurJuice = Convert.ToInt32(fila["HomeMoneyLine"]); } catch (Exception) { b.OurJuice = 0; }
}
else if (b.WagerPlay == "TOT")
{
try
{
if (b.OverUnder == "u")
{
try { b.OurPoints = Convert.ToDouble(fila["Total"]); } catch (Exception) { b.OurJuice = 0; }
try { b.OurJuice = Convert.ToInt32(fila["TotalUnderJuice"]); } catch (Exception) { b.OurJuice = 0; }
}
else
{
try { b.OurPoints = Convert.ToDouble(fila["Total"]); } catch (Exception) { b.OurJuice = 0; }
try { b.OurJuice = Convert.ToInt32(fila["TotalOverJuice"]); } catch (Exception) { b.OurJuice = 0; }
}
}
catch (Exception) { }
}
}
else
{
if (b.WagerPlay == "SP")
{
try { b.OurPoints = Convert.ToDouble(fila["AwaySpread"]); } catch (Exception) { b.OurJuice = 0; }
try { b.OurJuice = Convert.ToInt32(fila["AwayJuice"]); } catch (Exception) { b.OurJuice = 0; }
}
else if (b.WagerPlay == "ML" || b.WagerPlay == "DR")
{
b.OurPoints = 0;
try { b.OurJuice = Convert.ToInt32(fila["AwayMoneyLine"]); } catch (Exception) { b.OurJuice = 0; }
}
else if (b.WagerPlay == "TOT")
{
try
{
if (b.OverUnder == "u")
{
try { b.OurPoints = Convert.ToDouble(fila["Total"]); } catch (Exception) { b.OurJuice = 0; }
try { b.OurJuice = Convert.ToInt32(fila["TotalUnderJuice"]); } catch (Exception) { b.OurJuice = 0; }
}
else
{
try { b.OurPoints = Convert.ToDouble(fila["Total"]); } catch (Exception) { b.OurJuice = 0; }
try { b.OurJuice = Convert.ToInt32(fila["TotalOverJuice"]); } catch (Exception) { b.OurJuice = 0; }
}
}
catch (Exception) { }
}
}
}
}
}
catch (Exception)
{
b.OurJuice = 0;
b.OurPoints = 0;
}
finally
{
parameters.Clear();
}
return(b);
}
// pinnacle lines
public csBet PinniLines(csBet b, csGame g)
{
try
{
parameters.Add("@pDate", b.PlacedDate);
parameters.Add("@pRot", g.HomeNumber);
parameters.Add("@pPeriod", b.Period);
parameters.Add("@pRot2", g.VisitorNumber);
parameters.Add("@pWagerPlay", b.WagerPlay);
dataset = csPinnacle.ExecutePA("[dbo].[spGetLeansLines]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
if (b.VisHome == "H") // HOME
{
if (b.WagerPlay == "SP")
{
try { b.PinniPoints = Convert.ToDouble(fila["homeSpread"]); } catch (Exception) { b.PinniPoints = 0; }
try { b.PinniJuice = Convert.ToInt32(fila["homeOdds"]); } catch (Exception) { b.PinniJuice = 0; }
}
else if (b.WagerPlay == "ML" || b.WagerPlay == "DR")
{
b.PinniPoints = 0;
try { b.PinniJuice = Convert.ToInt32(fila["homeML"]); } catch (Exception) { b.PinniJuice = 0; }
}
else if (b.WagerPlay == "TOT")
{
if (b.OverUnder == "u")
{
try { b.PinniPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.PinniPoints = 0; }
try { b.PinniJuice = Convert.ToInt32(fila["totalUnder"]); } catch (Exception) { b.PinniJuice = 0; }
}
else if (b.OverUnder == "o")
{
try { b.PinniPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.PinniPoints = 0; }
try { b.PinniJuice = Convert.ToInt32(fila["totalOver"]); } catch (Exception) { b.PinniJuice = 0; }
}
}
}
else //VISITOR
{
if (b.WagerPlay == "SP")
{
try { b.PinniPoints = Convert.ToDouble(fila["visitorSpread"]); } catch (Exception) { b.PinniPoints = 0; }
try { b.PinniJuice = Convert.ToInt32(fila["visitorOdds"]); } catch (Exception) { b.PinniJuice = 0; }
}
else if (b.WagerPlay == "ML" || b.WagerPlay == "DR")
{
b.PinniPoints = 0;
try { b.PinniJuice = Convert.ToInt32(fila["visitorML"]); } catch (Exception) { b.PinniJuice = 0; }
}
else if (b.WagerPlay == "TOT")
{
if (b.OverUnder == "u")
{
try { b.PinniPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.PinniPoints = 0; }
try { b.PinniJuice = Convert.ToInt32(fila["totalUnder"]); } catch (Exception) { b.PinniJuice = 0; }
}
else if (b.OverUnder == "o")
{
try { b.PinniPoints = Convert.ToDouble(fila["total"]); } catch (Exception) { b.PinniPoints = 0; }
try { b.PinniJuice = Convert.ToInt32(fila["totalOver"]); } catch (Exception) { b.PinniJuice = 0; }
}
}
}
}
}
}
catch (Exception)
{
b.PinniJuice = 0;
b.PinniPoints = 0;
}
finally
{
parameters.Clear();
}
return(b);
}
public void GenerateExcel(ObservableCollection <csGame> Games, string player, ObservableCollection <csBet> BetsWithLeans, ObservableCollection <csBet> NoLeansBets, ObservableCollection <csBet> L, ObservableCollection <csBet> SumGames)
{
try
{
if (Games != null)
{
//Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
// Excel.Workbook wb = app.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
//ObservableCollection<csBet> BetsWithLeans = new ObservableCollection<csBet>();
//ObservableCollection<csBet> NoLeansBets = new ObservableCollection<csBet>();
//ObservableCollection<csSummary> SummaryListGame = new ObservableCollection<csSummary>();
foreach (var g in Games)
{
ObservableCollection <csBet> LeansBets = betDB.BetListFromIdGame(g, player);
csBet GameSum = new csBet();
GameSum.Event = g.VisitorTeam + " vs " + g.HomeTeam;
GameSum.Sport = g.IdSport;
GameSum.GameDate = g.EventDate.Month + "/" + g.EventDate.Day + "/" + g.EventDate.Year;
if (LeansBets != null)
{
foreach (var l in LeansBets)
{
ObservableCollection <csBet> bets = betDB.GetBetsAfterLeans(g.IdGame, l, l.WagerPlay, player);
GameSum.Line += l.Odds + ", " + l.OverUnder + l.Points;
GameSum.CrisLine += l.CrisJuice + ", " + l.OverUnder + l.CrisPoints;
GameSum.PinniLine += l.PinniJuice + ", " + l.OverUnder + l.PinniPoints;
GameSum.OurLine += l.OurNextLine;
GameSum.Team += (l.Rot == g.HomeNumber) ? g.HomeTeam : g.VisitorTeam;
GameSum.WagerPlay = l.WagerPlay;
l.GameDate = GameSum.GameDate;
//GameSum.Time = l.PlacedDate.ToString();
LeansBetsList.Add(l);
L.Add(l);
// to check if the sport doesn't exist.
//bool has = Sports.Any(x => x == l.IdSport);
//if (!has)
//{
// Sports.Add(l.IdSport);
//}
if (bets != null && bets.Count > 0)
{
foreach (var b in bets)
{
// **************************** Aqui es donde hay que generar el excel ***********************
b.EventDate = g.EventDate;
b.EventName = g.VisitorTeam + " vs " + g.HomeTeam;
b.GameDate = GameSum.GameDate;
try
{
if (b.Rot == l.Rot)
{
//Same team with LEANS
b.Pick = (g.VisitorNumber == b.Rot) ? g.VisitorTeam : g.HomeTeam;
GameSum.ContLeansBets += 1;
GameSum.WinLeans += b.WinAmount;
GameSum.RiskLeans += b.RiskAmount;
GameSum.NetLeans += b.Net;
BetsWithLeans.Add(b);
summary.ContLeansBets += 1;
}
else
{
//Different team with LEANS
b.Pick = (g.VisitorNumber == b.Rot) ? g.VisitorTeam : g.HomeTeam;
GameSum.ContNoLeansBets += 1;
GameSum.WinNoLeans += b.WinAmount;
GameSum.RiskNoLeans += b.RiskAmount;
GameSum.NetNoLeans += b.Net;
NoLeansBets.Add(b);
summary.ContNoLeansBets += 1;
}
//by player
bool flag = Players.Any(x => x.IdPlayer == b.IdPlayer);
if (!flag)
{
csSummary s = new csSummary();
s.IdPlayer = b.IdPlayer;
s.Player = b.Player;
Players.Add(s);
}
// sum total
//GameSum.TotalBets += 1;
//GameSum.WinAmount += b.WinAmount;
//GameSum.RiskAmount += b.RiskAmount;
//GameSum.Net += b.Net;
}
catch (Exception)
{
}
// fin generacion de Excel
}
}
}
}
GameSum.LeansHold = Math.Round(Convert.ToDouble((GameSum.NetLeans * 100) / GameSum.RiskLeans), 2, MidpointRounding.AwayFromZero);
GameSum.NoLeansHold = Math.Round(Convert.ToDouble((GameSum.NetNoLeans * 100) / GameSum.RiskNoLeans), 2, MidpointRounding.AwayFromZero);
SumGames.Add(GameSum);
}
// ************************* bets with the same bet from Leans *********************
//if (Sports != null)
//{
// ObservableCollection<csSummary> SummaryList = new ObservableCollection<csSummary>();
// foreach (var sp in Sports)
// {
// //Excel.Worksheet wsSport = wb.Sheets.Add();
// //wsSport.Name = sp;
// //CompleteRange(wsSport);
// index = 0;
// bool flag = true;
// foreach (var g in Games)
// {
// if (g.IdSport.Trim(' ') == sp)
// {
// if(!flag) index += 1;
// if (LeansBetsList != null)
// {
// for (int j = 0; j < LeansBetsList.Count; j++)
// {
// if (LeansBetsList[j].IdGame == g.IdGame)
// {
// if (BetsWithLeans != null)
// {
// if (LeansBetsList[j].IdSport == sp)
// {
// if (!flag) index += 1;
// else flag = false;
// //ShowInfo(wsSport, index, j, LeansBetsList, 3, g);
// //CenterAllInfo(wsSport, index);
// for (int i = 0; i < BetsWithLeans.Count; i++)
// {
// if (LeansBetsList[j].IdGame == BetsWithLeans[i].IdGame &&
// LeansBetsList[j].Rot == BetsWithLeans[i].Rot &&
// LeansBetsList[j].WagerPlay == BetsWithLeans[i].WagerPlay)
// {
// index += 1;
// //ShowInfo(wsSport, index, i, BetsWithLeans, 1, g);
// //CenterAllInfo(wsSport, index);
// }
// }
// }
// }
// if (LeansBetsList[j].IdSport == sp)
// {
// if (NoLeansBets != null)
// {
// for (int i = 0; i < NoLeansBets.Count; i++)
// {
// if (LeansBetsList[j].IdGame == NoLeansBets[i].IdGame &&
// LeansBetsList[j].Rot != NoLeansBets[i].Rot &&
// LeansBetsList[j].WagerPlay == NoLeansBets[i].WagerPlay)
// {
// index += 1;
// //ShowInfo(wsSport, index, i, NoLeansBets, 2, g);
// //CenterAllInfo(wsSport, index);
// }
// }
// }
// }
// }
// }
// }
// index += 2;
// }
// }
// SummaryList.Add(GetValuesFromSummary(sp, BetsWithLeans, NoLeansBets));
// }
// // (sender as BackgroundWorker).ReportProgress(40);
// //Excel.Worksheet ws3 = wb.Sheets.Add();
// //ws3.Name = "SUMMARY";
// index = 0;
// csSummary general = new csSummary();
// if (SummaryList != null)
// {
// //CompleteRangeSport(ws3);
// for (int i = 0; i < SummaryList.Count; i++)
// {
// //ShowInfoSport(ws3, i, SummaryList[i].sport, SummaryList[i]);
// //CenterAllInfoSport(ws3, i);
// general.ContLeansBets += SummaryList[i].ContLeansBets;
// general.RiskLeans += SummaryList[i].RiskLeans;
// general.NetLeans += SummaryList[i].NetLeans;
// general.WinBetsLeans += SummaryList[i].WinBetsLeans;
// general.ContNoLeansBets += SummaryList[i].ContNoLeansBets;
// general.RiskNoLeans += SummaryList[i].RiskNoLeans;
// general.NetNoLeans += SummaryList[i].NetNoLeans;
// general.WinBetsNoLeans += SummaryList[i].WinBetsNoLeans;
// index = i;
// }
// }
// try { general.WinPerLeans = (general.WinBetsLeans * 100 / general.ContLeansBets); } catch (Exception) { general.WinPerLeans = 0; }
// try { general.WinPerNoLeans = (general.WinBetsNoLeans * 100 / general.ContNoLeansBets); } catch (Exception) { general.WinPerNoLeans = 0; }
// try { general.LeansHold = (general.NetLeans * 100 / general.RiskLeans); } catch (Exception) { general.LeansHold = 0; }
// try { general.NoLeansHold = (general.NetNoLeans * 100 / general.RiskNoLeans); } catch (Exception) { general.NoLeansHold = 0; }
// index += 6;
// //RangeGeneral(ws3, index);
// index += 1;
// //ShowInfoGeneral(ws3, index, general);
// //CenterAllInfoGeneral(ws3, index - 2);
// // (sender as BackgroundWorker).ReportProgress(60);
//}
//// ********************** area by player ********************************** //
//if (Players != null)
//{
// //Excel.Worksheet wsp = wb.Sheets.Add();
// //wsp.Name = "By Player";
// index = 1;
// //CompleteRangePlayer(wsp, index);
// index -= 2;
// foreach (var p in Players)
// {
// index += 1;
// if (BetsWithLeans != null)
// {
// foreach (var s in BetsWithLeans)
// {
// if (p.IdPlayer == s.IdPlayer)
// {
// p.ContLeansBets += 1;
// p.RiskLeans += s.RiskAmount;
// p.NetLeans += s.Net;
// if (s.Result == "WIN") p.WinBetsLeans += 1;
// else p.LostBetsLeans += 1;
// }
// }
// try { p.WinPerLeans = (p.WinBetsLeans * 100 / p.ContLeansBets); } catch (Exception) { p.WinPerLeans = 0; }
// try { if (p.ContLeansBets > 0) { p.LeansHold = (p.NetLeans * 100 / p.RiskLeans); } else p.LeansHold = 0; } catch (Exception) { p.LeansHold = 0; }
// }
// if (NoLeansBets != null)
// {
// foreach (var s in NoLeansBets)
// {
// if (p.IdPlayer == s.IdPlayer)
// {
// p.ContNoLeansBets += 1;
// p.RiskNoLeans += s.RiskAmount;
// p.NetNoLeans += s.Net;
// if (s.Result == "WIN") p.WinBetsNoLeans += 1;
// else p.LostBetsNoLeans += 1;
// }
// }
// try { p.WinPerNoLeans = (p.WinBetsNoLeans * 100 / p.ContNoLeansBets); } catch (Exception) { p.WinPerNoLeans = 0; }
// try { if (p.ContNoLeansBets > 0) { p.NoLeansHold = (p.NetNoLeans * 100 / p.RiskNoLeans); } else p.NoLeansHold = 0; } catch (Exception) { p.NoLeansHold = 0; }
// }
// //ShowPlayer(wsp, index, p);
// //CenterAllInfoSport(wsp, index);
// }
//} //fin area player
//// ********************** Shett by game ********************************** //
//if (SummaryListGame != null)
//{
// //Excel.Worksheet ws4 = wb.Sheets.Add();
// //ws4.Name = "BY GAME";
// index = 0;
// //CompleteRangeGame(ws4,player);
// foreach (var i in SummaryListGame)
// {
// //ShowInfoGame(ws4, index, i);
// //CenterAllInfoGame(ws4, index);
// index += 2;
// }
// // (sender as BackgroundWorker).ReportProgress(100);
//}
//// ************************* SAVE THE DOCUMENT *********************
////wb.SaveAs(path + @"/LeansReport.xls");
////wb.Saved = true;
////wb.Close(true);
////app.Quit();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static string Leans(string start, string end, string player, string sport)
{
csBet BetGeneral = null;
var obj = new ObservableCollection <csBet>();
var ByGame = new ObservableCollection <csBet>();
if (start != "" && end != "")
{
sport = (sport == "ALL") ? "" : sport;
var spli1 = start.Split('/');
var spli2 = end.Split('/');
var date1 = spli1[2] + "-" + spli1[0] + "-" + spli1[1];
var date2 = spli2[2] + "-" + spli2[0] + "-" + spli2[1];
DateTime dt2 = Convert.ToDateTime(date2);
dt2 = dt2.AddDays(1);
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
var GamesList = gameDB.ListGames(date1, date2, sport, -1, "LEANS");
if (GamesList != null && GamesList.Count > 0)
{
BetGeneral = LeansExcel.GenerateExcel(GamesList, player, BetGeneral);
}
}
//************************************ EXECUTION **************************************
var b = new csBet();
if (BetGeneral != null)
{
b.Risk_wADJ = BetGeneral.Risk_wADJ;
b.Risk_aADJ = BetGeneral.Risk_aADJ;
obj.Add(b);
b.Net_wADJ = BetGeneral.Net_wADJ;
b.Net_aADJ = BetGeneral.Net_aADJ;
obj.Add(b);
b.LinesPlayed_wADJ = BetGeneral.LinesPlayed_wADJ;
b.LinesPlayed_aADJ = BetGeneral.LinesPlayed_aADJ;
obj.Add(b);
b.Fav_wADJ = BetGeneral.Fav_wADJ;
b.Fav_aADJ = BetGeneral.Fav_aADJ;
obj.Add(b);
b.Dog_wADJ = BetGeneral.Dog_wADJ;
b.Dog_aADJ = BetGeneral.Dog_aADJ;
obj.Add(b);
b.Hold_wADJ = Math.Round((BetGeneral.Net_wADJ * 100 / BetGeneral.Risk_wADJ), 2, MidpointRounding.AwayFromZero);
b.Hold_aADJ = Math.Round((BetGeneral.Net_aADJ * 100 / BetGeneral.Risk_aADJ), 2, MidpointRounding.AwayFromZero);
b.Hold_wADJ = (Double.IsNaN(b.Hold_wADJ)) ? 0 : b.Hold_wADJ;
b.Hold_aADJ = (Double.IsNaN(b.Hold_aADJ)) ? 0 : b.Hold_aADJ;
obj.Add(b);
}
else
{
obj.Add(b);
obj.Add(b);
obj.Add(b);
obj.Add(b);
obj.Add(b);
obj.Add(b);
}
return(JsonConvert.SerializeObject(obj));
}
public ObservableCollection <csBet> BetList(string d1, string d2, string s, int a, string wagerPlay, string betType, int league, int player)
{
ObservableCollection <csBet> data = new ObservableCollection <csBet>();
try
{
parameters.Clear();
parameters.Add("@pStartDate", d1);
parameters.Add("@pEndDate", d2);
parameters.Add("@pSport", s.Trim());
parameters.Add("@pAgent", a);
parameters.Add("@pWagerPlay", wagerPlay);
parameters.Add("@pBetType", betType);
parameters.Add("@pIdLeague", league);
parameters.Add("@pPlayer", player);
dataset = csG8Apps.ExecutePA("[dbo].[webGetBets]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow fila in dataset.Tables[0].Rows)
{
csBet u = new csBet(
Convert.ToInt64(fila["Id_BI"]),
Convert.ToInt32(fila["IdWager"]),
Convert.ToInt32(fila["IdWagerDetail"]),
Convert.ToInt32(fila["IdAgent"]),
Convert.ToString(fila["Agent"]),
Convert.ToInt32(fila["IdPlayer"]),
Convert.ToString(fila["Player"]),
Convert.ToInt32(fila["IdLineType"]),
Convert.ToString(fila["LineTypeName"]),
Convert.ToString(fila["LoginName"]),
Convert.ToDouble(fila["WinAmount"]),
Convert.ToInt32(fila["RiskAmount"]),
Convert.ToString(fila["Result"]),
Convert.ToDouble(fila["Net"]),
Convert.ToString(fila["GamePeriod"]),
Convert.ToString(fila["League"]),
Convert.ToString(fila["CompleteDescription"]),
Convert.ToString(fila["DetailDescription"]),
Convert.ToString(fila["Team"]),
Convert.ToInt32(fila["IdGame"]),
Convert.ToInt32(fila["IdLeague"]),
Convert.ToInt32(fila["Period"]),
Convert.ToString(fila["FAV_DOG"]),
Convert.ToInt32(fila["Play"]),
Convert.ToString(fila["WagerPlay"]),
Convert.ToString(fila["IdSport"]),
Convert.ToDateTime(fila["SettledDate"]),
Convert.ToDateTime(fila["PlacedDate"]),
Convert.ToInt32(fila["Odds"]),
Convert.ToDouble(fila["Points"]),
Convert.ToString(fila["Score"]),
Convert.ToString(fila["IP"]),
Convert.ToString(fila["BeatLine"]));
data.Add(u);
}
}
else
{
data = null;
}
}
catch (Exception ex)
{
data = null;
throw new Exception(ex.Message);
}
finally { parameters.Clear(); }
return(data);
}
