private ObservableCollection <csReportNHL> FindNulls(ObservableCollection <csReportNHL> list, Boolean alternative) { if (list != null && list.Count > 0) { foreach (var data in list) { if ((data.HomeSpecial == null && data.HomeOdds == null && data.HomeSpecialOdds == null) || (data.VisitorOdds == null && data.VisitorSpecial == null && data.VisitorSpecialOdds == null) || (data.HomeSpecial == null && data.HomeOdds == null) || (data.VisitorOdds == null && data.VisitorSpecial == null) || (data.HomeSpecialOdds == null && data.HomeOdds == null) || (data.VisitorOdds == null && data.VisitorSpecialOdds == null) || data.HomeSpecialOdds == null || data.VisitorSpecialOdds == null && !alternative) { csReportNHL n = data; lastLine.SetLastLine(data); if (n != null) { data.VisitorSpecial = n.VisitorSpecial; data.HomeSpecial = n.HomeSpecial; data.VisitorOdds = n.VisitorOdds; data.HomeOdds = n.HomeOdds; data.VisitorSpecialOdds = n.VisitorSpecialOdds; data.HomeSpecialOdds = n.HomeSpecialOdds; } } if (!alternative) { lastLine.SetFisrtLine(data); } } } return(list); }
private csReportNHL GetFisrtLine(int idGame) { csReportNHL NHL = new csReportNHL(); try { parameters.Clear(); parameters.Add("@pIdGame", idGame); parameters.Add("@pPlay", 0); parameters.Add("@pFisrtEnd", "F"); dataset.Clear(); dataset = csG8Apps.ExecutePA("[dbo].[web_getOrderLines]", parameters); if (dataset.Tables[0].Rows.Count > 0) { foreach (DataRow fila in dataset.Tables[0].Rows) { try { NHL.OpeningHomeSpecial = Convert.ToDouble(fila["HomeSpread"]); } catch (Exception) { NHL.OpeningHomeSpecial = 0; } try { NHL.OpeningVisitorSpecial = Convert.ToDouble(fila["AwaySpread"]); } catch (Exception) { NHL.OpeningVisitorSpecial = 0; } try { NHL.OpeningHomeSpecialOdds = Convert.ToInt32(fila["HomeJuice"]); } catch (Exception) { NHL.OpeningHomeSpecialOdds = 0; } try { NHL.OpeningVisitorSpecialOdds = Convert.ToInt32(fila["AwayJuice"]); } catch (Exception) { NHL.OpeningVisitorSpecialOdds = 0; } } } parameters.Clear(); parameters.Add("@pIdGame", idGame); parameters.Add("@pPlay", 4); parameters.Add("@pFisrtEnd", "F"); dataset.Clear(); dataset = csG8Apps.ExecutePA("[dbo].[web_getOrderLines]", parameters); if (dataset.Tables[0].Rows.Count > 0) { foreach (DataRow fila in dataset.Tables[0].Rows) { try { NHL.OpeningHomeOdds = Convert.ToInt32(fila["HomeMoneyLine"]); } catch (Exception) { NHL.OpeningHomeOdds = 0; } try { NHL.OpeningVisitorOdds = Convert.ToInt32(fila["AwayMoneyLine"]); } catch (Exception) { NHL.OpeningVisitorOdds = 0; } } } } catch (Exception) { return(null); } finally { parameters.Clear(); } return(NHL); }
public void SetLastLine(csReportNHL NHL) { csReportNHL l = GetLastLine(NHL.IdGame); if (l != null) { NHL.VisitorSpecial = (l.VisitorSpecial == 0) ? null : l.VisitorSpecial; NHL.VisitorSpecialOdds = (l.VisitorSpecialOdds == 0) ? null : l.VisitorSpecialOdds; NHL.HomeSpecial = (l.HomeSpecial == 0) ? null : l.HomeSpecial; NHL.HomeSpecialOdds = (l.HomeSpecialOdds == 0) ? null : l.HomeSpecialOdds; NHL.VisitorOdds = (l.VisitorOdds == 0) ? null : l.VisitorOdds; NHL.HomeOdds = (l.HomeOdds == 0) ? null : l.HomeOdds; } }
public void SetFisrtLine(csReportNHL NHL) { try { csReportNHL l = GetFisrtLine(NHL.IdGame); try { NHL.OpeningVisitorSpecial = (l == null || l.OpeningVisitorSpecial == null || l.OpeningVisitorSpecial == 0) ? NHL.VisitorSpecial : l.OpeningVisitorSpecial; } catch (Exception) { NHL.OpeningVisitorSpecial = NHL.VisitorSpecial; } try { NHL.OpeningVisitorSpecialOdds = (l == null || l.OpeningVisitorSpecialOdds == null || l.OpeningVisitorSpecialOdds == 0) ? NHL.VisitorSpecialOdds : l.OpeningVisitorSpecialOdds; } catch (Exception) { NHL.OpeningVisitorSpecialOdds = NHL.VisitorSpecialOdds; } try { NHL.OpeningHomeSpecial = (l == null || l.OpeningHomeSpecial == null || l.OpeningHomeSpecial == 0) ? NHL.HomeSpecial : l.OpeningHomeSpecial; } catch (Exception) { NHL.OpeningHomeSpecial = NHL.HomeSpecial; } try { NHL.OpeningHomeSpecialOdds = (l == null || l.OpeningHomeSpecialOdds == null || l.OpeningHomeSpecialOdds == 0) ? NHL.HomeSpecialOdds : l.OpeningHomeSpecialOdds; } catch (Exception) { NHL.OpeningHomeSpecialOdds = NHL.HomeSpecialOdds; } try { NHL.OpeningVisitorOdds = (l == null || l.OpeningVisitorOdds == null || l.OpeningVisitorOdds == 0) ? NHL.VisitorOdds : l.OpeningHomeOdds; } catch (Exception) { NHL.OpeningVisitorOdds = NHL.VisitorOdds; } try { NHL.OpeningHomeOdds = (l == null || l.OpeningHomeOdds == null || l.OpeningHomeOdds == 0) ? NHL.HomeOdds : l.OpeningHomeOdds; } catch (Exception) { NHL.OpeningHomeOdds = NHL.HomeOdds; } if (NHL.OpeningVisitorSpecial == null) { NHL.OpeningVisitorSpecial = NHL.VisitorSpecial; } if (NHL.OpeningVisitorSpecialOdds == null) { NHL.OpeningVisitorSpecialOdds = NHL.VisitorSpecialOdds; } if (NHL.OpeningHomeSpecial == null) { NHL.OpeningHomeSpecial = NHL.HomeSpecial; } if (NHL.OpeningHomeSpecialOdds == null) { NHL.OpeningHomeSpecialOdds = NHL.HomeSpecialOdds; } if (NHL.OpeningVisitorOdds == null) { NHL.OpeningVisitorOdds = NHL.VisitorOdds; } if (NHL.OpeningHomeOdds == null) { NHL.OpeningHomeOdds = NHL.HomeOdds; } } catch (Exception) { //MessageBox.Show("Error to set the first line: " + ex.Message); } }
public ObservableCollection <csReportNHL> SportListNHL(string date1, string date2, int league, string side, string team, bool alternative, DataSet dt) { ObservableCollection <csReportNHL> list = new ObservableCollection <csReportNHL>(); try { parameters.Clear(); parameters.Add("@startD", date1); parameters.Add("@endD", date2); parameters.Add("@leagueID", league); parameters.Add("@side", side); parameters.Add("@team", team); ListNull.Clear(); dt.Clear(); dt = csConnection.ExecutePA("[dbo].[_web_GenerateSportRange]", parameters); csReportNHL data = null; if (dt.Tables[0].Rows.Count > 0) { foreach (DataRow fila in dt.Tables[0].Rows) { data = new csReportNHL(); try { data.HomeScore = Convert.ToInt32(fila["HomeScore"]); } catch (Exception) { data.HomeScore = 0; } try { data.VisitorTeam = Convert.ToString(fila["VisitorTeam"]); } catch (Exception) { data.VisitorTeam = ""; } try { data.HomeNumber = Convert.ToInt32(fila["HomeNumber"]); } catch (Exception) { data.HomeNumber = -1; } try { data.HomeTeam = Convert.ToString(fila["HomeTeam"]); } catch (Exception) { data.HomeTeam = ""; } try { data.WINNER = Convert.ToString(fila["WINNER"]); } catch (Exception) { data.WINNER = "NONE"; } try { data.IdGame = Convert.ToInt32(fila["IdGame"]); } catch (Exception) { data.IdGame = -1; } try { data.GameDateTime = Convert.ToDateTime(fila["GameDateTime"]); } catch (Exception) { data.GameDateTime = DateTime.Now; } try { data.VisitorNumber = Convert.ToInt32(fila["VisitorNumber"]); } catch (Exception) { data.VisitorNumber = -1; } try { data.VisitorScore = Convert.ToInt32(fila["VisitorScore"]); } catch (Exception) { data.VisitorScore = 0; } try { data.VisitorSpecial = Convert.ToDouble(fila["VisitorSpecial"]); } catch { data.VisitorSpecial = null; } try { data.VisitorSpecialOdds = Convert.ToInt32(fila["VisitorSpecialOdds"]); } catch { data.VisitorSpecialOdds = null; } try { data.HomeSpecial = Convert.ToDouble(fila["HomeSpecial"]); } catch { data.HomeSpecial = null; } try { data.HomeSpecialOdds = Convert.ToInt32(fila["HomeSpecialOdds"]); } catch { data.HomeSpecialOdds = null; } try { data.VisitorOdds = Convert.ToInt32(fila["VisitorOdds"]); } catch { data.VisitorOdds = null; } try { data.HomeOdds = Convert.ToInt32(fila["HomeOdds"]); } catch { data.HomeOdds = null; } try { data.TotalOver = Convert.ToDouble(fila["TotalOver"]); } catch { data.TotalOver = null; } try { data.OverOdds = Convert.ToInt32(fila["OverOdds"]); } catch { data.OverOdds = null; } try { data.UnderOdds = Convert.ToInt32(fila["UnderOdds"]); } catch { data.UnderOdds = null; } list.Add(data); } list = FindNulls(list, alternative); } else { list = null; } } catch (NoNullAllowedException ex) { list = null; } catch (Exception ex) { list = null; } finally { parameters.Clear(); } return(list); }