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