public ObservableCollection <csGroupSerie> GetAllGamesBySerie(csMlbSeries serie)
{
ObservableCollection <csGroupSerie> data = new ObservableCollection <csGroupSerie>();
csGroupSerie mlb = null;
int n = 0;
try
{
DateTime dt = serie.EventDate.AddDays(serie.CountGames);
parameters.Clear();
parameters.Add("@pStartDate", serie.EventDate.Year + "-" + serie.EventDate.Month + "-" + serie.EventDate.Day);
parameters.Add("@pEndDate", dt.Year + "-" + dt.Month + "-" + dt.Day);
parameters.Add("@pHomeTeam", serie.HomeTeam);
parameters.Add("@pvisitorTeam", serie.VisitorTeam);
dataset = csDonBest.ExecutePA("[dbo].[web_getGameSameSerie]", parameters);
if (dataset.Tables[0].Rows.Count > 0)
{
//serie.SetCountGames(dataset.Tables[0].Rows.Count);
foreach (DataRow fila in dataset.Tables[0].Rows)
{
mlb = new csGroupSerie(
Convert.ToDateTime(fila["date"]),
Convert.ToString(fila["name"]),
Convert.ToInt32(fila["participant_away_rot"]),
Convert.ToInt32(fila["participant_home_rot"]),
Convert.ToInt32(fila["id"]));
data.Add(mlb);
}
n++;
}
else
{
data = null;
}
}
catch (Exception ex)
{
data = null;
n = n;
throw new Exception(ex.Message);
}
finally
{
parameters.Clear();
}
return(data);
}
public ObservableCollection <csGamesBySerie> GetGamesBySerie(csGroupSerie serie, string Ref)
{
ObservableCollection <csGamesBySerie> data = new ObservableCollection <csGamesBySerie>();
csGamesBySerie mlb = null;
try
{
int n = Convert.ToInt32(serie.AwayRot.ToString().Substring(1, serie.AwayRot.ToString().Length - 1));
parameters.Clear();
parameters.Add("@pDate", serie.EventDate.Year + "-" + serie.EventDate.Month + "-" + serie.EventDate.Day);
parameters.Add("@pRot", n);
dataset = csG8Apps.ExecutePA("[dbo].[web_getGamesBySerie]", parameters);
if (dataset.Tables[0].Rows.Count == 1)
{
mlb = new csGamesBySerie();
mlb.EventDate = Convert.ToDateTime(dataset.Tables[0].Rows[0]["GameDateTime"]);
mlb.VisitorNumber = Convert.ToInt32(dataset.Tables[0].Rows[0]["VisitorNumber"]);
mlb.HomeNumber = Convert.ToInt32(dataset.Tables[0].Rows[0]["HomeNumber"]);
mlb.Id = Convert.ToInt32(dataset.Tables[0].Rows[0]["IdGame"]);
mlb.VisitorTeam = Convert.ToString(dataset.Tables[0].Rows[0]["VisitorTeam"]);
mlb.HomeTeam = Convert.ToString(dataset.Tables[0].Rows[0]["HomeTeam"]);
mlb.VisitorPitcher = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["VisitorPitcher"].ToString())) ? dataset.Tables[0].Rows[0]["VisitorPitcher"].ToString() : null;
mlb.HomePitcher = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["HomePitcher"].ToString())) ? dataset.Tables[0].Rows[0]["HomePitcher"].ToString() : null;
mlb.HomeScore = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["HomeScore"].ToString())) ? Convert.ToInt32(dataset.Tables[0].Rows[0]["HomeScore"]) : mlb.HomeScore;
mlb.VisitorScore = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["VisitorScore"].ToString())) ? Convert.ToInt32(dataset.Tables[0].Rows[0]["VisitorScore"]) : mlb.VisitorScore;
mlb.HomeOdds = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["HomeOdds"].ToString())) ? Convert.ToInt32(dataset.Tables[0].Rows[0]["HomeOdds"]) : mlb.HomeOdds;
mlb.VisitorOdds = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["VisitorOdds"].ToString())) ? Convert.ToInt32(dataset.Tables[0].Rows[0]["VisitorOdds"]) : mlb.VisitorOdds;
mlb.Spread = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["VisitorSpread"].ToString())) ? (Ref == "AWAY") ? Convert.ToDouble(dataset.Tables[0].Rows[0]["VisitorSpread"]) : Convert.ToDouble(dataset.Tables[0].Rows[0]["HomeSpread"]) : mlb.Spread;
mlb.Total = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["TotalOver"].ToString())) ? Convert.ToDouble(dataset.Tables[0].Rows[0]["TotalOver"]) : mlb.Total;
mlb.TotalOver = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["OverOdds"].ToString())) ? Convert.ToDouble(dataset.Tables[0].Rows[0]["OverOdds"]) : mlb.TotalOver;
mlb.TotalUnder = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["UnderOdds"].ToString())) ? Convert.ToDouble(dataset.Tables[0].Rows[0]["UnderOdds"]) : mlb.TotalUnder;
mlb.SpreadOdds = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["VisitorSpreadOdds"].ToString())) ? (Ref == "AWAY") ? Convert.ToDouble(dataset.Tables[0].Rows[0]["VisitorSpreadOdds"]) : Convert.ToDouble(dataset.Tables[0].Rows[0]["HomeSpreadOdds"]) : mlb.SpreadOdds;
if (mlb.HomeOdds != null)
{
mlb.Line = (Ref == "AWAY") ? mlb.VisitorOdds : mlb.HomeOdds;
}
else
{
// ********* HERE MOST BE THE SECOND CONSULT TO EXTRACT THE MONEY LINE *************
mlb = GetLine(mlb, Ref);
}
data.Add(mlb);
}
else if (dataset.Tables[0].Rows.Count > 1)
{
int ne = 0;
}
}
catch (Exception ex)
{
data = null;
throw new Exception(ex.Message);
}
finally
{
parameters.Clear();
}
return(data);
}
