public static string BetStats(string player, string wagerType, string sport)
{
var obj = new ObservableCollection <Entities.Profiling.csSummary>();
sport = (sport == "ALL") ? "" : sport;
DateTime dt1 = DateTime.Now;
DateTime dt2 = DateTime.Now;
string date1 = "", date2 = "";
//***************************** CURRRENT SEASON ********************************
var current = seasonDB.GetSeasonBySport(sport);
date1 = current.startDateLastSeason;
date2 = current.endDateLastSeason;
var p = summaryDB.InfoByBets(date1, date2, sport, player, wagerType, "Spread", "Current Season");
obj.Add(p);
p = summaryDB.InfoByBets(date1, date2, sport, player, wagerType, "Money", "Current Season");
obj.Add(p);
p = summaryDB.InfoByBets(date1, date2, sport, player, wagerType, "Total", "Current Season");
obj.Add(p);
//***************************** CURRRENT WEEK ********************************
dt1 = dt1.AddDays(TW());
dt2 = dt2.AddDays(1);
date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
p = summaryDB.InfoByBets(date1, date2, sport, player, wagerType, "Spread", "Current Week");
obj.Add(p);
p = summaryDB.InfoByBets(date1, date2, sport, player, wagerType, "Money", "Current Week");
obj.Add(p);
p = summaryDB.InfoByBets(date1, date2, sport, player, wagerType, "Total", "Current Week");
obj.Add(p);
// *********************************** FINAL PROCESS ************************
if (obj != null && obj.Count == 6)
{
var aux = new Entities.Profiling.csSummary(player,
"",
obj[0].RiskAmount + obj[3].RiskAmount,
obj[0].Net + obj[3].Net,
obj[0].Bets + obj[3].Bets,
obj[0].Wins + obj[3].Wins,
"Overall",
"Spread");
obj.Add(aux);
aux = new Entities.Profiling.csSummary(player,
"",
obj[1].RiskAmount + obj[4].RiskAmount,
obj[1].Net + obj[4].Net,
obj[1].Bets + obj[4].Bets,
obj[1].Wins + obj[4].Wins,
"Overall",
"Money");
obj.Add(aux);
aux = new Entities.Profiling.csSummary(player,
"",
obj[2].RiskAmount + obj[5].RiskAmount,
obj[2].Net + obj[5].Net,
obj[2].Bets + obj[5].Bets,
obj[2].Wins + obj[5].Wins,
"Overall",
"Total");
obj.Add(aux);
}
return(Json.Encode(obj));
}
public static string ParlayTeaser(string player, string range, string sport)
{
var obj = new ObservableCollection <Entities.Profiling.csSummary>();
sport = (sport == "ALL") ? "" : sport;
DateTime dt1 = DateTime.Now;
DateTime dt2 = DateTime.Now;
string date1 = "", date2 = "";
//dt2 = dt2.AddDays(1);
if (range == "T") //today
{
dt2 = dt2.AddDays(1);
date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
}
else if (range == "Y") //yesterday
{
dt1 = dt1.AddDays(-1);
date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
}
else if (range == "TW") //this week
{
dt1 = dt1.AddDays(TW());
dt2 = dt2.AddDays(1);
date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
}
else if (range == "LW") //last week
{
dt1 = dt1.AddDays(TW() - 7);
dt2 = dt2.AddDays(TW());
date1 = dt1.Year + "-" + dt1.Month + "-" + dt1.Day;
date2 = dt2.Year + "-" + dt2.Month + "-" + dt2.Day;
}
else if (range == "TS") //this season
{
var current = seasonDB.GetSeasonBySport(sport);
date1 = current.startDateCurrentSeason;
date2 = current.endDateCurrentSeason;
}
else if (range == "LS") //last season
{
var current = seasonDB.GetSeasonBySport(sport);
date1 = current.startDateLastSeason;
date2 = current.endDateLastSeason;
}
var p = summaryDB.InfoByBets(date1, date2, sport, player, "TEASER");
p.WagerType = "Teaser";
obj.Add(p);
p = summaryDB.InfoByBets(date1, date2, sport, player, "PARLAY");
p.WagerType = "Parlay";
obj.Add(p);
if (obj != null && obj.Count == 2)
{
var aux = new Entities.Profiling.csSummary(player,
"",
obj[0].RiskAmount + obj[1].RiskAmount,
obj[0].Net + obj[1].Net,
obj[0].Bets + obj[1].Bets,
obj[0].Wins + obj[1].Wins);
aux.WagerType = "Overall";
obj.Add(aux);
}
return(Json.Encode(obj));
}
