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