public csGamesBySerie GetLine(csGamesBySerie mlb, string Ref) { try { parameters.Clear(); parameters.Add("@pIdGame", mlb.Id); parameters.Add("@pPlay", (Ref == "AWAY") ? 4 : 5); parameters.Add("@pFisrtEnd", "E"); parameters.Add("@pIdLineType", 140); dataset = csConnection.ExecutePA("[dbo].[web_getOrderLines]", parameters); if (dataset.Tables[0].Rows.Count == 1) { mlb.Line = (!String.IsNullOrWhiteSpace(dataset.Tables[0].Rows[0]["ChangeValue"].ToString())) ? Convert.ToInt32(dataset.Tables[0].Rows[0]["ChangeValue"]) : mlb.Line; } else { mlb.Line = null; } } catch (Exception ex) { throw new Exception(ex.Message); } finally { parameters.Clear(); } return(mlb); }
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); }